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_HEADERS_V

Line 3029: WHEN 1 THEN 'PN_XLA_EXTRACT_HEADERS_V'

3025: FROM (
3026: SELECT xet.event_id event_id
3027: , 0 line_number
3028: , CASE r
3029: WHEN 1 THEN 'PN_XLA_EXTRACT_HEADERS_V'
3030: WHEN 2 THEN 'PN_XLA_EXTRACT_HEADERS_V'
3031: WHEN 3 THEN 'PN_XLA_EXTRACT_HEADERS_V'
3032: WHEN 4 THEN 'PN_XLA_EXTRACT_HEADERS_V'
3033: WHEN 5 THEN 'PN_XLA_EXTRACT_HEADERS_V'

Line 3030: WHEN 2 THEN 'PN_XLA_EXTRACT_HEADERS_V'

3026: SELECT xet.event_id event_id
3027: , 0 line_number
3028: , CASE r
3029: WHEN 1 THEN 'PN_XLA_EXTRACT_HEADERS_V'
3030: WHEN 2 THEN 'PN_XLA_EXTRACT_HEADERS_V'
3031: WHEN 3 THEN 'PN_XLA_EXTRACT_HEADERS_V'
3032: WHEN 4 THEN 'PN_XLA_EXTRACT_HEADERS_V'
3033: WHEN 5 THEN 'PN_XLA_EXTRACT_HEADERS_V'
3034: WHEN 6 THEN 'PN_XLA_EXTRACT_HEADERS_V'

Line 3031: WHEN 3 THEN 'PN_XLA_EXTRACT_HEADERS_V'

3027: , 0 line_number
3028: , CASE r
3029: WHEN 1 THEN 'PN_XLA_EXTRACT_HEADERS_V'
3030: WHEN 2 THEN 'PN_XLA_EXTRACT_HEADERS_V'
3031: WHEN 3 THEN 'PN_XLA_EXTRACT_HEADERS_V'
3032: WHEN 4 THEN 'PN_XLA_EXTRACT_HEADERS_V'
3033: WHEN 5 THEN 'PN_XLA_EXTRACT_HEADERS_V'
3034: WHEN 6 THEN 'PN_XLA_EXTRACT_HEADERS_V'
3035: WHEN 7 THEN 'PN_XLA_EXTRACT_HEADERS_V'

Line 3032: WHEN 4 THEN 'PN_XLA_EXTRACT_HEADERS_V'

3028: , CASE r
3029: WHEN 1 THEN 'PN_XLA_EXTRACT_HEADERS_V'
3030: WHEN 2 THEN 'PN_XLA_EXTRACT_HEADERS_V'
3031: WHEN 3 THEN 'PN_XLA_EXTRACT_HEADERS_V'
3032: WHEN 4 THEN 'PN_XLA_EXTRACT_HEADERS_V'
3033: WHEN 5 THEN 'PN_XLA_EXTRACT_HEADERS_V'
3034: WHEN 6 THEN 'PN_XLA_EXTRACT_HEADERS_V'
3035: WHEN 7 THEN 'PN_XLA_EXTRACT_HEADERS_V'
3036: WHEN 8 THEN 'PN_XLA_EXTRACT_HEADERS_V'

Line 3033: WHEN 5 THEN 'PN_XLA_EXTRACT_HEADERS_V'

3029: WHEN 1 THEN 'PN_XLA_EXTRACT_HEADERS_V'
3030: WHEN 2 THEN 'PN_XLA_EXTRACT_HEADERS_V'
3031: WHEN 3 THEN 'PN_XLA_EXTRACT_HEADERS_V'
3032: WHEN 4 THEN 'PN_XLA_EXTRACT_HEADERS_V'
3033: WHEN 5 THEN 'PN_XLA_EXTRACT_HEADERS_V'
3034: WHEN 6 THEN 'PN_XLA_EXTRACT_HEADERS_V'
3035: WHEN 7 THEN 'PN_XLA_EXTRACT_HEADERS_V'
3036: WHEN 8 THEN 'PN_XLA_EXTRACT_HEADERS_V'
3037:

Line 3034: WHEN 6 THEN 'PN_XLA_EXTRACT_HEADERS_V'

3030: WHEN 2 THEN 'PN_XLA_EXTRACT_HEADERS_V'
3031: WHEN 3 THEN 'PN_XLA_EXTRACT_HEADERS_V'
3032: WHEN 4 THEN 'PN_XLA_EXTRACT_HEADERS_V'
3033: WHEN 5 THEN 'PN_XLA_EXTRACT_HEADERS_V'
3034: WHEN 6 THEN 'PN_XLA_EXTRACT_HEADERS_V'
3035: WHEN 7 THEN 'PN_XLA_EXTRACT_HEADERS_V'
3036: WHEN 8 THEN 'PN_XLA_EXTRACT_HEADERS_V'
3037:
3038: ELSE null

Line 3035: WHEN 7 THEN 'PN_XLA_EXTRACT_HEADERS_V'

3031: WHEN 3 THEN 'PN_XLA_EXTRACT_HEADERS_V'
3032: WHEN 4 THEN 'PN_XLA_EXTRACT_HEADERS_V'
3033: WHEN 5 THEN 'PN_XLA_EXTRACT_HEADERS_V'
3034: WHEN 6 THEN 'PN_XLA_EXTRACT_HEADERS_V'
3035: WHEN 7 THEN 'PN_XLA_EXTRACT_HEADERS_V'
3036: WHEN 8 THEN 'PN_XLA_EXTRACT_HEADERS_V'
3037:
3038: ELSE null
3039: END object_name

Line 3036: WHEN 8 THEN 'PN_XLA_EXTRACT_HEADERS_V'

3032: WHEN 4 THEN 'PN_XLA_EXTRACT_HEADERS_V'
3033: WHEN 5 THEN 'PN_XLA_EXTRACT_HEADERS_V'
3034: WHEN 6 THEN 'PN_XLA_EXTRACT_HEADERS_V'
3035: WHEN 7 THEN 'PN_XLA_EXTRACT_HEADERS_V'
3036: WHEN 8 THEN 'PN_XLA_EXTRACT_HEADERS_V'
3037:
3038: ELSE null
3039: END object_name
3040: , CASE r

Line 3091: , PN_XLA_EXTRACT_HEADERS_V h1

3087: ELSE null
3088: END source_value
3089: , null source_meaning
3090: FROM xla_events_gt xet
3091: , PN_XLA_EXTRACT_HEADERS_V h1
3092: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
3093: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
3094: AND xet.event_type_code = C_EVENT_TYPE_CODE
3095: AND h1.event_id = xet.event_id

Line 3362: TYPE t_array_source_1 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.SUPPLIER_NAME%TYPE INDEX BY BINARY_INTEGER;

3358: --
3359: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
3360: --
3361:
3362: TYPE t_array_source_1 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.SUPPLIER_NAME%TYPE INDEX BY BINARY_INTEGER;
3363: TYPE t_array_source_2 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.SUPPLIER_SITE%TYPE INDEX BY BINARY_INTEGER;
3364: TYPE t_array_source_3 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PAYMENT_PURPOSE%TYPE INDEX BY BINARY_INTEGER;
3365: TYPE t_array_source_4 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
3366: TYPE t_array_source_5 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.LOCATION_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 3363: TYPE t_array_source_2 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.SUPPLIER_SITE%TYPE INDEX BY BINARY_INTEGER;

3359: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
3360: --
3361:
3362: TYPE t_array_source_1 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.SUPPLIER_NAME%TYPE INDEX BY BINARY_INTEGER;
3363: TYPE t_array_source_2 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.SUPPLIER_SITE%TYPE INDEX BY BINARY_INTEGER;
3364: TYPE t_array_source_3 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PAYMENT_PURPOSE%TYPE INDEX BY BINARY_INTEGER;
3365: TYPE t_array_source_4 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
3366: TYPE t_array_source_5 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.LOCATION_CODE%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;

Line 3364: TYPE t_array_source_3 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PAYMENT_PURPOSE%TYPE INDEX BY BINARY_INTEGER;

3360: --
3361:
3362: TYPE t_array_source_1 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.SUPPLIER_NAME%TYPE INDEX BY BINARY_INTEGER;
3363: TYPE t_array_source_2 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.SUPPLIER_SITE%TYPE INDEX BY BINARY_INTEGER;
3364: TYPE t_array_source_3 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PAYMENT_PURPOSE%TYPE INDEX BY BINARY_INTEGER;
3365: TYPE t_array_source_4 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
3366: TYPE t_array_source_5 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.LOCATION_CODE%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;

Line 3365: TYPE t_array_source_4 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

3361:
3362: TYPE t_array_source_1 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.SUPPLIER_NAME%TYPE INDEX BY BINARY_INTEGER;
3363: TYPE t_array_source_2 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.SUPPLIER_SITE%TYPE INDEX BY BINARY_INTEGER;
3364: TYPE t_array_source_3 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PAYMENT_PURPOSE%TYPE INDEX BY BINARY_INTEGER;
3365: TYPE t_array_source_4 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
3366: TYPE t_array_source_5 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.LOCATION_CODE%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;

Line 3366: TYPE t_array_source_5 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.LOCATION_CODE%TYPE INDEX BY BINARY_INTEGER;

3362: TYPE t_array_source_1 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.SUPPLIER_NAME%TYPE INDEX BY BINARY_INTEGER;
3363: TYPE t_array_source_2 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.SUPPLIER_SITE%TYPE INDEX BY BINARY_INTEGER;
3364: TYPE t_array_source_3 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PAYMENT_PURPOSE%TYPE INDEX BY BINARY_INTEGER;
3365: TYPE t_array_source_4 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
3366: TYPE t_array_source_5 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.LOCATION_CODE%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:

Line 3367: TYPE t_array_source_6 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.LEASE_NUMBER%TYPE INDEX BY BINARY_INTEGER;

3363: TYPE t_array_source_2 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.SUPPLIER_SITE%TYPE INDEX BY BINARY_INTEGER;
3364: TYPE t_array_source_3 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PAYMENT_PURPOSE%TYPE INDEX BY BINARY_INTEGER;
3365: TYPE t_array_source_4 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
3366: TYPE t_array_source_5 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.LOCATION_CODE%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;

Line 3368: TYPE t_array_source_7 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PROPERTY_CODE%TYPE INDEX BY BINARY_INTEGER;

3364: TYPE t_array_source_3 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PAYMENT_PURPOSE%TYPE INDEX BY BINARY_INTEGER;
3365: TYPE t_array_source_4 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
3366: TYPE t_array_source_5 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.LOCATION_CODE%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;

Line 3369: TYPE t_array_source_12 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PAYMENT_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

3365: TYPE t_array_source_4 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
3366: TYPE t_array_source_5 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.LOCATION_CODE%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;

Line 3437: , PN_XLA_EXTRACT_HEADERS_V h1

3433: , h1.LEASE_NUMBER source_6
3434: , h1.PROPERTY_CODE source_7
3435: , h1.PAYMENT_ITEM_ID source_12
3436: FROM xla_events_gt xet
3437: , PN_XLA_EXTRACT_HEADERS_V h1
3438: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
3439: and xet.event_type_code = C_EVENT_TYPE_CODE
3440: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
3441:

Line 4279: WHEN 1 THEN 'PN_XLA_EXTRACT_HEADERS_V'

4275: FROM (
4276: SELECT xet.event_id event_id
4277: , 0 line_number
4278: , CASE r
4279: WHEN 1 THEN 'PN_XLA_EXTRACT_HEADERS_V'
4280: WHEN 2 THEN 'PN_XLA_EXTRACT_HEADERS_V'
4281: WHEN 3 THEN 'PN_XLA_EXTRACT_HEADERS_V'
4282: WHEN 4 THEN 'PN_XLA_EXTRACT_HEADERS_V'
4283: WHEN 5 THEN 'PN_XLA_EXTRACT_HEADERS_V'

Line 4280: WHEN 2 THEN 'PN_XLA_EXTRACT_HEADERS_V'

4276: SELECT xet.event_id event_id
4277: , 0 line_number
4278: , CASE r
4279: WHEN 1 THEN 'PN_XLA_EXTRACT_HEADERS_V'
4280: WHEN 2 THEN 'PN_XLA_EXTRACT_HEADERS_V'
4281: WHEN 3 THEN 'PN_XLA_EXTRACT_HEADERS_V'
4282: WHEN 4 THEN 'PN_XLA_EXTRACT_HEADERS_V'
4283: WHEN 5 THEN 'PN_XLA_EXTRACT_HEADERS_V'
4284: WHEN 6 THEN 'PN_XLA_EXTRACT_HEADERS_V'

Line 4281: WHEN 3 THEN 'PN_XLA_EXTRACT_HEADERS_V'

4277: , 0 line_number
4278: , CASE r
4279: WHEN 1 THEN 'PN_XLA_EXTRACT_HEADERS_V'
4280: WHEN 2 THEN 'PN_XLA_EXTRACT_HEADERS_V'
4281: WHEN 3 THEN 'PN_XLA_EXTRACT_HEADERS_V'
4282: WHEN 4 THEN 'PN_XLA_EXTRACT_HEADERS_V'
4283: WHEN 5 THEN 'PN_XLA_EXTRACT_HEADERS_V'
4284: WHEN 6 THEN 'PN_XLA_EXTRACT_HEADERS_V'
4285: WHEN 7 THEN 'PN_XLA_EXTRACT_HEADERS_V'

Line 4282: WHEN 4 THEN 'PN_XLA_EXTRACT_HEADERS_V'

4278: , CASE r
4279: WHEN 1 THEN 'PN_XLA_EXTRACT_HEADERS_V'
4280: WHEN 2 THEN 'PN_XLA_EXTRACT_HEADERS_V'
4281: WHEN 3 THEN 'PN_XLA_EXTRACT_HEADERS_V'
4282: WHEN 4 THEN 'PN_XLA_EXTRACT_HEADERS_V'
4283: WHEN 5 THEN 'PN_XLA_EXTRACT_HEADERS_V'
4284: WHEN 6 THEN 'PN_XLA_EXTRACT_HEADERS_V'
4285: WHEN 7 THEN 'PN_XLA_EXTRACT_HEADERS_V'
4286: WHEN 8 THEN 'PN_XLA_EXTRACT_HEADERS_V'

Line 4283: WHEN 5 THEN 'PN_XLA_EXTRACT_HEADERS_V'

4279: WHEN 1 THEN 'PN_XLA_EXTRACT_HEADERS_V'
4280: WHEN 2 THEN 'PN_XLA_EXTRACT_HEADERS_V'
4281: WHEN 3 THEN 'PN_XLA_EXTRACT_HEADERS_V'
4282: WHEN 4 THEN 'PN_XLA_EXTRACT_HEADERS_V'
4283: WHEN 5 THEN 'PN_XLA_EXTRACT_HEADERS_V'
4284: WHEN 6 THEN 'PN_XLA_EXTRACT_HEADERS_V'
4285: WHEN 7 THEN 'PN_XLA_EXTRACT_HEADERS_V'
4286: WHEN 8 THEN 'PN_XLA_EXTRACT_HEADERS_V'
4287:

Line 4284: WHEN 6 THEN 'PN_XLA_EXTRACT_HEADERS_V'

4280: WHEN 2 THEN 'PN_XLA_EXTRACT_HEADERS_V'
4281: WHEN 3 THEN 'PN_XLA_EXTRACT_HEADERS_V'
4282: WHEN 4 THEN 'PN_XLA_EXTRACT_HEADERS_V'
4283: WHEN 5 THEN 'PN_XLA_EXTRACT_HEADERS_V'
4284: WHEN 6 THEN 'PN_XLA_EXTRACT_HEADERS_V'
4285: WHEN 7 THEN 'PN_XLA_EXTRACT_HEADERS_V'
4286: WHEN 8 THEN 'PN_XLA_EXTRACT_HEADERS_V'
4287:
4288: ELSE null

Line 4285: WHEN 7 THEN 'PN_XLA_EXTRACT_HEADERS_V'

4281: WHEN 3 THEN 'PN_XLA_EXTRACT_HEADERS_V'
4282: WHEN 4 THEN 'PN_XLA_EXTRACT_HEADERS_V'
4283: WHEN 5 THEN 'PN_XLA_EXTRACT_HEADERS_V'
4284: WHEN 6 THEN 'PN_XLA_EXTRACT_HEADERS_V'
4285: WHEN 7 THEN 'PN_XLA_EXTRACT_HEADERS_V'
4286: WHEN 8 THEN 'PN_XLA_EXTRACT_HEADERS_V'
4287:
4288: ELSE null
4289: END object_name

Line 4286: WHEN 8 THEN 'PN_XLA_EXTRACT_HEADERS_V'

4282: WHEN 4 THEN 'PN_XLA_EXTRACT_HEADERS_V'
4283: WHEN 5 THEN 'PN_XLA_EXTRACT_HEADERS_V'
4284: WHEN 6 THEN 'PN_XLA_EXTRACT_HEADERS_V'
4285: WHEN 7 THEN 'PN_XLA_EXTRACT_HEADERS_V'
4286: WHEN 8 THEN 'PN_XLA_EXTRACT_HEADERS_V'
4287:
4288: ELSE null
4289: END object_name
4290: , CASE r

Line 4341: , PN_XLA_EXTRACT_HEADERS_V h1

4337: ELSE null
4338: END source_value
4339: , null source_meaning
4340: FROM xla_events_gt xet
4341: , PN_XLA_EXTRACT_HEADERS_V h1
4342: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
4343: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
4344: AND xet.event_type_code = C_EVENT_TYPE_CODE
4345: AND h1.event_id = xet.event_id

Line 4612: TYPE t_array_source_3 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PAYMENT_PURPOSE%TYPE INDEX BY BINARY_INTEGER;

4608: --
4609: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
4610: --
4611:
4612: TYPE t_array_source_3 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PAYMENT_PURPOSE%TYPE INDEX BY BINARY_INTEGER;
4613: TYPE t_array_source_4 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
4614: TYPE t_array_source_5 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.LOCATION_CODE%TYPE INDEX BY BINARY_INTEGER;
4615: TYPE t_array_source_6 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.LEASE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
4616: TYPE t_array_source_7 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PROPERTY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 4613: TYPE t_array_source_4 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

4609: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
4610: --
4611:
4612: TYPE t_array_source_3 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PAYMENT_PURPOSE%TYPE INDEX BY BINARY_INTEGER;
4613: TYPE t_array_source_4 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
4614: TYPE t_array_source_5 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.LOCATION_CODE%TYPE INDEX BY BINARY_INTEGER;
4615: TYPE t_array_source_6 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.LEASE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
4616: TYPE t_array_source_7 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PROPERTY_CODE%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;

Line 4614: TYPE t_array_source_5 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.LOCATION_CODE%TYPE INDEX BY BINARY_INTEGER;

4610: --
4611:
4612: TYPE t_array_source_3 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PAYMENT_PURPOSE%TYPE INDEX BY BINARY_INTEGER;
4613: TYPE t_array_source_4 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
4614: TYPE t_array_source_5 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.LOCATION_CODE%TYPE INDEX BY BINARY_INTEGER;
4615: TYPE t_array_source_6 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.LEASE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
4616: TYPE t_array_source_7 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PROPERTY_CODE%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;

Line 4615: TYPE t_array_source_6 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.LEASE_NUMBER%TYPE INDEX BY BINARY_INTEGER;

4611:
4612: TYPE t_array_source_3 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PAYMENT_PURPOSE%TYPE INDEX BY BINARY_INTEGER;
4613: TYPE t_array_source_4 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
4614: TYPE t_array_source_5 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.LOCATION_CODE%TYPE INDEX BY BINARY_INTEGER;
4615: TYPE t_array_source_6 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.LEASE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
4616: TYPE t_array_source_7 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PROPERTY_CODE%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;

Line 4616: TYPE t_array_source_7 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PROPERTY_CODE%TYPE INDEX BY BINARY_INTEGER;

4612: TYPE t_array_source_3 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PAYMENT_PURPOSE%TYPE INDEX BY BINARY_INTEGER;
4613: TYPE t_array_source_4 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
4614: TYPE t_array_source_5 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.LOCATION_CODE%TYPE INDEX BY BINARY_INTEGER;
4615: TYPE t_array_source_6 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.LEASE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
4616: TYPE t_array_source_7 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PROPERTY_CODE%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:

Line 4617: TYPE t_array_source_8 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.CUSTOMER_NAME%TYPE INDEX BY BINARY_INTEGER;

4613: TYPE t_array_source_4 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
4614: TYPE t_array_source_5 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.LOCATION_CODE%TYPE INDEX BY BINARY_INTEGER;
4615: TYPE t_array_source_6 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.LEASE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
4616: TYPE t_array_source_7 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PROPERTY_CODE%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;

Line 4618: TYPE t_array_source_9 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.CUSTOMER_SITE%TYPE INDEX BY BINARY_INTEGER;

4614: TYPE t_array_source_5 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.LOCATION_CODE%TYPE INDEX BY BINARY_INTEGER;
4615: TYPE t_array_source_6 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.LEASE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
4616: TYPE t_array_source_7 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PROPERTY_CODE%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;

Line 4619: TYPE t_array_source_12 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PAYMENT_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

4615: TYPE t_array_source_6 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.LEASE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
4616: TYPE t_array_source_7 IS TABLE OF PN_XLA_EXTRACT_HEADERS_V.PROPERTY_CODE%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;

Line 4687: , PN_XLA_EXTRACT_HEADERS_V h1

4683: , h1.CUSTOMER_NAME source_8
4684: , h1.CUSTOMER_SITE source_9
4685: , h1.PAYMENT_ITEM_ID source_12
4686: FROM xla_events_gt xet
4687: , PN_XLA_EXTRACT_HEADERS_V h1
4688: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
4689: and xet.event_type_code = C_EVENT_TYPE_CODE
4690: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
4691: