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_00240_AAD_S_000003_PKG dependencies on PN_XLA_EXTRACT_LINES_V

Line 3161: WHEN 1 THEN 'PN_XLA_EXTRACT_LINES_V'

3157: FROM (
3158: SELECT xet.event_id event_id
3159: , l2.line_number line_number
3160: , CASE r
3161: WHEN 1 THEN 'PN_XLA_EXTRACT_LINES_V'
3162: WHEN 2 THEN 'PN_XLA_EXTRACT_LINES_V'
3163: WHEN 3 THEN 'PN_XLA_EXTRACT_LINES_V'
3164: WHEN 4 THEN 'PN_XLA_EXTRACT_LINES_V'
3165: WHEN 5 THEN 'PN_XLA_EXTRACT_LINES_V'

Line 3162: WHEN 2 THEN 'PN_XLA_EXTRACT_LINES_V'

3158: SELECT xet.event_id event_id
3159: , l2.line_number line_number
3160: , CASE r
3161: WHEN 1 THEN 'PN_XLA_EXTRACT_LINES_V'
3162: WHEN 2 THEN 'PN_XLA_EXTRACT_LINES_V'
3163: WHEN 3 THEN 'PN_XLA_EXTRACT_LINES_V'
3164: WHEN 4 THEN 'PN_XLA_EXTRACT_LINES_V'
3165: WHEN 5 THEN 'PN_XLA_EXTRACT_LINES_V'
3166: WHEN 6 THEN 'PN_XLA_EXTRACT_LINES_V'

Line 3163: WHEN 3 THEN 'PN_XLA_EXTRACT_LINES_V'

3159: , l2.line_number line_number
3160: , CASE r
3161: WHEN 1 THEN 'PN_XLA_EXTRACT_LINES_V'
3162: WHEN 2 THEN 'PN_XLA_EXTRACT_LINES_V'
3163: WHEN 3 THEN 'PN_XLA_EXTRACT_LINES_V'
3164: WHEN 4 THEN 'PN_XLA_EXTRACT_LINES_V'
3165: WHEN 5 THEN 'PN_XLA_EXTRACT_LINES_V'
3166: WHEN 6 THEN 'PN_XLA_EXTRACT_LINES_V'
3167: WHEN 7 THEN 'PN_XLA_EXTRACT_LINES_V'

Line 3164: WHEN 4 THEN 'PN_XLA_EXTRACT_LINES_V'

3160: , CASE r
3161: WHEN 1 THEN 'PN_XLA_EXTRACT_LINES_V'
3162: WHEN 2 THEN 'PN_XLA_EXTRACT_LINES_V'
3163: WHEN 3 THEN 'PN_XLA_EXTRACT_LINES_V'
3164: WHEN 4 THEN 'PN_XLA_EXTRACT_LINES_V'
3165: WHEN 5 THEN 'PN_XLA_EXTRACT_LINES_V'
3166: WHEN 6 THEN 'PN_XLA_EXTRACT_LINES_V'
3167: WHEN 7 THEN 'PN_XLA_EXTRACT_LINES_V'
3168: WHEN 8 THEN 'PN_XLA_EXTRACT_LINES_V'

Line 3165: WHEN 5 THEN 'PN_XLA_EXTRACT_LINES_V'

3161: WHEN 1 THEN 'PN_XLA_EXTRACT_LINES_V'
3162: WHEN 2 THEN 'PN_XLA_EXTRACT_LINES_V'
3163: WHEN 3 THEN 'PN_XLA_EXTRACT_LINES_V'
3164: WHEN 4 THEN 'PN_XLA_EXTRACT_LINES_V'
3165: WHEN 5 THEN 'PN_XLA_EXTRACT_LINES_V'
3166: WHEN 6 THEN 'PN_XLA_EXTRACT_LINES_V'
3167: WHEN 7 THEN 'PN_XLA_EXTRACT_LINES_V'
3168: WHEN 8 THEN 'PN_XLA_EXTRACT_LINES_V'
3169:

Line 3166: WHEN 6 THEN 'PN_XLA_EXTRACT_LINES_V'

3162: WHEN 2 THEN 'PN_XLA_EXTRACT_LINES_V'
3163: WHEN 3 THEN 'PN_XLA_EXTRACT_LINES_V'
3164: WHEN 4 THEN 'PN_XLA_EXTRACT_LINES_V'
3165: WHEN 5 THEN 'PN_XLA_EXTRACT_LINES_V'
3166: WHEN 6 THEN 'PN_XLA_EXTRACT_LINES_V'
3167: WHEN 7 THEN 'PN_XLA_EXTRACT_LINES_V'
3168: WHEN 8 THEN 'PN_XLA_EXTRACT_LINES_V'
3169:
3170: ELSE null

Line 3167: WHEN 7 THEN 'PN_XLA_EXTRACT_LINES_V'

3163: WHEN 3 THEN 'PN_XLA_EXTRACT_LINES_V'
3164: WHEN 4 THEN 'PN_XLA_EXTRACT_LINES_V'
3165: WHEN 5 THEN 'PN_XLA_EXTRACT_LINES_V'
3166: WHEN 6 THEN 'PN_XLA_EXTRACT_LINES_V'
3167: WHEN 7 THEN 'PN_XLA_EXTRACT_LINES_V'
3168: WHEN 8 THEN 'PN_XLA_EXTRACT_LINES_V'
3169:
3170: ELSE null
3171: END object_name

Line 3168: WHEN 8 THEN 'PN_XLA_EXTRACT_LINES_V'

3164: WHEN 4 THEN 'PN_XLA_EXTRACT_LINES_V'
3165: WHEN 5 THEN 'PN_XLA_EXTRACT_LINES_V'
3166: WHEN 6 THEN 'PN_XLA_EXTRACT_LINES_V'
3167: WHEN 7 THEN 'PN_XLA_EXTRACT_LINES_V'
3168: WHEN 8 THEN 'PN_XLA_EXTRACT_LINES_V'
3169:
3170: ELSE null
3171: END object_name
3172: , CASE r

Line 3223: , PN_XLA_EXTRACT_LINES_V l2

3219: ELSE null
3220: END source_value
3221: , null source_meaning
3222: FROM xla_events_gt xet
3223: , PN_XLA_EXTRACT_LINES_V l2
3224: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
3225: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
3226: AND xet.event_type_code = C_EVENT_TYPE_CODE
3227: AND l2.event_id = xet.event_id

Line 3371: TYPE t_array_source_10 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

3367: TYPE t_array_source_6 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.LEASE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
3368: TYPE t_array_source_7 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PROPERTY_CODE%TYPE INDEX BY BINARY_INTEGER;
3369: TYPE t_array_source_12 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PAYMENT_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
3370:
3371: TYPE t_array_source_10 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
3372: TYPE t_array_source_11 IS TABLE OF PN_XLA_EXTRACT_LINES_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
3373: TYPE t_array_source_13 IS TABLE OF PN_XLA_EXTRACT_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
3374: TYPE t_array_source_14 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
3375: TYPE t_array_source_15 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 3372: TYPE t_array_source_11 IS TABLE OF PN_XLA_EXTRACT_LINES_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

3368: TYPE t_array_source_7 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PROPERTY_CODE%TYPE INDEX BY BINARY_INTEGER;
3369: TYPE t_array_source_12 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PAYMENT_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
3370:
3371: TYPE t_array_source_10 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
3372: TYPE t_array_source_11 IS TABLE OF PN_XLA_EXTRACT_LINES_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
3373: TYPE t_array_source_13 IS TABLE OF PN_XLA_EXTRACT_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
3374: TYPE t_array_source_14 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
3375: TYPE t_array_source_15 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
3376: TYPE t_array_source_16 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 3373: TYPE t_array_source_13 IS TABLE OF PN_XLA_EXTRACT_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

3369: TYPE t_array_source_12 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PAYMENT_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
3370:
3371: TYPE t_array_source_10 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
3372: TYPE t_array_source_11 IS TABLE OF PN_XLA_EXTRACT_LINES_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
3373: TYPE t_array_source_13 IS TABLE OF PN_XLA_EXTRACT_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
3374: TYPE t_array_source_14 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
3375: TYPE t_array_source_15 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
3376: TYPE t_array_source_16 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
3377: TYPE t_array_source_17 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CONVERSION_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 3374: TYPE t_array_source_14 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

3370:
3371: TYPE t_array_source_10 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
3372: TYPE t_array_source_11 IS TABLE OF PN_XLA_EXTRACT_LINES_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
3373: TYPE t_array_source_13 IS TABLE OF PN_XLA_EXTRACT_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
3374: TYPE t_array_source_14 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
3375: TYPE t_array_source_15 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
3376: TYPE t_array_source_16 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
3377: TYPE t_array_source_17 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CONVERSION_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
3378: TYPE t_array_source_18 IS TABLE OF PN_XLA_EXTRACT_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 3375: TYPE t_array_source_15 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

3371: TYPE t_array_source_10 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
3372: TYPE t_array_source_11 IS TABLE OF PN_XLA_EXTRACT_LINES_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
3373: TYPE t_array_source_13 IS TABLE OF PN_XLA_EXTRACT_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
3374: TYPE t_array_source_14 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
3375: TYPE t_array_source_15 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
3376: TYPE t_array_source_16 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
3377: TYPE t_array_source_17 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CONVERSION_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
3378: TYPE t_array_source_18 IS TABLE OF PN_XLA_EXTRACT_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
3379:

Line 3376: TYPE t_array_source_16 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

3372: TYPE t_array_source_11 IS TABLE OF PN_XLA_EXTRACT_LINES_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
3373: TYPE t_array_source_13 IS TABLE OF PN_XLA_EXTRACT_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
3374: TYPE t_array_source_14 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
3375: TYPE t_array_source_15 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
3376: TYPE t_array_source_16 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
3377: TYPE t_array_source_17 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CONVERSION_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
3378: TYPE t_array_source_18 IS TABLE OF PN_XLA_EXTRACT_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
3379:
3380: l_array_source_1 t_array_source_1;

Line 3377: TYPE t_array_source_17 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CONVERSION_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

3373: TYPE t_array_source_13 IS TABLE OF PN_XLA_EXTRACT_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
3374: TYPE t_array_source_14 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
3375: TYPE t_array_source_15 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
3376: TYPE t_array_source_16 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
3377: TYPE t_array_source_17 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CONVERSION_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
3378: TYPE t_array_source_18 IS TABLE OF PN_XLA_EXTRACT_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
3379:
3380: l_array_source_1 t_array_source_1;
3381: l_array_source_2 t_array_source_2;

Line 3378: TYPE t_array_source_18 IS TABLE OF PN_XLA_EXTRACT_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

3374: TYPE t_array_source_14 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
3375: TYPE t_array_source_15 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
3376: TYPE t_array_source_16 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
3377: TYPE t_array_source_17 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CONVERSION_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
3378: TYPE t_array_source_18 IS TABLE OF PN_XLA_EXTRACT_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
3379:
3380: l_array_source_1 t_array_source_1;
3381: l_array_source_2 t_array_source_2;
3382: l_array_source_3 t_array_source_3;

Line 3485: , PN_XLA_EXTRACT_LINES_V l2

3481: , l2.CONVERSION_RATE source_16
3482: , l2.CONVERSION_RATE_TYPE source_17
3483: , l2.ACCOUNTED_AMOUNT source_18
3484: FROM xla_events_gt xet
3485: , PN_XLA_EXTRACT_LINES_V l2
3486: WHERE xet.event_id between x_first_event_id and x_last_event_id
3487: and xet.event_date between p_pad_start_date and p_pad_end_date
3488: and xet.event_type_code = C_EVENT_TYPE_CODE
3489: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 4411: WHEN 1 THEN 'PN_XLA_EXTRACT_LINES_V'

4407: FROM (
4408: SELECT xet.event_id event_id
4409: , l2.line_number line_number
4410: , CASE r
4411: WHEN 1 THEN 'PN_XLA_EXTRACT_LINES_V'
4412: WHEN 2 THEN 'PN_XLA_EXTRACT_LINES_V'
4413: WHEN 3 THEN 'PN_XLA_EXTRACT_LINES_V'
4414: WHEN 4 THEN 'PN_XLA_EXTRACT_LINES_V'
4415: WHEN 5 THEN 'PN_XLA_EXTRACT_LINES_V'

Line 4412: WHEN 2 THEN 'PN_XLA_EXTRACT_LINES_V'

4408: SELECT xet.event_id event_id
4409: , l2.line_number line_number
4410: , CASE r
4411: WHEN 1 THEN 'PN_XLA_EXTRACT_LINES_V'
4412: WHEN 2 THEN 'PN_XLA_EXTRACT_LINES_V'
4413: WHEN 3 THEN 'PN_XLA_EXTRACT_LINES_V'
4414: WHEN 4 THEN 'PN_XLA_EXTRACT_LINES_V'
4415: WHEN 5 THEN 'PN_XLA_EXTRACT_LINES_V'
4416: WHEN 6 THEN 'PN_XLA_EXTRACT_LINES_V'

Line 4413: WHEN 3 THEN 'PN_XLA_EXTRACT_LINES_V'

4409: , l2.line_number line_number
4410: , CASE r
4411: WHEN 1 THEN 'PN_XLA_EXTRACT_LINES_V'
4412: WHEN 2 THEN 'PN_XLA_EXTRACT_LINES_V'
4413: WHEN 3 THEN 'PN_XLA_EXTRACT_LINES_V'
4414: WHEN 4 THEN 'PN_XLA_EXTRACT_LINES_V'
4415: WHEN 5 THEN 'PN_XLA_EXTRACT_LINES_V'
4416: WHEN 6 THEN 'PN_XLA_EXTRACT_LINES_V'
4417: WHEN 7 THEN 'PN_XLA_EXTRACT_LINES_V'

Line 4414: WHEN 4 THEN 'PN_XLA_EXTRACT_LINES_V'

4410: , CASE r
4411: WHEN 1 THEN 'PN_XLA_EXTRACT_LINES_V'
4412: WHEN 2 THEN 'PN_XLA_EXTRACT_LINES_V'
4413: WHEN 3 THEN 'PN_XLA_EXTRACT_LINES_V'
4414: WHEN 4 THEN 'PN_XLA_EXTRACT_LINES_V'
4415: WHEN 5 THEN 'PN_XLA_EXTRACT_LINES_V'
4416: WHEN 6 THEN 'PN_XLA_EXTRACT_LINES_V'
4417: WHEN 7 THEN 'PN_XLA_EXTRACT_LINES_V'
4418: WHEN 8 THEN 'PN_XLA_EXTRACT_LINES_V'

Line 4415: WHEN 5 THEN 'PN_XLA_EXTRACT_LINES_V'

4411: WHEN 1 THEN 'PN_XLA_EXTRACT_LINES_V'
4412: WHEN 2 THEN 'PN_XLA_EXTRACT_LINES_V'
4413: WHEN 3 THEN 'PN_XLA_EXTRACT_LINES_V'
4414: WHEN 4 THEN 'PN_XLA_EXTRACT_LINES_V'
4415: WHEN 5 THEN 'PN_XLA_EXTRACT_LINES_V'
4416: WHEN 6 THEN 'PN_XLA_EXTRACT_LINES_V'
4417: WHEN 7 THEN 'PN_XLA_EXTRACT_LINES_V'
4418: WHEN 8 THEN 'PN_XLA_EXTRACT_LINES_V'
4419:

Line 4416: WHEN 6 THEN 'PN_XLA_EXTRACT_LINES_V'

4412: WHEN 2 THEN 'PN_XLA_EXTRACT_LINES_V'
4413: WHEN 3 THEN 'PN_XLA_EXTRACT_LINES_V'
4414: WHEN 4 THEN 'PN_XLA_EXTRACT_LINES_V'
4415: WHEN 5 THEN 'PN_XLA_EXTRACT_LINES_V'
4416: WHEN 6 THEN 'PN_XLA_EXTRACT_LINES_V'
4417: WHEN 7 THEN 'PN_XLA_EXTRACT_LINES_V'
4418: WHEN 8 THEN 'PN_XLA_EXTRACT_LINES_V'
4419:
4420: ELSE null

Line 4417: WHEN 7 THEN 'PN_XLA_EXTRACT_LINES_V'

4413: WHEN 3 THEN 'PN_XLA_EXTRACT_LINES_V'
4414: WHEN 4 THEN 'PN_XLA_EXTRACT_LINES_V'
4415: WHEN 5 THEN 'PN_XLA_EXTRACT_LINES_V'
4416: WHEN 6 THEN 'PN_XLA_EXTRACT_LINES_V'
4417: WHEN 7 THEN 'PN_XLA_EXTRACT_LINES_V'
4418: WHEN 8 THEN 'PN_XLA_EXTRACT_LINES_V'
4419:
4420: ELSE null
4421: END object_name

Line 4418: WHEN 8 THEN 'PN_XLA_EXTRACT_LINES_V'

4414: WHEN 4 THEN 'PN_XLA_EXTRACT_LINES_V'
4415: WHEN 5 THEN 'PN_XLA_EXTRACT_LINES_V'
4416: WHEN 6 THEN 'PN_XLA_EXTRACT_LINES_V'
4417: WHEN 7 THEN 'PN_XLA_EXTRACT_LINES_V'
4418: WHEN 8 THEN 'PN_XLA_EXTRACT_LINES_V'
4419:
4420: ELSE null
4421: END object_name
4422: , CASE r

Line 4473: , PN_XLA_EXTRACT_LINES_V l2

4469: ELSE null
4470: END source_value
4471: , null source_meaning
4472: FROM xla_events_gt xet
4473: , PN_XLA_EXTRACT_LINES_V l2
4474: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
4475: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
4476: AND xet.event_type_code = C_EVENT_TYPE_CODE
4477: AND l2.event_id = xet.event_id

Line 4621: TYPE t_array_source_10 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

4617: TYPE t_array_source_8 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.CUSTOMER_NAME%TYPE INDEX BY BINARY_INTEGER;
4618: TYPE t_array_source_9 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.CUSTOMER_SITE%TYPE INDEX BY BINARY_INTEGER;
4619: TYPE t_array_source_12 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PAYMENT_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
4620:
4621: TYPE t_array_source_10 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
4622: TYPE t_array_source_11 IS TABLE OF PN_XLA_EXTRACT_LINES_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
4623: TYPE t_array_source_13 IS TABLE OF PN_XLA_EXTRACT_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
4624: TYPE t_array_source_14 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
4625: TYPE t_array_source_15 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 4622: TYPE t_array_source_11 IS TABLE OF PN_XLA_EXTRACT_LINES_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

4618: TYPE t_array_source_9 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.CUSTOMER_SITE%TYPE INDEX BY BINARY_INTEGER;
4619: TYPE t_array_source_12 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PAYMENT_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
4620:
4621: TYPE t_array_source_10 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
4622: TYPE t_array_source_11 IS TABLE OF PN_XLA_EXTRACT_LINES_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
4623: TYPE t_array_source_13 IS TABLE OF PN_XLA_EXTRACT_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
4624: TYPE t_array_source_14 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
4625: TYPE t_array_source_15 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
4626: TYPE t_array_source_16 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 4623: TYPE t_array_source_13 IS TABLE OF PN_XLA_EXTRACT_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

4619: TYPE t_array_source_12 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PAYMENT_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
4620:
4621: TYPE t_array_source_10 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
4622: TYPE t_array_source_11 IS TABLE OF PN_XLA_EXTRACT_LINES_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
4623: TYPE t_array_source_13 IS TABLE OF PN_XLA_EXTRACT_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
4624: TYPE t_array_source_14 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
4625: TYPE t_array_source_15 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
4626: TYPE t_array_source_16 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
4627: TYPE t_array_source_17 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CONVERSION_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 4624: TYPE t_array_source_14 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

4620:
4621: TYPE t_array_source_10 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
4622: TYPE t_array_source_11 IS TABLE OF PN_XLA_EXTRACT_LINES_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
4623: TYPE t_array_source_13 IS TABLE OF PN_XLA_EXTRACT_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
4624: TYPE t_array_source_14 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
4625: TYPE t_array_source_15 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
4626: TYPE t_array_source_16 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
4627: TYPE t_array_source_17 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CONVERSION_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
4628: TYPE t_array_source_18 IS TABLE OF PN_XLA_EXTRACT_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 4625: TYPE t_array_source_15 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

4621: TYPE t_array_source_10 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
4622: TYPE t_array_source_11 IS TABLE OF PN_XLA_EXTRACT_LINES_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
4623: TYPE t_array_source_13 IS TABLE OF PN_XLA_EXTRACT_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
4624: TYPE t_array_source_14 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
4625: TYPE t_array_source_15 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
4626: TYPE t_array_source_16 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
4627: TYPE t_array_source_17 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CONVERSION_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
4628: TYPE t_array_source_18 IS TABLE OF PN_XLA_EXTRACT_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
4629:

Line 4626: TYPE t_array_source_16 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

4622: TYPE t_array_source_11 IS TABLE OF PN_XLA_EXTRACT_LINES_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
4623: TYPE t_array_source_13 IS TABLE OF PN_XLA_EXTRACT_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
4624: TYPE t_array_source_14 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
4625: TYPE t_array_source_15 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
4626: TYPE t_array_source_16 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
4627: TYPE t_array_source_17 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CONVERSION_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
4628: TYPE t_array_source_18 IS TABLE OF PN_XLA_EXTRACT_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
4629:
4630: l_array_source_3 t_array_source_3;

Line 4627: TYPE t_array_source_17 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CONVERSION_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

4623: TYPE t_array_source_13 IS TABLE OF PN_XLA_EXTRACT_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
4624: TYPE t_array_source_14 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
4625: TYPE t_array_source_15 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
4626: TYPE t_array_source_16 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
4627: TYPE t_array_source_17 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CONVERSION_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
4628: TYPE t_array_source_18 IS TABLE OF PN_XLA_EXTRACT_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
4629:
4630: l_array_source_3 t_array_source_3;
4631: l_array_source_4 t_array_source_4;

Line 4628: TYPE t_array_source_18 IS TABLE OF PN_XLA_EXTRACT_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

4624: TYPE t_array_source_14 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
4625: TYPE t_array_source_15 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
4626: TYPE t_array_source_16 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
4627: TYPE t_array_source_17 IS TABLE OF PN_XLA_EXTRACT_LINES_V.CONVERSION_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
4628: TYPE t_array_source_18 IS TABLE OF PN_XLA_EXTRACT_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
4629:
4630: l_array_source_3 t_array_source_3;
4631: l_array_source_4 t_array_source_4;
4632: l_array_source_5 t_array_source_5;

Line 4735: , PN_XLA_EXTRACT_LINES_V l2

4731: , l2.CONVERSION_RATE source_16
4732: , l2.CONVERSION_RATE_TYPE source_17
4733: , l2.ACCOUNTED_AMOUNT source_18
4734: FROM xla_events_gt xet
4735: , PN_XLA_EXTRACT_LINES_V l2
4736: WHERE xet.event_id between x_first_event_id and x_last_event_id
4737: and xet.event_date between p_pad_start_date and p_pad_end_date
4738: and xet.event_type_code = C_EVENT_TYPE_CODE
4739: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id