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_RCV_LINES_V

Line 147233: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'

147229: FROM (
147230: SELECT xet.event_id event_id
147231: , l2.line_number line_number
147232: , CASE r
147233: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
147234: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
147235: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
147236: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
147237: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'

Line 147234: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'

147230: SELECT xet.event_id event_id
147231: , l2.line_number line_number
147232: , CASE r
147233: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
147234: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
147235: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
147236: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
147237: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
147238:

Line 147235: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'

147231: , l2.line_number line_number
147232: , CASE r
147233: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
147234: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
147235: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
147236: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
147237: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
147238:
147239: ELSE null

Line 147236: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'

147232: , CASE r
147233: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
147234: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
147235: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
147236: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
147237: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
147238:
147239: ELSE null
147240: END object_name

Line 147237: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'

147233: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
147234: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
147235: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
147236: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
147237: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
147238:
147239: ELSE null
147240: END object_name
147241: , CASE r

Line 147280: , CST_XLA_RCV_LINES_V l2

147276: ELSE null
147277: END source_value
147278: , null source_meaning
147279: FROM xla_events_gt xet
147280: , CST_XLA_RCV_LINES_V l2
147281: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
147282: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
147283: AND xet.event_class_code = C_EVENT_CLASS_CODE
147284: AND l2.event_id = xet.event_id

Line 147435: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

147431: TYPE t_array_source_23 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
147432: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
147433: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
147434:
147435: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
147436: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
147437: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
147438: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
147439: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 147436: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

147432: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
147433: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
147434:
147435: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
147436: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
147437: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
147438: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
147439: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
147440:

Line 147437: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

147433: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
147434:
147435: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
147436: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
147437: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
147438: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
147439: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
147440:
147441: l_array_source_6 t_array_source_6;

Line 147438: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

147434:
147435: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
147436: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
147437: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
147438: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
147439: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
147440:
147441: l_array_source_6 t_array_source_6;
147442: l_array_source_7 t_array_source_7;

Line 147439: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

147435: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
147436: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
147437: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
147438: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
147439: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
147440:
147441: l_array_source_6 t_array_source_6;
147442: l_array_source_7 t_array_source_7;
147443: l_array_source_8 t_array_source_8;

Line 147573: , CST_XLA_RCV_LINES_V l2

147569: , l2.DISTRIBUTION_IDENTIFIER source_11
147570: , l2.ENTERED_AMOUNT source_18
147571: , l2.ACCOUNTED_AMOUNT source_22
147572: FROM xla_events_gt xet
147573: , CST_XLA_RCV_LINES_V l2
147574: WHERE xet.event_id between x_first_event_id and x_last_event_id
147575: and xet.event_date between p_pad_start_date and p_pad_end_date
147576: and xet.event_class_code = C_EVENT_CLASS_CODE
147577: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 162335: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'

162331: FROM (
162332: SELECT xet.event_id event_id
162333: , l2.line_number line_number
162334: , CASE r
162335: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
162336: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
162337: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
162338: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
162339: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'

Line 162336: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'

162332: SELECT xet.event_id event_id
162333: , l2.line_number line_number
162334: , CASE r
162335: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
162336: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
162337: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
162338: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
162339: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
162340:

Line 162337: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'

162333: , l2.line_number line_number
162334: , CASE r
162335: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
162336: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
162337: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
162338: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
162339: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
162340:
162341: ELSE null

Line 162338: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'

162334: , CASE r
162335: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
162336: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
162337: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
162338: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
162339: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
162340:
162341: ELSE null
162342: END object_name

Line 162339: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'

162335: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
162336: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
162337: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
162338: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
162339: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
162340:
162341: ELSE null
162342: END object_name
162343: , CASE r

Line 162382: , CST_XLA_RCV_LINES_V l2

162378: ELSE null
162379: END source_value
162380: , null source_meaning
162381: FROM xla_events_gt xet
162382: , CST_XLA_RCV_LINES_V l2
162383: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
162384: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
162385: AND xet.event_class_code = C_EVENT_CLASS_CODE
162386: AND l2.event_id = xet.event_id

Line 162526: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

162522: TYPE t_array_source_33 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
162523: TYPE t_array_source_34 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
162524: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
162525:
162526: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
162527: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
162528: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
162529: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
162530: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 162527: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

162523: TYPE t_array_source_34 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
162524: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
162525:
162526: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
162527: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
162528: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
162529: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
162530: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
162531:

Line 162528: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

162524: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
162525:
162526: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
162527: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
162528: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
162529: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
162530: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
162531:
162532: l_array_source_12 t_array_source_12;

Line 162529: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

162525:
162526: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
162527: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
162528: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
162529: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
162530: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
162531:
162532: l_array_source_12 t_array_source_12;
162533: l_array_source_12_meaning t_array_lookup_meaning;

Line 162530: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

162526: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
162527: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
162528: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
162529: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
162530: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
162531:
162532: l_array_source_12 t_array_source_12;
162533: l_array_source_12_meaning t_array_lookup_meaning;
162534: l_array_source_32 t_array_source_32;

Line 162640: , CST_XLA_RCV_LINES_V l2

162636: , l2.DISTRIBUTION_IDENTIFIER source_11
162637: , l2.ENTERED_AMOUNT source_18
162638: , l2.ACCOUNTED_AMOUNT source_22
162639: FROM xla_events_gt xet
162640: , CST_XLA_RCV_LINES_V l2
162641: WHERE xet.event_id between x_first_event_id and x_last_event_id
162642: and xet.event_date between p_pad_start_date and p_pad_end_date
162643: and xet.event_class_code = C_EVENT_CLASS_CODE
162644: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 163599: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'

163595: FROM (
163596: SELECT xet.event_id event_id
163597: , l2.line_number line_number
163598: , CASE r
163599: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
163600: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
163601: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
163602: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
163603: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'

Line 163600: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'

163596: SELECT xet.event_id event_id
163597: , l2.line_number line_number
163598: , CASE r
163599: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
163600: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
163601: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
163602: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
163603: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
163604:

Line 163601: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'

163597: , l2.line_number line_number
163598: , CASE r
163599: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
163600: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
163601: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
163602: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
163603: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
163604:
163605: ELSE null

Line 163602: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'

163598: , CASE r
163599: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
163600: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
163601: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
163602: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
163603: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
163604:
163605: ELSE null
163606: END object_name

Line 163603: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'

163599: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
163600: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
163601: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
163602: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
163603: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
163604:
163605: ELSE null
163606: END object_name
163607: , CASE r

Line 163646: , CST_XLA_RCV_LINES_V l2

163642: ELSE null
163643: END source_value
163644: , null source_meaning
163645: FROM xla_events_gt xet
163646: , CST_XLA_RCV_LINES_V l2
163647: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
163648: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
163649: AND xet.event_class_code = C_EVENT_CLASS_CODE
163650: AND l2.event_id = xet.event_id

Line 163791: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

163787: TYPE t_array_source_34 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
163788: TYPE t_array_source_36 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
163789: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
163790:
163791: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
163792: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
163793: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
163794: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
163795: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 163792: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

163788: TYPE t_array_source_36 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
163789: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
163790:
163791: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
163792: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
163793: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
163794: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
163795: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
163796:

Line 163793: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

163789: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
163790:
163791: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
163792: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
163793: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
163794: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
163795: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
163796:
163797: l_array_source_12 t_array_source_12;

Line 163794: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

163790:
163791: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
163792: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
163793: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
163794: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
163795: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
163796:
163797: l_array_source_12 t_array_source_12;
163798: l_array_source_12_meaning t_array_lookup_meaning;

Line 163795: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

163791: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
163792: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
163793: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
163794: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
163795: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
163796:
163797: l_array_source_12 t_array_source_12;
163798: l_array_source_12_meaning t_array_lookup_meaning;
163799: l_array_source_32 t_array_source_32;

Line 163907: , CST_XLA_RCV_LINES_V l2

163903: , l2.DISTRIBUTION_IDENTIFIER source_11
163904: , l2.ENTERED_AMOUNT source_18
163905: , l2.ACCOUNTED_AMOUNT source_22
163906: FROM xla_events_gt xet
163907: , CST_XLA_RCV_LINES_V l2
163908: WHERE xet.event_id between x_first_event_id and x_last_event_id
163909: and xet.event_date between p_pad_start_date and p_pad_end_date
163910: and xet.event_class_code = C_EVENT_CLASS_CODE
163911: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 171237: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'

171233: FROM (
171234: SELECT xet.event_id event_id
171235: , l2.line_number line_number
171236: , CASE r
171237: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
171238: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
171239: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
171240: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
171241: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'

Line 171238: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'

171234: SELECT xet.event_id event_id
171235: , l2.line_number line_number
171236: , CASE r
171237: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
171238: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
171239: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
171240: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
171241: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
171242:

Line 171239: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'

171235: , l2.line_number line_number
171236: , CASE r
171237: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
171238: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
171239: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
171240: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
171241: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
171242:
171243: ELSE null

Line 171240: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'

171236: , CASE r
171237: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
171238: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
171239: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
171240: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
171241: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
171242:
171243: ELSE null
171244: END object_name

Line 171241: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'

171237: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
171238: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
171239: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
171240: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
171241: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
171242:
171243: ELSE null
171244: END object_name
171245: , CASE r

Line 171284: , CST_XLA_RCV_LINES_V l2

171280: ELSE null
171281: END source_value
171282: , null source_meaning
171283: FROM xla_events_gt xet
171284: , CST_XLA_RCV_LINES_V l2
171285: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
171286: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
171287: AND xet.event_class_code = C_EVENT_CLASS_CODE
171288: AND l2.event_id = xet.event_id

Line 171439: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

171435: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
171436: TYPE t_array_source_23 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
171437: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
171438:
171439: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
171440: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
171441: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
171442: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
171443: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 171440: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

171436: TYPE t_array_source_23 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
171437: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
171438:
171439: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
171440: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
171441: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
171442: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
171443: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
171444:

Line 171441: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

171437: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
171438:
171439: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
171440: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
171441: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
171442: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
171443: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
171444:
171445: l_array_source_6 t_array_source_6;

Line 171442: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

171438:
171439: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
171440: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
171441: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
171442: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
171443: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
171444:
171445: l_array_source_6 t_array_source_6;
171446: l_array_source_7 t_array_source_7;

Line 171443: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

171439: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
171440: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
171441: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
171442: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
171443: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
171444:
171445: l_array_source_6 t_array_source_6;
171446: l_array_source_7 t_array_source_7;
171447: l_array_source_8 t_array_source_8;

Line 171577: , CST_XLA_RCV_LINES_V l2

171573: , l2.DISTRIBUTION_IDENTIFIER source_11
171574: , l2.ENTERED_AMOUNT source_18
171575: , l2.ACCOUNTED_AMOUNT source_22
171576: FROM xla_events_gt xet
171577: , CST_XLA_RCV_LINES_V l2
171578: WHERE xet.event_id between x_first_event_id and x_last_event_id
171579: and xet.event_date between p_pad_start_date and p_pad_end_date
171580: and xet.event_class_code = C_EVENT_CLASS_CODE
171581: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 174141: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'

174137: FROM (
174138: SELECT xet.event_id event_id
174139: , l2.line_number line_number
174140: , CASE r
174141: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
174142: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
174143: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
174144: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
174145: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'

Line 174142: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'

174138: SELECT xet.event_id event_id
174139: , l2.line_number line_number
174140: , CASE r
174141: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
174142: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
174143: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
174144: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
174145: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
174146:

Line 174143: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'

174139: , l2.line_number line_number
174140: , CASE r
174141: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
174142: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
174143: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
174144: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
174145: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
174146:
174147: ELSE null

Line 174144: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'

174140: , CASE r
174141: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
174142: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
174143: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
174144: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
174145: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
174146:
174147: ELSE null
174148: END object_name

Line 174145: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'

174141: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
174142: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
174143: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
174144: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
174145: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
174146:
174147: ELSE null
174148: END object_name
174149: , CASE r

Line 174188: , CST_XLA_RCV_LINES_V l2

174184: ELSE null
174185: END source_value
174186: , null source_meaning
174187: FROM xla_events_gt xet
174188: , CST_XLA_RCV_LINES_V l2
174189: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
174190: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
174191: AND xet.event_class_code = C_EVENT_CLASS_CODE
174192: AND l2.event_id = xet.event_id

Line 174333: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

174329: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
174330: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
174331: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
174332:
174333: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
174334: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
174335: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
174336: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
174337: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 174334: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

174330: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
174331: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
174332:
174333: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
174334: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
174335: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
174336: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
174337: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
174338:

Line 174335: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

174331: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
174332:
174333: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
174334: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
174335: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
174336: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
174337: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
174338:
174339: l_array_source_12 t_array_source_12;

Line 174336: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

174332:
174333: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
174334: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
174335: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
174336: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
174337: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
174338:
174339: l_array_source_12 t_array_source_12;
174340: l_array_source_12_meaning t_array_lookup_meaning;

Line 174337: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

174333: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
174334: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
174335: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
174336: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
174337: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
174338:
174339: l_array_source_12 t_array_source_12;
174340: l_array_source_12_meaning t_array_lookup_meaning;
174341: l_array_source_15 t_array_source_15;

Line 174447: , CST_XLA_RCV_LINES_V l2

174443: , l2.DISTRIBUTION_IDENTIFIER source_11
174444: , l2.ENTERED_AMOUNT source_18
174445: , l2.ACCOUNTED_AMOUNT source_22
174446: FROM xla_events_gt xet
174447: , CST_XLA_RCV_LINES_V l2
174448: WHERE xet.event_id between x_first_event_id and x_last_event_id
174449: and xet.event_date between p_pad_start_date and p_pad_end_date
174450: and xet.event_class_code = C_EVENT_CLASS_CODE
174451: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 176670: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'

176666: FROM (
176667: SELECT xet.event_id event_id
176668: , l2.line_number line_number
176669: , CASE r
176670: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
176671: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
176672: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
176673: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
176674: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'

Line 176671: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'

176667: SELECT xet.event_id event_id
176668: , l2.line_number line_number
176669: , CASE r
176670: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
176671: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
176672: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
176673: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
176674: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
176675:

Line 176672: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'

176668: , l2.line_number line_number
176669: , CASE r
176670: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
176671: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
176672: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
176673: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
176674: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
176675:
176676: ELSE null

Line 176673: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'

176669: , CASE r
176670: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
176671: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
176672: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
176673: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
176674: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
176675:
176676: ELSE null
176677: END object_name

Line 176674: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'

176670: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
176671: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
176672: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
176673: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
176674: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
176675:
176676: ELSE null
176677: END object_name
176678: , CASE r

Line 176717: , CST_XLA_RCV_LINES_V l2

176713: ELSE null
176714: END source_value
176715: , null source_meaning
176716: FROM xla_events_gt xet
176717: , CST_XLA_RCV_LINES_V l2
176718: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
176719: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
176720: AND xet.event_class_code = C_EVENT_CLASS_CODE
176721: AND l2.event_id = xet.event_id

Line 176861: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

176857: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
176858: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
176859: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
176860:
176861: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
176862: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
176863: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
176864: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
176865: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 176862: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

176858: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
176859: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
176860:
176861: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
176862: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
176863: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
176864: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
176865: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
176866:

Line 176863: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

176859: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
176860:
176861: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
176862: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
176863: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
176864: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
176865: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
176866:
176867: l_array_source_12 t_array_source_12;

Line 176864: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

176860:
176861: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
176862: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
176863: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
176864: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
176865: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
176866:
176867: l_array_source_12 t_array_source_12;
176868: l_array_source_12_meaning t_array_lookup_meaning;

Line 176865: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

176861: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
176862: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
176863: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
176864: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
176865: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
176866:
176867: l_array_source_12 t_array_source_12;
176868: l_array_source_12_meaning t_array_lookup_meaning;
176869: l_array_source_15 t_array_source_15;

Line 176973: , CST_XLA_RCV_LINES_V l2

176969: , l2.DISTRIBUTION_IDENTIFIER source_11
176970: , l2.ENTERED_AMOUNT source_18
176971: , l2.ACCOUNTED_AMOUNT source_22
176972: FROM xla_events_gt xet
176973: , CST_XLA_RCV_LINES_V l2
176974: WHERE xet.event_id between x_first_event_id and x_last_event_id
176975: and xet.event_date between p_pad_start_date and p_pad_end_date
176976: and xet.event_class_code = C_EVENT_CLASS_CODE
176977: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 177902: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'

177898: FROM (
177899: SELECT xet.event_id event_id
177900: , l2.line_number line_number
177901: , CASE r
177902: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
177903: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
177904: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
177905: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
177906: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'

Line 177903: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'

177899: SELECT xet.event_id event_id
177900: , l2.line_number line_number
177901: , CASE r
177902: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
177903: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
177904: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
177905: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
177906: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
177907:

Line 177904: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'

177900: , l2.line_number line_number
177901: , CASE r
177902: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
177903: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
177904: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
177905: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
177906: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
177907:
177908: ELSE null

Line 177905: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'

177901: , CASE r
177902: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
177903: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
177904: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
177905: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
177906: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
177907:
177908: ELSE null
177909: END object_name

Line 177906: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'

177902: WHEN 1 THEN 'CST_XLA_RCV_LINES_V'
177903: WHEN 2 THEN 'CST_XLA_RCV_LINES_V'
177904: WHEN 3 THEN 'CST_XLA_RCV_LINES_V'
177905: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
177906: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
177907:
177908: ELSE null
177909: END object_name
177910: , CASE r

Line 177949: , CST_XLA_RCV_LINES_V l2

177945: ELSE null
177946: END source_value
177947: , null source_meaning
177948: FROM xla_events_gt xet
177949: , CST_XLA_RCV_LINES_V l2
177950: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
177951: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
177952: AND xet.event_class_code = C_EVENT_CLASS_CODE
177953: AND l2.event_id = xet.event_id

Line 178094: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

178090: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
178091: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
178092: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
178093:
178094: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
178095: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
178096: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
178097: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
178098: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 178095: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

178091: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
178092: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
178093:
178094: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
178095: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
178096: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
178097: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
178098: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
178099:

Line 178096: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

178092: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
178093:
178094: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
178095: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
178096: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
178097: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
178098: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
178099:
178100: l_array_source_12 t_array_source_12;

Line 178097: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

178093:
178094: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
178095: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
178096: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
178097: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
178098: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
178099:
178100: l_array_source_12 t_array_source_12;
178101: l_array_source_12_meaning t_array_lookup_meaning;

Line 178098: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

178094: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
178095: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
178096: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
178097: TYPE t_array_source_18 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
178098: TYPE t_array_source_22 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
178099:
178100: l_array_source_12 t_array_source_12;
178101: l_array_source_12_meaning t_array_lookup_meaning;
178102: l_array_source_15 t_array_source_15;

Line 178208: , CST_XLA_RCV_LINES_V l2

178204: , l2.DISTRIBUTION_IDENTIFIER source_11
178205: , l2.ENTERED_AMOUNT source_18
178206: , l2.ACCOUNTED_AMOUNT source_22
178207: FROM xla_events_gt xet
178208: , CST_XLA_RCV_LINES_V l2
178209: WHERE xet.event_id between x_first_event_id and x_last_event_id
178210: and xet.event_date between p_pad_start_date and p_pad_end_date
178211: and xet.event_class_code = C_EVENT_CLASS_CODE
178212: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id