eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_00707_AAD_S_000007_PKG dependencies on CST_XLA_WIP_HEADERS_V

Line 138170: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'

138166: FROM (
138167: SELECT xet.event_id event_id
138168: , 0 line_number
138169: , CASE r
138170: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
138171: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
138172: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
138173: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
138174: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'

Line 138171: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'

138167: SELECT xet.event_id event_id
138168: , 0 line_number
138169: , CASE r
138170: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
138171: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
138172: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
138173: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
138174: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
138175: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'

Line 138172: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'

138168: , 0 line_number
138169: , CASE r
138170: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
138171: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
138172: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
138173: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
138174: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
138175: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
138176:

Line 138173: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'

138169: , CASE r
138170: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
138171: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
138172: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
138173: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
138174: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
138175: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
138176:
138177: ELSE null

Line 138174: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'

138170: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
138171: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
138172: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
138173: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
138174: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
138175: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
138176:
138177: ELSE null
138178: END object_name

Line 138175: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'

138171: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
138172: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
138173: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
138174: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
138175: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
138176:
138177: ELSE null
138178: END object_name
138179: , CASE r

Line 138227: , CST_XLA_WIP_HEADERS_V h1

138223:
138224: ELSE null
138225: END source_meaning
138226: FROM xla_events_gt xet
138227: , CST_XLA_WIP_HEADERS_V h1
138228: , fnd_lookup_values fvl12
138229: , fnd_lookup_values fvl38
138230: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
138231: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 138493: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

138489: --
138490: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
138491: --
138492:
138493: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
138494: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
138495: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
138496: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
138497: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 138494: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

138490: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
138491: --
138492:
138493: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
138494: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
138495: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
138496: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
138497: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
138498: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 138495: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

138491: --
138492:
138493: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
138494: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
138495: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
138496: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
138497: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
138498: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
138499:

Line 138496: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

138492:
138493: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
138494: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
138495: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
138496: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
138497: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
138498: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
138499:
138500: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 138497: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

138493: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
138494: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
138495: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
138496: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
138497: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
138498: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
138499:
138500: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
138501: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 138498: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

138494: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
138495: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
138496: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
138497: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
138498: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
138499:
138500: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
138501: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
138502: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 138559: , CST_XLA_WIP_HEADERS_V h1

138555: , h1.CURRENCY_CONVERSION_TYPE source_21
138556: , h1.TRANSFER_TO_GL_INDICATOR source_38
138557: , fvl38.meaning source_38_meaning
138558: FROM xla_events_gt xet
138559: , CST_XLA_WIP_HEADERS_V h1
138560: , fnd_lookup_values fvl12
138561: , fnd_lookup_values fvl38
138562: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
138563: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 162241: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'

162237: FROM (
162238: SELECT xet.event_id event_id
162239: , 0 line_number
162240: , CASE r
162241: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
162242: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
162243: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
162244: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
162245: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'

Line 162242: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'

162238: SELECT xet.event_id event_id
162239: , 0 line_number
162240: , CASE r
162241: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
162242: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
162243: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
162244: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
162245: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
162246:

Line 162243: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'

162239: , 0 line_number
162240: , CASE r
162241: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
162242: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
162243: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
162244: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
162245: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
162246:
162247: ELSE null

Line 162244: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'

162240: , CASE r
162241: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
162242: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
162243: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
162244: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
162245: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
162246:
162247: ELSE null
162248: END object_name

Line 162245: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'

162241: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
162242: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
162243: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
162244: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
162245: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
162246:
162247: ELSE null
162248: END object_name
162249: , CASE r

Line 162293: , CST_XLA_WIP_HEADERS_V h1

162289:
162290: ELSE null
162291: END source_meaning
162292: FROM xla_events_gt xet
162293: , CST_XLA_WIP_HEADERS_V h1
162294: , fnd_lookup_values fvl12
162295: , fnd_lookup_values fvl38
162296: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
162297: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 162559: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

162555: --
162556: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
162557: --
162558:
162559: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
162560: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
162561: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
162562: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
162563: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 162560: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

162556: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
162557: --
162558:
162559: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
162560: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
162561: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
162562: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
162563: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
162564:

Line 162561: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

162557: --
162558:
162559: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
162560: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
162561: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
162562: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
162563: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
162564:
162565: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 162562: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

162558:
162559: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
162560: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
162561: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
162562: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
162563: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
162564:
162565: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
162566: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 162563: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

162559: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
162560: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
162561: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
162562: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
162563: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
162564:
162565: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
162566: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
162567: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 162622: , CST_XLA_WIP_HEADERS_V h1

162618: , h1.CURRENCY_CONVERSION_RATE source_20
162619: , h1.TRANSFER_TO_GL_INDICATOR source_38
162620: , fvl38.meaning source_38_meaning
162621: FROM xla_events_gt xet
162622: , CST_XLA_WIP_HEADERS_V h1
162623: , fnd_lookup_values fvl12
162624: , fnd_lookup_values fvl38
162625: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
162626: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 194292: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'

194288: FROM (
194289: SELECT xet.event_id event_id
194290: , 0 line_number
194291: , CASE r
194292: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
194293: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
194294: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
194295: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
194296: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'

Line 194293: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'

194289: SELECT xet.event_id event_id
194290: , 0 line_number
194291: , CASE r
194292: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
194293: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
194294: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
194295: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
194296: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
194297: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'

Line 194294: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'

194290: , 0 line_number
194291: , CASE r
194292: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
194293: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
194294: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
194295: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
194296: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
194297: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
194298:

Line 194295: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'

194291: , CASE r
194292: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
194293: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
194294: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
194295: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
194296: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
194297: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
194298:
194299: ELSE null

Line 194296: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'

194292: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
194293: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
194294: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
194295: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
194296: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
194297: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
194298:
194299: ELSE null
194300: END object_name

Line 194297: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'

194293: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
194294: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
194295: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
194296: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
194297: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
194298:
194299: ELSE null
194300: END object_name
194301: , CASE r

Line 194349: , CST_XLA_WIP_HEADERS_V h1

194345:
194346: ELSE null
194347: END source_meaning
194348: FROM xla_events_gt xet
194349: , CST_XLA_WIP_HEADERS_V h1
194350: , fnd_lookup_values fvl12
194351: , fnd_lookup_values fvl38
194352: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
194353: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 194615: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

194611: --
194612: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
194613: --
194614:
194615: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
194616: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
194617: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
194618: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
194619: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 194616: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

194612: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
194613: --
194614:
194615: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
194616: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
194617: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
194618: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
194619: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
194620: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 194617: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

194613: --
194614:
194615: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
194616: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
194617: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
194618: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
194619: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
194620: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
194621:

Line 194618: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

194614:
194615: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
194616: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
194617: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
194618: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
194619: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
194620: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
194621:
194622: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 194619: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

194615: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
194616: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
194617: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
194618: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
194619: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
194620: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
194621:
194622: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
194623: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 194620: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

194616: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
194617: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
194618: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
194619: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
194620: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
194621:
194622: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
194623: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
194624: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 194681: , CST_XLA_WIP_HEADERS_V h1

194677: , h1.CURRENCY_CONVERSION_TYPE source_21
194678: , h1.TRANSFER_TO_GL_INDICATOR source_38
194679: , fvl38.meaning source_38_meaning
194680: FROM xla_events_gt xet
194681: , CST_XLA_WIP_HEADERS_V h1
194682: , fnd_lookup_values fvl12
194683: , fnd_lookup_values fvl38
194684: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
194685: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 195503: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'

195499: FROM (
195500: SELECT xet.event_id event_id
195501: , 0 line_number
195502: , CASE r
195503: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
195504: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
195505: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
195506: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
195507: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'

Line 195504: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'

195500: SELECT xet.event_id event_id
195501: , 0 line_number
195502: , CASE r
195503: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
195504: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
195505: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
195506: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
195507: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
195508: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'

Line 195505: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'

195501: , 0 line_number
195502: , CASE r
195503: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
195504: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
195505: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
195506: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
195507: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
195508: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
195509:

Line 195506: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'

195502: , CASE r
195503: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
195504: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
195505: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
195506: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
195507: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
195508: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
195509:
195510: ELSE null

Line 195507: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'

195503: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
195504: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
195505: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
195506: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
195507: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
195508: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
195509:
195510: ELSE null
195511: END object_name

Line 195508: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'

195504: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
195505: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
195506: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
195507: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
195508: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
195509:
195510: ELSE null
195511: END object_name
195512: , CASE r

Line 195560: , CST_XLA_WIP_HEADERS_V h1

195556:
195557: ELSE null
195558: END source_meaning
195559: FROM xla_events_gt xet
195560: , CST_XLA_WIP_HEADERS_V h1
195561: , fnd_lookup_values fvl12
195562: , fnd_lookup_values fvl38
195563: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
195564: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 195826: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

195822: --
195823: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
195824: --
195825:
195826: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
195827: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
195828: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
195829: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
195830: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 195827: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

195823: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
195824: --
195825:
195826: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
195827: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
195828: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
195829: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
195830: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
195831: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 195828: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

195824: --
195825:
195826: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
195827: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
195828: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
195829: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
195830: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
195831: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
195832:

Line 195829: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

195825:
195826: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
195827: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
195828: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
195829: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
195830: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
195831: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
195832:
195833: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 195830: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

195826: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
195827: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
195828: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
195829: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
195830: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
195831: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
195832:
195833: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
195834: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 195831: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

195827: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
195828: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
195829: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
195830: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
195831: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
195832:
195833: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
195834: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
195835: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 195892: , CST_XLA_WIP_HEADERS_V h1

195888: , h1.CURRENCY_CONVERSION_TYPE source_21
195889: , h1.TRANSFER_TO_GL_INDICATOR source_38
195890: , fvl38.meaning source_38_meaning
195891: FROM xla_events_gt xet
195892: , CST_XLA_WIP_HEADERS_V h1
195893: , fnd_lookup_values fvl12
195894: , fnd_lookup_values fvl38
195895: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
195896: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 196714: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'

196710: FROM (
196711: SELECT xet.event_id event_id
196712: , 0 line_number
196713: , CASE r
196714: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
196715: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
196716: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
196717: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
196718: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'

Line 196715: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'

196711: SELECT xet.event_id event_id
196712: , 0 line_number
196713: , CASE r
196714: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
196715: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
196716: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
196717: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
196718: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
196719: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'

Line 196716: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'

196712: , 0 line_number
196713: , CASE r
196714: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
196715: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
196716: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
196717: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
196718: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
196719: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
196720:

Line 196717: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'

196713: , CASE r
196714: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
196715: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
196716: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
196717: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
196718: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
196719: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
196720:
196721: ELSE null

Line 196718: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'

196714: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
196715: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
196716: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
196717: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
196718: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
196719: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
196720:
196721: ELSE null
196722: END object_name

Line 196719: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'

196715: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
196716: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
196717: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
196718: WHEN 5 THEN 'CST_XLA_WIP_HEADERS_V'
196719: WHEN 6 THEN 'CST_XLA_WIP_HEADERS_V'
196720:
196721: ELSE null
196722: END object_name
196723: , CASE r

Line 196771: , CST_XLA_WIP_HEADERS_V h1

196767:
196768: ELSE null
196769: END source_meaning
196770: FROM xla_events_gt xet
196771: , CST_XLA_WIP_HEADERS_V h1
196772: , fnd_lookup_values fvl12
196773: , fnd_lookup_values fvl38
196774: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
196775: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 197037: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

197033: --
197034: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
197035: --
197036:
197037: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
197038: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
197039: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
197040: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
197041: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 197038: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

197034: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
197035: --
197036:
197037: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
197038: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
197039: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
197040: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
197041: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
197042: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 197039: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

197035: --
197036:
197037: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
197038: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
197039: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
197040: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
197041: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
197042: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
197043:

Line 197040: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

197036:
197037: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
197038: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
197039: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
197040: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
197041: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
197042: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
197043:
197044: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 197041: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

197037: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
197038: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
197039: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
197040: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
197041: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
197042: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
197043:
197044: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
197045: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 197042: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

197038: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
197039: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
197040: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
197041: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
197042: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
197043:
197044: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
197045: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
197046: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 197103: , CST_XLA_WIP_HEADERS_V h1

197099: , h1.CURRENCY_CONVERSION_TYPE source_21
197100: , h1.TRANSFER_TO_GL_INDICATOR source_38
197101: , fvl38.meaning source_38_meaning
197102: FROM xla_events_gt xet
197103: , CST_XLA_WIP_HEADERS_V h1
197104: , fnd_lookup_values fvl12
197105: , fnd_lookup_values fvl38
197106: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
197107: and xet.event_class_code = C_EVENT_CLASS_CODE