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_00201_AAD_S_000004_BC_PKG dependencies on ALL_OBJECTS

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

47277: END source_value
47278: , null source_meaning
47279: FROM xla_events_gt xet
47280: , PO_EXTRACT_HEADER_V h4
47281: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
47282: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
47283: AND xet.event_class_code = C_EVENT_CLASS_CODE
47284: AND h4.event_id = xet.event_id
47285:

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

47527: FROM xla_events_gt xet
47528: , FV_XLA_PO_REF_V l1
47529: , PO_DISTS_REF_V l2
47530: , PO_EXTRACT_DETAIL_V l3
47531: , (select rownum r from all_objects where rownum <= 31 and owner = p_apps_owner)
47532: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
47533: AND xet.event_class_code = C_EVENT_CLASS_CODE
47534: AND l3.event_id = xet.event_id
47535: AND l1.federal_event_id (+) = l3.event_id and l1.federal_line_number (+) = l3.line_number AND l3.po_distribution_id = l2.po_distribution_id (+) and l3.po_distribution_type = l2.po_distribution_type (+)

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

50082: , null source_meaning
50083: FROM xla_events_gt xet
50084: , PO_EXTRACT_HEADER_V h4
50085: , PO_RELEASES_REF_V h5
50086: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
50087: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
50088: AND xet.event_class_code = C_EVENT_CLASS_CODE
50089: AND h4.event_id = xet.event_id
50090: AND h4.po_release_id = h5.po_release_id

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

50327: FROM xla_events_gt xet
50328: , FV_XLA_PO_REF_V l1
50329: , PO_DISTS_REF_V l2
50330: , PO_EXTRACT_DETAIL_V l3
50331: , (select rownum r from all_objects where rownum <= 30 and owner = p_apps_owner)
50332: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
50333: AND xet.event_class_code = C_EVENT_CLASS_CODE
50334: AND l3.event_id = xet.event_id
50335: AND l1.federal_event_id (+) = l3.event_id and l3.line_number = l1.federal_line_number (+) AND l3.po_distribution_id = l2.po_distribution_id (+) and l3.po_distribution_type = l2.po_distribution_type (+)

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

52585: END source_value
52586: , null source_meaning
52587: FROM xla_events_gt xet
52588: , PO_REQ_EXTRACT_HEADER_V h3
52589: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
52590: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
52591: AND xet.event_class_code = C_EVENT_CLASS_CODE
52592: AND h3.event_id = xet.event_id
52593:

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

52795: FROM xla_events_gt xet
52796: , FV_XLA_PO_REF_V l1
52797: , PO_REQ_EXTRACT_DETAIL_V l2
52798: , PO_REQ_LINES_REF_V l4
52799: , (select rownum r from all_objects where rownum <= 23 and owner = p_apps_owner)
52800: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
52801: AND xet.event_class_code = C_EVENT_CLASS_CODE
52802: AND l2.event_id = xet.event_id
52803: AND l1.federal_event_id (+) =l2.event_id and l1.federal_line_number (+) =l2.line_number AND l2.req_line_id = l4.req_line_id (+)