eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_00275_AAD_S_000004_PKG dependencies on PA_XLA_EVENT_TYPE_REF_V

Line 73214: WHEN 15 THEN 'PA_XLA_EVENT_TYPE_REF_V'

73210: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73211: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73212: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73213: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73214: WHEN 15 THEN 'PA_XLA_EVENT_TYPE_REF_V'
73215: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73216: WHEN 17 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73217: WHEN 18 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73218: WHEN 19 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 73341: , PA_XLA_EVENT_TYPE_REF_V l1

73337:
73338: ELSE null
73339: END source_meaning
73340: FROM xla_events_gt xet
73341: , PA_XLA_EVENT_TYPE_REF_V l1
73342: , PA_XLA_REVENUE_LINES_ADJ_V l3
73343: , fnd_lookup_values fvl58
73344: , (select rownum r from all_objects where rownum <= 23 and owner = p_apps_owner)
73345: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

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

73499: TYPE t_array_source_39 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73500: TYPE t_array_source_40 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73501: TYPE t_array_source_41 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
73502: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
73503: TYPE t_array_source_58 IS TABLE OF PA_XLA_EVENT_TYPE_REF_V.REV_EVENT_TYPE_CLASSIFICATION%TYPE INDEX BY BINARY_INTEGER;
73504: TYPE t_array_source_59 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
73505: TYPE t_array_source_60 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
73506: TYPE t_array_source_61 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
73507: TYPE t_array_source_62 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 73643: , PA_XLA_EVENT_TYPE_REF_V l1

73639: , l3.PROJECT_ID source_64
73640: , l3.CR_REVENUE_SECOND_DIST_ID source_65
73641: , l3.PDR_DRAFT_REV_NUM_CREDITED source_66
73642: FROM xla_events_gt xet
73643: , PA_XLA_EVENT_TYPE_REF_V l1
73644: , PA_XLA_REVENUE_LINES_ADJ_V l3
73645: , fnd_lookup_values fvl58
73646: WHERE xet.event_id between x_first_event_id and x_last_event_id
73647: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 74758: WHEN 17 THEN 'PA_XLA_EVENT_TYPE_REF_V'

74754: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_V'
74755: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_V'
74756: WHEN 15 THEN 'PA_XLA_REVENUE_LINES_V'
74757: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_V'
74758: WHEN 17 THEN 'PA_XLA_EVENT_TYPE_REF_V'
74759:
74760: ELSE null
74761: END object_name
74762: , CASE r

Line 74853: , PA_XLA_EVENT_TYPE_REF_V l1

74849:
74850: ELSE null
74851: END source_meaning
74852: FROM xla_events_gt xet
74853: , PA_XLA_EVENT_TYPE_REF_V l1
74854: , PA_XLA_REVENUE_LINES_V l3
74855: , fnd_lookup_values fvl58
74856: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
74857: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

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

75013: TYPE t_array_source_39 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
75014: TYPE t_array_source_40 IS TABLE OF PA_XLA_REVENUE_LINES_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
75015: TYPE t_array_source_41 IS TABLE OF PA_XLA_REVENUE_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
75016: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
75017: TYPE t_array_source_58 IS TABLE OF PA_XLA_EVENT_TYPE_REF_V.REV_EVENT_TYPE_CLASSIFICATION%TYPE INDEX BY BINARY_INTEGER;
75018:
75019: l_array_source_38 t_array_source_38;
75020: l_array_source_42 t_array_source_42;
75021: l_array_source_87 t_array_source_87;

Line 75137: , PA_XLA_EVENT_TYPE_REF_V l1

75133: , l3.ACCT_AMOUNT source_43
75134: , l1.REV_EVENT_TYPE_CLASSIFICATION source_58
75135: , fvl58.meaning source_58_meaning
75136: FROM xla_events_gt xet
75137: , PA_XLA_EVENT_TYPE_REF_V l1
75138: , PA_XLA_REVENUE_LINES_V l3
75139: , fnd_lookup_values fvl58
75140: WHERE xet.event_id between x_first_event_id and x_last_event_id
75141: and xet.event_date between p_pad_start_date and p_pad_end_date