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_HEADERS_V

Line 305128: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'

305124: FROM (
305125: SELECT xet.event_id event_id
305126: , 0 line_number
305127: , CASE r
305128: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
305129: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
305130: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
305131: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
305132: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'

Line 305129: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'

305125: SELECT xet.event_id event_id
305126: , 0 line_number
305127: , CASE r
305128: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
305129: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
305130: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
305131: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
305132: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
305133: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'

Line 305130: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'

305126: , 0 line_number
305127: , CASE r
305128: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
305129: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
305130: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
305131: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
305132: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
305133: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
305134: WHEN 7 THEN 'CST_XLA_WIP_HEADERS_V'

Line 305131: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'

305127: , CASE r
305128: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
305129: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
305130: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
305131: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
305132: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
305133: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
305134: WHEN 7 THEN 'CST_XLA_WIP_HEADERS_V'
305135: WHEN 8 THEN 'CST_XLA_WIP_HEADERS_V'

Line 305132: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'

305128: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
305129: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
305130: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
305131: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
305132: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
305133: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
305134: WHEN 7 THEN 'CST_XLA_WIP_HEADERS_V'
305135: WHEN 8 THEN 'CST_XLA_WIP_HEADERS_V'
305136: WHEN 9 THEN 'CST_XLA_WIP_HEADERS_V'

Line 305133: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'

305129: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
305130: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
305131: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
305132: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
305133: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
305134: WHEN 7 THEN 'CST_XLA_WIP_HEADERS_V'
305135: WHEN 8 THEN 'CST_XLA_WIP_HEADERS_V'
305136: WHEN 9 THEN 'CST_XLA_WIP_HEADERS_V'
305137: WHEN 10 THEN 'CST_XLA_WIP_HEADERS_V'

Line 305134: WHEN 7 THEN 'CST_XLA_WIP_HEADERS_V'

305130: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
305131: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
305132: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
305133: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
305134: WHEN 7 THEN 'CST_XLA_WIP_HEADERS_V'
305135: WHEN 8 THEN 'CST_XLA_WIP_HEADERS_V'
305136: WHEN 9 THEN 'CST_XLA_WIP_HEADERS_V'
305137: WHEN 10 THEN 'CST_XLA_WIP_HEADERS_V'
305138:

Line 305135: WHEN 8 THEN 'CST_XLA_WIP_HEADERS_V'

305131: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
305132: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
305133: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
305134: WHEN 7 THEN 'CST_XLA_WIP_HEADERS_V'
305135: WHEN 8 THEN 'CST_XLA_WIP_HEADERS_V'
305136: WHEN 9 THEN 'CST_XLA_WIP_HEADERS_V'
305137: WHEN 10 THEN 'CST_XLA_WIP_HEADERS_V'
305138:
305139: ELSE null

Line 305136: WHEN 9 THEN 'CST_XLA_WIP_HEADERS_V'

305132: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
305133: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
305134: WHEN 7 THEN 'CST_XLA_WIP_HEADERS_V'
305135: WHEN 8 THEN 'CST_XLA_WIP_HEADERS_V'
305136: WHEN 9 THEN 'CST_XLA_WIP_HEADERS_V'
305137: WHEN 10 THEN 'CST_XLA_WIP_HEADERS_V'
305138:
305139: ELSE null
305140: END object_name

Line 305137: WHEN 10 THEN 'CST_XLA_WIP_HEADERS_V'

305133: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
305134: WHEN 7 THEN 'CST_XLA_WIP_HEADERS_V'
305135: WHEN 8 THEN 'CST_XLA_WIP_HEADERS_V'
305136: WHEN 9 THEN 'CST_XLA_WIP_HEADERS_V'
305137: WHEN 10 THEN 'CST_XLA_WIP_HEADERS_V'
305138:
305139: ELSE null
305140: END object_name
305141: , CASE r

Line 305206: , CST_XLA_WIP_HEADERS_V h1

305202:
305203: ELSE null
305204: END source_meaning
305205: FROM xla_events_gt xet
305206: , CST_XLA_WIP_HEADERS_V h1
305207: , fnd_lookup_values fvl7
305208: , fnd_lookup_values fvl85
305209: , fnd_lookup_values fvl114
305210: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)

Line 305477: TYPE t_array_source_1 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;

305473: --
305474: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
305475: --
305476:
305477: TYPE t_array_source_1 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
305478: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
305479: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
305480: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
305481: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 305478: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;

305474: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
305475: --
305476:
305477: TYPE t_array_source_1 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
305478: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
305479: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
305480: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
305481: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
305482: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 305479: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;

305475: --
305476:
305477: TYPE t_array_source_1 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
305478: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
305479: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
305480: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
305481: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
305482: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
305483: TYPE t_array_source_92 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 305480: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

305476:
305477: TYPE t_array_source_1 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
305478: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
305479: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
305480: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
305481: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
305482: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
305483: TYPE t_array_source_92 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%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;

Line 305481: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

305477: TYPE t_array_source_1 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
305478: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
305479: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
305480: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
305481: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
305482: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
305483: TYPE t_array_source_92 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%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;

Line 305482: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

305478: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
305479: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
305480: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
305481: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
305482: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
305483: TYPE t_array_source_92 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%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;

Line 305483: TYPE t_array_source_92 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

305479: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
305480: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
305481: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
305482: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
305483: TYPE t_array_source_92 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%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:

Line 305484: TYPE t_array_source_93 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

305480: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
305481: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
305482: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
305483: TYPE t_array_source_92 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%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;

Line 305485: TYPE t_array_source_94 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

305481: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
305482: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
305483: TYPE t_array_source_92 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%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;

Line 305486: TYPE t_array_source_114 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

305482: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
305483: TYPE t_array_source_92 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%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;

Line 305557: , CST_XLA_WIP_HEADERS_V h1

305553: , h1.CURRENCY_CONVERSION_TYPE source_94
305554: , h1.TRANSFER_TO_GL_INDICATOR source_114
305555: , fvl114.meaning source_114_meaning
305556: FROM xla_events_gt xet
305557: , CST_XLA_WIP_HEADERS_V h1
305558: , fnd_lookup_values fvl7
305559: , fnd_lookup_values fvl85
305560: , fnd_lookup_values fvl114
305561: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 318663: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'

