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_REVENUE_HEADERS_V

Line 73073: WHEN 1 THEN 'PA_XLA_REVENUE_HEADERS_V'

73069: FROM (
73070: SELECT xet.event_id event_id
73071: , 0 line_number
73072: , CASE r
73073: WHEN 1 THEN 'PA_XLA_REVENUE_HEADERS_V'
73074: WHEN 2 THEN 'PA_XLA_REVENUE_HEADERS_V'
73075: WHEN 3 THEN 'PA_XLA_REVENUE_HEADERS_V'
73076: WHEN 4 THEN 'PA_XLA_REVENUE_HEADERS_V'
73077: WHEN 5 THEN 'PA_XLA_REVENUE_HEADERS_V'

Line 73074: WHEN 2 THEN 'PA_XLA_REVENUE_HEADERS_V'

73070: SELECT xet.event_id event_id
73071: , 0 line_number
73072: , CASE r
73073: WHEN 1 THEN 'PA_XLA_REVENUE_HEADERS_V'
73074: WHEN 2 THEN 'PA_XLA_REVENUE_HEADERS_V'
73075: WHEN 3 THEN 'PA_XLA_REVENUE_HEADERS_V'
73076: WHEN 4 THEN 'PA_XLA_REVENUE_HEADERS_V'
73077: WHEN 5 THEN 'PA_XLA_REVENUE_HEADERS_V'
73078:

Line 73075: WHEN 3 THEN 'PA_XLA_REVENUE_HEADERS_V'

73071: , 0 line_number
73072: , CASE r
73073: WHEN 1 THEN 'PA_XLA_REVENUE_HEADERS_V'
73074: WHEN 2 THEN 'PA_XLA_REVENUE_HEADERS_V'
73075: WHEN 3 THEN 'PA_XLA_REVENUE_HEADERS_V'
73076: WHEN 4 THEN 'PA_XLA_REVENUE_HEADERS_V'
73077: WHEN 5 THEN 'PA_XLA_REVENUE_HEADERS_V'
73078:
73079: ELSE null

Line 73076: WHEN 4 THEN 'PA_XLA_REVENUE_HEADERS_V'

73072: , CASE r
73073: WHEN 1 THEN 'PA_XLA_REVENUE_HEADERS_V'
73074: WHEN 2 THEN 'PA_XLA_REVENUE_HEADERS_V'
73075: WHEN 3 THEN 'PA_XLA_REVENUE_HEADERS_V'
73076: WHEN 4 THEN 'PA_XLA_REVENUE_HEADERS_V'
73077: WHEN 5 THEN 'PA_XLA_REVENUE_HEADERS_V'
73078:
73079: ELSE null
73080: END object_name

Line 73077: WHEN 5 THEN 'PA_XLA_REVENUE_HEADERS_V'

73073: WHEN 1 THEN 'PA_XLA_REVENUE_HEADERS_V'
73074: WHEN 2 THEN 'PA_XLA_REVENUE_HEADERS_V'
73075: WHEN 3 THEN 'PA_XLA_REVENUE_HEADERS_V'
73076: WHEN 4 THEN 'PA_XLA_REVENUE_HEADERS_V'
73077: WHEN 5 THEN 'PA_XLA_REVENUE_HEADERS_V'
73078:
73079: ELSE null
73080: END object_name
73081: , CASE r

Line 73129: , PA_XLA_REVENUE_HEADERS_V h2

73125:
73126: ELSE null
73127: END source_meaning
73128: FROM xla_events_gt xet
73129: , PA_XLA_REVENUE_HEADERS_V h2
73130: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
73131: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
73132: AND xet.event_class_code = C_EVENT_CLASS_CODE
73133: AND h2.event_id = xet.event_id

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

73479: --
73480: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
73481: --
73482:
73483: TYPE t_array_source_38 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.CREDITING_REVENUE_FLAG%TYPE INDEX BY BINARY_INTEGER;
73484: TYPE t_array_source_42 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;
73485: TYPE t_array_source_87 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
73486: TYPE t_array_source_91 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UER_CCID%TYPE INDEX BY BINARY_INTEGER;
73487: TYPE t_array_source_92 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;

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

73480: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
73481: --
73482:
73483: TYPE t_array_source_38 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.CREDITING_REVENUE_FLAG%TYPE INDEX BY BINARY_INTEGER;
73484: TYPE t_array_source_42 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;
73485: TYPE t_array_source_87 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
73486: TYPE t_array_source_91 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UER_CCID%TYPE INDEX BY BINARY_INTEGER;
73487: TYPE t_array_source_92 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
73488:

Line 73485: TYPE t_array_source_87 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

73481: --
73482:
73483: TYPE t_array_source_38 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.CREDITING_REVENUE_FLAG%TYPE INDEX BY BINARY_INTEGER;
73484: TYPE t_array_source_42 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;
73485: TYPE t_array_source_87 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
73486: TYPE t_array_source_91 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UER_CCID%TYPE INDEX BY BINARY_INTEGER;
73487: TYPE t_array_source_92 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
73488:
73489: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 73486: TYPE t_array_source_91 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UER_CCID%TYPE INDEX BY BINARY_INTEGER;

73482:
73483: TYPE t_array_source_38 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.CREDITING_REVENUE_FLAG%TYPE INDEX BY BINARY_INTEGER;
73484: TYPE t_array_source_42 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;
73485: TYPE t_array_source_87 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
73486: TYPE t_array_source_91 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UER_CCID%TYPE INDEX BY BINARY_INTEGER;
73487: TYPE t_array_source_92 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
73488:
73489: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
73490: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 73487: TYPE t_array_source_92 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;

73483: TYPE t_array_source_38 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.CREDITING_REVENUE_FLAG%TYPE INDEX BY BINARY_INTEGER;
73484: TYPE t_array_source_42 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;
73485: TYPE t_array_source_87 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
73486: TYPE t_array_source_91 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UER_CCID%TYPE INDEX BY BINARY_INTEGER;
73487: TYPE t_array_source_92 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
73488:
73489: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
73490: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;
73491: 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 73579: , PA_XLA_REVENUE_HEADERS_V h2

73575: , h2.GL_DATE source_87
73576: , h2.UER_CCID source_91
73577: , h2.UBR_CCID source_92
73578: FROM xla_events_gt xet
73579: , PA_XLA_REVENUE_HEADERS_V h2
73580: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
73581: and xet.event_class_code = C_EVENT_CLASS_CODE
73582: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
73583:

Line 74615: WHEN 1 THEN 'PA_XLA_REVENUE_HEADERS_V'

74611: FROM (
74612: SELECT xet.event_id event_id
74613: , 0 line_number
74614: , CASE r
74615: WHEN 1 THEN 'PA_XLA_REVENUE_HEADERS_V'
74616: WHEN 2 THEN 'PA_XLA_REVENUE_HEADERS_V'
74617: WHEN 3 THEN 'PA_XLA_REVENUE_HEADERS_V'
74618: WHEN 4 THEN 'PA_XLA_REVENUE_HEADERS_V'
74619: WHEN 5 THEN 'PA_XLA_REVENUE_HEADERS_V'

Line 74616: WHEN 2 THEN 'PA_XLA_REVENUE_HEADERS_V'

74612: SELECT xet.event_id event_id
74613: , 0 line_number
74614: , CASE r
74615: WHEN 1 THEN 'PA_XLA_REVENUE_HEADERS_V'
74616: WHEN 2 THEN 'PA_XLA_REVENUE_HEADERS_V'
74617: WHEN 3 THEN 'PA_XLA_REVENUE_HEADERS_V'
74618: WHEN 4 THEN 'PA_XLA_REVENUE_HEADERS_V'
74619: WHEN 5 THEN 'PA_XLA_REVENUE_HEADERS_V'
74620:

Line 74617: WHEN 3 THEN 'PA_XLA_REVENUE_HEADERS_V'

74613: , 0 line_number
74614: , CASE r
74615: WHEN 1 THEN 'PA_XLA_REVENUE_HEADERS_V'
74616: WHEN 2 THEN 'PA_XLA_REVENUE_HEADERS_V'
74617: WHEN 3 THEN 'PA_XLA_REVENUE_HEADERS_V'
74618: WHEN 4 THEN 'PA_XLA_REVENUE_HEADERS_V'
74619: WHEN 5 THEN 'PA_XLA_REVENUE_HEADERS_V'
74620:
74621: ELSE null

Line 74618: WHEN 4 THEN 'PA_XLA_REVENUE_HEADERS_V'

74614: , CASE r
74615: WHEN 1 THEN 'PA_XLA_REVENUE_HEADERS_V'
74616: WHEN 2 THEN 'PA_XLA_REVENUE_HEADERS_V'
74617: WHEN 3 THEN 'PA_XLA_REVENUE_HEADERS_V'
74618: WHEN 4 THEN 'PA_XLA_REVENUE_HEADERS_V'
74619: WHEN 5 THEN 'PA_XLA_REVENUE_HEADERS_V'
74620:
74621: ELSE null
74622: END object_name

Line 74619: WHEN 5 THEN 'PA_XLA_REVENUE_HEADERS_V'

74615: WHEN 1 THEN 'PA_XLA_REVENUE_HEADERS_V'
74616: WHEN 2 THEN 'PA_XLA_REVENUE_HEADERS_V'
74617: WHEN 3 THEN 'PA_XLA_REVENUE_HEADERS_V'
74618: WHEN 4 THEN 'PA_XLA_REVENUE_HEADERS_V'
74619: WHEN 5 THEN 'PA_XLA_REVENUE_HEADERS_V'
74620:
74621: ELSE null
74622: END object_name
74623: , CASE r

Line 74671: , PA_XLA_REVENUE_HEADERS_V h2

74667:
74668: ELSE null
74669: END source_meaning
74670: FROM xla_events_gt xet
74671: , PA_XLA_REVENUE_HEADERS_V h2
74672: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
74673: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
74674: AND xet.event_class_code = C_EVENT_CLASS_CODE
74675: AND h2.event_id = xet.event_id

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

74991: --
74992: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
74993: --
74994:
74995: TYPE t_array_source_38 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.CREDITING_REVENUE_FLAG%TYPE INDEX BY BINARY_INTEGER;
74996: TYPE t_array_source_42 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;
74997: TYPE t_array_source_87 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
74998: TYPE t_array_source_91 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UER_CCID%TYPE INDEX BY BINARY_INTEGER;
74999: TYPE t_array_source_92 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;

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

74992: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
74993: --
74994:
74995: TYPE t_array_source_38 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.CREDITING_REVENUE_FLAG%TYPE INDEX BY BINARY_INTEGER;
74996: TYPE t_array_source_42 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;
74997: TYPE t_array_source_87 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
74998: TYPE t_array_source_91 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UER_CCID%TYPE INDEX BY BINARY_INTEGER;
74999: TYPE t_array_source_92 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
75000:

Line 74997: TYPE t_array_source_87 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

74993: --
74994:
74995: TYPE t_array_source_38 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.CREDITING_REVENUE_FLAG%TYPE INDEX BY BINARY_INTEGER;
74996: TYPE t_array_source_42 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;
74997: TYPE t_array_source_87 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
74998: TYPE t_array_source_91 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UER_CCID%TYPE INDEX BY BINARY_INTEGER;
74999: TYPE t_array_source_92 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
75000:
75001: TYPE t_array_source_1 IS TABLE OF PA_XLA_REVENUE_LINES_V.PERDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 74998: TYPE t_array_source_91 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UER_CCID%TYPE INDEX BY BINARY_INTEGER;

74994:
74995: TYPE t_array_source_38 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.CREDITING_REVENUE_FLAG%TYPE INDEX BY BINARY_INTEGER;
74996: TYPE t_array_source_42 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;
74997: TYPE t_array_source_87 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
74998: TYPE t_array_source_91 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UER_CCID%TYPE INDEX BY BINARY_INTEGER;
74999: TYPE t_array_source_92 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
75000:
75001: TYPE t_array_source_1 IS TABLE OF PA_XLA_REVENUE_LINES_V.PERDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
75002: TYPE t_array_source_16 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_GAINS_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 74999: TYPE t_array_source_92 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;

74995: TYPE t_array_source_38 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.CREDITING_REVENUE_FLAG%TYPE INDEX BY BINARY_INTEGER;
74996: TYPE t_array_source_42 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;
74997: TYPE t_array_source_87 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
74998: TYPE t_array_source_91 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UER_CCID%TYPE INDEX BY BINARY_INTEGER;
74999: TYPE t_array_source_92 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
75000:
75001: TYPE t_array_source_1 IS TABLE OF PA_XLA_REVENUE_LINES_V.PERDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
75002: TYPE t_array_source_16 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_GAINS_CCID%TYPE INDEX BY BINARY_INTEGER;
75003: TYPE t_array_source_17 IS TABLE OF PA_XLA_REVENUE_LINES_V.PDR_REALIZED_LOSSES_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 75079: , PA_XLA_REVENUE_HEADERS_V h2

75075: , h2.GL_DATE source_87
75076: , h2.UER_CCID source_91
75077: , h2.UBR_CCID source_92
75078: FROM xla_events_gt xet
75079: , PA_XLA_REVENUE_HEADERS_V h2
75080: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
75081: and xet.event_class_code = C_EVENT_CLASS_CODE
75082: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
75083: