DBA Data[Home] [Help]

APPS.XLA_00707_AAD_S_000019_PKG dependencies on CST_XLA_RES_OVH_REF_V

Line 417435: WHEN 2 THEN 'CST_XLA_RES_OVH_REF_V'

417431: SELECT xet.event_id event_id
417432: , l4.line_number line_number
417433: , CASE r
417434: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
417435: WHEN 2 THEN 'CST_XLA_RES_OVH_REF_V'
417436: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
417437: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
417438: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
417439: WHEN 6 THEN 'CST_XLA_INV_LINES_V'

Line 417533: , CST_XLA_RES_OVH_REF_V l12

417529: END source_meaning
417530: FROM xla_events_gt xet
417531: , CST_XLA_INV_LINES_V l4
417532: , CST_XLA_INV_SEC_INVS_REF_V l7
417533: , CST_XLA_RES_OVH_REF_V l12
417534: , fnd_lookup_values fvl110
417535: ,(select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)
417536: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
417537: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 417699: TYPE t_array_source_13 IS TABLE OF CST_XLA_RES_OVH_REF_V.RES_OVH_ABSORPTION_ACCT%TYPE INDEX BY BINARY_INTEGER;

417695: TYPE t_array_source_85 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
417696: TYPE t_array_source_114 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
417697:
417698: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
417699: TYPE t_array_source_13 IS TABLE OF CST_XLA_RES_OVH_REF_V.RES_OVH_ABSORPTION_ACCT%TYPE INDEX BY BINARY_INTEGER;
417700: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.COST_ELEMENT_ID%TYPE INDEX BY BINARY_INTEGER;
417701: TYPE t_array_source_84 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
417702: TYPE t_array_source_88 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
417703: TYPE t_array_source_91 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 417896: , CST_XLA_RES_OVH_REF_V l12

417892: , fvl110.meaning source_110_meaning
417893: FROM xla_events_gt xet
417894: , CST_XLA_INV_LINES_V l4
417895: , CST_XLA_INV_SEC_INVS_REF_V l7
417896: , CST_XLA_RES_OVH_REF_V l12
417897: , fnd_lookup_values fvl110
417898: WHERE xet.event_id between x_first_event_id and x_last_event_id
417899: and xet.event_date between p_pad_start_date and p_pad_end_date
417900: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 419158: WHEN 2 THEN 'CST_XLA_RES_OVH_REF_V'

419154: SELECT xet.event_id event_id
419155: , l4.line_number line_number
419156: , CASE r
419157: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
419158: WHEN 2 THEN 'CST_XLA_RES_OVH_REF_V'
419159: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
419160: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
419161: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
419162: WHEN 6 THEN 'CST_XLA_INV_LINES_V'

Line 419256: , CST_XLA_RES_OVH_REF_V l12

419252: END source_meaning
419253: FROM xla_events_gt xet
419254: , CST_XLA_INV_LINES_V l4
419255: , CST_XLA_INV_SEC_INVS_REF_V l7
419256: , CST_XLA_RES_OVH_REF_V l12
419257: , fnd_lookup_values fvl110
419258: ,(select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)
419259: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
419260: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 419422: TYPE t_array_source_13 IS TABLE OF CST_XLA_RES_OVH_REF_V.RES_OVH_ABSORPTION_ACCT%TYPE INDEX BY BINARY_INTEGER;

419418: TYPE t_array_source_85 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
419419: TYPE t_array_source_114 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
419420:
419421: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
419422: TYPE t_array_source_13 IS TABLE OF CST_XLA_RES_OVH_REF_V.RES_OVH_ABSORPTION_ACCT%TYPE INDEX BY BINARY_INTEGER;
419423: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.COST_ELEMENT_ID%TYPE INDEX BY BINARY_INTEGER;
419424: TYPE t_array_source_84 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
419425: TYPE t_array_source_88 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
419426: TYPE t_array_source_91 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 419619: , CST_XLA_RES_OVH_REF_V l12

419615: , fvl110.meaning source_110_meaning
419616: FROM xla_events_gt xet
419617: , CST_XLA_INV_LINES_V l4
419618: , CST_XLA_INV_SEC_INVS_REF_V l7
419619: , CST_XLA_RES_OVH_REF_V l12
419620: , fnd_lookup_values fvl110
419621: WHERE xet.event_id between x_first_event_id and x_last_event_id
419622: and xet.event_date between p_pad_start_date and p_pad_end_date
419623: and xet.event_type_code = C_EVENT_TYPE_CODE