Post date: Jul 05, 2013 10:58:39 AM
--1. Find File Version PLS
SELECT DISTINCT af.app_short_name, af.subdir, af.filename, afv.VERSION,
afv.creation_date
FROM ad_file_versions afv, ad_files af
WHERE afv.file_id = af.file_id
AND af.filename IN
('CSTVXLAB.pls', 'CSTACDPB.pls', 'xlajeaex.pkb',
'cstcxla.odf', 'cstxlaaad.ldt', 'cstxlaemseed.ldt')
AND afv.VERSION LIKE '120.%.12%'
ORDER BY 3, 4 DESC
--2. Find DBA Objects that Invalid
SELECT owner, object_name, object_type, status
FROM dba_objects
WHERE status = 'INVALID'
ORDER BY DECODE (SUBSTR (object_type, 1, 4), 'PACK', 1, 2), 1, 2;
--3 From Event ID to PO
select *
from xla_events
where event_id='102910' --entity_id=64142
select *
from xla_transaction_entities_upg
where entity_id=64142 --source_id_int_1=17062, transaction_number=17062
--where legal_entity_id is null
select *
from mtl_material_transactions
where transaction_id='17062' --rcv_transaction_id=6157
select *
from rcv_transactions
where transaction_id=6157 --po_header_id=31328
--where po_header_id is null
select *
from po_headers_all
where po_header_id=31328
select *
from po_lines_all
where po_header_id=31328
--4.
select bug_number, creation_date from ad_bugs where bug_number = '16060007'