318659: FROM (
318660: SELECT xet.event_id event_id
318661: , 0 line_number
318662: , CASE r
318663: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
318664: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
318665: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
318666: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
318667: WHEN 5 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'

Line 318664: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'

318660: SELECT xet.event_id event_id
318661: , 0 line_number
318662: , CASE r
318663: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
318664: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
318665: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
318666: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
318667: WHEN 5 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
318668: WHEN 6 THEN 'CST_XLA_DISCRETE_JOB_REF_V'

Line 318665: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'

318661: , 0 line_number
318662: , CASE r
318663: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
318664: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
318665: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
318666: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
318667: WHEN 5 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
318668: WHEN 6 THEN 'CST_XLA_DISCRETE_JOB_REF_V'
318669: WHEN 7 THEN 'CST_XLA_WIP_ENTITY_REF_V'

Line 318666: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'

318662: , CASE r
318663: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
318664: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
318665: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
318666: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
318667: WHEN 5 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
318668: WHEN 6 THEN 'CST_XLA_DISCRETE_JOB_REF_V'
318669: WHEN 7 THEN 'CST_XLA_WIP_ENTITY_REF_V'
318670: WHEN 8 THEN 'CST_XLA_FLOW_SCHEDULE_REF_V'

Line 318672: WHEN 10 THEN 'CST_XLA_WIP_HEADERS_V'

318668: WHEN 6 THEN 'CST_XLA_DISCRETE_JOB_REF_V'
318669: WHEN 7 THEN 'CST_XLA_WIP_ENTITY_REF_V'
318670: WHEN 8 THEN 'CST_XLA_FLOW_SCHEDULE_REF_V'
318671: WHEN 9 THEN 'CST_XLA_REP_ITEM_REF_V'
318672: WHEN 10 THEN 'CST_XLA_WIP_HEADERS_V'
318673: WHEN 11 THEN 'CST_XLA_WIP_HEADERS_V'
318674: WHEN 12 THEN 'CST_XLA_WIP_HEADERS_V'
318675: WHEN 13 THEN 'CST_XLA_WIP_HEADERS_V'
318676: WHEN 14 THEN 'CST_XLA_WIP_HEADERS_V'

Line 318673: WHEN 11 THEN 'CST_XLA_WIP_HEADERS_V'

318669: WHEN 7 THEN 'CST_XLA_WIP_ENTITY_REF_V'
318670: WHEN 8 THEN 'CST_XLA_FLOW_SCHEDULE_REF_V'
318671: WHEN 9 THEN 'CST_XLA_REP_ITEM_REF_V'
318672: WHEN 10 THEN 'CST_XLA_WIP_HEADERS_V'
318673: WHEN 11 THEN 'CST_XLA_WIP_HEADERS_V'
318674: WHEN 12 THEN 'CST_XLA_WIP_HEADERS_V'
318675: WHEN 13 THEN 'CST_XLA_WIP_HEADERS_V'
318676: WHEN 14 THEN 'CST_XLA_WIP_HEADERS_V'
318677:

Line 318674: WHEN 12 THEN 'CST_XLA_WIP_HEADERS_V'

318670: WHEN 8 THEN 'CST_XLA_FLOW_SCHEDULE_REF_V'
318671: WHEN 9 THEN 'CST_XLA_REP_ITEM_REF_V'
318672: WHEN 10 THEN 'CST_XLA_WIP_HEADERS_V'
318673: WHEN 11 THEN 'CST_XLA_WIP_HEADERS_V'
318674: WHEN 12 THEN 'CST_XLA_WIP_HEADERS_V'
318675: WHEN 13 THEN 'CST_XLA_WIP_HEADERS_V'
318676: WHEN 14 THEN 'CST_XLA_WIP_HEADERS_V'
318677:
318678: ELSE null

Line 318675: WHEN 13 THEN 'CST_XLA_WIP_HEADERS_V'

318671: WHEN 9 THEN 'CST_XLA_REP_ITEM_REF_V'
318672: WHEN 10 THEN 'CST_XLA_WIP_HEADERS_V'
318673: WHEN 11 THEN 'CST_XLA_WIP_HEADERS_V'
318674: WHEN 12 THEN 'CST_XLA_WIP_HEADERS_V'
318675: WHEN 13 THEN 'CST_XLA_WIP_HEADERS_V'
318676: WHEN 14 THEN 'CST_XLA_WIP_HEADERS_V'
318677:
318678: ELSE null
318679: END object_name

Line 318676: WHEN 14 THEN 'CST_XLA_WIP_HEADERS_V'

318672: WHEN 10 THEN 'CST_XLA_WIP_HEADERS_V'
318673: WHEN 11 THEN 'CST_XLA_WIP_HEADERS_V'
318674: WHEN 12 THEN 'CST_XLA_WIP_HEADERS_V'
318675: WHEN 13 THEN 'CST_XLA_WIP_HEADERS_V'
318676: WHEN 14 THEN 'CST_XLA_WIP_HEADERS_V'
318677:
318678: ELSE null
318679: END object_name
318680: , CASE r

Line 318767: , CST_XLA_WIP_HEADERS_V h6

318763: , CST_XLA_FLOW_SCHEDULE_REF_V h2
318764: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h3
318765: , CST_XLA_REP_ITEM_REF_V h4
318766: , CST_XLA_WIP_ENTITY_REF_V h5
318767: , CST_XLA_WIP_HEADERS_V h6
318768: , fnd_lookup_values fvl7
318769: , fnd_lookup_values fvl55
318770: , fnd_lookup_values fvl85
318771: , fnd_lookup_values fvl114

Line 319042: TYPE t_array_source_1 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;

319038: --
319039: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
319040: --
319041:
319042: TYPE t_array_source_1 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
319043: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
319044: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
319045: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
319046: TYPE t_array_source_53 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.INV_ITEM_EXPENSE_ACCT%TYPE INDEX BY BINARY_INTEGER;

Line 319043: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;

319039: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
319040: --
319041:
319042: TYPE t_array_source_1 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
319043: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
319044: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
319045: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
319046: TYPE t_array_source_53 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.INV_ITEM_EXPENSE_ACCT%TYPE INDEX BY BINARY_INTEGER;
319047: TYPE t_array_source_54 IS TABLE OF CST_XLA_DISCRETE_JOB_REF_V.DIS_JOB_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;

Line 319044: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;

319040: --
319041:
319042: TYPE t_array_source_1 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
319043: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
319044: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
319045: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
319046: TYPE t_array_source_53 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.INV_ITEM_EXPENSE_ACCT%TYPE INDEX BY BINARY_INTEGER;
319047: TYPE t_array_source_54 IS TABLE OF CST_XLA_DISCRETE_JOB_REF_V.DIS_JOB_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
319048: TYPE t_array_source_55 IS TABLE OF CST_XLA_WIP_ENTITY_REF_V.WIP_ENTITY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 319045: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

319041:
319042: TYPE t_array_source_1 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
319043: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
319044: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
319045: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
319046: TYPE t_array_source_53 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.INV_ITEM_EXPENSE_ACCT%TYPE INDEX BY BINARY_INTEGER;
319047: TYPE t_array_source_54 IS TABLE OF CST_XLA_DISCRETE_JOB_REF_V.DIS_JOB_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
319048: TYPE t_array_source_55 IS TABLE OF CST_XLA_WIP_ENTITY_REF_V.WIP_ENTITY_TYPE%TYPE INDEX BY BINARY_INTEGER;
319049: TYPE t_array_source_56 IS TABLE OF CST_XLA_FLOW_SCHEDULE_REF_V.FLO_SCH_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;

Line 319051: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

319047: TYPE t_array_source_54 IS TABLE OF CST_XLA_DISCRETE_JOB_REF_V.DIS_JOB_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
319048: TYPE t_array_source_55 IS TABLE OF CST_XLA_WIP_ENTITY_REF_V.WIP_ENTITY_TYPE%TYPE INDEX BY BINARY_INTEGER;
319049: TYPE t_array_source_56 IS TABLE OF CST_XLA_FLOW_SCHEDULE_REF_V.FLO_SCH_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
319050: TYPE t_array_source_57 IS TABLE OF CST_XLA_REP_ITEM_REF_V.REP_ITM_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
319051: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
319052: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%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;

Line 319052: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

319048: TYPE t_array_source_55 IS TABLE OF CST_XLA_WIP_ENTITY_REF_V.WIP_ENTITY_TYPE%TYPE INDEX BY BINARY_INTEGER;
319049: TYPE t_array_source_56 IS TABLE OF CST_XLA_FLOW_SCHEDULE_REF_V.FLO_SCH_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
319050: TYPE t_array_source_57 IS TABLE OF CST_XLA_REP_ITEM_REF_V.REP_ITM_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
319051: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
319052: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%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:

Line 319053: TYPE t_array_source_92 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

319049: TYPE t_array_source_56 IS TABLE OF CST_XLA_FLOW_SCHEDULE_REF_V.FLO_SCH_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
319050: TYPE t_array_source_57 IS TABLE OF CST_XLA_REP_ITEM_REF_V.REP_ITM_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
319051: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
319052: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%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;

Line 319054: TYPE t_array_source_93 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

319050: TYPE t_array_source_57 IS TABLE OF CST_XLA_REP_ITEM_REF_V.REP_ITM_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
319051: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
319052: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%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;

Line 319055: TYPE t_array_source_114 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

319051: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
319052: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%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;

Line 319142: , CST_XLA_WIP_HEADERS_V h6

319138: , CST_XLA_FLOW_SCHEDULE_REF_V h2
319139: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h3
319140: , CST_XLA_REP_ITEM_REF_V h4
319141: , CST_XLA_WIP_ENTITY_REF_V h5
319142: , CST_XLA_WIP_HEADERS_V h6
319143: , fnd_lookup_values fvl7
319144: , fnd_lookup_values fvl55
319145: , fnd_lookup_values fvl85
319146: , fnd_lookup_values fvl114

Line 344729: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'

344725: FROM (
344726: SELECT xet.event_id event_id
344727: , 0 line_number
344728: , CASE r
344729: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
344730: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
344731: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
344732: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
344733: WHEN 5 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'

Line 344730: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'

344726: SELECT xet.event_id event_id
344727: , 0 line_number
344728: , CASE r
344729: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
344730: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
344731: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
344732: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
344733: WHEN 5 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
344734: WHEN 6 THEN 'CST_XLA_DISCRETE_JOB_REF_V'

Line 344731: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'

344727: , 0 line_number
344728: , CASE r
344729: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
344730: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
344731: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
344732: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
344733: WHEN 5 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
344734: WHEN 6 THEN 'CST_XLA_DISCRETE_JOB_REF_V'
344735: WHEN 7 THEN 'CST_XLA_WIP_ENTITY_REF_V'

Line 344732: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'

344728: , CASE r
344729: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
344730: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
344731: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
344732: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
344733: WHEN 5 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
344734: WHEN 6 THEN 'CST_XLA_DISCRETE_JOB_REF_V'
344735: WHEN 7 THEN 'CST_XLA_WIP_ENTITY_REF_V'
344736: WHEN 8 THEN 'CST_XLA_FLOW_SCHEDULE_REF_V'

Line 344738: WHEN 10 THEN 'CST_XLA_WIP_HEADERS_V'

344734: WHEN 6 THEN 'CST_XLA_DISCRETE_JOB_REF_V'
344735: WHEN 7 THEN 'CST_XLA_WIP_ENTITY_REF_V'
344736: WHEN 8 THEN 'CST_XLA_FLOW_SCHEDULE_REF_V'
344737: WHEN 9 THEN 'CST_XLA_REP_ITEM_REF_V'
344738: WHEN 10 THEN 'CST_XLA_WIP_HEADERS_V'
344739: WHEN 11 THEN 'CST_XLA_WIP_HEADERS_V'
344740: WHEN 12 THEN 'CST_XLA_WIP_HEADERS_V'
344741: WHEN 13 THEN 'CST_XLA_WIP_HEADERS_V'
344742: WHEN 14 THEN 'CST_XLA_WIP_HEADERS_V'

Line 344739: WHEN 11 THEN 'CST_XLA_WIP_HEADERS_V'

344735: WHEN 7 THEN 'CST_XLA_WIP_ENTITY_REF_V'
344736: WHEN 8 THEN 'CST_XLA_FLOW_SCHEDULE_REF_V'
344737: WHEN 9 THEN 'CST_XLA_REP_ITEM_REF_V'
344738: WHEN 10 THEN 'CST_XLA_WIP_HEADERS_V'
344739: WHEN 11 THEN 'CST_XLA_WIP_HEADERS_V'
344740: WHEN 12 THEN 'CST_XLA_WIP_HEADERS_V'
344741: WHEN 13 THEN 'CST_XLA_WIP_HEADERS_V'
344742: WHEN 14 THEN 'CST_XLA_WIP_HEADERS_V'
344743:

Line 344740: WHEN 12 THEN 'CST_XLA_WIP_HEADERS_V'

344736: WHEN 8 THEN 'CST_XLA_FLOW_SCHEDULE_REF_V'
344737: WHEN 9 THEN 'CST_XLA_REP_ITEM_REF_V'
344738: WHEN 10 THEN 'CST_XLA_WIP_HEADERS_V'
344739: WHEN 11 THEN 'CST_XLA_WIP_HEADERS_V'
344740: WHEN 12 THEN 'CST_XLA_WIP_HEADERS_V'
344741: WHEN 13 THEN 'CST_XLA_WIP_HEADERS_V'
344742: WHEN 14 THEN 'CST_XLA_WIP_HEADERS_V'
344743:
344744: ELSE null

Line 344741: WHEN 13 THEN 'CST_XLA_WIP_HEADERS_V'

344737: WHEN 9 THEN 'CST_XLA_REP_ITEM_REF_V'
344738: WHEN 10 THEN 'CST_XLA_WIP_HEADERS_V'
344739: WHEN 11 THEN 'CST_XLA_WIP_HEADERS_V'
344740: WHEN 12 THEN 'CST_XLA_WIP_HEADERS_V'
344741: WHEN 13 THEN 'CST_XLA_WIP_HEADERS_V'
344742: WHEN 14 THEN 'CST_XLA_WIP_HEADERS_V'
344743:
344744: ELSE null
344745: END object_name

Line 344742: WHEN 14 THEN 'CST_XLA_WIP_HEADERS_V'

344738: WHEN 10 THEN 'CST_XLA_WIP_HEADERS_V'
344739: WHEN 11 THEN 'CST_XLA_WIP_HEADERS_V'
344740: WHEN 12 THEN 'CST_XLA_WIP_HEADERS_V'
344741: WHEN 13 THEN 'CST_XLA_WIP_HEADERS_V'
344742: WHEN 14 THEN 'CST_XLA_WIP_HEADERS_V'
344743:
344744: ELSE null
344745: END object_name
344746: , CASE r

Line 344833: , CST_XLA_WIP_HEADERS_V h6

344829: , CST_XLA_FLOW_SCHEDULE_REF_V h2
344830: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h3
344831: , CST_XLA_REP_ITEM_REF_V h4
344832: , CST_XLA_WIP_ENTITY_REF_V h5
344833: , CST_XLA_WIP_HEADERS_V h6
344834: , fnd_lookup_values fvl7
344835: , fnd_lookup_values fvl55
344836: , fnd_lookup_values fvl85
344837: , fnd_lookup_values fvl114

Line 345108: TYPE t_array_source_1 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;

345104: --
345105: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
345106: --
345107:
345108: TYPE t_array_source_1 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
345109: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
345110: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
345111: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
345112: TYPE t_array_source_53 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.INV_ITEM_EXPENSE_ACCT%TYPE INDEX BY BINARY_INTEGER;

Line 345109: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;

345105: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
345106: --
345107:
345108: TYPE t_array_source_1 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
345109: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
345110: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
345111: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
345112: TYPE t_array_source_53 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.INV_ITEM_EXPENSE_ACCT%TYPE INDEX BY BINARY_INTEGER;
345113: TYPE t_array_source_54 IS TABLE OF CST_XLA_DISCRETE_JOB_REF_V.DIS_JOB_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;

Line 345110: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;

345106: --
345107:
345108: TYPE t_array_source_1 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
345109: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
345110: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
345111: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
345112: TYPE t_array_source_53 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.INV_ITEM_EXPENSE_ACCT%TYPE INDEX BY BINARY_INTEGER;
345113: TYPE t_array_source_54 IS TABLE OF CST_XLA_DISCRETE_JOB_REF_V.DIS_JOB_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
345114: TYPE t_array_source_55 IS TABLE OF CST_XLA_WIP_ENTITY_REF_V.WIP_ENTITY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 345111: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

345107:
345108: TYPE t_array_source_1 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
345109: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
345110: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
345111: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
345112: TYPE t_array_source_53 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.INV_ITEM_EXPENSE_ACCT%TYPE INDEX BY BINARY_INTEGER;
345113: TYPE t_array_source_54 IS TABLE OF CST_XLA_DISCRETE_JOB_REF_V.DIS_JOB_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
345114: TYPE t_array_source_55 IS TABLE OF CST_XLA_WIP_ENTITY_REF_V.WIP_ENTITY_TYPE%TYPE INDEX BY BINARY_INTEGER;
345115: TYPE t_array_source_56 IS TABLE OF CST_XLA_FLOW_SCHEDULE_REF_V.FLO_SCH_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;

Line 345117: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

345113: TYPE t_array_source_54 IS TABLE OF CST_XLA_DISCRETE_JOB_REF_V.DIS_JOB_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
345114: TYPE t_array_source_55 IS TABLE OF CST_XLA_WIP_ENTITY_REF_V.WIP_ENTITY_TYPE%TYPE INDEX BY BINARY_INTEGER;
345115: TYPE t_array_source_56 IS TABLE OF CST_XLA_FLOW_SCHEDULE_REF_V.FLO_SCH_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
345116: TYPE t_array_source_57 IS TABLE OF CST_XLA_REP_ITEM_REF_V.REP_ITM_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
345117: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
345118: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%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;

Line 345118: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

345114: TYPE t_array_source_55 IS TABLE OF CST_XLA_WIP_ENTITY_REF_V.WIP_ENTITY_TYPE%TYPE INDEX BY BINARY_INTEGER;
345115: TYPE t_array_source_56 IS TABLE OF CST_XLA_FLOW_SCHEDULE_REF_V.FLO_SCH_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
345116: TYPE t_array_source_57 IS TABLE OF CST_XLA_REP_ITEM_REF_V.REP_ITM_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
345117: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
345118: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%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:

Line 345119: TYPE t_array_source_92 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

345115: TYPE t_array_source_56 IS TABLE OF CST_XLA_FLOW_SCHEDULE_REF_V.FLO_SCH_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
345116: TYPE t_array_source_57 IS TABLE OF CST_XLA_REP_ITEM_REF_V.REP_ITM_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
345117: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
345118: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%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;

Line 345120: TYPE t_array_source_93 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

345116: TYPE t_array_source_57 IS TABLE OF CST_XLA_REP_ITEM_REF_V.REP_ITM_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
345117: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
345118: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%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;

Line 345121: TYPE t_array_source_114 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

345117: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
345118: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%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;

Line 345208: , CST_XLA_WIP_HEADERS_V h6

345204: , CST_XLA_FLOW_SCHEDULE_REF_V h2
345205: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h3
345206: , CST_XLA_REP_ITEM_REF_V h4
345207: , CST_XLA_WIP_ENTITY_REF_V h5
345208: , CST_XLA_WIP_HEADERS_V h6
345209: , fnd_lookup_values fvl7
345210: , fnd_lookup_values fvl55
345211: , fnd_lookup_values fvl85
345212: , fnd_lookup_values fvl114

Line 368859: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'

368855: FROM (
368856: SELECT xet.event_id event_id
368857: , 0 line_number
368858: , CASE r
368859: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
368860: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
368861: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
368862: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
368863: WHEN 5 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'

Line 368860: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'

368856: SELECT xet.event_id event_id
368857: , 0 line_number
368858: , CASE r
368859: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
368860: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
368861: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
368862: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
368863: WHEN 5 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
368864: WHEN 6 THEN 'CST_XLA_DISCRETE_JOB_REF_V'

Line 368861: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'

368857: , 0 line_number
368858: , CASE r
368859: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
368860: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
368861: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
368862: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
368863: WHEN 5 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
368864: WHEN 6 THEN 'CST_XLA_DISCRETE_JOB_REF_V'
368865: WHEN 7 THEN 'CST_XLA_WIP_ENTITY_REF_V'

Line 368862: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'

368858: , CASE r
368859: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
368860: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
368861: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
368862: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
368863: WHEN 5 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
368864: WHEN 6 THEN 'CST_XLA_DISCRETE_JOB_REF_V'
368865: WHEN 7 THEN 'CST_XLA_WIP_ENTITY_REF_V'
368866: WHEN 8 THEN 'CST_XLA_FLOW_SCHEDULE_REF_V'

Line 368868: WHEN 10 THEN 'CST_XLA_WIP_HEADERS_V'

368864: WHEN 6 THEN 'CST_XLA_DISCRETE_JOB_REF_V'
368865: WHEN 7 THEN 'CST_XLA_WIP_ENTITY_REF_V'
368866: WHEN 8 THEN 'CST_XLA_FLOW_SCHEDULE_REF_V'
368867: WHEN 9 THEN 'CST_XLA_REP_ITEM_REF_V'
368868: WHEN 10 THEN 'CST_XLA_WIP_HEADERS_V'
368869: WHEN 11 THEN 'CST_XLA_WIP_HEADERS_V'
368870: WHEN 12 THEN 'CST_XLA_WIP_HEADERS_V'
368871: WHEN 13 THEN 'CST_XLA_WIP_HEADERS_V'
368872: WHEN 14 THEN 'CST_XLA_WIP_HEADERS_V'

Line 368869: WHEN 11 THEN 'CST_XLA_WIP_HEADERS_V'

368865: WHEN 7 THEN 'CST_XLA_WIP_ENTITY_REF_V'
368866: WHEN 8 THEN 'CST_XLA_FLOW_SCHEDULE_REF_V'
368867: WHEN 9 THEN 'CST_XLA_REP_ITEM_REF_V'
368868: WHEN 10 THEN 'CST_XLA_WIP_HEADERS_V'
368869: WHEN 11 THEN 'CST_XLA_WIP_HEADERS_V'
368870: WHEN 12 THEN 'CST_XLA_WIP_HEADERS_V'
368871: WHEN 13 THEN 'CST_XLA_WIP_HEADERS_V'
368872: WHEN 14 THEN 'CST_XLA_WIP_HEADERS_V'
368873:

Line 368870: WHEN 12 THEN 'CST_XLA_WIP_HEADERS_V'

368866: WHEN 8 THEN 'CST_XLA_FLOW_SCHEDULE_REF_V'
368867: WHEN 9 THEN 'CST_XLA_REP_ITEM_REF_V'
368868: WHEN 10 THEN 'CST_XLA_WIP_HEADERS_V'
368869: WHEN 11 THEN 'CST_XLA_WIP_HEADERS_V'
368870: WHEN 12 THEN 'CST_XLA_WIP_HEADERS_V'
368871: WHEN 13 THEN 'CST_XLA_WIP_HEADERS_V'
368872: WHEN 14 THEN 'CST_XLA_WIP_HEADERS_V'
368873:
368874: ELSE null

Line 368871: WHEN 13 THEN 'CST_XLA_WIP_HEADERS_V'

368867: WHEN 9 THEN 'CST_XLA_REP_ITEM_REF_V'
368868: WHEN 10 THEN 'CST_XLA_WIP_HEADERS_V'
368869: WHEN 11 THEN 'CST_XLA_WIP_HEADERS_V'
368870: WHEN 12 THEN 'CST_XLA_WIP_HEADERS_V'
368871: WHEN 13 THEN 'CST_XLA_WIP_HEADERS_V'
368872: WHEN 14 THEN 'CST_XLA_WIP_HEADERS_V'
368873:
368874: ELSE null
368875: END object_name

Line 368872: WHEN 14 THEN 'CST_XLA_WIP_HEADERS_V'

368868: WHEN 10 THEN 'CST_XLA_WIP_HEADERS_V'
368869: WHEN 11 THEN 'CST_XLA_WIP_HEADERS_V'
368870: WHEN 12 THEN 'CST_XLA_WIP_HEADERS_V'
368871: WHEN 13 THEN 'CST_XLA_WIP_HEADERS_V'
368872: WHEN 14 THEN 'CST_XLA_WIP_HEADERS_V'
368873:
368874: ELSE null
368875: END object_name
368876: , CASE r

Line 368963: , CST_XLA_WIP_HEADERS_V h6

368959: , CST_XLA_FLOW_SCHEDULE_REF_V h2
368960: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h3
368961: , CST_XLA_REP_ITEM_REF_V h4
368962: , CST_XLA_WIP_ENTITY_REF_V h5
368963: , CST_XLA_WIP_HEADERS_V h6
368964: , fnd_lookup_values fvl7
368965: , fnd_lookup_values fvl55
368966: , fnd_lookup_values fvl85
368967: , fnd_lookup_values fvl114

Line 369238: TYPE t_array_source_1 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;

369234: --
369235: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
369236: --
369237:
369238: TYPE t_array_source_1 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
369239: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
369240: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
369241: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
369242: TYPE t_array_source_53 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.INV_ITEM_EXPENSE_ACCT%TYPE INDEX BY BINARY_INTEGER;

Line 369239: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;

369235: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
369236: --
369237:
369238: TYPE t_array_source_1 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
369239: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
369240: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
369241: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
369242: TYPE t_array_source_53 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.INV_ITEM_EXPENSE_ACCT%TYPE INDEX BY BINARY_INTEGER;
369243: TYPE t_array_source_54 IS TABLE OF CST_XLA_DISCRETE_JOB_REF_V.DIS_JOB_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;

Line 369240: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;

369236: --
369237:
369238: TYPE t_array_source_1 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
369239: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
369240: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
369241: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
369242: TYPE t_array_source_53 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.INV_ITEM_EXPENSE_ACCT%TYPE INDEX BY BINARY_INTEGER;
369243: TYPE t_array_source_54 IS TABLE OF CST_XLA_DISCRETE_JOB_REF_V.DIS_JOB_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
369244: TYPE t_array_source_55 IS TABLE OF CST_XLA_WIP_ENTITY_REF_V.WIP_ENTITY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 369241: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

369237:
369238: TYPE t_array_source_1 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
369239: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
369240: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
369241: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
369242: TYPE t_array_source_53 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.INV_ITEM_EXPENSE_ACCT%TYPE INDEX BY BINARY_INTEGER;
369243: TYPE t_array_source_54 IS TABLE OF CST_XLA_DISCRETE_JOB_REF_V.DIS_JOB_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
369244: TYPE t_array_source_55 IS TABLE OF CST_XLA_WIP_ENTITY_REF_V.WIP_ENTITY_TYPE%TYPE INDEX BY BINARY_INTEGER;
369245: TYPE t_array_source_56 IS TABLE OF CST_XLA_FLOW_SCHEDULE_REF_V.FLO_SCH_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;

Line 369247: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

369243: TYPE t_array_source_54 IS TABLE OF CST_XLA_DISCRETE_JOB_REF_V.DIS_JOB_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
369244: TYPE t_array_source_55 IS TABLE OF CST_XLA_WIP_ENTITY_REF_V.WIP_ENTITY_TYPE%TYPE INDEX BY BINARY_INTEGER;
369245: TYPE t_array_source_56 IS TABLE OF CST_XLA_FLOW_SCHEDULE_REF_V.FLO_SCH_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
369246: TYPE t_array_source_57 IS TABLE OF CST_XLA_REP_ITEM_REF_V.REP_ITM_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
369247: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
369248: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%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;

Line 369248: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

369244: TYPE t_array_source_55 IS TABLE OF CST_XLA_WIP_ENTITY_REF_V.WIP_ENTITY_TYPE%TYPE INDEX BY BINARY_INTEGER;
369245: TYPE t_array_source_56 IS TABLE OF CST_XLA_FLOW_SCHEDULE_REF_V.FLO_SCH_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
369246: TYPE t_array_source_57 IS TABLE OF CST_XLA_REP_ITEM_REF_V.REP_ITM_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
369247: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
369248: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%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:

Line 369249: TYPE t_array_source_92 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

369245: TYPE t_array_source_56 IS TABLE OF CST_XLA_FLOW_SCHEDULE_REF_V.FLO_SCH_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
369246: TYPE t_array_source_57 IS TABLE OF CST_XLA_REP_ITEM_REF_V.REP_ITM_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
369247: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
369248: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%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;

Line 369250: TYPE t_array_source_93 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

369246: TYPE t_array_source_57 IS TABLE OF CST_XLA_REP_ITEM_REF_V.REP_ITM_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
369247: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
369248: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%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;

Line 369251: TYPE t_array_source_114 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

369247: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
369248: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%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;

Line 369338: , CST_XLA_WIP_HEADERS_V h6

369334: , CST_XLA_FLOW_SCHEDULE_REF_V h2
369335: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h3
369336: , CST_XLA_REP_ITEM_REF_V h4
369337: , CST_XLA_WIP_ENTITY_REF_V h5
369338: , CST_XLA_WIP_HEADERS_V h6
369339: , fnd_lookup_values fvl7
369340: , fnd_lookup_values fvl55
369341: , fnd_lookup_values fvl85
369342: , fnd_lookup_values fvl114

Line 415920: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'

415916: FROM (
415917: SELECT xet.event_id event_id
415918: , 0 line_number
415919: , CASE r
415920: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
415921: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
415922: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
415923: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
415924: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'

Line 415921: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'

415917: SELECT xet.event_id event_id
415918: , 0 line_number
415919: , CASE r
415920: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
415921: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
415922: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
415923: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
415924: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
415925: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'

Line 415922: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'

415918: , 0 line_number
415919: , CASE r
415920: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
415921: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
415922: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
415923: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
415924: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
415925: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
415926: WHEN 7 THEN 'CST_XLA_WIP_HEADERS_V'

Line 415923: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'

415919: , CASE r
415920: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
415921: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
415922: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
415923: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
415924: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
415925: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
415926: WHEN 7 THEN 'CST_XLA_WIP_HEADERS_V'
415927: WHEN 8 THEN 'CST_XLA_WIP_HEADERS_V'

Line 415924: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'

415920: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
415921: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
415922: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
415923: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
415924: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
415925: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
415926: WHEN 7 THEN 'CST_XLA_WIP_HEADERS_V'
415927: WHEN 8 THEN 'CST_XLA_WIP_HEADERS_V'
415928: WHEN 9 THEN 'CST_XLA_WIP_HEADERS_V'

Line 415925: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'

415921: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
415922: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
415923: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
415924: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
415925: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
415926: WHEN 7 THEN 'CST_XLA_WIP_HEADERS_V'
415927: WHEN 8 THEN 'CST_XLA_WIP_HEADERS_V'
415928: WHEN 9 THEN 'CST_XLA_WIP_HEADERS_V'
415929: WHEN 10 THEN 'CST_XLA_WIP_HEADERS_V'

Line 415926: WHEN 7 THEN 'CST_XLA_WIP_HEADERS_V'

415922: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
415923: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
415924: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
415925: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
415926: WHEN 7 THEN 'CST_XLA_WIP_HEADERS_V'
415927: WHEN 8 THEN 'CST_XLA_WIP_HEADERS_V'
415928: WHEN 9 THEN 'CST_XLA_WIP_HEADERS_V'
415929: WHEN 10 THEN 'CST_XLA_WIP_HEADERS_V'
415930:

Line 415927: WHEN 8 THEN 'CST_XLA_WIP_HEADERS_V'

415923: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
415924: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
415925: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
415926: WHEN 7 THEN 'CST_XLA_WIP_HEADERS_V'
415927: WHEN 8 THEN 'CST_XLA_WIP_HEADERS_V'
415928: WHEN 9 THEN 'CST_XLA_WIP_HEADERS_V'
415929: WHEN 10 THEN 'CST_XLA_WIP_HEADERS_V'
415930:
415931: ELSE null

Line 415928: WHEN 9 THEN 'CST_XLA_WIP_HEADERS_V'

415924: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
415925: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
415926: WHEN 7 THEN 'CST_XLA_WIP_HEADERS_V'
415927: WHEN 8 THEN 'CST_XLA_WIP_HEADERS_V'
415928: WHEN 9 THEN 'CST_XLA_WIP_HEADERS_V'
415929: WHEN 10 THEN 'CST_XLA_WIP_HEADERS_V'
415930:
415931: ELSE null
415932: END object_name

Line 415929: WHEN 10 THEN 'CST_XLA_WIP_HEADERS_V'

415925: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
415926: WHEN 7 THEN 'CST_XLA_WIP_HEADERS_V'
415927: WHEN 8 THEN 'CST_XLA_WIP_HEADERS_V'
415928: WHEN 9 THEN 'CST_XLA_WIP_HEADERS_V'
415929: WHEN 10 THEN 'CST_XLA_WIP_HEADERS_V'
415930:
415931: ELSE null
415932: END object_name
415933: , CASE r

Line 415998: , CST_XLA_WIP_HEADERS_V h1

415994:
415995: ELSE null
415996: END source_meaning
415997: FROM xla_events_gt xet
415998: , CST_XLA_WIP_HEADERS_V h1
415999: , fnd_lookup_values fvl7
416000: , fnd_lookup_values fvl85
416001: , fnd_lookup_values fvl114
416002: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)

Line 416269: TYPE t_array_source_1 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;

416265: --
416266: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
416267: --
416268:
416269: TYPE t_array_source_1 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
416270: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
416271: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
416272: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
416273: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 416270: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;

416266: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
416267: --
416268:
416269: TYPE t_array_source_1 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
416270: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
416271: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
416272: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
416273: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
416274: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 416271: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;

416267: --
416268:
416269: TYPE t_array_source_1 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
416270: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
416271: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
416272: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
416273: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
416274: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
416275: TYPE t_array_source_92 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 416272: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

416268:
416269: TYPE t_array_source_1 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
416270: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
416271: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
416272: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
416273: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
416274: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
416275: TYPE t_array_source_92 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%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;

Line 416273: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

416269: TYPE t_array_source_1 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
416270: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
416271: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
416272: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
416273: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
416274: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
416275: TYPE t_array_source_92 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%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;

Line 416274: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

416270: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
416271: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
416272: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
416273: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
416274: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
416275: TYPE t_array_source_92 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%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;

Line 416275: TYPE t_array_source_92 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

416271: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
416272: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
416273: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
416274: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
416275: TYPE t_array_source_92 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%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:

Line 416276: TYPE t_array_source_93 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

416272: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
416273: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
416274: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
416275: TYPE t_array_source_92 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%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;

Line 416277: TYPE t_array_source_94 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

416273: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
416274: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
416275: TYPE t_array_source_92 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%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;

Line 416278: TYPE t_array_source_114 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

416274: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
416275: TYPE t_array_source_92 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%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;

Line 416349: , CST_XLA_WIP_HEADERS_V h1

416345: , h1.CURRENCY_CONVERSION_TYPE source_94
416346: , h1.TRANSFER_TO_GL_INDICATOR source_114
416347: , fvl114.meaning source_114_meaning
416348: FROM xla_events_gt xet
416349: , CST_XLA_WIP_HEADERS_V h1
416350: , fnd_lookup_values fvl7
416351: , fnd_lookup_values fvl85
416352: , fnd_lookup_values fvl114
416353: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 424055: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'

424051: FROM (
424052: SELECT xet.event_id event_id
424053: , 0 line_number
424054: , CASE r
424055: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
424056: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
424057: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
424058: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
424059: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'

Line 424056: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'

424052: SELECT xet.event_id event_id
424053: , 0 line_number
424054: , CASE r
424055: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
424056: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
424057: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
424058: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
424059: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
424060: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'

Line 424057: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'

424053: , 0 line_number
424054: , CASE r
424055: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
424056: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
424057: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
424058: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
424059: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
424060: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
424061: WHEN 7 THEN 'CST_XLA_WIP_HEADERS_V'

Line 424058: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'

424054: , CASE r
424055: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
424056: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
424057: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
424058: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
424059: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
424060: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
424061: WHEN 7 THEN 'CST_XLA_WIP_HEADERS_V'
424062: WHEN 8 THEN 'CST_XLA_WIP_HEADERS_V'

Line 424059: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'

424055: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
424056: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
424057: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
424058: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
424059: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
424060: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
424061: WHEN 7 THEN 'CST_XLA_WIP_HEADERS_V'
424062: WHEN 8 THEN 'CST_XLA_WIP_HEADERS_V'
424063: WHEN 9 THEN 'CST_XLA_WIP_HEADERS_V'

Line 424060: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'

424056: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
424057: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
424058: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
424059: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
424060: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
424061: WHEN 7 THEN 'CST_XLA_WIP_HEADERS_V'
424062: WHEN 8 THEN 'CST_XLA_WIP_HEADERS_V'
424063: WHEN 9 THEN 'CST_XLA_WIP_HEADERS_V'
424064: WHEN 10 THEN 'CST_XLA_WIP_HEADERS_V'

Line 424061: WHEN 7 THEN 'CST_XLA_WIP_HEADERS_V'

424057: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
424058: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
424059: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
424060: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
424061: WHEN 7 THEN 'CST_XLA_WIP_HEADERS_V'
424062: WHEN 8 THEN 'CST_XLA_WIP_HEADERS_V'
424063: WHEN 9 THEN 'CST_XLA_WIP_HEADERS_V'
424064: WHEN 10 THEN 'CST_XLA_WIP_HEADERS_V'
424065:

Line 424062: WHEN 8 THEN 'CST_XLA_WIP_HEADERS_V'

424058: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
424059: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
424060: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
424061: WHEN 7 THEN 'CST_XLA_WIP_HEADERS_V'
424062: WHEN 8 THEN 'CST_XLA_WIP_HEADERS_V'
424063: WHEN 9 THEN 'CST_XLA_WIP_HEADERS_V'
424064: WHEN 10 THEN 'CST_XLA_WIP_HEADERS_V'
424065:
424066: ELSE null

Line 424063: WHEN 9 THEN 'CST_XLA_WIP_HEADERS_V'

424059: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
424060: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
424061: WHEN 7 THEN 'CST_XLA_WIP_HEADERS_V'
424062: WHEN 8 THEN 'CST_XLA_WIP_HEADERS_V'
424063: WHEN 9 THEN 'CST_XLA_WIP_HEADERS_V'
424064: WHEN 10 THEN 'CST_XLA_WIP_HEADERS_V'
424065:
424066: ELSE null
424067: END object_name

Line 424064: WHEN 10 THEN 'CST_XLA_WIP_HEADERS_V'

424060: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
424061: WHEN 7 THEN 'CST_XLA_WIP_HEADERS_V'
424062: WHEN 8 THEN 'CST_XLA_WIP_HEADERS_V'
424063: WHEN 9 THEN 'CST_XLA_WIP_HEADERS_V'
424064: WHEN 10 THEN 'CST_XLA_WIP_HEADERS_V'
424065:
424066: ELSE null
424067: END object_name
424068: , CASE r

Line 424133: , CST_XLA_WIP_HEADERS_V h1

424129:
424130: ELSE null
424131: END source_meaning
424132: FROM xla_events_gt xet
424133: , CST_XLA_WIP_HEADERS_V h1
424134: , fnd_lookup_values fvl7
424135: , fnd_lookup_values fvl85
424136: , fnd_lookup_values fvl114
424137: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)

Line 424404: TYPE t_array_source_1 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;

424400: --
424401: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
424402: --
424403:
424404: TYPE t_array_source_1 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
424405: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
424406: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
424407: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
424408: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 424405: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;

424401: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
424402: --
424403:
424404: TYPE t_array_source_1 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
424405: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
424406: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
424407: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
424408: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
424409: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 424406: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;

424402: --
424403:
424404: TYPE t_array_source_1 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
424405: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
424406: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
424407: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
424408: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
424409: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
424410: TYPE t_array_source_92 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 424407: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

424403:
424404: TYPE t_array_source_1 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
424405: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
424406: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
424407: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
424408: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
424409: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
424410: TYPE t_array_source_92 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%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;

Line 424408: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

424404: TYPE t_array_source_1 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
424405: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
424406: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
424407: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
424408: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
424409: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
424410: TYPE t_array_source_92 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%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;

Line 424409: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

424405: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
424406: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
424407: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
424408: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
424409: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
424410: TYPE t_array_source_92 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%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;

Line 424410: TYPE t_array_source_92 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

424406: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
424407: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
424408: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
424409: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
424410: TYPE t_array_source_92 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%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:

Line 424411: TYPE t_array_source_93 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

424407: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
424408: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
424409: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
424410: TYPE t_array_source_92 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%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;

Line 424412: TYPE t_array_source_94 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

424408: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
424409: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
424410: TYPE t_array_source_92 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%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;

Line 424413: TYPE t_array_source_114 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

424409: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
424410: TYPE t_array_source_92 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%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;

Line 424484: , CST_XLA_WIP_HEADERS_V h1

424480: , h1.CURRENCY_CONVERSION_TYPE source_94
424481: , h1.TRANSFER_TO_GL_INDICATOR source_114
424482: , fvl114.meaning source_114_meaning
424483: FROM xla_events_gt xet
424484: , CST_XLA_WIP_HEADERS_V h1
424485: , fnd_lookup_values fvl7
424486: , fnd_lookup_values fvl85
424487: , fnd_lookup_values fvl114
424488: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 426622: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'

426618: FROM (
426619: SELECT xet.event_id event_id
426620: , 0 line_number
426621: , CASE r
426622: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
426623: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
426624: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
426625: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
426626: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'

Line 426623: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'

426619: SELECT xet.event_id event_id
426620: , 0 line_number
426621: , CASE r
426622: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
426623: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
426624: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
426625: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
426626: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
426627: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'

Line 426624: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'

426620: , 0 line_number
426621: , CASE r
426622: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
426623: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
426624: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
426625: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
426626: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
426627: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
426628: WHEN 7 THEN 'CST_XLA_WIP_HEADERS_V'

Line 426625: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'

426621: , CASE r
426622: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
426623: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
426624: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
426625: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
426626: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
426627: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
426628: WHEN 7 THEN 'CST_XLA_WIP_HEADERS_V'
426629: WHEN 8 THEN 'CST_XLA_WIP_HEADERS_V'

Line 426626: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'

426622: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
426623: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
426624: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
426625: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
426626: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
426627: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
426628: WHEN 7 THEN 'CST_XLA_WIP_HEADERS_V'
426629: WHEN 8 THEN 'CST_XLA_WIP_HEADERS_V'
426630: WHEN 9 THEN 'CST_XLA_WIP_HEADERS_V'

Line 426627: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'

426623: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
426624: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
426625: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
426626: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
426627: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
426628: WHEN 7 THEN 'CST_XLA_WIP_HEADERS_V'
426629: WHEN 8 THEN 'CST_XLA_WIP_HEADERS_V'
426630: WHEN 9 THEN 'CST_XLA_WIP_HEADERS_V'
426631: WHEN 10 THEN 'CST_XLA_WIP_HEADERS_V'

Line 426628: WHEN 7 THEN 'CST_XLA_WIP_HEADERS_V'

426624: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
426625: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
426626: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
426627: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
426628: WHEN 7 THEN 'CST_XLA_WIP_HEADERS_V'
426629: WHEN 8 THEN 'CST_XLA_WIP_HEADERS_V'
426630: WHEN 9 THEN 'CST_XLA_WIP_HEADERS_V'
426631: WHEN 10 THEN 'CST_XLA_WIP_HEADERS_V'
426632:

Line 426629: WHEN 8 THEN 'CST_XLA_WIP_HEADERS_V'

426625: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
426626: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
426627: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
426628: WHEN 7 THEN 'CST_XLA_WIP_HEADERS_V'
426629: WHEN 8 THEN 'CST_XLA_WIP_HEADERS_V'
426630: WHEN 9 THEN 'CST_XLA_WIP_HEADERS_V'
426631: WHEN 10 THEN 'CST_XLA_WIP_HEADERS_V'
426632:
426633: ELSE null

Line 426630: WHEN 9 THEN 'CST_XLA_WIP_HEADERS_V'

426626: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
426627: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
426628: WHEN 7 THEN 'CST_XLA_WIP_HEADERS_V'
426629: WHEN 8 THEN 'CST_XLA_WIP_HEADERS_V'
426630: WHEN 9 THEN 'CST_XLA_WIP_HEADERS_V'
426631: WHEN 10 THEN 'CST_XLA_WIP_HEADERS_V'
426632:
426633: ELSE null
426634: END object_name

Line 426631: WHEN 10 THEN 'CST_XLA_WIP_HEADERS_V'

426627: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
426628: WHEN 7 THEN 'CST_XLA_WIP_HEADERS_V'
426629: WHEN 8 THEN 'CST_XLA_WIP_HEADERS_V'
426630: WHEN 9 THEN 'CST_XLA_WIP_HEADERS_V'
426631: WHEN 10 THEN 'CST_XLA_WIP_HEADERS_V'
426632:
426633: ELSE null
426634: END object_name
426635: , CASE r

Line 426700: , CST_XLA_WIP_HEADERS_V h1

426696:
426697: ELSE null
426698: END source_meaning
426699: FROM xla_events_gt xet
426700: , CST_XLA_WIP_HEADERS_V h1
426701: , fnd_lookup_values fvl7
426702: , fnd_lookup_values fvl85
426703: , fnd_lookup_values fvl114
426704: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)

Line 426971: TYPE t_array_source_1 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;

426967: --
426968: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
426969: --
426970:
426971: TYPE t_array_source_1 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
426972: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
426973: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
426974: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
426975: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 426972: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;

426968: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
426969: --
426970:
426971: TYPE t_array_source_1 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
426972: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
426973: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
426974: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
426975: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
426976: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 426973: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;

426969: --
426970:
426971: TYPE t_array_source_1 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
426972: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
426973: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
426974: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
426975: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
426976: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
426977: TYPE t_array_source_92 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 426974: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

426970:
426971: TYPE t_array_source_1 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
426972: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
426973: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
426974: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
426975: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
426976: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
426977: TYPE t_array_source_92 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%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;

Line 426975: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

426971: TYPE t_array_source_1 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
426972: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
426973: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
426974: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
426975: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
426976: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
426977: TYPE t_array_source_92 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%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;

Line 426976: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

426972: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
426973: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
426974: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
426975: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
426976: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
426977: TYPE t_array_source_92 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%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;

Line 426977: TYPE t_array_source_92 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

426973: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
426974: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
426975: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
426976: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
426977: TYPE t_array_source_92 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%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:

Line 426978: TYPE t_array_source_93 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

426974: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
426975: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
426976: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
426977: TYPE t_array_source_92 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%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;

Line 426979: TYPE t_array_source_94 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

426975: TYPE t_array_source_85 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
426976: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
426977: TYPE t_array_source_92 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%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;

Line 426980: TYPE t_array_source_114 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

426976: TYPE t_array_source_88 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
426977: TYPE t_array_source_92 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%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;

Line 427051: , CST_XLA_WIP_HEADERS_V h1

427047: , h1.CURRENCY_CONVERSION_TYPE source_94
427048: , h1.TRANSFER_TO_GL_INDICATOR source_114
427049: , fvl114.meaning source_114_meaning
427050: FROM xla_events_gt xet
427051: , CST_XLA_WIP_HEADERS_V h1
427052: , fnd_lookup_values fvl7
427053: , fnd_lookup_values fvl85
427054: , fnd_lookup_values fvl114
427055: WHERE xet.event_date between p_pad_start_date and p_pad_end_date