15468: FROM (
15469: SELECT xet.event_id event_id
15470: , l2.line_number line_number
15471: , CASE r
15472: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
15473: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
15474: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
15475: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
15476: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
15469: SELECT xet.event_id event_id
15470: , l2.line_number line_number
15471: , CASE r
15472: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
15473: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
15474: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
15475: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
15476: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
15477:
15470: , l2.line_number line_number
15471: , CASE r
15472: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
15473: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
15474: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
15475: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
15476: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
15477:
15478: ELSE null
15471: , CASE r
15472: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
15473: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
15474: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
15475: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
15476: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
15477:
15478: ELSE null
15479: END object_name
15472: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
15473: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
15474: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
15475: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
15476: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
15477:
15478: ELSE null
15479: END object_name
15480: , CASE r
15519:
15520: ELSE null
15521: END source_meaning
15522: FROM xla_events_gt xet
15523: , OKL_CMN_EXTRACT_LINE_V l2
15524: , fnd_lookup_values fvl6
15525: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
15526: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
15527: AND xet.event_class_code = C_EVENT_CLASS_CODE
15670: TYPE t_array_source_14 IS TABLE OF OKL_SHR_EXTRACT_HDR_V.TCN_ACCRUAL_REVERSAL_DATE%TYPE INDEX BY BINARY_INTEGER;
15671: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
15672: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
15673:
15674: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
15675: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
15676: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
15677: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
15678: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
15671: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
15672: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
15673:
15674: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
15675: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
15676: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
15677: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
15678: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
15679:
15672: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
15673:
15674: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
15675: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
15676: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
15677: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
15678: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
15679:
15680: l_array_source_1 t_array_source_1;
15673:
15674: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
15675: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
15676: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
15677: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
15678: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
15679:
15680: l_array_source_1 t_array_source_1;
15681: l_array_source_2 t_array_source_2;
15674: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
15675: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
15676: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
15677: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
15678: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
15679:
15680: l_array_source_1 t_array_source_1;
15681: l_array_source_2 t_array_source_2;
15682: l_array_source_10 t_array_source_10;
15779: , l2.DIST_ID source_7
15780: , l2.DIST_TYPE source_8
15781: , l2.DIST_ENTERED_AMOUNT source_9
15782: FROM xla_events_gt xet
15783: , OKL_CMN_EXTRACT_LINE_V l2
15784: , fnd_lookup_values fvl6
15785: WHERE xet.event_id between x_first_event_id and x_last_event_id
15786: and xet.event_date between p_pad_start_date and p_pad_end_date
15787: and xet.event_class_code = C_EVENT_CLASS_CODE
16715: FROM (
16716: SELECT xet.event_id event_id
16717: , l2.line_number line_number
16718: , CASE r
16719: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
16720: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
16721: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
16722: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
16723: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
16716: SELECT xet.event_id event_id
16717: , l2.line_number line_number
16718: , CASE r
16719: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
16720: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
16721: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
16722: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
16723: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
16724:
16717: , l2.line_number line_number
16718: , CASE r
16719: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
16720: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
16721: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
16722: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
16723: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
16724:
16725: ELSE null
16718: , CASE r
16719: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
16720: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
16721: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
16722: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
16723: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
16724:
16725: ELSE null
16726: END object_name
16719: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
16720: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
16721: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
16722: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
16723: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
16724:
16725: ELSE null
16726: END object_name
16727: , CASE r
16766:
16767: ELSE null
16768: END source_meaning
16769: FROM xla_events_gt xet
16770: , OKL_CMN_EXTRACT_LINE_V l2
16771: , fnd_lookup_values fvl6
16772: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
16773: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
16774: AND xet.event_class_code = C_EVENT_CLASS_CODE
16916: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
16917: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
16918: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
16919:
16920: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
16921: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
16922: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
16923: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
16924: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
16917: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
16918: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
16919:
16920: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
16921: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
16922: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
16923: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
16924: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
16925:
16918: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
16919:
16920: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
16921: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
16922: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
16923: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
16924: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
16925:
16926: l_array_source_1 t_array_source_1;
16919:
16920: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
16921: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
16922: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
16923: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
16924: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
16925:
16926: l_array_source_1 t_array_source_1;
16927: l_array_source_2 t_array_source_2;
16920: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
16921: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
16922: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
16923: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
16924: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
16925:
16926: l_array_source_1 t_array_source_1;
16927: l_array_source_2 t_array_source_2;
16928: l_array_source_10 t_array_source_10;
17022: , l2.DIST_ID source_7
17023: , l2.DIST_TYPE source_8
17024: , l2.DIST_ENTERED_AMOUNT source_9
17025: FROM xla_events_gt xet
17026: , OKL_CMN_EXTRACT_LINE_V l2
17027: , fnd_lookup_values fvl6
17028: WHERE xet.event_id between x_first_event_id and x_last_event_id
17029: and xet.event_date between p_pad_start_date and p_pad_end_date
17030: and xet.event_class_code = C_EVENT_CLASS_CODE
17900: FROM (
17901: SELECT xet.event_id event_id
17902: , l2.line_number line_number
17903: , CASE r
17904: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
17905: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
17906: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
17907: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
17908: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
17901: SELECT xet.event_id event_id
17902: , l2.line_number line_number
17903: , CASE r
17904: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
17905: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
17906: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
17907: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
17908: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
17909:
17902: , l2.line_number line_number
17903: , CASE r
17904: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
17905: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
17906: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
17907: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
17908: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
17909:
17910: ELSE null
17903: , CASE r
17904: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
17905: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
17906: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
17907: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
17908: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
17909:
17910: ELSE null
17911: END object_name
17904: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
17905: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
17906: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
17907: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
17908: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
17909:
17910: ELSE null
17911: END object_name
17912: , CASE r
17951:
17952: ELSE null
17953: END source_meaning
17954: FROM xla_events_gt xet
17955: , OKL_CMN_EXTRACT_LINE_V l2
17956: , fnd_lookup_values fvl6
17957: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
17958: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
17959: AND xet.event_class_code = C_EVENT_CLASS_CODE
18101: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
18102: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
18103: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
18104:
18105: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
18106: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
18107: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
18108: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
18109: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
18102: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
18103: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
18104:
18105: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
18106: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
18107: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
18108: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
18109: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
18110:
18103: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
18104:
18105: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
18106: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
18107: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
18108: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
18109: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
18110:
18111: l_array_source_1 t_array_source_1;
18104:
18105: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
18106: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
18107: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
18108: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
18109: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
18110:
18111: l_array_source_1 t_array_source_1;
18112: l_array_source_2 t_array_source_2;
18105: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
18106: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
18107: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
18108: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
18109: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
18110:
18111: l_array_source_1 t_array_source_1;
18112: l_array_source_2 t_array_source_2;
18113: l_array_source_10 t_array_source_10;
18207: , l2.DIST_ID source_7
18208: , l2.DIST_TYPE source_8
18209: , l2.DIST_ENTERED_AMOUNT source_9
18210: FROM xla_events_gt xet
18211: , OKL_CMN_EXTRACT_LINE_V l2
18212: , fnd_lookup_values fvl6
18213: WHERE xet.event_id between x_first_event_id and x_last_event_id
18214: and xet.event_date between p_pad_start_date and p_pad_end_date
18215: and xet.event_class_code = C_EVENT_CLASS_CODE
19085: FROM (
19086: SELECT xet.event_id event_id
19087: , l2.line_number line_number
19088: , CASE r
19089: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
19090: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
19091: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
19092: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
19093: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
19086: SELECT xet.event_id event_id
19087: , l2.line_number line_number
19088: , CASE r
19089: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
19090: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
19091: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
19092: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
19093: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
19094:
19087: , l2.line_number line_number
19088: , CASE r
19089: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
19090: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
19091: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
19092: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
19093: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
19094:
19095: ELSE null
19088: , CASE r
19089: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
19090: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
19091: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
19092: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
19093: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
19094:
19095: ELSE null
19096: END object_name
19089: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
19090: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
19091: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
19092: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
19093: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
19094:
19095: ELSE null
19096: END object_name
19097: , CASE r
19136:
19137: ELSE null
19138: END source_meaning
19139: FROM xla_events_gt xet
19140: , OKL_CMN_EXTRACT_LINE_V l2
19141: , fnd_lookup_values fvl6
19142: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
19143: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
19144: AND xet.event_class_code = C_EVENT_CLASS_CODE
19286: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
19287: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
19288: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
19289:
19290: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
19291: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
19292: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
19293: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
19294: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
19287: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
19288: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
19289:
19290: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
19291: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
19292: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
19293: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
19294: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
19295:
19288: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
19289:
19290: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
19291: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
19292: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
19293: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
19294: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
19295:
19296: l_array_source_1 t_array_source_1;
19289:
19290: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
19291: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
19292: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
19293: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
19294: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
19295:
19296: l_array_source_1 t_array_source_1;
19297: l_array_source_2 t_array_source_2;
19290: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
19291: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
19292: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
19293: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
19294: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
19295:
19296: l_array_source_1 t_array_source_1;
19297: l_array_source_2 t_array_source_2;
19298: l_array_source_10 t_array_source_10;
19392: , l2.DIST_ID source_7
19393: , l2.DIST_TYPE source_8
19394: , l2.DIST_ENTERED_AMOUNT source_9
19395: FROM xla_events_gt xet
19396: , OKL_CMN_EXTRACT_LINE_V l2
19397: , fnd_lookup_values fvl6
19398: WHERE xet.event_id between x_first_event_id and x_last_event_id
19399: and xet.event_date between p_pad_start_date and p_pad_end_date
19400: and xet.event_class_code = C_EVENT_CLASS_CODE
20270: FROM (
20271: SELECT xet.event_id event_id
20272: , l2.line_number line_number
20273: , CASE r
20274: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
20275: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
20276: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
20277: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
20278: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
20271: SELECT xet.event_id event_id
20272: , l2.line_number line_number
20273: , CASE r
20274: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
20275: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
20276: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
20277: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
20278: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
20279:
20272: , l2.line_number line_number
20273: , CASE r
20274: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
20275: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
20276: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
20277: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
20278: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
20279:
20280: ELSE null
20273: , CASE r
20274: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
20275: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
20276: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
20277: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
20278: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
20279:
20280: ELSE null
20281: END object_name
20274: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
20275: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
20276: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
20277: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
20278: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
20279:
20280: ELSE null
20281: END object_name
20282: , CASE r
20321:
20322: ELSE null
20323: END source_meaning
20324: FROM xla_events_gt xet
20325: , OKL_CMN_EXTRACT_LINE_V l2
20326: , fnd_lookup_values fvl6
20327: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
20328: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
20329: AND xet.event_class_code = C_EVENT_CLASS_CODE
20471: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
20472: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
20473: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
20474:
20475: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
20476: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
20477: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
20478: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
20479: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
20472: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
20473: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
20474:
20475: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
20476: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
20477: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
20478: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
20479: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
20480:
20473: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
20474:
20475: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
20476: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
20477: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
20478: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
20479: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
20480:
20481: l_array_source_1 t_array_source_1;
20474:
20475: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
20476: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
20477: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
20478: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
20479: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
20480:
20481: l_array_source_1 t_array_source_1;
20482: l_array_source_2 t_array_source_2;
20475: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
20476: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
20477: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
20478: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
20479: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
20480:
20481: l_array_source_1 t_array_source_1;
20482: l_array_source_2 t_array_source_2;
20483: l_array_source_10 t_array_source_10;
20577: , l2.DIST_ID source_7
20578: , l2.DIST_TYPE source_8
20579: , l2.DIST_ENTERED_AMOUNT source_9
20580: FROM xla_events_gt xet
20581: , OKL_CMN_EXTRACT_LINE_V l2
20582: , fnd_lookup_values fvl6
20583: WHERE xet.event_id between x_first_event_id and x_last_event_id
20584: and xet.event_date between p_pad_start_date and p_pad_end_date
20585: and xet.event_class_code = C_EVENT_CLASS_CODE
21455: FROM (
21456: SELECT xet.event_id event_id
21457: , l1.line_number line_number
21458: , CASE r
21459: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
21460: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
21461: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
21462: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
21463: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
21456: SELECT xet.event_id event_id
21457: , l1.line_number line_number
21458: , CASE r
21459: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
21460: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
21461: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
21462: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
21463: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
21464:
21457: , l1.line_number line_number
21458: , CASE r
21459: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
21460: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
21461: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
21462: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
21463: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
21464:
21465: ELSE null
21458: , CASE r
21459: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
21460: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
21461: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
21462: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
21463: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
21464:
21465: ELSE null
21466: END object_name
21459: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
21460: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
21461: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
21462: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
21463: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
21464:
21465: ELSE null
21466: END object_name
21467: , CASE r
21506:
21507: ELSE null
21508: END source_meaning
21509: FROM xla_events_gt xet
21510: , OKL_CMN_EXTRACT_LINE_V l1
21511: , fnd_lookup_values fvl6
21512: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
21513: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
21514: AND xet.event_class_code = C_EVENT_CLASS_CODE
21656: TYPE t_array_source_13 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
21657: TYPE t_array_source_15 IS TABLE OF OKL_IA_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
21658: TYPE t_array_source_16 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
21659:
21660: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
21661: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
21662: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
21663: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
21664: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
21657: TYPE t_array_source_15 IS TABLE OF OKL_IA_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
21658: TYPE t_array_source_16 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
21659:
21660: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
21661: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
21662: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
21663: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
21664: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
21665:
21658: TYPE t_array_source_16 IS TABLE OF OKL_IA_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
21659:
21660: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
21661: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
21662: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
21663: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
21664: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
21665:
21666: l_array_source_3 t_array_source_3;
21659:
21660: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
21661: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
21662: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
21663: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
21664: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
21665:
21666: l_array_source_3 t_array_source_3;
21667: l_array_source_4 t_array_source_4;
21660: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
21661: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
21662: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
21663: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
21664: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
21665:
21666: l_array_source_3 t_array_source_3;
21667: l_array_source_4 t_array_source_4;
21668: l_array_source_10 t_array_source_10;
21762: , l1.DIST_ID source_7
21763: , l1.DIST_TYPE source_8
21764: , l1.DIST_ENTERED_AMOUNT source_9
21765: FROM xla_events_gt xet
21766: , OKL_CMN_EXTRACT_LINE_V l1
21767: , fnd_lookup_values fvl6
21768: WHERE xet.event_id between x_first_event_id and x_last_event_id
21769: and xet.event_date between p_pad_start_date and p_pad_end_date
21770: and xet.event_class_code = C_EVENT_CLASS_CODE
22640: FROM (
22641: SELECT xet.event_id event_id
22642: , l2.line_number line_number
22643: , CASE r
22644: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
22645: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
22646: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
22647: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
22648: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
22641: SELECT xet.event_id event_id
22642: , l2.line_number line_number
22643: , CASE r
22644: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
22645: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
22646: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
22647: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
22648: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
22649:
22642: , l2.line_number line_number
22643: , CASE r
22644: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
22645: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
22646: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
22647: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
22648: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
22649:
22650: ELSE null
22643: , CASE r
22644: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
22645: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
22646: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
22647: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
22648: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
22649:
22650: ELSE null
22651: END object_name
22644: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
22645: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
22646: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
22647: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
22648: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
22649:
22650: ELSE null
22651: END object_name
22652: , CASE r
22691:
22692: ELSE null
22693: END source_meaning
22694: FROM xla_events_gt xet
22695: , OKL_CMN_EXTRACT_LINE_V l2
22696: , fnd_lookup_values fvl6
22697: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
22698: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
22699: AND xet.event_class_code = C_EVENT_CLASS_CODE
22841: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
22842: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
22843: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
22844:
22845: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
22846: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
22847: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
22848: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
22849: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
22842: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
22843: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
22844:
22845: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
22846: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
22847: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
22848: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
22849: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
22850:
22843: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
22844:
22845: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
22846: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
22847: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
22848: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
22849: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
22850:
22851: l_array_source_1 t_array_source_1;
22844:
22845: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
22846: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
22847: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
22848: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
22849: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
22850:
22851: l_array_source_1 t_array_source_1;
22852: l_array_source_2 t_array_source_2;
22845: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
22846: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
22847: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
22848: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
22849: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
22850:
22851: l_array_source_1 t_array_source_1;
22852: l_array_source_2 t_array_source_2;
22853: l_array_source_10 t_array_source_10;
22947: , l2.DIST_ID source_7
22948: , l2.DIST_TYPE source_8
22949: , l2.DIST_ENTERED_AMOUNT source_9
22950: FROM xla_events_gt xet
22951: , OKL_CMN_EXTRACT_LINE_V l2
22952: , fnd_lookup_values fvl6
22953: WHERE xet.event_id between x_first_event_id and x_last_event_id
22954: and xet.event_date between p_pad_start_date and p_pad_end_date
22955: and xet.event_class_code = C_EVENT_CLASS_CODE
23825: FROM (
23826: SELECT xet.event_id event_id
23827: , l2.line_number line_number
23828: , CASE r
23829: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
23830: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
23831: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
23832: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
23833: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
23826: SELECT xet.event_id event_id
23827: , l2.line_number line_number
23828: , CASE r
23829: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
23830: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
23831: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
23832: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
23833: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
23834:
23827: , l2.line_number line_number
23828: , CASE r
23829: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
23830: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
23831: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
23832: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
23833: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
23834:
23835: ELSE null
23828: , CASE r
23829: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
23830: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
23831: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
23832: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
23833: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
23834:
23835: ELSE null
23836: END object_name
23829: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
23830: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
23831: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
23832: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
23833: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
23834:
23835: ELSE null
23836: END object_name
23837: , CASE r
23876:
23877: ELSE null
23878: END source_meaning
23879: FROM xla_events_gt xet
23880: , OKL_CMN_EXTRACT_LINE_V l2
23881: , fnd_lookup_values fvl6
23882: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
23883: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
23884: AND xet.event_class_code = C_EVENT_CLASS_CODE
24026: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
24027: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
24028: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
24029:
24030: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
24031: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
24032: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
24033: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
24034: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
24027: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
24028: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
24029:
24030: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
24031: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
24032: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
24033: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
24034: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
24035:
24028: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
24029:
24030: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
24031: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
24032: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
24033: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
24034: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
24035:
24036: l_array_source_1 t_array_source_1;
24029:
24030: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
24031: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
24032: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
24033: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
24034: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
24035:
24036: l_array_source_1 t_array_source_1;
24037: l_array_source_2 t_array_source_2;
24030: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
24031: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
24032: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
24033: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
24034: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
24035:
24036: l_array_source_1 t_array_source_1;
24037: l_array_source_2 t_array_source_2;
24038: l_array_source_10 t_array_source_10;
24132: , l2.DIST_ID source_7
24133: , l2.DIST_TYPE source_8
24134: , l2.DIST_ENTERED_AMOUNT source_9
24135: FROM xla_events_gt xet
24136: , OKL_CMN_EXTRACT_LINE_V l2
24137: , fnd_lookup_values fvl6
24138: WHERE xet.event_id between x_first_event_id and x_last_event_id
24139: and xet.event_date between p_pad_start_date and p_pad_end_date
24140: and xet.event_class_code = C_EVENT_CLASS_CODE
25010: FROM (
25011: SELECT xet.event_id event_id
25012: , l2.line_number line_number
25013: , CASE r
25014: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
25015: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
25016: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
25017: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
25018: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
25011: SELECT xet.event_id event_id
25012: , l2.line_number line_number
25013: , CASE r
25014: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
25015: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
25016: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
25017: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
25018: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
25019:
25012: , l2.line_number line_number
25013: , CASE r
25014: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
25015: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
25016: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
25017: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
25018: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
25019:
25020: ELSE null
25013: , CASE r
25014: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
25015: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
25016: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
25017: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
25018: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
25019:
25020: ELSE null
25021: END object_name
25014: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
25015: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
25016: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
25017: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
25018: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
25019:
25020: ELSE null
25021: END object_name
25022: , CASE r
25061:
25062: ELSE null
25063: END source_meaning
25064: FROM xla_events_gt xet
25065: , OKL_CMN_EXTRACT_LINE_V l2
25066: , fnd_lookup_values fvl6
25067: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
25068: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
25069: AND xet.event_class_code = C_EVENT_CLASS_CODE
25211: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
25212: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
25213: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
25214:
25215: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
25216: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
25217: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
25218: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
25219: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
25212: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
25213: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
25214:
25215: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
25216: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
25217: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
25218: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
25219: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
25220:
25213: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
25214:
25215: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
25216: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
25217: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
25218: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
25219: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
25220:
25221: l_array_source_1 t_array_source_1;
25214:
25215: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
25216: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
25217: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
25218: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
25219: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
25220:
25221: l_array_source_1 t_array_source_1;
25222: l_array_source_2 t_array_source_2;
25215: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
25216: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
25217: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
25218: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
25219: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
25220:
25221: l_array_source_1 t_array_source_1;
25222: l_array_source_2 t_array_source_2;
25223: l_array_source_10 t_array_source_10;
25317: , l2.DIST_ID source_7
25318: , l2.DIST_TYPE source_8
25319: , l2.DIST_ENTERED_AMOUNT source_9
25320: FROM xla_events_gt xet
25321: , OKL_CMN_EXTRACT_LINE_V l2
25322: , fnd_lookup_values fvl6
25323: WHERE xet.event_id between x_first_event_id and x_last_event_id
25324: and xet.event_date between p_pad_start_date and p_pad_end_date
25325: and xet.event_class_code = C_EVENT_CLASS_CODE
26195: FROM (
26196: SELECT xet.event_id event_id
26197: , l2.line_number line_number
26198: , CASE r
26199: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
26200: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
26201: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
26202: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
26203: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
26196: SELECT xet.event_id event_id
26197: , l2.line_number line_number
26198: , CASE r
26199: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
26200: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
26201: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
26202: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
26203: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
26204:
26197: , l2.line_number line_number
26198: , CASE r
26199: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
26200: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
26201: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
26202: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
26203: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
26204:
26205: ELSE null
26198: , CASE r
26199: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
26200: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
26201: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
26202: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
26203: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
26204:
26205: ELSE null
26206: END object_name
26199: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
26200: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
26201: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
26202: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
26203: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
26204:
26205: ELSE null
26206: END object_name
26207: , CASE r
26246:
26247: ELSE null
26248: END source_meaning
26249: FROM xla_events_gt xet
26250: , OKL_CMN_EXTRACT_LINE_V l2
26251: , fnd_lookup_values fvl6
26252: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
26253: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
26254: AND xet.event_class_code = C_EVENT_CLASS_CODE
26396: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
26397: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
26398: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
26399:
26400: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
26401: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
26402: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
26403: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
26404: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
26397: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
26398: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
26399:
26400: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
26401: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
26402: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
26403: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
26404: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
26405:
26398: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
26399:
26400: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
26401: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
26402: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
26403: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
26404: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
26405:
26406: l_array_source_1 t_array_source_1;
26399:
26400: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
26401: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
26402: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
26403: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
26404: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
26405:
26406: l_array_source_1 t_array_source_1;
26407: l_array_source_2 t_array_source_2;
26400: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
26401: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
26402: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
26403: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
26404: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
26405:
26406: l_array_source_1 t_array_source_1;
26407: l_array_source_2 t_array_source_2;
26408: l_array_source_10 t_array_source_10;
26502: , l2.DIST_ID source_7
26503: , l2.DIST_TYPE source_8
26504: , l2.DIST_ENTERED_AMOUNT source_9
26505: FROM xla_events_gt xet
26506: , OKL_CMN_EXTRACT_LINE_V l2
26507: , fnd_lookup_values fvl6
26508: WHERE xet.event_id between x_first_event_id and x_last_event_id
26509: and xet.event_date between p_pad_start_date and p_pad_end_date
26510: and xet.event_class_code = C_EVENT_CLASS_CODE
27380: FROM (
27381: SELECT xet.event_id event_id
27382: , l2.line_number line_number
27383: , CASE r
27384: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
27385: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
27386: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
27387: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
27388: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
27381: SELECT xet.event_id event_id
27382: , l2.line_number line_number
27383: , CASE r
27384: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
27385: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
27386: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
27387: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
27388: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
27389:
27382: , l2.line_number line_number
27383: , CASE r
27384: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
27385: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
27386: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
27387: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
27388: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
27389:
27390: ELSE null
27383: , CASE r
27384: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
27385: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
27386: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
27387: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
27388: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
27389:
27390: ELSE null
27391: END object_name
27384: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
27385: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
27386: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
27387: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
27388: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
27389:
27390: ELSE null
27391: END object_name
27392: , CASE r
27431:
27432: ELSE null
27433: END source_meaning
27434: FROM xla_events_gt xet
27435: , OKL_CMN_EXTRACT_LINE_V l2
27436: , fnd_lookup_values fvl6
27437: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
27438: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
27439: AND xet.event_class_code = C_EVENT_CLASS_CODE
27581: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
27582: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
27583: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
27584:
27585: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
27586: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
27587: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
27588: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
27589: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
27582: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
27583: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
27584:
27585: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
27586: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
27587: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
27588: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
27589: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
27590:
27583: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
27584:
27585: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
27586: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
27587: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
27588: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
27589: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
27590:
27591: l_array_source_1 t_array_source_1;
27584:
27585: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
27586: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
27587: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
27588: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
27589: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
27590:
27591: l_array_source_1 t_array_source_1;
27592: l_array_source_2 t_array_source_2;
27585: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
27586: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
27587: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
27588: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
27589: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
27590:
27591: l_array_source_1 t_array_source_1;
27592: l_array_source_2 t_array_source_2;
27593: l_array_source_10 t_array_source_10;
27687: , l2.DIST_ID source_7
27688: , l2.DIST_TYPE source_8
27689: , l2.DIST_ENTERED_AMOUNT source_9
27690: FROM xla_events_gt xet
27691: , OKL_CMN_EXTRACT_LINE_V l2
27692: , fnd_lookup_values fvl6
27693: WHERE xet.event_id between x_first_event_id and x_last_event_id
27694: and xet.event_date between p_pad_start_date and p_pad_end_date
27695: and xet.event_class_code = C_EVENT_CLASS_CODE
28560: FROM (
28561: SELECT xet.event_id event_id
28562: , l2.line_number line_number
28563: , CASE r
28564: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
28565: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
28566: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
28567: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
28568: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
28561: SELECT xet.event_id event_id
28562: , l2.line_number line_number
28563: , CASE r
28564: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
28565: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
28566: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
28567: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
28568: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
28569:
28562: , l2.line_number line_number
28563: , CASE r
28564: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
28565: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
28566: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
28567: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
28568: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
28569:
28570: ELSE null
28563: , CASE r
28564: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
28565: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
28566: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
28567: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
28568: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
28569:
28570: ELSE null
28571: END object_name
28564: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
28565: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
28566: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
28567: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
28568: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
28569:
28570: ELSE null
28571: END object_name
28572: , CASE r
28611:
28612: ELSE null
28613: END source_meaning
28614: FROM xla_events_gt xet
28615: , OKL_CMN_EXTRACT_LINE_V l2
28616: , fnd_lookup_values fvl6
28617: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
28618: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
28619: AND xet.event_class_code = C_EVENT_CLASS_CODE
28760: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
28761: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
28762: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
28763:
28764: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
28765: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
28766: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
28767: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
28768: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
28761: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
28762: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
28763:
28764: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
28765: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
28766: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
28767: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
28768: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
28769:
28762: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
28763:
28764: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
28765: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
28766: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
28767: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
28768: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
28769:
28770: l_array_source_1 t_array_source_1;
28763:
28764: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
28765: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
28766: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
28767: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
28768: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
28769:
28770: l_array_source_1 t_array_source_1;
28771: l_array_source_2 t_array_source_2;
28764: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
28765: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
28766: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
28767: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
28768: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
28769:
28770: l_array_source_1 t_array_source_1;
28771: l_array_source_2 t_array_source_2;
28772: l_array_source_10 t_array_source_10;
28864: , l2.DIST_ID source_7
28865: , l2.DIST_TYPE source_8
28866: , l2.DIST_ENTERED_AMOUNT source_9
28867: FROM xla_events_gt xet
28868: , OKL_CMN_EXTRACT_LINE_V l2
28869: , fnd_lookup_values fvl6
28870: WHERE xet.event_id between x_first_event_id and x_last_event_id
28871: and xet.event_date between p_pad_start_date and p_pad_end_date
28872: and xet.event_class_code = C_EVENT_CLASS_CODE
29728: FROM (
29729: SELECT xet.event_id event_id
29730: , l2.line_number line_number
29731: , CASE r
29732: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
29733: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
29734: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
29735: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
29736: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
29729: SELECT xet.event_id event_id
29730: , l2.line_number line_number
29731: , CASE r
29732: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
29733: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
29734: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
29735: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
29736: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
29737:
29730: , l2.line_number line_number
29731: , CASE r
29732: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
29733: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
29734: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
29735: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
29736: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
29737:
29738: ELSE null
29731: , CASE r
29732: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
29733: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
29734: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
29735: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
29736: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
29737:
29738: ELSE null
29739: END object_name
29732: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
29733: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
29734: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
29735: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
29736: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
29737:
29738: ELSE null
29739: END object_name
29740: , CASE r
29779:
29780: ELSE null
29781: END source_meaning
29782: FROM xla_events_gt xet
29783: , OKL_CMN_EXTRACT_LINE_V l2
29784: , fnd_lookup_values fvl6
29785: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
29786: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
29787: AND xet.event_class_code = C_EVENT_CLASS_CODE
29929: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
29930: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
29931: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
29932:
29933: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
29934: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
29935: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
29936: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
29937: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
29930: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
29931: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
29932:
29933: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
29934: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
29935: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
29936: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
29937: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
29938:
29931: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
29932:
29933: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
29934: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
29935: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
29936: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
29937: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
29938:
29939: l_array_source_1 t_array_source_1;
29932:
29933: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
29934: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
29935: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
29936: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
29937: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
29938:
29939: l_array_source_1 t_array_source_1;
29940: l_array_source_2 t_array_source_2;
29933: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
29934: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
29935: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
29936: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
29937: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
29938:
29939: l_array_source_1 t_array_source_1;
29940: l_array_source_2 t_array_source_2;
29941: l_array_source_10 t_array_source_10;
30035: , l2.DIST_ID source_7
30036: , l2.DIST_TYPE source_8
30037: , l2.DIST_ENTERED_AMOUNT source_9
30038: FROM xla_events_gt xet
30039: , OKL_CMN_EXTRACT_LINE_V l2
30040: , fnd_lookup_values fvl6
30041: WHERE xet.event_id between x_first_event_id and x_last_event_id
30042: and xet.event_date between p_pad_start_date and p_pad_end_date
30043: and xet.event_class_code = C_EVENT_CLASS_CODE
30913: FROM (
30914: SELECT xet.event_id event_id
30915: , l2.line_number line_number
30916: , CASE r
30917: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
30918: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
30919: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
30920: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
30921: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
30914: SELECT xet.event_id event_id
30915: , l2.line_number line_number
30916: , CASE r
30917: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
30918: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
30919: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
30920: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
30921: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
30922:
30915: , l2.line_number line_number
30916: , CASE r
30917: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
30918: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
30919: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
30920: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
30921: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
30922:
30923: ELSE null
30916: , CASE r
30917: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
30918: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
30919: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
30920: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
30921: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
30922:
30923: ELSE null
30924: END object_name
30917: WHEN 1 THEN 'OKL_CMN_EXTRACT_LINE_V'
30918: WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
30919: WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
30920: WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
30921: WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_V'
30922:
30923: ELSE null
30924: END object_name
30925: , CASE r
30964:
30965: ELSE null
30966: END source_meaning
30967: FROM xla_events_gt xet
30968: , OKL_CMN_EXTRACT_LINE_V l2
30969: , fnd_lookup_values fvl6
30970: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
30971: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
30972: AND xet.event_class_code = C_EVENT_CLASS_CODE
31114: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
31115: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
31116: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
31117:
31118: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
31119: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
31120: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
31121: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
31122: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
31115: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
31116: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
31117:
31118: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
31119: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
31120: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
31121: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
31122: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
31123:
31116: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
31117:
31118: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
31119: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
31120: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
31121: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
31122: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
31123:
31124: l_array_source_1 t_array_source_1;
31117:
31118: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
31119: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
31120: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
31121: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
31122: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
31123:
31124: l_array_source_1 t_array_source_1;
31125: l_array_source_2 t_array_source_2;
31118: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
31119: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
31120: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;
31121: TYPE t_array_source_8 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
31122: TYPE t_array_source_9 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
31123:
31124: l_array_source_1 t_array_source_1;
31125: l_array_source_2 t_array_source_2;
31126: l_array_source_10 t_array_source_10;
31220: , l2.DIST_ID source_7
31221: , l2.DIST_TYPE source_8
31222: , l2.DIST_ENTERED_AMOUNT source_9
31223: FROM xla_events_gt xet
31224: , OKL_CMN_EXTRACT_LINE_V l2
31225: , fnd_lookup_values fvl6
31226: WHERE xet.event_id between x_first_event_id and x_last_event_id
31227: and xet.event_date between p_pad_start_date and p_pad_end_date
31228: and xet.event_class_code = C_EVENT_CLASS_CODE