DBA Data[Home] [Help]

APPS.XLA_00275_AAD_S_000015_PKG dependencies on PA_XLA_EVENT_TYPE_REF_V

Line 92303: WHEN 25 THEN 'PA_XLA_EVENT_TYPE_REF_V'

92299: WHEN 21 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92300: WHEN 22 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92301: WHEN 23 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92302: WHEN 24 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92303: WHEN 25 THEN 'PA_XLA_EVENT_TYPE_REF_V'
92304:
92305: ELSE null
92306: END object_name
92307: , CASE r

Line 92430: , PA_XLA_EVENT_TYPE_REF_V l1

92426:
92427: ELSE null
92428: END source_meaning
92429: FROM xla_events_gt xet
92430: , PA_XLA_EVENT_TYPE_REF_V l1
92431: , PA_XLA_REVENUE_LINES_ADJ_V l3
92432: , fnd_lookup_values fvl72
92433: , (select rownum r from all_objects where rownum <= 25 and owner = p_apps_owner)
92434: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 92602: TYPE t_array_source_72 IS TABLE OF PA_XLA_EVENT_TYPE_REF_V.REV_EVENT_TYPE_CLASSIFICATION%TYPE INDEX BY BINARY_INTEGER;

92598: TYPE t_array_source_68 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
92599: TYPE t_array_source_69 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PROJECT_ID%TYPE INDEX BY BINARY_INTEGER;
92600: TYPE t_array_source_70 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
92601: TYPE t_array_source_71 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_DRAFT_REV_NUM_CREDITED%TYPE INDEX BY BINARY_INTEGER;
92602: TYPE t_array_source_72 IS TABLE OF PA_XLA_EVENT_TYPE_REF_V.REV_EVENT_TYPE_CLASSIFICATION%TYPE INDEX BY BINARY_INTEGER;
92603:
92604: l_array_source_48 t_array_source_48;
92605: l_array_source_51 t_array_source_51;
92606: l_array_source_75 t_array_source_75;

Line 92738: , PA_XLA_EVENT_TYPE_REF_V l1

92734: , l3.PDR_DRAFT_REV_NUM_CREDITED source_71
92735: , l1.REV_EVENT_TYPE_CLASSIFICATION source_72
92736: , fvl72.meaning source_72_meaning
92737: FROM xla_events_gt xet
92738: , PA_XLA_EVENT_TYPE_REF_V l1
92739: , PA_XLA_REVENUE_LINES_ADJ_V l3
92740: , fnd_lookup_values fvl72
92741: WHERE xet.event_id between x_first_event_id and x_last_event_id
92742: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 94064: WHEN 17 THEN 'PA_XLA_EVENT_TYPE_REF_V'

94060: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_V'
94061: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_V'
94062: WHEN 15 THEN 'PA_XLA_REVENUE_LINES_V'
94063: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_V'
94064: WHEN 17 THEN 'PA_XLA_EVENT_TYPE_REF_V'
94065:
94066: ELSE null
94067: END object_name
94068: , CASE r

Line 94159: , PA_XLA_EVENT_TYPE_REF_V l1

94155:
94156: ELSE null
94157: END source_meaning
94158: FROM xla_events_gt xet
94159: , PA_XLA_EVENT_TYPE_REF_V l1
94160: , PA_XLA_REVENUE_LINES_V l3
94161: , fnd_lookup_values fvl72
94162: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
94163: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 94323: TYPE t_array_source_72 IS TABLE OF PA_XLA_EVENT_TYPE_REF_V.REV_EVENT_TYPE_CLASSIFICATION%TYPE INDEX BY BINARY_INTEGER;

94319: TYPE t_array_source_46 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
94320: TYPE t_array_source_47 IS TABLE OF PA_XLA_REVENUE_LINES_V.SYSTEM_LINKAGE_FUNCTION%TYPE INDEX BY BINARY_INTEGER;
94321: TYPE t_array_source_49 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
94322: TYPE t_array_source_50 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
94323: TYPE t_array_source_72 IS TABLE OF PA_XLA_EVENT_TYPE_REF_V.REV_EVENT_TYPE_CLASSIFICATION%TYPE INDEX BY BINARY_INTEGER;
94324:
94325: l_array_source_48 t_array_source_48;
94326: l_array_source_51 t_array_source_51;
94327: l_array_source_75 t_array_source_75;

Line 94443: , PA_XLA_EVENT_TYPE_REF_V l1

94439: , l3.REVENUE_SECOND_DIST_ID source_50
94440: , l1.REV_EVENT_TYPE_CLASSIFICATION source_72
94441: , fvl72.meaning source_72_meaning
94442: FROM xla_events_gt xet
94443: , PA_XLA_EVENT_TYPE_REF_V l1
94444: , PA_XLA_REVENUE_LINES_V l3
94445: , fnd_lookup_values fvl72
94446: WHERE xet.event_id between x_first_event_id and x_last_event_id
94447: and xet.event_date between p_pad_start_date and p_pad_end_date