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

Line 92152: WHEN 1 THEN 'PA_XLA_REVENUE_HEADERS_V'

92148: FROM (
92149: SELECT xet.event_id event_id
92150: , 0 line_number
92151: , CASE r
92152: WHEN 1 THEN 'PA_XLA_REVENUE_HEADERS_V'
92153: WHEN 2 THEN 'PA_XLA_REVENUE_HEADERS_V'
92154: WHEN 3 THEN 'PA_XLA_REVENUE_HEADERS_V'
92155: WHEN 4 THEN 'PA_XLA_REVENUE_HEADERS_V'
92156: WHEN 5 THEN 'PA_XLA_REVENUE_HEADERS_V'

Line 92153: WHEN 2 THEN 'PA_XLA_REVENUE_HEADERS_V'

92149: SELECT xet.event_id event_id
92150: , 0 line_number
92151: , CASE r
92152: WHEN 1 THEN 'PA_XLA_REVENUE_HEADERS_V'
92153: WHEN 2 THEN 'PA_XLA_REVENUE_HEADERS_V'
92154: WHEN 3 THEN 'PA_XLA_REVENUE_HEADERS_V'
92155: WHEN 4 THEN 'PA_XLA_REVENUE_HEADERS_V'
92156: WHEN 5 THEN 'PA_XLA_REVENUE_HEADERS_V'
92157:

Line 92154: WHEN 3 THEN 'PA_XLA_REVENUE_HEADERS_V'

92150: , 0 line_number
92151: , CASE r
92152: WHEN 1 THEN 'PA_XLA_REVENUE_HEADERS_V'
92153: WHEN 2 THEN 'PA_XLA_REVENUE_HEADERS_V'
92154: WHEN 3 THEN 'PA_XLA_REVENUE_HEADERS_V'
92155: WHEN 4 THEN 'PA_XLA_REVENUE_HEADERS_V'
92156: WHEN 5 THEN 'PA_XLA_REVENUE_HEADERS_V'
92157:
92158: ELSE null

Line 92155: WHEN 4 THEN 'PA_XLA_REVENUE_HEADERS_V'

92151: , CASE r
92152: WHEN 1 THEN 'PA_XLA_REVENUE_HEADERS_V'
92153: WHEN 2 THEN 'PA_XLA_REVENUE_HEADERS_V'
92154: WHEN 3 THEN 'PA_XLA_REVENUE_HEADERS_V'
92155: WHEN 4 THEN 'PA_XLA_REVENUE_HEADERS_V'
92156: WHEN 5 THEN 'PA_XLA_REVENUE_HEADERS_V'
92157:
92158: ELSE null
92159: END object_name

Line 92156: WHEN 5 THEN 'PA_XLA_REVENUE_HEADERS_V'

92152: WHEN 1 THEN 'PA_XLA_REVENUE_HEADERS_V'
92153: WHEN 2 THEN 'PA_XLA_REVENUE_HEADERS_V'
92154: WHEN 3 THEN 'PA_XLA_REVENUE_HEADERS_V'
92155: WHEN 4 THEN 'PA_XLA_REVENUE_HEADERS_V'
92156: WHEN 5 THEN 'PA_XLA_REVENUE_HEADERS_V'
92157:
92158: ELSE null
92159: END object_name
92160: , CASE r

Line 92208: , PA_XLA_REVENUE_HEADERS_V h2

92204:
92205: ELSE null
92206: END source_meaning
92207: FROM xla_events_gt xet
92208: , PA_XLA_REVENUE_HEADERS_V h2
92209: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
92210: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
92211: AND xet.event_class_code = C_EVENT_CLASS_CODE
92212: AND h2.event_id = xet.event_id

Line 92572: TYPE t_array_source_48 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.CREDITING_REVENUE_FLAG%TYPE INDEX BY BINARY_INTEGER;

92568: --
92569: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
92570: --
92571:
92572: TYPE t_array_source_48 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.CREDITING_REVENUE_FLAG%TYPE INDEX BY BINARY_INTEGER;
92573: TYPE t_array_source_51 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;
92574: TYPE t_array_source_75 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
92575: TYPE t_array_source_77 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UER_CCID%TYPE INDEX BY BINARY_INTEGER;
92576: TYPE t_array_source_78 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 92573: TYPE t_array_source_51 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;

92569: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
92570: --
92571:
92572: TYPE t_array_source_48 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.CREDITING_REVENUE_FLAG%TYPE INDEX BY BINARY_INTEGER;
92573: TYPE t_array_source_51 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;
92574: TYPE t_array_source_75 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
92575: TYPE t_array_source_77 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UER_CCID%TYPE INDEX BY BINARY_INTEGER;
92576: TYPE t_array_source_78 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
92577:

Line 92574: TYPE t_array_source_75 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

92570: --
92571:
92572: TYPE t_array_source_48 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.CREDITING_REVENUE_FLAG%TYPE INDEX BY BINARY_INTEGER;
92573: TYPE t_array_source_51 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;
92574: TYPE t_array_source_75 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
92575: TYPE t_array_source_77 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UER_CCID%TYPE INDEX BY BINARY_INTEGER;
92576: TYPE t_array_source_78 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
92577:
92578: TYPE t_array_source_1 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PERDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 92575: TYPE t_array_source_77 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UER_CCID%TYPE INDEX BY BINARY_INTEGER;

92571:
92572: TYPE t_array_source_48 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.CREDITING_REVENUE_FLAG%TYPE INDEX BY BINARY_INTEGER;
92573: TYPE t_array_source_51 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;
92574: TYPE t_array_source_75 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
92575: TYPE t_array_source_77 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UER_CCID%TYPE INDEX BY BINARY_INTEGER;
92576: TYPE t_array_source_78 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
92577:
92578: TYPE t_array_source_1 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PERDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
92579: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PRDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 92576: TYPE t_array_source_78 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;

92572: TYPE t_array_source_48 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.CREDITING_REVENUE_FLAG%TYPE INDEX BY BINARY_INTEGER;
92573: TYPE t_array_source_51 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;
92574: TYPE t_array_source_75 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
92575: TYPE t_array_source_77 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UER_CCID%TYPE INDEX BY BINARY_INTEGER;
92576: TYPE t_array_source_78 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
92577:
92578: TYPE t_array_source_1 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PERDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
92579: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PRDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
92580: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 92672: , PA_XLA_REVENUE_HEADERS_V h2

92668: , h2.GL_DATE source_75
92669: , h2.UER_CCID source_77
92670: , h2.UBR_CCID source_78
92671: FROM xla_events_gt xet
92672: , PA_XLA_REVENUE_HEADERS_V h2
92673: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
92674: and xet.event_class_code = C_EVENT_CLASS_CODE
92675: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
92676:

Line 93921: WHEN 1 THEN 'PA_XLA_REVENUE_HEADERS_V'

93917: FROM (
93918: SELECT xet.event_id event_id
93919: , 0 line_number
93920: , CASE r
93921: WHEN 1 THEN 'PA_XLA_REVENUE_HEADERS_V'
93922: WHEN 2 THEN 'PA_XLA_REVENUE_HEADERS_V'
93923: WHEN 3 THEN 'PA_XLA_REVENUE_HEADERS_V'
93924: WHEN 4 THEN 'PA_XLA_REVENUE_HEADERS_V'
93925: WHEN 5 THEN 'PA_XLA_REVENUE_HEADERS_V'

Line 93922: WHEN 2 THEN 'PA_XLA_REVENUE_HEADERS_V'

93918: SELECT xet.event_id event_id
93919: , 0 line_number
93920: , CASE r
93921: WHEN 1 THEN 'PA_XLA_REVENUE_HEADERS_V'
93922: WHEN 2 THEN 'PA_XLA_REVENUE_HEADERS_V'
93923: WHEN 3 THEN 'PA_XLA_REVENUE_HEADERS_V'
93924: WHEN 4 THEN 'PA_XLA_REVENUE_HEADERS_V'
93925: WHEN 5 THEN 'PA_XLA_REVENUE_HEADERS_V'
93926:

Line 93923: WHEN 3 THEN 'PA_XLA_REVENUE_HEADERS_V'

93919: , 0 line_number
93920: , CASE r
93921: WHEN 1 THEN 'PA_XLA_REVENUE_HEADERS_V'
93922: WHEN 2 THEN 'PA_XLA_REVENUE_HEADERS_V'
93923: WHEN 3 THEN 'PA_XLA_REVENUE_HEADERS_V'
93924: WHEN 4 THEN 'PA_XLA_REVENUE_HEADERS_V'
93925: WHEN 5 THEN 'PA_XLA_REVENUE_HEADERS_V'
93926:
93927: ELSE null

Line 93924: WHEN 4 THEN 'PA_XLA_REVENUE_HEADERS_V'

93920: , CASE r
93921: WHEN 1 THEN 'PA_XLA_REVENUE_HEADERS_V'
93922: WHEN 2 THEN 'PA_XLA_REVENUE_HEADERS_V'
93923: WHEN 3 THEN 'PA_XLA_REVENUE_HEADERS_V'
93924: WHEN 4 THEN 'PA_XLA_REVENUE_HEADERS_V'
93925: WHEN 5 THEN 'PA_XLA_REVENUE_HEADERS_V'
93926:
93927: ELSE null
93928: END object_name

Line 93925: WHEN 5 THEN 'PA_XLA_REVENUE_HEADERS_V'

93921: WHEN 1 THEN 'PA_XLA_REVENUE_HEADERS_V'
93922: WHEN 2 THEN 'PA_XLA_REVENUE_HEADERS_V'
93923: WHEN 3 THEN 'PA_XLA_REVENUE_HEADERS_V'
93924: WHEN 4 THEN 'PA_XLA_REVENUE_HEADERS_V'
93925: WHEN 5 THEN 'PA_XLA_REVENUE_HEADERS_V'
93926:
93927: ELSE null
93928: END object_name
93929: , CASE r

Line 93977: , PA_XLA_REVENUE_HEADERS_V h2

93973:
93974: ELSE null
93975: END source_meaning
93976: FROM xla_events_gt xet
93977: , PA_XLA_REVENUE_HEADERS_V h2
93978: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
93979: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
93980: AND xet.event_class_code = C_EVENT_CLASS_CODE
93981: AND h2.event_id = xet.event_id

Line 94301: TYPE t_array_source_48 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.CREDITING_REVENUE_FLAG%TYPE INDEX BY BINARY_INTEGER;

94297: --
94298: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
94299: --
94300:
94301: TYPE t_array_source_48 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.CREDITING_REVENUE_FLAG%TYPE INDEX BY BINARY_INTEGER;
94302: TYPE t_array_source_51 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;
94303: TYPE t_array_source_75 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
94304: TYPE t_array_source_77 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UER_CCID%TYPE INDEX BY BINARY_INTEGER;
94305: TYPE t_array_source_78 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 94302: TYPE t_array_source_51 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;

94298: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
94299: --
94300:
94301: TYPE t_array_source_48 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.CREDITING_REVENUE_FLAG%TYPE INDEX BY BINARY_INTEGER;
94302: TYPE t_array_source_51 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;
94303: TYPE t_array_source_75 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
94304: TYPE t_array_source_77 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UER_CCID%TYPE INDEX BY BINARY_INTEGER;
94305: TYPE t_array_source_78 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
94306:

Line 94303: TYPE t_array_source_75 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

94299: --
94300:
94301: TYPE t_array_source_48 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.CREDITING_REVENUE_FLAG%TYPE INDEX BY BINARY_INTEGER;
94302: TYPE t_array_source_51 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;
94303: TYPE t_array_source_75 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
94304: TYPE t_array_source_77 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UER_CCID%TYPE INDEX BY BINARY_INTEGER;
94305: TYPE t_array_source_78 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
94306:
94307: TYPE t_array_source_1 IS TABLE OF PA_XLA_REVENUE_LINES_V.PERDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 94304: TYPE t_array_source_77 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UER_CCID%TYPE INDEX BY BINARY_INTEGER;

94300:
94301: TYPE t_array_source_48 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.CREDITING_REVENUE_FLAG%TYPE INDEX BY BINARY_INTEGER;
94302: TYPE t_array_source_51 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;
94303: TYPE t_array_source_75 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
94304: TYPE t_array_source_77 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UER_CCID%TYPE INDEX BY BINARY_INTEGER;
94305: TYPE t_array_source_78 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
94306:
94307: TYPE t_array_source_1 IS TABLE OF PA_XLA_REVENUE_LINES_V.PERDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
94308: TYPE t_array_source_17 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_GAINS_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 94305: TYPE t_array_source_78 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;

94301: TYPE t_array_source_48 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.CREDITING_REVENUE_FLAG%TYPE INDEX BY BINARY_INTEGER;
94302: TYPE t_array_source_51 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;
94303: TYPE t_array_source_75 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
94304: TYPE t_array_source_77 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UER_CCID%TYPE INDEX BY BINARY_INTEGER;
94305: TYPE t_array_source_78 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
94306:
94307: TYPE t_array_source_1 IS TABLE OF PA_XLA_REVENUE_LINES_V.PERDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
94308: TYPE t_array_source_17 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_GAINS_CCID%TYPE INDEX BY BINARY_INTEGER;
94309: TYPE t_array_source_18 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_LOSSES_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 94385: , PA_XLA_REVENUE_HEADERS_V h2

94381: , h2.GL_DATE source_75
94382: , h2.UER_CCID source_77
94383: , h2.UBR_CCID source_78
94384: FROM xla_events_gt xet
94385: , PA_XLA_REVENUE_HEADERS_V h2
94386: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
94387: and xet.event_class_code = C_EVENT_CLASS_CODE
94388: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
94389: