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

Line 138308: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'

138304: FROM (
138305: SELECT xet.event_id event_id
138306: , l2.line_number line_number
138307: , CASE r
138308: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
138309: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
138310: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
138311: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
138312: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'

Line 138309: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'

138305: SELECT xet.event_id event_id
138306: , l2.line_number line_number
138307: , CASE r
138308: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
138309: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
138310: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
138311: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
138312: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
138313:

Line 138310: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'

138306: , l2.line_number line_number
138307: , CASE r
138308: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
138309: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
138310: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
138311: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
138312: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
138313:
138314: ELSE null

Line 138311: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'

138307: , CASE r
138308: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
138309: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
138310: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
138311: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
138312: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
138313:
138314: ELSE null
138315: END object_name

Line 138312: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'

138308: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
138309: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
138310: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
138311: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
138312: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
138313:
138314: ELSE null
138315: END object_name
138316: , CASE r

Line 138355: , CST_XLA_WIP_LINES_V l2

138351: ELSE null
138352: END source_value
138353: , null source_meaning
138354: FROM xla_events_gt xet
138355: , CST_XLA_WIP_LINES_V l2
138356: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
138357: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
138358: AND xet.event_class_code = C_EVENT_CLASS_CODE
138359: AND l2.event_id = xet.event_id

Line 138500: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

138496: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
138497: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
138498: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
138499:
138500: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
138501: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
138502: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
138503: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
138504: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 138501: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

138497: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
138498: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
138499:
138500: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
138501: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
138502: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
138503: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
138504: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
138505:

Line 138502: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

138498: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
138499:
138500: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
138501: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
138502: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
138503: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
138504: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
138505:
138506: l_array_source_12 t_array_source_12;

Line 138503: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

138499:
138500: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
138501: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
138502: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
138503: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
138504: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
138505:
138506: l_array_source_12 t_array_source_12;
138507: l_array_source_12_meaning t_array_lookup_meaning;

Line 138504: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

138500: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
138501: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
138502: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
138503: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
138504: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
138505:
138506: l_array_source_12 t_array_source_12;
138507: l_array_source_12_meaning t_array_lookup_meaning;
138508: l_array_source_15 t_array_source_15;

Line 138614: , CST_XLA_WIP_LINES_V l2

138610: , l2.ENTERED_AMOUNT source_18
138611: , l2.ACCOUNTED_AMOUNT source_22
138612: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
138613: FROM xla_events_gt xet
138614: , CST_XLA_WIP_LINES_V l2
138615: WHERE xet.event_id between x_first_event_id and x_last_event_id
138616: and xet.event_date between p_pad_start_date and p_pad_end_date
138617: and xet.event_class_code = C_EVENT_CLASS_CODE
138618: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 162374: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'

162370: FROM (
162371: SELECT xet.event_id event_id
162372: , l2.line_number line_number
162373: , CASE r
162374: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
162375: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
162376: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
162377: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
162378: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'

Line 162375: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'

162371: SELECT xet.event_id event_id
162372: , l2.line_number line_number
162373: , CASE r
162374: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
162375: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
162376: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
162377: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
162378: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
162379:

Line 162376: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'

162372: , l2.line_number line_number
162373: , CASE r
162374: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
162375: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
162376: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
162377: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
162378: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
162379:
162380: ELSE null

Line 162377: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'

162373: , CASE r
162374: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
162375: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
162376: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
162377: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
162378: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
162379:
162380: ELSE null
162381: END object_name

Line 162378: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'

162374: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
162375: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
162376: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
162377: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
162378: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
162379:
162380: ELSE null
162381: END object_name
162382: , CASE r

Line 162421: , CST_XLA_WIP_LINES_V l2

162417: ELSE null
162418: END source_value
162419: , null source_meaning
162420: FROM xla_events_gt xet
162421: , CST_XLA_WIP_LINES_V l2
162422: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
162423: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
162424: AND xet.event_class_code = C_EVENT_CLASS_CODE
162425: AND l2.event_id = xet.event_id

Line 162565: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

162561: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
162562: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
162563: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
162564:
162565: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
162566: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
162567: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
162568: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
162569: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 162566: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

162562: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
162563: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
162564:
162565: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
162566: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
162567: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
162568: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
162569: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
162570:

Line 162567: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

162563: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
162564:
162565: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
162566: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
162567: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
162568: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
162569: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
162570:
162571: l_array_source_12 t_array_source_12;

Line 162568: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

162564:
162565: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
162566: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
162567: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
162568: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
162569: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
162570:
162571: l_array_source_12 t_array_source_12;
162572: l_array_source_12_meaning t_array_lookup_meaning;

Line 162569: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

162565: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
162566: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
162567: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
162568: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
162569: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
162570:
162571: l_array_source_12 t_array_source_12;
162572: l_array_source_12_meaning t_array_lookup_meaning;
162573: l_array_source_15 t_array_source_15;

Line 162677: , CST_XLA_WIP_LINES_V l2

162673: , l2.ENTERED_AMOUNT source_18
162674: , l2.ACCOUNTED_AMOUNT source_22
162675: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
162676: FROM xla_events_gt xet
162677: , CST_XLA_WIP_LINES_V l2
162678: WHERE xet.event_id between x_first_event_id and x_last_event_id
162679: and xet.event_date between p_pad_start_date and p_pad_end_date
162680: and xet.event_class_code = C_EVENT_CLASS_CODE
162681: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 194430: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'

194426: FROM (
194427: SELECT xet.event_id event_id
194428: , l2.line_number line_number
194429: , CASE r
194430: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
194431: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
194432: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
194433: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
194434: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'

Line 194431: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'

194427: SELECT xet.event_id event_id
194428: , l2.line_number line_number
194429: , CASE r
194430: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
194431: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
194432: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
194433: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
194434: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
194435:

Line 194432: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'

194428: , l2.line_number line_number
194429: , CASE r
194430: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
194431: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
194432: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
194433: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
194434: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
194435:
194436: ELSE null

Line 194433: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'

194429: , CASE r
194430: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
194431: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
194432: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
194433: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
194434: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
194435:
194436: ELSE null
194437: END object_name

Line 194434: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'

194430: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
194431: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
194432: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
194433: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
194434: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
194435:
194436: ELSE null
194437: END object_name
194438: , CASE r

Line 194477: , CST_XLA_WIP_LINES_V l2

194473: ELSE null
194474: END source_value
194475: , null source_meaning
194476: FROM xla_events_gt xet
194477: , CST_XLA_WIP_LINES_V l2
194478: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
194479: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
194480: AND xet.event_class_code = C_EVENT_CLASS_CODE
194481: AND l2.event_id = xet.event_id

Line 194622: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

194618: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
194619: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
194620: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
194621:
194622: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
194623: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
194624: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
194625: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
194626: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 194623: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

194619: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
194620: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
194621:
194622: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
194623: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
194624: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
194625: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
194626: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
194627:

Line 194624: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

194620: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
194621:
194622: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
194623: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
194624: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
194625: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
194626: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
194627:
194628: l_array_source_12 t_array_source_12;

Line 194625: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

194621:
194622: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
194623: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
194624: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
194625: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
194626: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
194627:
194628: l_array_source_12 t_array_source_12;
194629: l_array_source_12_meaning t_array_lookup_meaning;

Line 194626: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

194622: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
194623: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
194624: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
194625: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
194626: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
194627:
194628: l_array_source_12 t_array_source_12;
194629: l_array_source_12_meaning t_array_lookup_meaning;
194630: l_array_source_15 t_array_source_15;

Line 194736: , CST_XLA_WIP_LINES_V l2

194732: , l2.ENTERED_AMOUNT source_18
194733: , l2.ACCOUNTED_AMOUNT source_22
194734: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
194735: FROM xla_events_gt xet
194736: , CST_XLA_WIP_LINES_V l2
194737: WHERE xet.event_id between x_first_event_id and x_last_event_id
194738: and xet.event_date between p_pad_start_date and p_pad_end_date
194739: and xet.event_class_code = C_EVENT_CLASS_CODE
194740: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 195641: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'

195637: FROM (
195638: SELECT xet.event_id event_id
195639: , l2.line_number line_number
195640: , CASE r
195641: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
195642: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
195643: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
195644: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
195645: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'

Line 195642: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'

195638: SELECT xet.event_id event_id
195639: , l2.line_number line_number
195640: , CASE r
195641: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
195642: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
195643: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
195644: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
195645: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
195646:

Line 195643: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'

195639: , l2.line_number line_number
195640: , CASE r
195641: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
195642: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
195643: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
195644: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
195645: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
195646:
195647: ELSE null

Line 195644: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'

195640: , CASE r
195641: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
195642: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
195643: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
195644: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
195645: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
195646:
195647: ELSE null
195648: END object_name

Line 195645: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'

195641: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
195642: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
195643: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
195644: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
195645: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
195646:
195647: ELSE null
195648: END object_name
195649: , CASE r

Line 195688: , CST_XLA_WIP_LINES_V l2

195684: ELSE null
195685: END source_value
195686: , null source_meaning
195687: FROM xla_events_gt xet
195688: , CST_XLA_WIP_LINES_V l2
195689: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
195690: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
195691: AND xet.event_class_code = C_EVENT_CLASS_CODE
195692: AND l2.event_id = xet.event_id

Line 195833: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

195829: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
195830: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
195831: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
195832:
195833: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
195834: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
195835: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
195836: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
195837: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 195834: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

195830: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
195831: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
195832:
195833: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
195834: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
195835: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
195836: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
195837: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
195838:

Line 195835: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

195831: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
195832:
195833: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
195834: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
195835: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
195836: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
195837: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
195838:
195839: l_array_source_12 t_array_source_12;

Line 195836: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

195832:
195833: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
195834: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
195835: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
195836: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
195837: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
195838:
195839: l_array_source_12 t_array_source_12;
195840: l_array_source_12_meaning t_array_lookup_meaning;

Line 195837: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

195833: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
195834: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
195835: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
195836: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
195837: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
195838:
195839: l_array_source_12 t_array_source_12;
195840: l_array_source_12_meaning t_array_lookup_meaning;
195841: l_array_source_15 t_array_source_15;

Line 195947: , CST_XLA_WIP_LINES_V l2

195943: , l2.ENTERED_AMOUNT source_18
195944: , l2.ACCOUNTED_AMOUNT source_22
195945: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
195946: FROM xla_events_gt xet
195947: , CST_XLA_WIP_LINES_V l2
195948: WHERE xet.event_id between x_first_event_id and x_last_event_id
195949: and xet.event_date between p_pad_start_date and p_pad_end_date
195950: and xet.event_class_code = C_EVENT_CLASS_CODE
195951: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 196852: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'

196848: FROM (
196849: SELECT xet.event_id event_id
196850: , l2.line_number line_number
196851: , CASE r
196852: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
196853: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
196854: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
196855: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
196856: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'

Line 196853: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'

196849: SELECT xet.event_id event_id
196850: , l2.line_number line_number
196851: , CASE r
196852: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
196853: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
196854: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
196855: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
196856: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
196857:

Line 196854: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'

196850: , l2.line_number line_number
196851: , CASE r
196852: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
196853: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
196854: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
196855: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
196856: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
196857:
196858: ELSE null

Line 196855: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'

196851: , CASE r
196852: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
196853: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
196854: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
196855: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
196856: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
196857:
196858: ELSE null
196859: END object_name

Line 196856: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'

196852: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
196853: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
196854: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
196855: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
196856: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
196857:
196858: ELSE null
196859: END object_name
196860: , CASE r

Line 196899: , CST_XLA_WIP_LINES_V l2

196895: ELSE null
196896: END source_value
196897: , null source_meaning
196898: FROM xla_events_gt xet
196899: , CST_XLA_WIP_LINES_V l2
196900: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
196901: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
196902: AND xet.event_class_code = C_EVENT_CLASS_CODE
196903: AND l2.event_id = xet.event_id

Line 197044: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

197040: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
197041: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
197042: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
197043:
197044: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
197045: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
197046: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
197047: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
197048: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 197045: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

197041: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
197042: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
197043:
197044: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
197045: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
197046: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
197047: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
197048: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
197049:

Line 197046: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

197042: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
197043:
197044: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
197045: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
197046: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
197047: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
197048: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
197049:
197050: l_array_source_12 t_array_source_12;

Line 197047: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

197043:
197044: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
197045: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
197046: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
197047: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
197048: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
197049:
197050: l_array_source_12 t_array_source_12;
197051: l_array_source_12_meaning t_array_lookup_meaning;

Line 197048: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

197044: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
197045: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
197046: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
197047: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
197048: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
197049:
197050: l_array_source_12 t_array_source_12;
197051: l_array_source_12_meaning t_array_lookup_meaning;
197052: l_array_source_15 t_array_source_15;

Line 197158: , CST_XLA_WIP_LINES_V l2

197154: , l2.ENTERED_AMOUNT source_18
197155: , l2.ACCOUNTED_AMOUNT source_22
197156: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
197157: FROM xla_events_gt xet
197158: , CST_XLA_WIP_LINES_V l2
197159: WHERE xet.event_id between x_first_event_id and x_last_event_id
197160: and xet.event_date between p_pad_start_date and p_pad_end_date
197161: and xet.event_class_code = C_EVENT_CLASS_CODE
197162: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id