eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_00707_AAD_S_000007_BC_PKG dependencies on ALL_OBJECTS

Line 29197: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)

29193: , PO_HEADERS_REF_V h6
29194: , PSA_CST_XLA_UPG_V h7
29195: , fnd_lookup_values fvl13
29196: , fnd_lookup_values fvl36
29197: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
29198: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
29199: AND xet.event_class_code = C_EVENT_CLASS_CODE
29200: AND h1.event_id = xet.event_id
29201: AND h3.ref_rcv_accounting_event_id = h1.rcv_accounting_event_id AND h3.po_header_id = h5.po_header_id (+) and h3.po_distribution_id = h5.po_distribution_id (+) AND h3.po_header_id = h6.po_header_id (+) AND h3.rcv_transaction_id = h7.transaction_id (+) AND fvl13.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 29369: , (select rownum r from all_objects where rownum <= 14 and owner = p_apps_owner)

29365: , null source_meaning
29366: FROM xla_events_gt xet
29367: , CST_XLA_RCV_LINES_V l2
29368: , FV_XLA_CST_REF_V l4
29369: , (select rownum r from all_objects where rownum <= 14 and owner = p_apps_owner)
29370: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
29371: AND xet.event_class_code = C_EVENT_CLASS_CODE
29372: AND l2.event_id = xet.event_id
29373: AND l4.federal_event_id = l2.event_id and l4.federal_line_number=l2.line_number

Line 31323: ,(select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)

31319: , PO_HEADERS_REF_V h6
31320: , PSA_CST_XLA_UPG_V h7
31321: , fnd_lookup_values fvl13
31322: , fnd_lookup_values fvl36
31323: ,(select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)
31324: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
31325: AND xet.event_class_code = C_EVENT_CLASS_CODE
31326: AND h1.event_id = xet.event_id
31327: AND h3.ref_transaction_id = h1.transaction_id AND h3.txn_po_header_id = h5.po_header_id (+) and h3.txn_po_distribution_id = h5.po_distribution_id (+) AND h3.txn_po_header_id = h6.po_header_id (+) AND h3.rcv_transaction_id = h7.transaction_id (+) AND fvl13.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 31510: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)

31506: , null source_meaning
31507: FROM xla_events_gt xet
31508: , CST_XLA_INV_LINES_V l2
31509: , FV_XLA_CST_REF_V l4
31510: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
31511: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
31512: AND xet.event_class_code = C_EVENT_CLASS_CODE
31513: AND l2.event_id = xet.event_id
31514: AND l4.federal_event_id (+) = l2.event_id and l4.federal_line_number (+) =l2.line_number