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_00707_AAD_S_000019_PKG dependencies on CST_XLA_WIP_LINES_V

Line 305292: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'

305288: FROM (
305289: SELECT xet.event_id event_id
305290: , l2.line_number line_number
305291: , CASE r
305292: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
305293: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
305294: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
305295: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
305296: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'

Line 305293: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'

305289: SELECT xet.event_id event_id
305290: , l2.line_number line_number
305291: , CASE r
305292: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
305293: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
305294: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
305295: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
305296: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
305297:

Line 305294: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'

305290: , l2.line_number line_number
305291: , CASE r
305292: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
305293: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
305294: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
305295: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
305296: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
305297:
305298: ELSE null

Line 305295: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'

305291: , CASE r
305292: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
305293: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
305294: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
305295: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
305296: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
305297:
305298: ELSE null
305299: END object_name

Line 305296: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'

305292: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
305293: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
305294: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
305295: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
305296: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
305297:
305298: ELSE null
305299: END object_name
305300: , CASE r

Line 305339: , CST_XLA_WIP_LINES_V l2

305335: ELSE null
305336: END source_value
305337: , null source_meaning
305338: FROM xla_events_gt xet
305339: , CST_XLA_WIP_LINES_V l2
305340: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
305341: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
305342: AND xet.event_class_code = C_EVENT_CLASS_CODE
305343: AND l2.event_id = xet.event_id

Line 305488: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

305484: TYPE t_array_source_93 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
305485: TYPE t_array_source_94 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
305486: TYPE t_array_source_114 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
305487:
305488: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
305489: TYPE t_array_source_84 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
305490: TYPE t_array_source_91 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
305491: TYPE t_array_source_95 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
305492: TYPE t_array_source_97 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 305489: TYPE t_array_source_84 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

305485: TYPE t_array_source_94 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
305486: TYPE t_array_source_114 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
305487:
305488: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
305489: TYPE t_array_source_84 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
305490: TYPE t_array_source_91 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
305491: TYPE t_array_source_95 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
305492: TYPE t_array_source_97 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
305493:

Line 305490: TYPE t_array_source_91 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

305486: TYPE t_array_source_114 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
305487:
305488: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
305489: TYPE t_array_source_84 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
305490: TYPE t_array_source_91 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
305491: TYPE t_array_source_95 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
305492: TYPE t_array_source_97 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
305493:
305494: l_array_source_1 t_array_source_1;

Line 305491: TYPE t_array_source_95 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

305487:
305488: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
305489: TYPE t_array_source_84 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
305490: TYPE t_array_source_91 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
305491: TYPE t_array_source_95 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
305492: TYPE t_array_source_97 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
305493:
305494: l_array_source_1 t_array_source_1;
305495: l_array_source_4 t_array_source_4;

Line 305492: TYPE t_array_source_97 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

305488: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
305489: TYPE t_array_source_84 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
305490: TYPE t_array_source_91 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
305491: TYPE t_array_source_95 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
305492: TYPE t_array_source_97 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
305493:
305494: l_array_source_1 t_array_source_1;
305495: l_array_source_4 t_array_source_4;
305496: l_array_source_6 t_array_source_6;

Line 305617: , CST_XLA_WIP_LINES_V l2

305613: , l2.ENTERED_AMOUNT source_91
305614: , l2.ACCOUNTED_AMOUNT source_95
305615: , l2.ACCOUNTING_LINE_TYPE_CODE source_97
305616: FROM xla_events_gt xet
305617: , CST_XLA_WIP_LINES_V l2
305618: WHERE xet.event_id between x_first_event_id and x_last_event_id
305619: and xet.event_date between p_pad_start_date and p_pad_end_date
305620: and xet.event_class_code = C_EVENT_CLASS_CODE
305621: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 318857: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'

318853: FROM (
318854: SELECT xet.event_id event_id
318855: , l7.line_number line_number
318856: , CASE r
318857: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
318858: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
318859: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
318860: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
318861: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'

Line 318858: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'

318854: SELECT xet.event_id event_id
318855: , l7.line_number line_number
318856: , CASE r
318857: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
318858: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
318859: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
318860: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
318861: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
318862:

Line 318859: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'

318855: , l7.line_number line_number
318856: , CASE r
318857: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
318858: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
318859: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
318860: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
318861: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
318862:
318863: ELSE null

Line 318860: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'

318856: , CASE r
318857: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
318858: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
318859: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
318860: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
318861: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
318862:
318863: ELSE null
318864: END object_name

Line 318861: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'

318857: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
318858: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
318859: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
318860: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
318861: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
318862:
318863: ELSE null
318864: END object_name
318865: , CASE r

Line 318904: , CST_XLA_WIP_LINES_V l7

318900: ELSE null
318901: END source_value
318902: , null source_meaning
318903: FROM xla_events_gt xet
318904: , CST_XLA_WIP_LINES_V l7
318905: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
318906: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
318907: AND xet.event_type_code = C_EVENT_TYPE_CODE
318908: AND l7.event_id = xet.event_id

Line 319057: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

319053: TYPE t_array_source_92 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
319054: TYPE t_array_source_93 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
319055: TYPE t_array_source_114 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
319056:
319057: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
319058: TYPE t_array_source_84 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
319059: TYPE t_array_source_91 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
319060: TYPE t_array_source_95 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
319061: TYPE t_array_source_97 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 319058: TYPE t_array_source_84 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

319054: TYPE t_array_source_93 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
319055: TYPE t_array_source_114 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
319056:
319057: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
319058: TYPE t_array_source_84 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
319059: TYPE t_array_source_91 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
319060: TYPE t_array_source_95 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
319061: TYPE t_array_source_97 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
319062:

Line 319059: TYPE t_array_source_91 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

319055: TYPE t_array_source_114 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
319056:
319057: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
319058: TYPE t_array_source_84 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
319059: TYPE t_array_source_91 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
319060: TYPE t_array_source_95 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
319061: TYPE t_array_source_97 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
319062:
319063: l_array_source_1 t_array_source_1;

Line 319060: TYPE t_array_source_95 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

319056:
319057: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
319058: TYPE t_array_source_84 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
319059: TYPE t_array_source_91 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
319060: TYPE t_array_source_95 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
319061: TYPE t_array_source_97 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
319062:
319063: l_array_source_1 t_array_source_1;
319064: l_array_source_4 t_array_source_4;

Line 319061: TYPE t_array_source_97 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

319057: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
319058: TYPE t_array_source_84 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
319059: TYPE t_array_source_91 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
319060: TYPE t_array_source_95 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
319061: TYPE t_array_source_97 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
319062:
319063: l_array_source_1 t_array_source_1;
319064: l_array_source_4 t_array_source_4;
319065: l_array_source_6 t_array_source_6;

Line 319207: , CST_XLA_WIP_LINES_V l7

319203: , l7.ENTERED_AMOUNT source_91
319204: , l7.ACCOUNTED_AMOUNT source_95
319205: , l7.ACCOUNTING_LINE_TYPE_CODE source_97
319206: FROM xla_events_gt xet
319207: , CST_XLA_WIP_LINES_V l7
319208: WHERE xet.event_id between x_first_event_id and x_last_event_id
319209: and xet.event_date between p_pad_start_date and p_pad_end_date
319210: and xet.event_type_code = C_EVENT_TYPE_CODE
319211: and xet.event_status_code <> 'N' AND l7.event_id = xet.event_id

Line 344923: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'

344919: FROM (
344920: SELECT xet.event_id event_id
344921: , l7.line_number line_number
344922: , CASE r
344923: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
344924: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
344925: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
344926: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
344927: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'

Line 344924: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'

344920: SELECT xet.event_id event_id
344921: , l7.line_number line_number
344922: , CASE r
344923: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
344924: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
344925: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
344926: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
344927: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
344928:

Line 344925: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'

344921: , l7.line_number line_number
344922: , CASE r
344923: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
344924: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
344925: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
344926: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
344927: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
344928:
344929: ELSE null

Line 344926: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'

344922: , CASE r
344923: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
344924: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
344925: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
344926: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
344927: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
344928:
344929: ELSE null
344930: END object_name

Line 344927: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'

344923: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
344924: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
344925: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
344926: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
344927: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
344928:
344929: ELSE null
344930: END object_name
344931: , CASE r

Line 344970: , CST_XLA_WIP_LINES_V l7

344966: ELSE null
344967: END source_value
344968: , null source_meaning
344969: FROM xla_events_gt xet
344970: , CST_XLA_WIP_LINES_V l7
344971: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
344972: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
344973: AND xet.event_type_code = C_EVENT_TYPE_CODE
344974: AND l7.event_id = xet.event_id

Line 345123: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

345119: TYPE t_array_source_92 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
345120: TYPE t_array_source_93 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
345121: TYPE t_array_source_114 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
345122:
345123: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
345124: TYPE t_array_source_84 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
345125: TYPE t_array_source_91 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
345126: TYPE t_array_source_95 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
345127: TYPE t_array_source_97 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 345124: TYPE t_array_source_84 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

345120: TYPE t_array_source_93 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
345121: TYPE t_array_source_114 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
345122:
345123: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
345124: TYPE t_array_source_84 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
345125: TYPE t_array_source_91 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
345126: TYPE t_array_source_95 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
345127: TYPE t_array_source_97 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
345128:

Line 345125: TYPE t_array_source_91 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

345121: TYPE t_array_source_114 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
345122:
345123: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
345124: TYPE t_array_source_84 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
345125: TYPE t_array_source_91 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
345126: TYPE t_array_source_95 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
345127: TYPE t_array_source_97 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
345128:
345129: l_array_source_1 t_array_source_1;

Line 345126: TYPE t_array_source_95 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

345122:
345123: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
345124: TYPE t_array_source_84 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
345125: TYPE t_array_source_91 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
345126: TYPE t_array_source_95 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
345127: TYPE t_array_source_97 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
345128:
345129: l_array_source_1 t_array_source_1;
345130: l_array_source_4 t_array_source_4;

Line 345127: TYPE t_array_source_97 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

345123: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
345124: TYPE t_array_source_84 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
345125: TYPE t_array_source_91 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
345126: TYPE t_array_source_95 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
345127: TYPE t_array_source_97 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
345128:
345129: l_array_source_1 t_array_source_1;
345130: l_array_source_4 t_array_source_4;
345131: l_array_source_6 t_array_source_6;

Line 345273: , CST_XLA_WIP_LINES_V l7

345269: , l7.ENTERED_AMOUNT source_91
345270: , l7.ACCOUNTED_AMOUNT source_95
345271: , l7.ACCOUNTING_LINE_TYPE_CODE source_97
345272: FROM xla_events_gt xet
345273: , CST_XLA_WIP_LINES_V l7
345274: WHERE xet.event_id between x_first_event_id and x_last_event_id
345275: and xet.event_date between p_pad_start_date and p_pad_end_date
345276: and xet.event_type_code = C_EVENT_TYPE_CODE
345277: and xet.event_status_code <> 'N' AND l7.event_id = xet.event_id

Line 369053: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'

369049: FROM (
369050: SELECT xet.event_id event_id
369051: , l7.line_number line_number
369052: , CASE r
369053: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
369054: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
369055: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
369056: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
369057: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'

Line 369054: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'

369050: SELECT xet.event_id event_id
369051: , l7.line_number line_number
369052: , CASE r
369053: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
369054: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
369055: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
369056: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
369057: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
369058:

Line 369055: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'

369051: , l7.line_number line_number
369052: , CASE r
369053: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
369054: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
369055: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
369056: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
369057: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
369058:
369059: ELSE null

Line 369056: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'

369052: , CASE r
369053: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
369054: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
369055: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
369056: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
369057: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
369058:
369059: ELSE null
369060: END object_name

Line 369057: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'

369053: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
369054: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
369055: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
369056: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
369057: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
369058:
369059: ELSE null
369060: END object_name
369061: , CASE r

Line 369100: , CST_XLA_WIP_LINES_V l7

369096: ELSE null
369097: END source_value
369098: , null source_meaning
369099: FROM xla_events_gt xet
369100: , CST_XLA_WIP_LINES_V l7
369101: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
369102: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
369103: AND xet.event_type_code = C_EVENT_TYPE_CODE
369104: AND l7.event_id = xet.event_id

Line 369253: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

369249: TYPE t_array_source_92 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
369250: TYPE t_array_source_93 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
369251: TYPE t_array_source_114 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
369252:
369253: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
369254: TYPE t_array_source_84 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
369255: TYPE t_array_source_91 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
369256: TYPE t_array_source_95 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
369257: TYPE t_array_source_97 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 369254: TYPE t_array_source_84 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

369250: TYPE t_array_source_93 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
369251: TYPE t_array_source_114 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
369252:
369253: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
369254: TYPE t_array_source_84 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
369255: TYPE t_array_source_91 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
369256: TYPE t_array_source_95 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
369257: TYPE t_array_source_97 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
369258:

Line 369255: TYPE t_array_source_91 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

369251: TYPE t_array_source_114 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
369252:
369253: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
369254: TYPE t_array_source_84 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
369255: TYPE t_array_source_91 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
369256: TYPE t_array_source_95 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
369257: TYPE t_array_source_97 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
369258:
369259: l_array_source_1 t_array_source_1;

Line 369256: TYPE t_array_source_95 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

369252:
369253: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
369254: TYPE t_array_source_84 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
369255: TYPE t_array_source_91 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
369256: TYPE t_array_source_95 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
369257: TYPE t_array_source_97 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
369258:
369259: l_array_source_1 t_array_source_1;
369260: l_array_source_4 t_array_source_4;

Line 369257: TYPE t_array_source_97 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

369253: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
369254: TYPE t_array_source_84 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
369255: TYPE t_array_source_91 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
369256: TYPE t_array_source_95 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
369257: TYPE t_array_source_97 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
369258:
369259: l_array_source_1 t_array_source_1;
369260: l_array_source_4 t_array_source_4;
369261: l_array_source_6 t_array_source_6;

Line 369403: , CST_XLA_WIP_LINES_V l7

369399: , l7.ENTERED_AMOUNT source_91
369400: , l7.ACCOUNTED_AMOUNT source_95
369401: , l7.ACCOUNTING_LINE_TYPE_CODE source_97
369402: FROM xla_events_gt xet
369403: , CST_XLA_WIP_LINES_V l7
369404: WHERE xet.event_id between x_first_event_id and x_last_event_id
369405: and xet.event_date between p_pad_start_date and p_pad_end_date
369406: and xet.event_type_code = C_EVENT_TYPE_CODE
369407: and xet.event_status_code <> 'N' AND l7.event_id = xet.event_id

Line 416084: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'

416080: FROM (
416081: SELECT xet.event_id event_id
416082: , l2.line_number line_number
416083: , CASE r
416084: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
416085: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
416086: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
416087: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
416088: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'

Line 416085: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'

416081: SELECT xet.event_id event_id
416082: , l2.line_number line_number
416083: , CASE r
416084: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
416085: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
416086: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
416087: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
416088: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
416089:

Line 416086: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'

416082: , l2.line_number line_number
416083: , CASE r
416084: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
416085: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
416086: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
416087: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
416088: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
416089:
416090: ELSE null

Line 416087: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'

416083: , CASE r
416084: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
416085: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
416086: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
416087: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
416088: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
416089:
416090: ELSE null
416091: END object_name

Line 416088: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'

416084: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
416085: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
416086: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
416087: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
416088: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
416089:
416090: ELSE null
416091: END object_name
416092: , CASE r

Line 416131: , CST_XLA_WIP_LINES_V l2

416127: ELSE null
416128: END source_value
416129: , null source_meaning
416130: FROM xla_events_gt xet
416131: , CST_XLA_WIP_LINES_V l2
416132: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
416133: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
416134: AND xet.event_class_code = C_EVENT_CLASS_CODE
416135: AND l2.event_id = xet.event_id

Line 416280: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

416276: TYPE t_array_source_93 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
416277: TYPE t_array_source_94 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
416278: TYPE t_array_source_114 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
416279:
416280: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
416281: TYPE t_array_source_84 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
416282: TYPE t_array_source_91 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
416283: TYPE t_array_source_95 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
416284: TYPE t_array_source_97 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 416281: TYPE t_array_source_84 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

416277: TYPE t_array_source_94 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
416278: TYPE t_array_source_114 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
416279:
416280: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
416281: TYPE t_array_source_84 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
416282: TYPE t_array_source_91 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
416283: TYPE t_array_source_95 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
416284: TYPE t_array_source_97 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
416285:

Line 416282: TYPE t_array_source_91 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

416278: TYPE t_array_source_114 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
416279:
416280: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
416281: TYPE t_array_source_84 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
416282: TYPE t_array_source_91 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
416283: TYPE t_array_source_95 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
416284: TYPE t_array_source_97 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
416285:
416286: l_array_source_1 t_array_source_1;

Line 416283: TYPE t_array_source_95 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

416279:
416280: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
416281: TYPE t_array_source_84 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
416282: TYPE t_array_source_91 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
416283: TYPE t_array_source_95 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
416284: TYPE t_array_source_97 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
416285:
416286: l_array_source_1 t_array_source_1;
416287: l_array_source_4 t_array_source_4;

Line 416284: TYPE t_array_source_97 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

416280: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
416281: TYPE t_array_source_84 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
416282: TYPE t_array_source_91 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
416283: TYPE t_array_source_95 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
416284: TYPE t_array_source_97 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
416285:
416286: l_array_source_1 t_array_source_1;
416287: l_array_source_4 t_array_source_4;
416288: l_array_source_6 t_array_source_6;

Line 416409: , CST_XLA_WIP_LINES_V l2

416405: , l2.ENTERED_AMOUNT source_91
416406: , l2.ACCOUNTED_AMOUNT source_95
416407: , l2.ACCOUNTING_LINE_TYPE_CODE source_97
416408: FROM xla_events_gt xet
416409: , CST_XLA_WIP_LINES_V l2
416410: WHERE xet.event_id between x_first_event_id and x_last_event_id
416411: and xet.event_date between p_pad_start_date and p_pad_end_date
416412: and xet.event_class_code = C_EVENT_CLASS_CODE
416413: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 424219: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'

424215: FROM (
424216: SELECT xet.event_id event_id
424217: , l2.line_number line_number
424218: , CASE r
424219: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
424220: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
424221: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
424222: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
424223: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'

Line 424220: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'

424216: SELECT xet.event_id event_id
424217: , l2.line_number line_number
424218: , CASE r
424219: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
424220: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
424221: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
424222: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
424223: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
424224:

Line 424221: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'

424217: , l2.line_number line_number
424218: , CASE r
424219: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
424220: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
424221: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
424222: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
424223: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
424224:
424225: ELSE null

Line 424222: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'

424218: , CASE r
424219: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
424220: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
424221: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
424222: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
424223: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
424224:
424225: ELSE null
424226: END object_name

Line 424223: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'

424219: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
424220: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
424221: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
424222: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
424223: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
424224:
424225: ELSE null
424226: END object_name
424227: , CASE r

Line 424266: , CST_XLA_WIP_LINES_V l2

424262: ELSE null
424263: END source_value
424264: , null source_meaning
424265: FROM xla_events_gt xet
424266: , CST_XLA_WIP_LINES_V l2
424267: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
424268: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
424269: AND xet.event_class_code = C_EVENT_CLASS_CODE
424270: AND l2.event_id = xet.event_id

Line 424415: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

424411: TYPE t_array_source_93 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
424412: TYPE t_array_source_94 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
424413: TYPE t_array_source_114 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
424414:
424415: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
424416: TYPE t_array_source_84 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
424417: TYPE t_array_source_91 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
424418: TYPE t_array_source_95 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
424419: TYPE t_array_source_97 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 424416: TYPE t_array_source_84 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

424412: TYPE t_array_source_94 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
424413: TYPE t_array_source_114 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
424414:
424415: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
424416: TYPE t_array_source_84 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
424417: TYPE t_array_source_91 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
424418: TYPE t_array_source_95 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
424419: TYPE t_array_source_97 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
424420:

Line 424417: TYPE t_array_source_91 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

424413: TYPE t_array_source_114 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
424414:
424415: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
424416: TYPE t_array_source_84 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
424417: TYPE t_array_source_91 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
424418: TYPE t_array_source_95 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
424419: TYPE t_array_source_97 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
424420:
424421: l_array_source_1 t_array_source_1;

Line 424418: TYPE t_array_source_95 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

424414:
424415: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
424416: TYPE t_array_source_84 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
424417: TYPE t_array_source_91 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
424418: TYPE t_array_source_95 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
424419: TYPE t_array_source_97 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
424420:
424421: l_array_source_1 t_array_source_1;
424422: l_array_source_4 t_array_source_4;

Line 424419: TYPE t_array_source_97 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

424415: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
424416: TYPE t_array_source_84 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
424417: TYPE t_array_source_91 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
424418: TYPE t_array_source_95 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
424419: TYPE t_array_source_97 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
424420:
424421: l_array_source_1 t_array_source_1;
424422: l_array_source_4 t_array_source_4;
424423: l_array_source_6 t_array_source_6;

Line 424544: , CST_XLA_WIP_LINES_V l2

424540: , l2.ENTERED_AMOUNT source_91
424541: , l2.ACCOUNTED_AMOUNT source_95
424542: , l2.ACCOUNTING_LINE_TYPE_CODE source_97
424543: FROM xla_events_gt xet
424544: , CST_XLA_WIP_LINES_V l2
424545: WHERE xet.event_id between x_first_event_id and x_last_event_id
424546: and xet.event_date between p_pad_start_date and p_pad_end_date
424547: and xet.event_class_code = C_EVENT_CLASS_CODE
424548: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 426786: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'

426782: FROM (
426783: SELECT xet.event_id event_id
426784: , l2.line_number line_number
426785: , CASE r
426786: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
426787: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
426788: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
426789: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
426790: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'

Line 426787: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'

426783: SELECT xet.event_id event_id
426784: , l2.line_number line_number
426785: , CASE r
426786: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
426787: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
426788: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
426789: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
426790: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
426791:

Line 426788: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'

426784: , l2.line_number line_number
426785: , CASE r
426786: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
426787: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
426788: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
426789: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
426790: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
426791:
426792: ELSE null

Line 426789: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'

426785: , CASE r
426786: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
426787: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
426788: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
426789: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
426790: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
426791:
426792: ELSE null
426793: END object_name

Line 426790: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'

426786: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
426787: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
426788: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
426789: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
426790: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
426791:
426792: ELSE null
426793: END object_name
426794: , CASE r

Line 426833: , CST_XLA_WIP_LINES_V l2

426829: ELSE null
426830: END source_value
426831: , null source_meaning
426832: FROM xla_events_gt xet
426833: , CST_XLA_WIP_LINES_V l2
426834: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
426835: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
426836: AND xet.event_class_code = C_EVENT_CLASS_CODE
426837: AND l2.event_id = xet.event_id

Line 426982: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

426978: TYPE t_array_source_93 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
426979: TYPE t_array_source_94 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
426980: TYPE t_array_source_114 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
426981:
426982: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
426983: TYPE t_array_source_84 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
426984: TYPE t_array_source_91 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
426985: TYPE t_array_source_95 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
426986: TYPE t_array_source_97 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 426983: TYPE t_array_source_84 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

426979: TYPE t_array_source_94 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
426980: TYPE t_array_source_114 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
426981:
426982: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
426983: TYPE t_array_source_84 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
426984: TYPE t_array_source_91 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
426985: TYPE t_array_source_95 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
426986: TYPE t_array_source_97 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
426987:

Line 426984: TYPE t_array_source_91 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

426980: TYPE t_array_source_114 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
426981:
426982: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
426983: TYPE t_array_source_84 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
426984: TYPE t_array_source_91 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
426985: TYPE t_array_source_95 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
426986: TYPE t_array_source_97 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
426987:
426988: l_array_source_1 t_array_source_1;

Line 426985: TYPE t_array_source_95 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

426981:
426982: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
426983: TYPE t_array_source_84 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
426984: TYPE t_array_source_91 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
426985: TYPE t_array_source_95 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
426986: TYPE t_array_source_97 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
426987:
426988: l_array_source_1 t_array_source_1;
426989: l_array_source_4 t_array_source_4;

Line 426986: TYPE t_array_source_97 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

426982: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
426983: TYPE t_array_source_84 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
426984: TYPE t_array_source_91 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
426985: TYPE t_array_source_95 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
426986: TYPE t_array_source_97 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
426987:
426988: l_array_source_1 t_array_source_1;
426989: l_array_source_4 t_array_source_4;
426990: l_array_source_6 t_array_source_6;

Line 427111: , CST_XLA_WIP_LINES_V l2

427107: , l2.ENTERED_AMOUNT source_91
427108: , l2.ACCOUNTED_AMOUNT source_95
427109: , l2.ACCOUNTING_LINE_TYPE_CODE source_97
427110: FROM xla_events_gt xet
427111: , CST_XLA_WIP_LINES_V l2
427112: WHERE xet.event_id between x_first_event_id and x_last_event_id
427113: and xet.event_date between p_pad_start_date and p_pad_end_date
427114: and xet.event_class_code = C_EVENT_CLASS_CODE
427115: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id