DBA Data[Home] [Help]

APPS.XLA_00275_AAD_S_000016_PKG dependencies on PA_XLA_EVENT_TYPE_REF_V

Line 73322: WHEN 15 THEN 'PA_XLA_EVENT_TYPE_REF_V'

73318: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73319: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73320: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73321: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73322: WHEN 15 THEN 'PA_XLA_EVENT_TYPE_REF_V'
73323: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73324: WHEN 17 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73325: WHEN 18 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73326: WHEN 19 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 73449: , PA_XLA_EVENT_TYPE_REF_V l1

73445:
73446: ELSE null
73447: END source_meaning
73448: FROM xla_events_gt xet
73449: , PA_XLA_EVENT_TYPE_REF_V l1
73450: , PA_XLA_REVENUE_LINES_ADJ_V l3
73451: , fnd_lookup_values fvl58
73452: , (select rownum r from all_objects where rownum <= 23 and owner = p_apps_owner)
73453: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 73611: TYPE t_array_source_58 IS TABLE OF PA_XLA_EVENT_TYPE_REF_V.REV_EVENT_TYPE_CLASSIFICATION%TYPE INDEX BY BINARY_INTEGER;

73607: TYPE t_array_source_39 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73608: TYPE t_array_source_40 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73609: TYPE t_array_source_41 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
73610: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
73611: TYPE t_array_source_58 IS TABLE OF PA_XLA_EVENT_TYPE_REF_V.REV_EVENT_TYPE_CLASSIFICATION%TYPE INDEX BY BINARY_INTEGER;
73612: TYPE t_array_source_59 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
73613: TYPE t_array_source_60 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
73614: TYPE t_array_source_61 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
73615: TYPE t_array_source_62 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 73751: , PA_XLA_EVENT_TYPE_REF_V l1

73747: , l3.PROJECT_ID source_64
73748: , l3.CR_REVENUE_SECOND_DIST_ID source_65
73749: , l3.PDR_DRAFT_REV_NUM_CREDITED source_66
73750: FROM xla_events_gt xet
73751: , PA_XLA_EVENT_TYPE_REF_V l1
73752: , PA_XLA_REVENUE_LINES_ADJ_V l3
73753: , fnd_lookup_values fvl58
73754: WHERE xet.event_id between x_first_event_id and x_last_event_id
73755: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 74866: WHEN 17 THEN 'PA_XLA_EVENT_TYPE_REF_V'

74862: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_V'
74863: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_V'
74864: WHEN 15 THEN 'PA_XLA_REVENUE_LINES_V'
74865: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_V'
74866: WHEN 17 THEN 'PA_XLA_EVENT_TYPE_REF_V'
74867:
74868: ELSE null
74869: END object_name
74870: , CASE r

Line 74961: , PA_XLA_EVENT_TYPE_REF_V l1

74957:
74958: ELSE null
74959: END source_meaning
74960: FROM xla_events_gt xet
74961: , PA_XLA_EVENT_TYPE_REF_V l1
74962: , PA_XLA_REVENUE_LINES_V l3
74963: , fnd_lookup_values fvl58
74964: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
74965: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 75125: TYPE t_array_source_58 IS TABLE OF PA_XLA_EVENT_TYPE_REF_V.REV_EVENT_TYPE_CLASSIFICATION%TYPE INDEX BY BINARY_INTEGER;

75121: TYPE t_array_source_39 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
75122: TYPE t_array_source_40 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
75123: TYPE t_array_source_41 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
75124: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
75125: TYPE t_array_source_58 IS TABLE OF PA_XLA_EVENT_TYPE_REF_V.REV_EVENT_TYPE_CLASSIFICATION%TYPE INDEX BY BINARY_INTEGER;
75126:
75127: l_array_source_38 t_array_source_38;
75128: l_array_source_42 t_array_source_42;
75129: l_array_source_88 t_array_source_88;

Line 75245: , PA_XLA_EVENT_TYPE_REF_V l1

75241: , l3.ACCT_AMOUNT source_43
75242: , l1.REV_EVENT_TYPE_CLASSIFICATION source_58
75243: , fvl58.meaning source_58_meaning
75244: FROM xla_events_gt xet
75245: , PA_XLA_EVENT_TYPE_REF_V l1
75246: , PA_XLA_REVENUE_LINES_V l3
75247: , fnd_lookup_values fvl58
75248: WHERE xet.event_id between x_first_event_id and x_last_event_id
75249: and xet.event_date between p_pad_start_date and p_pad_end_date