DBA Data[Home] [Help]

APPS.XLA_00222_AAD_S_000004_PKG dependencies on ALL_OBJECTS

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

20919: END source_value
20920: , null source_meaning
20921: FROM xla_events_gt xet
20922: , AR_CASH_RECEIPTS_H_V h1
20923: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)
20924: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
20925: AND xet.event_class_code = C_EVENT_CLASS_CODE
20926:
20927: )

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

21067: , null source_meaning
21068: FROM xla_events_gt xet
21069: , AR_DISTRIBUTIONS_BASE_V l2
21070: , AR_DISTRIBUTIONS_L_V l3
21071: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
21072: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
21073: AND xet.event_class_code = C_EVENT_CLASS_CODE
21074: AND l2.event_id = xet.event_id
21075: AND l3.event_id = l2.event_id

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

22354: , AR_CASH_RECEIPTS_H_V h1
22355: , AR_RCT_SITE_USES_H_V h5
22356: , AR_REMIT_BANK_ACCT_H_V h7
22357: , AR_SYSTEM_PARAM_H_V h8
22358: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
22359: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
22360: AND xet.event_class_code = C_EVENT_CLASS_CODE
22361: AND h1.event_id = xet.event_id
22362: AND h5.event_id (+) = h1.event_id

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

22599: , AR_DISTRIBUTIONS_BASE_V l3
22600: , AR_DISTRIBUTIONS_L_V l4
22601: , AR_RECEIVABLES_TRX_ACT_S_V l6
22602: , AR_TRANSACTIONS_S_V l9
22603: , (select rownum r from all_objects where rownum <= 29 and owner = p_apps_owner)
22604: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
22605: AND xet.event_class_code = C_EVENT_CLASS_CODE
22606: AND l3.event_id = xet.event_id
22607: AND l2.event_id (+) = l3.event_id