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_000016_PKG dependencies on PA_XLA_REVENUE_HEADERS_V

Line 73181: WHEN 1 THEN 'PA_XLA_REVENUE_HEADERS_V'

73177: FROM (
73178: SELECT xet.event_id event_id
73179: , 0 line_number
73180: , CASE r
73181: WHEN 1 THEN 'PA_XLA_REVENUE_HEADERS_V'
73182: WHEN 2 THEN 'PA_XLA_REVENUE_HEADERS_V'
73183: WHEN 3 THEN 'PA_XLA_REVENUE_HEADERS_V'
73184: WHEN 4 THEN 'PA_XLA_REVENUE_HEADERS_V'
73185: WHEN 5 THEN 'PA_XLA_REVENUE_HEADERS_V'

Line 73182: WHEN 2 THEN 'PA_XLA_REVENUE_HEADERS_V'

73178: SELECT xet.event_id event_id
73179: , 0 line_number
73180: , CASE r
73181: WHEN 1 THEN 'PA_XLA_REVENUE_HEADERS_V'
73182: WHEN 2 THEN 'PA_XLA_REVENUE_HEADERS_V'
73183: WHEN 3 THEN 'PA_XLA_REVENUE_HEADERS_V'
73184: WHEN 4 THEN 'PA_XLA_REVENUE_HEADERS_V'
73185: WHEN 5 THEN 'PA_XLA_REVENUE_HEADERS_V'
73186:

Line 73183: WHEN 3 THEN 'PA_XLA_REVENUE_HEADERS_V'

73179: , 0 line_number
73180: , CASE r
73181: WHEN 1 THEN 'PA_XLA_REVENUE_HEADERS_V'
73182: WHEN 2 THEN 'PA_XLA_REVENUE_HEADERS_V'
73183: WHEN 3 THEN 'PA_XLA_REVENUE_HEADERS_V'
73184: WHEN 4 THEN 'PA_XLA_REVENUE_HEADERS_V'
73185: WHEN 5 THEN 'PA_XLA_REVENUE_HEADERS_V'
73186:
73187: ELSE null

Line 73184: WHEN 4 THEN 'PA_XLA_REVENUE_HEADERS_V'

73180: , CASE r
73181: WHEN 1 THEN 'PA_XLA_REVENUE_HEADERS_V'
73182: WHEN 2 THEN 'PA_XLA_REVENUE_HEADERS_V'
73183: WHEN 3 THEN 'PA_XLA_REVENUE_HEADERS_V'
73184: WHEN 4 THEN 'PA_XLA_REVENUE_HEADERS_V'
73185: WHEN 5 THEN 'PA_XLA_REVENUE_HEADERS_V'
73186:
73187: ELSE null
73188: END object_name

Line 73185: WHEN 5 THEN 'PA_XLA_REVENUE_HEADERS_V'

73181: WHEN 1 THEN 'PA_XLA_REVENUE_HEADERS_V'
73182: WHEN 2 THEN 'PA_XLA_REVENUE_HEADERS_V'
73183: WHEN 3 THEN 'PA_XLA_REVENUE_HEADERS_V'
73184: WHEN 4 THEN 'PA_XLA_REVENUE_HEADERS_V'
73185: WHEN 5 THEN 'PA_XLA_REVENUE_HEADERS_V'
73186:
73187: ELSE null
73188: END object_name
73189: , CASE r

Line 73237: , PA_XLA_REVENUE_HEADERS_V h2

73233:
73234: ELSE null
73235: END source_meaning
73236: FROM xla_events_gt xet
73237: , PA_XLA_REVENUE_HEADERS_V h2
73238: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
73239: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
73240: AND xet.event_class_code = C_EVENT_CLASS_CODE
73241: AND h2.event_id = xet.event_id

Line 73591: TYPE t_array_source_38 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.CREDITING_REVENUE_FLAG%TYPE INDEX BY BINARY_INTEGER;

73587: --
73588: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
73589: --
73590:
73591: TYPE t_array_source_38 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.CREDITING_REVENUE_FLAG%TYPE INDEX BY BINARY_INTEGER;
73592: TYPE t_array_source_42 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;
73593: TYPE t_array_source_88 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
73594: TYPE t_array_source_92 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UER_CCID%TYPE INDEX BY BINARY_INTEGER;
73595: TYPE t_array_source_93 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 73592: TYPE t_array_source_42 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;

73588: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
73589: --
73590:
73591: TYPE t_array_source_38 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.CREDITING_REVENUE_FLAG%TYPE INDEX BY BINARY_INTEGER;
73592: TYPE t_array_source_42 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;
73593: TYPE t_array_source_88 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
73594: TYPE t_array_source_92 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UER_CCID%TYPE INDEX BY BINARY_INTEGER;
73595: TYPE t_array_source_93 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
73596:

Line 73593: TYPE t_array_source_88 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

73589: --
73590:
73591: TYPE t_array_source_38 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.CREDITING_REVENUE_FLAG%TYPE INDEX BY BINARY_INTEGER;
73592: TYPE t_array_source_42 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;
73593: TYPE t_array_source_88 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
73594: TYPE t_array_source_92 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UER_CCID%TYPE INDEX BY BINARY_INTEGER;
73595: TYPE t_array_source_93 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
73596:
73597: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 73594: TYPE t_array_source_92 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UER_CCID%TYPE INDEX BY BINARY_INTEGER;

73590:
73591: TYPE t_array_source_38 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.CREDITING_REVENUE_FLAG%TYPE INDEX BY BINARY_INTEGER;
73592: TYPE t_array_source_42 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;
73593: TYPE t_array_source_88 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
73594: TYPE t_array_source_92 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UER_CCID%TYPE INDEX BY BINARY_INTEGER;
73595: TYPE t_array_source_93 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
73596:
73597: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
73598: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 73595: TYPE t_array_source_93 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;

73591: TYPE t_array_source_38 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.CREDITING_REVENUE_FLAG%TYPE INDEX BY BINARY_INTEGER;
73592: TYPE t_array_source_42 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;
73593: TYPE t_array_source_88 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
73594: TYPE t_array_source_92 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UER_CCID%TYPE INDEX BY BINARY_INTEGER;
73595: TYPE t_array_source_93 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
73596:
73597: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
73598: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;
73599: TYPE t_array_source_23 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 73687: , PA_XLA_REVENUE_HEADERS_V h2

73683: , h2.GL_DATE source_88
73684: , h2.UER_CCID source_92
73685: , h2.UBR_CCID source_93
73686: FROM xla_events_gt xet
73687: , PA_XLA_REVENUE_HEADERS_V h2
73688: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
73689: and xet.event_class_code = C_EVENT_CLASS_CODE
73690: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
73691:

Line 74723: WHEN 1 THEN 'PA_XLA_REVENUE_HEADERS_V'

74719: FROM (
74720: SELECT xet.event_id event_id
74721: , 0 line_number
74722: , CASE r
74723: WHEN 1 THEN 'PA_XLA_REVENUE_HEADERS_V'
74724: WHEN 2 THEN 'PA_XLA_REVENUE_HEADERS_V'
74725: WHEN 3 THEN 'PA_XLA_REVENUE_HEADERS_V'
74726: WHEN 4 THEN 'PA_XLA_REVENUE_HEADERS_V'
74727: WHEN 5 THEN 'PA_XLA_REVENUE_HEADERS_V'

Line 74724: WHEN 2 THEN 'PA_XLA_REVENUE_HEADERS_V'

74720: SELECT xet.event_id event_id
74721: , 0 line_number
74722: , CASE r
74723: WHEN 1 THEN 'PA_XLA_REVENUE_HEADERS_V'
74724: WHEN 2 THEN 'PA_XLA_REVENUE_HEADERS_V'
74725: WHEN 3 THEN 'PA_XLA_REVENUE_HEADERS_V'
74726: WHEN 4 THEN 'PA_XLA_REVENUE_HEADERS_V'
74727: WHEN 5 THEN 'PA_XLA_REVENUE_HEADERS_V'
74728:

Line 74725: WHEN 3 THEN 'PA_XLA_REVENUE_HEADERS_V'

74721: , 0 line_number
74722: , CASE r
74723: WHEN 1 THEN 'PA_XLA_REVENUE_HEADERS_V'
74724: WHEN 2 THEN 'PA_XLA_REVENUE_HEADERS_V'
74725: WHEN 3 THEN 'PA_XLA_REVENUE_HEADERS_V'
74726: WHEN 4 THEN 'PA_XLA_REVENUE_HEADERS_V'
74727: WHEN 5 THEN 'PA_XLA_REVENUE_HEADERS_V'
74728:
74729: ELSE null

Line 74726: WHEN 4 THEN 'PA_XLA_REVENUE_HEADERS_V'

74722: , CASE r
74723: WHEN 1 THEN 'PA_XLA_REVENUE_HEADERS_V'
74724: WHEN 2 THEN 'PA_XLA_REVENUE_HEADERS_V'
74725: WHEN 3 THEN 'PA_XLA_REVENUE_HEADERS_V'
74726: WHEN 4 THEN 'PA_XLA_REVENUE_HEADERS_V'
74727: WHEN 5 THEN 'PA_XLA_REVENUE_HEADERS_V'
74728:
74729: ELSE null
74730: END object_name

Line 74727: WHEN 5 THEN 'PA_XLA_REVENUE_HEADERS_V'

74723: WHEN 1 THEN 'PA_XLA_REVENUE_HEADERS_V'
74724: WHEN 2 THEN 'PA_XLA_REVENUE_HEADERS_V'
74725: WHEN 3 THEN 'PA_XLA_REVENUE_HEADERS_V'
74726: WHEN 4 THEN 'PA_XLA_REVENUE_HEADERS_V'
74727: WHEN 5 THEN 'PA_XLA_REVENUE_HEADERS_V'
74728:
74729: ELSE null
74730: END object_name
74731: , CASE r

Line 74779: , PA_XLA_REVENUE_HEADERS_V h2

74775:
74776: ELSE null
74777: END source_meaning
74778: FROM xla_events_gt xet
74779: , PA_XLA_REVENUE_HEADERS_V h2
74780: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
74781: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
74782: AND xet.event_class_code = C_EVENT_CLASS_CODE
74783: AND h2.event_id = xet.event_id

Line 75103: TYPE t_array_source_38 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.CREDITING_REVENUE_FLAG%TYPE INDEX BY BINARY_INTEGER;

75099: --
75100: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
75101: --
75102:
75103: TYPE t_array_source_38 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.CREDITING_REVENUE_FLAG%TYPE INDEX BY BINARY_INTEGER;
75104: TYPE t_array_source_42 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;
75105: TYPE t_array_source_88 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
75106: TYPE t_array_source_92 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UER_CCID%TYPE INDEX BY BINARY_INTEGER;
75107: TYPE t_array_source_93 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 75104: TYPE t_array_source_42 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;

75100: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
75101: --
75102:
75103: TYPE t_array_source_38 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.CREDITING_REVENUE_FLAG%TYPE INDEX BY BINARY_INTEGER;
75104: TYPE t_array_source_42 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;
75105: TYPE t_array_source_88 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
75106: TYPE t_array_source_92 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UER_CCID%TYPE INDEX BY BINARY_INTEGER;
75107: TYPE t_array_source_93 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
75108:

Line 75105: TYPE t_array_source_88 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

75101: --
75102:
75103: TYPE t_array_source_38 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.CREDITING_REVENUE_FLAG%TYPE INDEX BY BINARY_INTEGER;
75104: TYPE t_array_source_42 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;
75105: TYPE t_array_source_88 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
75106: TYPE t_array_source_92 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UER_CCID%TYPE INDEX BY BINARY_INTEGER;
75107: TYPE t_array_source_93 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
75108:
75109: TYPE t_array_source_1 IS TABLE OF PA_XLA_REVENUE_LINES_V.PERDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 75106: TYPE t_array_source_92 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UER_CCID%TYPE INDEX BY BINARY_INTEGER;

75102:
75103: TYPE t_array_source_38 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.CREDITING_REVENUE_FLAG%TYPE INDEX BY BINARY_INTEGER;
75104: TYPE t_array_source_42 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;
75105: TYPE t_array_source_88 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
75106: TYPE t_array_source_92 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UER_CCID%TYPE INDEX BY BINARY_INTEGER;
75107: TYPE t_array_source_93 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
75108:
75109: TYPE t_array_source_1 IS TABLE OF PA_XLA_REVENUE_LINES_V.PERDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
75110: TYPE t_array_source_16 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_GAINS_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 75107: TYPE t_array_source_93 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;

75103: TYPE t_array_source_38 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.CREDITING_REVENUE_FLAG%TYPE INDEX BY BINARY_INTEGER;
75104: TYPE t_array_source_42 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;
75105: TYPE t_array_source_88 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
75106: TYPE t_array_source_92 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UER_CCID%TYPE INDEX BY BINARY_INTEGER;
75107: TYPE t_array_source_93 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
75108:
75109: TYPE t_array_source_1 IS TABLE OF PA_XLA_REVENUE_LINES_V.PERDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
75110: TYPE t_array_source_16 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_GAINS_CCID%TYPE INDEX BY BINARY_INTEGER;
75111: TYPE t_array_source_17 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_LOSSES_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 75187: , PA_XLA_REVENUE_HEADERS_V h2

75183: , h2.GL_DATE source_88
75184: , h2.UER_CCID source_92
75185: , h2.UBR_CCID source_93
75186: FROM xla_events_gt xet
75187: , PA_XLA_REVENUE_HEADERS_V h2
75188: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
75189: and xet.event_class_code = C_EVENT_CLASS_CODE
75190: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
75191: