DBA Data[Home] [Help]

APPS.XLA_08901_AAD_S_000002_PKG dependencies on ALL_OBJECTS

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

5884: END source_value
5885: , null source_meaning
5886: FROM xla_events_gt xet
5887: , FV_BE_BA_FD_HDR_V h1
5888: ,(select rownum r from all_objects where rownum <= 1 and owner = p_apps_owner)
5889: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
5890: AND xet.event_class_code = C_EVENT_CLASS_CODE
5891: AND h1.event_id = xet.event_id
5892:

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

6773: END source_value
6774: , null source_meaning
6775: FROM xla_events_gt xet
6776: , FV_BE_RPR_HDR_V h1
6777: ,(select rownum r from all_objects where rownum <= 1 and owner = p_apps_owner)
6778: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
6779: AND xet.event_class_code = C_EVENT_CLASS_CODE
6780: AND h1.event_id = xet.event_id
6781:

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

7678: FROM xla_events_gt xet
7679: , AP_SYSTEM_PARAMETERS_EXTRACT_V h1
7680: , FV_TREASURY_EXTRACT_HEADER_V h3
7681: , fnd_lookup_values fvl9
7682: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
7683: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
7684: AND xet.event_class_code = C_EVENT_CLASS_CODE
7685: AND h3.event_id = xet.event_id
7686: AND h3.org_id = h1.asp_org_id AND fvl9.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'

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

7875: END source_value
7876: , null source_meaning
7877: FROM xla_events_gt xet
7878: , FV_TREASURY_EXTRACT_DETAILS_V l2
7879: , (select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)
7880: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
7881: AND xet.event_class_code = C_EVENT_CLASS_CODE
7882: AND l2.event_id = xet.event_id
7883: