DBA Data[Home] [Help]

APPS.XLA_09000_AAD_S_000015_PKG dependencies on ALL_OBJECTS

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

6648: END source_value
6649: , null source_meaning
6650: FROM xla_events_gt xet
6651: , DPP_XLA_INV_HEADERS_V h1
6652: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
6653: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
6654: AND xet.event_class_code = C_EVENT_CLASS_CODE
6655: AND h1.event_id = xet.event_id
6656:

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

6766: END source_value
6767: , null source_meaning
6768: FROM xla_events_gt xet
6769: , DPP_XLA_INV_LINES_V l2
6770: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
6771: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
6772: AND xet.event_class_code = C_EVENT_CLASS_CODE
6773: AND l2.event_id = xet.event_id
6774:

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

7818: END source_value
7819: , null source_meaning
7820: FROM xla_events_gt xet
7821: , DPP_XLA_CLAIM_HEADERS_V h1
7822: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
7823: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
7824: AND xet.event_type_code = C_EVENT_TYPE_CODE
7825: AND h1.event_id = xet.event_id
7826:

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

7940: END source_value
7941: , null source_meaning
7942: FROM xla_events_gt xet
7943: , DPP_XLA_CLAIM_LINES_V l2
7944: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
7945: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
7946: AND xet.event_type_code = C_EVENT_TYPE_CODE
7947: AND l2.event_id = xet.event_id
7948:

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

9007: END source_value
9008: , null source_meaning
9009: FROM xla_events_gt xet
9010: , DPP_XLA_CLAIM_HEADERS_V h1
9011: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
9012: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
9013: AND xet.event_type_code = C_EVENT_TYPE_CODE
9014: AND h1.event_id = xet.event_id
9015:

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

9119: END source_value
9120: , null source_meaning
9121: FROM xla_events_gt xet
9122: , DPP_XLA_CLAIM_LINES_V l2
9123: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)
9124: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
9125: AND xet.event_type_code = C_EVENT_TYPE_CODE
9126: AND l2.event_id = xet.event_id
9127:

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

10175: END source_value
10176: , null source_meaning
10177: FROM xla_events_gt xet
10178: , DPP_XLA_CLAIM_HEADERS_V h1
10179: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
10180: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
10181: AND xet.event_type_code = C_EVENT_TYPE_CODE
10182: AND h1.event_id = xet.event_id
10183:

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

10297: END source_value
10298: , null source_meaning
10299: FROM xla_events_gt xet
10300: , DPP_XLA_CLAIM_LINES_V l2
10301: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
10302: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
10303: AND xet.event_type_code = C_EVENT_TYPE_CODE
10304: AND l2.event_id = xet.event_id
10305:

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

11369: END source_value
11370: , null source_meaning
11371: FROM xla_events_gt xet
11372: , DPP_XLA_CLAIM_HEADERS_V h1
11373: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
11374: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
11375: AND xet.event_type_code = C_EVENT_TYPE_CODE
11376: AND h1.event_id = xet.event_id
11377:

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

11491: END source_value
11492: , null source_meaning
11493: FROM xla_events_gt xet
11494: , DPP_XLA_CLAIM_LINES_V l2
11495: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
11496: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
11497: AND xet.event_type_code = C_EVENT_TYPE_CODE
11498: AND l2.event_id = xet.event_id
11499: