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

Line 143300: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'

143296: FROM (
143297: SELECT xet.event_id event_id
143298: , l2.line_number line_number
143299: , CASE r
143300: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
143301: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
143302: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
143303: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
143304: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'

Line 143301: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'

143297: SELECT xet.event_id event_id
143298: , l2.line_number line_number
143299: , CASE r
143300: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
143301: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
143302: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
143303: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
143304: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
143305:

Line 143302: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'

143298: , l2.line_number line_number
143299: , CASE r
143300: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
143301: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
143302: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
143303: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
143304: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
143305:
143306: ELSE null

Line 143303: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'

143299: , CASE r
143300: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
143301: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
143302: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
143303: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
143304: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
143305:
143306: ELSE null
143307: END object_name

Line 143304: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'

143300: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
143301: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
143302: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
143303: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
143304: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
143305:
143306: ELSE null
143307: END object_name
143308: , CASE r

Line 143347: , CST_XLA_WIP_LINES_V l2

143343: ELSE null
143344: END source_value
143345: , null source_meaning
143346: FROM xla_events_gt xet
143347: , CST_XLA_WIP_LINES_V l2
143348: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
143349: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
143350: AND xet.event_class_code = C_EVENT_CLASS_CODE
143351: AND l2.event_id = xet.event_id

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

143488: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
143489: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
143490: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
143491:
143492: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
143493: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
143494: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
143495: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
143496: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

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

143489: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
143490: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
143491:
143492: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
143493: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
143494: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
143495: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
143496: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
143497:

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

143490: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
143491:
143492: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
143493: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
143494: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
143495: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
143496: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
143497:
143498: l_array_source_12 t_array_source_12;

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

143491:
143492: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
143493: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
143494: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
143495: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
143496: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
143497:
143498: l_array_source_12 t_array_source_12;
143499: l_array_source_12_meaning t_array_lookup_meaning;

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

143492: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
143493: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
143494: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
143495: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
143496: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
143497:
143498: l_array_source_12 t_array_source_12;
143499: l_array_source_12_meaning t_array_lookup_meaning;
143500: l_array_source_15 t_array_source_15;

Line 143606: , CST_XLA_WIP_LINES_V l2

143602: , l2.ENTERED_AMOUNT source_18
143603: , l2.ACCOUNTED_AMOUNT source_22
143604: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
143605: FROM xla_events_gt xet
143606: , CST_XLA_WIP_LINES_V l2
143607: WHERE xet.event_id between x_first_event_id and x_last_event_id
143608: and xet.event_date between p_pad_start_date and p_pad_end_date
143609: and xet.event_class_code = C_EVENT_CLASS_CODE
143610: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 169867: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'

169863: FROM (
169864: SELECT xet.event_id event_id
169865: , l2.line_number line_number
169866: , CASE r
169867: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
169868: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
169869: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
169870: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
169871: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'

Line 169868: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'

169864: SELECT xet.event_id event_id
169865: , l2.line_number line_number
169866: , CASE r
169867: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
169868: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
169869: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
169870: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
169871: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
169872:

Line 169869: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'

169865: , l2.line_number line_number
169866: , CASE r
169867: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
169868: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
169869: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
169870: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
169871: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
169872:
169873: ELSE null

Line 169870: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'

169866: , CASE r
169867: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
169868: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
169869: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
169870: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
169871: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
169872:
169873: ELSE null
169874: END object_name

Line 169871: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'

169867: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
169868: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
169869: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
169870: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
169871: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
169872:
169873: ELSE null
169874: END object_name
169875: , CASE r

Line 169914: , CST_XLA_WIP_LINES_V l2

169910: ELSE null
169911: END source_value
169912: , null source_meaning
169913: FROM xla_events_gt xet
169914: , CST_XLA_WIP_LINES_V l2
169915: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
169916: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
169917: AND xet.event_class_code = C_EVENT_CLASS_CODE
169918: AND l2.event_id = xet.event_id

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

170054: TYPE t_array_source_19 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
170055: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
170056: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
170057:
170058: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
170059: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
170060: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
170061: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
170062: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

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

170055: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
170056: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
170057:
170058: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
170059: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
170060: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
170061: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
170062: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
170063:

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

170056: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
170057:
170058: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
170059: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
170060: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
170061: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
170062: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
170063:
170064: l_array_source_12 t_array_source_12;

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

170057:
170058: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
170059: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
170060: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
170061: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
170062: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
170063:
170064: l_array_source_12 t_array_source_12;
170065: l_array_source_12_meaning t_array_lookup_meaning;

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

170058: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
170059: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
170060: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
170061: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
170062: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
170063:
170064: l_array_source_12 t_array_source_12;
170065: l_array_source_12_meaning t_array_lookup_meaning;
170066: l_array_source_15 t_array_source_15;

Line 170170: , CST_XLA_WIP_LINES_V l2

170166: , l2.ENTERED_AMOUNT source_18
170167: , l2.ACCOUNTED_AMOUNT source_22
170168: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
170169: FROM xla_events_gt xet
170170: , CST_XLA_WIP_LINES_V l2
170171: WHERE xet.event_id between x_first_event_id and x_last_event_id
170172: and xet.event_date between p_pad_start_date and p_pad_end_date
170173: and xet.event_class_code = C_EVENT_CLASS_CODE
170174: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 203130: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'

203126: FROM (
203127: SELECT xet.event_id event_id
203128: , l2.line_number line_number
203129: , CASE r
203130: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
203131: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
203132: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
203133: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
203134: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'

Line 203131: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'

203127: SELECT xet.event_id event_id
203128: , l2.line_number line_number
203129: , CASE r
203130: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
203131: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
203132: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
203133: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
203134: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
203135:

Line 203132: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'

203128: , l2.line_number line_number
203129: , CASE r
203130: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
203131: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
203132: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
203133: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
203134: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
203135:
203136: ELSE null

Line 203133: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'

203129: , CASE r
203130: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
203131: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
203132: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
203133: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
203134: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
203135:
203136: ELSE null
203137: END object_name

Line 203134: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'

203130: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
203131: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
203132: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
203133: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
203134: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
203135:
203136: ELSE null
203137: END object_name
203138: , CASE r

Line 203177: , CST_XLA_WIP_LINES_V l2

203173: ELSE null
203174: END source_value
203175: , null source_meaning
203176: FROM xla_events_gt xet
203177: , CST_XLA_WIP_LINES_V l2
203178: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
203179: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
203180: AND xet.event_class_code = C_EVENT_CLASS_CODE
203181: AND l2.event_id = xet.event_id

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

203318: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
203319: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
203320: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
203321:
203322: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
203323: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
203324: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
203325: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
203326: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

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

203319: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
203320: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
203321:
203322: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
203323: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
203324: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
203325: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
203326: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
203327:

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

203320: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
203321:
203322: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
203323: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
203324: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
203325: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
203326: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
203327:
203328: l_array_source_12 t_array_source_12;

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

203321:
203322: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
203323: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
203324: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
203325: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
203326: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
203327:
203328: l_array_source_12 t_array_source_12;
203329: l_array_source_12_meaning t_array_lookup_meaning;

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

203322: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
203323: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
203324: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
203325: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
203326: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
203327:
203328: l_array_source_12 t_array_source_12;
203329: l_array_source_12_meaning t_array_lookup_meaning;
203330: l_array_source_15 t_array_source_15;

Line 203436: , CST_XLA_WIP_LINES_V l2

203432: , l2.ENTERED_AMOUNT source_18
203433: , l2.ACCOUNTED_AMOUNT source_22
203434: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
203435: FROM xla_events_gt xet
203436: , CST_XLA_WIP_LINES_V l2
203437: WHERE xet.event_id between x_first_event_id and x_last_event_id
203438: and xet.event_date between p_pad_start_date and p_pad_end_date
203439: and xet.event_class_code = C_EVENT_CLASS_CODE
203440: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 204341: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'

204337: FROM (
204338: SELECT xet.event_id event_id
204339: , l2.line_number line_number
204340: , CASE r
204341: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
204342: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
204343: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
204344: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
204345: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'

Line 204342: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'

204338: SELECT xet.event_id event_id
204339: , l2.line_number line_number
204340: , CASE r
204341: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
204342: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
204343: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
204344: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
204345: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
204346:

Line 204343: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'

204339: , l2.line_number line_number
204340: , CASE r
204341: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
204342: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
204343: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
204344: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
204345: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
204346:
204347: ELSE null

Line 204344: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'

204340: , CASE r
204341: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
204342: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
204343: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
204344: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
204345: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
204346:
204347: ELSE null
204348: END object_name

Line 204345: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'

204341: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
204342: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
204343: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
204344: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
204345: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
204346:
204347: ELSE null
204348: END object_name
204349: , CASE r

Line 204388: , CST_XLA_WIP_LINES_V l2

204384: ELSE null
204385: END source_value
204386: , null source_meaning
204387: FROM xla_events_gt xet
204388: , CST_XLA_WIP_LINES_V l2
204389: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
204390: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
204391: AND xet.event_class_code = C_EVENT_CLASS_CODE
204392: AND l2.event_id = xet.event_id

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

204529: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
204530: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
204531: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
204532:
204533: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
204534: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
204535: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
204536: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
204537: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

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

204530: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
204531: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
204532:
204533: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
204534: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
204535: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
204536: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
204537: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
204538:

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

204531: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
204532:
204533: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
204534: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
204535: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
204536: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
204537: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
204538:
204539: l_array_source_12 t_array_source_12;

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

204532:
204533: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
204534: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
204535: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
204536: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
204537: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
204538:
204539: l_array_source_12 t_array_source_12;
204540: l_array_source_12_meaning t_array_lookup_meaning;

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

204533: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
204534: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
204535: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
204536: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
204537: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
204538:
204539: l_array_source_12 t_array_source_12;
204540: l_array_source_12_meaning t_array_lookup_meaning;
204541: l_array_source_15 t_array_source_15;

Line 204647: , CST_XLA_WIP_LINES_V l2

204643: , l2.ENTERED_AMOUNT source_18
204644: , l2.ACCOUNTED_AMOUNT source_22
204645: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
204646: FROM xla_events_gt xet
204647: , CST_XLA_WIP_LINES_V l2
204648: WHERE xet.event_id between x_first_event_id and x_last_event_id
204649: and xet.event_date between p_pad_start_date and p_pad_end_date
204650: and xet.event_class_code = C_EVENT_CLASS_CODE
204651: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 205552: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'

205548: FROM (
205549: SELECT xet.event_id event_id
205550: , l2.line_number line_number
205551: , CASE r
205552: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
205553: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
205554: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
205555: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
205556: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'

Line 205553: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'

205549: SELECT xet.event_id event_id
205550: , l2.line_number line_number
205551: , CASE r
205552: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
205553: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
205554: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
205555: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
205556: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
205557:

Line 205554: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'

205550: , l2.line_number line_number
205551: , CASE r
205552: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
205553: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
205554: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
205555: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
205556: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
205557:
205558: ELSE null

Line 205555: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'

205551: , CASE r
205552: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
205553: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
205554: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
205555: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
205556: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
205557:
205558: ELSE null
205559: END object_name

Line 205556: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'

205552: WHEN 1 THEN 'CST_XLA_WIP_LINES_V'
205553: WHEN 2 THEN 'CST_XLA_WIP_LINES_V'
205554: WHEN 3 THEN 'CST_XLA_WIP_LINES_V'
205555: WHEN 4 THEN 'CST_XLA_WIP_LINES_V'
205556: WHEN 5 THEN 'CST_XLA_WIP_LINES_V'
205557:
205558: ELSE null
205559: END object_name
205560: , CASE r

Line 205599: , CST_XLA_WIP_LINES_V l2

205595: ELSE null
205596: END source_value
205597: , null source_meaning
205598: FROM xla_events_gt xet
205599: , CST_XLA_WIP_LINES_V l2
205600: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
205601: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
205602: AND xet.event_class_code = C_EVENT_CLASS_CODE
205603: AND l2.event_id = xet.event_id

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

205740: TYPE t_array_source_20 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
205741: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
205742: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
205743:
205744: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
205745: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
205746: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
205747: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
205748: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

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

205741: TYPE t_array_source_21 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
205742: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
205743:
205744: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
205745: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
205746: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
205747: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
205748: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
205749:

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

205742: TYPE t_array_source_38 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
205743:
205744: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
205745: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
205746: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
205747: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
205748: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
205749:
205750: l_array_source_12 t_array_source_12;

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

205743:
205744: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
205745: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
205746: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
205747: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
205748: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
205749:
205750: l_array_source_12 t_array_source_12;
205751: l_array_source_12_meaning t_array_lookup_meaning;

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

205744: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
205745: TYPE t_array_source_11 IS TABLE OF CST_XLA_WIP_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
205746: TYPE t_array_source_18 IS TABLE OF CST_XLA_WIP_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
205747: TYPE t_array_source_22 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
205748: TYPE t_array_source_24 IS TABLE OF CST_XLA_WIP_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
205749:
205750: l_array_source_12 t_array_source_12;
205751: l_array_source_12_meaning t_array_lookup_meaning;
205752: l_array_source_15 t_array_source_15;

Line 205858: , CST_XLA_WIP_LINES_V l2

205854: , l2.ENTERED_AMOUNT source_18
205855: , l2.ACCOUNTED_AMOUNT source_22
205856: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
205857: FROM xla_events_gt xet
205858: , CST_XLA_WIP_LINES_V l2
205859: WHERE xet.event_id between x_first_event_id and x_last_event_id
205860: and xet.event_date between p_pad_start_date and p_pad_end_date
205861: and xet.event_class_code = C_EVENT_CLASS_CODE
205862: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id