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_000005_BC_PKG dependencies on CST_XLA_INV_LINES_V

Line 7453: WHEN 1 THEN 'CST_XLA_INV_LINES_V'

7449: FROM (
7450: SELECT xet.event_id event_id
7451: , l2.line_number line_number
7452: , CASE r
7453: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
7454: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
7455:
7456: ELSE null
7457: END object_name

Line 7454: WHEN 2 THEN 'CST_XLA_INV_LINES_V'

7450: SELECT xet.event_id event_id
7451: , l2.line_number line_number
7452: , CASE r
7453: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
7454: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
7455:
7456: ELSE null
7457: END object_name
7458: , CASE r

Line 7485: , CST_XLA_INV_LINES_V l2

7481: ELSE null
7482: END source_value
7483: , null source_meaning
7484: FROM xla_events_gt xet
7485: , CST_XLA_INV_LINES_V l2
7486: , (select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
7487: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
7488: AND xet.event_class_code = C_EVENT_CLASS_CODE
7489: AND l2.event_id = xet.event_id

Line 7639: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

7635: TYPE t_array_source_34 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
7636: TYPE t_array_source_35 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
7637: TYPE t_array_source_37 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
7638:
7639: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
7640: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
7641:
7642: l_array_source_4 t_array_source_4;
7643: l_array_source_7 t_array_source_7;

Line 7640: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

7636: TYPE t_array_source_35 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
7637: TYPE t_array_source_37 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
7638:
7639: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
7640: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
7641:
7642: l_array_source_4 t_array_source_4;
7643: l_array_source_7 t_array_source_7;
7644: l_array_source_13 t_array_source_13;

Line 7767: , CST_XLA_INV_LINES_V l2

7763: , l2.LINE_NUMBER
7764: , l2.DISTRIBUTION_IDENTIFIER source_12
7765: , l2.CURRENCY_CODE source_16
7766: FROM xla_events_gt xet
7767: , CST_XLA_INV_LINES_V l2
7768: WHERE xet.event_id between x_first_event_id and x_last_event_id
7769: and xet.event_date between p_pad_start_date and p_pad_end_date
7770: and xet.event_class_code = C_EVENT_CLASS_CODE
7771: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 8716: WHEN 1 THEN 'CST_XLA_INV_LINES_V'

8712: FROM (
8713: SELECT xet.event_id event_id
8714: , l2.line_number line_number
8715: , CASE r
8716: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
8717: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
8718: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
8719:
8720: ELSE null

Line 8717: WHEN 2 THEN 'CST_XLA_INV_LINES_V'

8713: SELECT xet.event_id event_id
8714: , l2.line_number line_number
8715: , CASE r
8716: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
8717: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
8718: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
8719:
8720: ELSE null
8721: END object_name

Line 8718: WHEN 3 THEN 'CST_XLA_INV_LINES_V'

8714: , l2.line_number line_number
8715: , CASE r
8716: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
8717: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
8718: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
8719:
8720: ELSE null
8721: END object_name
8722: , CASE r

Line 8753: , CST_XLA_INV_LINES_V l2

8749: ELSE null
8750: END source_value
8751: , null source_meaning
8752: FROM xla_events_gt xet
8753: , CST_XLA_INV_LINES_V l2
8754: , (select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
8755: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
8756: AND xet.event_class_code = C_EVENT_CLASS_CODE
8757: AND l2.event_id = xet.event_id

Line 8907: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

8903: TYPE t_array_source_34 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
8904: TYPE t_array_source_35 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
8905: TYPE t_array_source_37 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
8906:
8907: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
8908: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
8909: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
8910:
8911: l_array_source_4 t_array_source_4;

Line 8908: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

8904: TYPE t_array_source_35 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
8905: TYPE t_array_source_37 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
8906:
8907: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
8908: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
8909: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
8910:
8911: l_array_source_4 t_array_source_4;
8912: l_array_source_7 t_array_source_7;

Line 8909: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

8905: TYPE t_array_source_37 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
8906:
8907: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
8908: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
8909: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
8910:
8911: l_array_source_4 t_array_source_4;
8912: l_array_source_7 t_array_source_7;
8913: l_array_source_13 t_array_source_13;

Line 9038: , CST_XLA_INV_LINES_V l2

9034: , l2.ACCOUNTING_LINE_TYPE_CODE source_6
9035: , l2.DISTRIBUTION_IDENTIFIER source_12
9036: , l2.CURRENCY_CODE source_16
9037: FROM xla_events_gt xet
9038: , CST_XLA_INV_LINES_V l2
9039: WHERE xet.event_id between x_first_event_id and x_last_event_id
9040: and xet.event_date between p_pad_start_date and p_pad_end_date
9041: and xet.event_class_code = C_EVENT_CLASS_CODE
9042: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 9919: WHEN 1 THEN 'CST_XLA_INV_LINES_V'

9915: FROM (
9916: SELECT xet.event_id event_id
9917: , l2.line_number line_number
9918: , CASE r
9919: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
9920: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
9921: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
9922: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
9923: WHEN 5 THEN 'CST_XLA_INV_LINES_V'

Line 9920: WHEN 2 THEN 'CST_XLA_INV_LINES_V'

9916: SELECT xet.event_id event_id
9917: , l2.line_number line_number
9918: , CASE r
9919: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
9920: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
9921: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
9922: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
9923: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
9924: WHEN 6 THEN 'CST_XLA_INV_LINES_V'

Line 9921: WHEN 3 THEN 'CST_XLA_INV_LINES_V'

9917: , l2.line_number line_number
9918: , CASE r
9919: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
9920: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
9921: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
9922: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
9923: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
9924: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
9925: WHEN 7 THEN 'CST_XLA_INV_LINES_V'

Line 9922: WHEN 4 THEN 'CST_XLA_INV_LINES_V'

9918: , CASE r
9919: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
9920: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
9921: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
9922: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
9923: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
9924: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
9925: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
9926: WHEN 8 THEN 'CST_XLA_INV_LINES_V'

Line 9923: WHEN 5 THEN 'CST_XLA_INV_LINES_V'

9919: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
9920: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
9921: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
9922: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
9923: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
9924: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
9925: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
9926: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
9927: WHEN 9 THEN 'CST_XLA_INV_LINES_V'

Line 9924: WHEN 6 THEN 'CST_XLA_INV_LINES_V'

9920: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
9921: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
9922: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
9923: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
9924: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
9925: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
9926: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
9927: WHEN 9 THEN 'CST_XLA_INV_LINES_V'
9928:

Line 9925: WHEN 7 THEN 'CST_XLA_INV_LINES_V'

9921: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
9922: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
9923: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
9924: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
9925: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
9926: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
9927: WHEN 9 THEN 'CST_XLA_INV_LINES_V'
9928:
9929: ELSE null

Line 9926: WHEN 8 THEN 'CST_XLA_INV_LINES_V'

9922: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
9923: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
9924: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
9925: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
9926: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
9927: WHEN 9 THEN 'CST_XLA_INV_LINES_V'
9928:
9929: ELSE null
9930: END object_name

Line 9927: WHEN 9 THEN 'CST_XLA_INV_LINES_V'

9923: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
9924: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
9925: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
9926: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
9927: WHEN 9 THEN 'CST_XLA_INV_LINES_V'
9928:
9929: ELSE null
9930: END object_name
9931: , CASE r

Line 9986: , CST_XLA_INV_LINES_V l2

9982: ELSE null
9983: END source_value
9984: , null source_meaning
9985: FROM xla_events_gt xet
9986: , CST_XLA_INV_LINES_V l2
9987: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
9988: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
9989: AND xet.event_class_code = C_EVENT_CLASS_CODE
9990: AND l2.event_id = xet.event_id

Line 10127: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

10123:
10124: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
10125: TYPE t_array_source_37 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
10126:
10127: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
10128: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
10129: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
10130: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
10131: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 10128: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

10124: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
10125: TYPE t_array_source_37 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
10126:
10127: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
10128: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
10129: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
10130: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
10131: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10132: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 10129: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

10125: TYPE t_array_source_37 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
10126:
10127: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
10128: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
10129: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
10130: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
10131: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10132: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
10133: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 10130: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

10126:
10127: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
10128: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
10129: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
10130: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
10131: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10132: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
10133: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
10134: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 10131: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

10127: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
10128: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
10129: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
10130: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
10131: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10132: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
10133: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
10134: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
10135: TYPE t_array_source_24 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 10132: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

10128: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
10129: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
10130: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
10131: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10132: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
10133: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
10134: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
10135: TYPE t_array_source_24 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10136:

Line 10133: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

10129: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
10130: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
10131: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10132: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
10133: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
10134: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
10135: TYPE t_array_source_24 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10136:
10137: l_array_source_13 t_array_source_13;

Line 10134: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

10130: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
10131: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10132: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
10133: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
10134: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
10135: TYPE t_array_source_24 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10136:
10137: l_array_source_13 t_array_source_13;
10138: l_array_source_13_meaning t_array_lookup_meaning;

Line 10135: TYPE t_array_source_24 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

10131: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10132: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
10133: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
10134: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
10135: TYPE t_array_source_24 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10136:
10137: l_array_source_13 t_array_source_13;
10138: l_array_source_13_meaning t_array_lookup_meaning;
10139: l_array_source_37 t_array_source_37;

Line 10245: , CST_XLA_INV_LINES_V l2

10241: , l2.CURRENCY_CONVERSION_RATE source_22
10242: , l2.CURRENCY_CONVERSION_TYPE source_23
10243: , l2.ACCOUNTED_AMOUNT source_24
10244: FROM xla_events_gt xet
10245: , CST_XLA_INV_LINES_V l2
10246: WHERE xet.event_id between x_first_event_id and x_last_event_id
10247: and xet.event_date between p_pad_start_date and p_pad_end_date
10248: and xet.event_class_code = C_EVENT_CLASS_CODE
10249: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 11097: WHEN 1 THEN 'CST_XLA_INV_LINES_V'

11093: FROM (
11094: SELECT xet.event_id event_id
11095: , l2.line_number line_number
11096: , CASE r
11097: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
11098: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
11099: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
11100: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
11101: WHEN 5 THEN 'CST_XLA_INV_LINES_V'

Line 11098: WHEN 2 THEN 'CST_XLA_INV_LINES_V'

11094: SELECT xet.event_id event_id
11095: , l2.line_number line_number
11096: , CASE r
11097: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
11098: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
11099: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
11100: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
11101: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
11102: WHEN 6 THEN 'CST_XLA_INV_LINES_V'

Line 11099: WHEN 3 THEN 'CST_XLA_INV_LINES_V'

11095: , l2.line_number line_number
11096: , CASE r
11097: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
11098: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
11099: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
11100: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
11101: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
11102: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
11103: WHEN 7 THEN 'CST_XLA_INV_LINES_V'

Line 11100: WHEN 4 THEN 'CST_XLA_INV_LINES_V'

11096: , CASE r
11097: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
11098: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
11099: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
11100: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
11101: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
11102: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
11103: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
11104: WHEN 8 THEN 'CST_XLA_INV_LINES_V'

Line 11101: WHEN 5 THEN 'CST_XLA_INV_LINES_V'

11097: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
11098: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
11099: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
11100: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
11101: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
11102: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
11103: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
11104: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
11105: WHEN 9 THEN 'CST_XLA_INV_LINES_V'

Line 11102: WHEN 6 THEN 'CST_XLA_INV_LINES_V'

11098: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
11099: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
11100: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
11101: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
11102: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
11103: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
11104: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
11105: WHEN 9 THEN 'CST_XLA_INV_LINES_V'
11106:

Line 11103: WHEN 7 THEN 'CST_XLA_INV_LINES_V'

11099: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
11100: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
11101: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
11102: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
11103: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
11104: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
11105: WHEN 9 THEN 'CST_XLA_INV_LINES_V'
11106:
11107: ELSE null

Line 11104: WHEN 8 THEN 'CST_XLA_INV_LINES_V'

11100: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
11101: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
11102: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
11103: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
11104: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
11105: WHEN 9 THEN 'CST_XLA_INV_LINES_V'
11106:
11107: ELSE null
11108: END object_name

Line 11105: WHEN 9 THEN 'CST_XLA_INV_LINES_V'

11101: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
11102: WHEN 6 THEN 'CST_XLA_INV_LINES_V'
11103: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
11104: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
11105: WHEN 9 THEN 'CST_XLA_INV_LINES_V'
11106:
11107: ELSE null
11108: END object_name
11109: , CASE r

Line 11164: , CST_XLA_INV_LINES_V l2

11160: ELSE null
11161: END source_value
11162: , null source_meaning
11163: FROM xla_events_gt xet
11164: , CST_XLA_INV_LINES_V l2
11165: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
11166: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
11167: AND xet.event_class_code = C_EVENT_CLASS_CODE
11168: AND l2.event_id = xet.event_id

Line 11305: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

11301:
11302: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
11303: TYPE t_array_source_37 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
11304:
11305: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
11306: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
11307: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
11308: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
11309: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 11306: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

11302: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
11303: TYPE t_array_source_37 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
11304:
11305: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
11306: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
11307: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
11308: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
11309: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
11310: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 11307: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

11303: TYPE t_array_source_37 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
11304:
11305: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
11306: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
11307: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
11308: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
11309: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
11310: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
11311: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 11308: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

11304:
11305: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
11306: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
11307: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
11308: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
11309: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
11310: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
11311: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
11312: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 11309: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

11305: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
11306: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
11307: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
11308: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
11309: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
11310: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
11311: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
11312: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
11313: TYPE t_array_source_24 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 11310: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

11306: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
11307: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
11308: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
11309: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
11310: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
11311: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
11312: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
11313: TYPE t_array_source_24 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
11314:

Line 11311: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

11307: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
11308: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
11309: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
11310: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
11311: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
11312: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
11313: TYPE t_array_source_24 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
11314:
11315: l_array_source_13 t_array_source_13;

Line 11312: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

11308: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
11309: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
11310: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
11311: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
11312: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
11313: TYPE t_array_source_24 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
11314:
11315: l_array_source_13 t_array_source_13;
11316: l_array_source_13_meaning t_array_lookup_meaning;

Line 11313: TYPE t_array_source_24 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

11309: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
11310: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
11311: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
11312: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
11313: TYPE t_array_source_24 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
11314:
11315: l_array_source_13 t_array_source_13;
11316: l_array_source_13_meaning t_array_lookup_meaning;
11317: l_array_source_37 t_array_source_37;

Line 11423: , CST_XLA_INV_LINES_V l2

11419: , l2.CURRENCY_CONVERSION_RATE source_22
11420: , l2.CURRENCY_CONVERSION_TYPE source_23
11421: , l2.ACCOUNTED_AMOUNT source_24
11422: FROM xla_events_gt xet
11423: , CST_XLA_INV_LINES_V l2
11424: WHERE xet.event_id between x_first_event_id and x_last_event_id
11425: and xet.event_date between p_pad_start_date and p_pad_end_date
11426: and xet.event_class_code = C_EVENT_CLASS_CODE
11427: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 13641: WHEN 1 THEN 'CST_XLA_INV_LINES_V'

13637: FROM (
13638: SELECT xet.event_id event_id
13639: , l2.line_number line_number
13640: , CASE r
13641: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
13642: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
13643: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
13644:
13645: ELSE null

Line 13642: WHEN 2 THEN 'CST_XLA_INV_LINES_V'

13638: SELECT xet.event_id event_id
13639: , l2.line_number line_number
13640: , CASE r
13641: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
13642: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
13643: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
13644:
13645: ELSE null
13646: END object_name

Line 13643: WHEN 3 THEN 'CST_XLA_INV_LINES_V'

13639: , l2.line_number line_number
13640: , CASE r
13641: WHEN 1 THEN 'CST_XLA_INV_LINES_V'
13642: WHEN 2 THEN 'CST_XLA_INV_LINES_V'
13643: WHEN 3 THEN 'CST_XLA_INV_LINES_V'
13644:
13645: ELSE null
13646: END object_name
13647: , CASE r

Line 13678: , CST_XLA_INV_LINES_V l2

13674: ELSE null
13675: END source_value
13676: , null source_meaning
13677: FROM xla_events_gt xet
13678: , CST_XLA_INV_LINES_V l2
13679: , (select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
13680: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
13681: AND xet.event_class_code = C_EVENT_CLASS_CODE
13682: AND l2.event_id = xet.event_id

Line 13832: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

13828: TYPE t_array_source_18 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
13829: TYPE t_array_source_19 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
13830: TYPE t_array_source_37 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
13831:
13832: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
13833: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
13834: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
13835:
13836: l_array_source_2 t_array_source_2;

Line 13833: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

13829: TYPE t_array_source_19 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
13830: TYPE t_array_source_37 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
13831:
13832: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
13833: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
13834: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
13835:
13836: l_array_source_2 t_array_source_2;
13837: l_array_source_3 t_array_source_3;

Line 13834: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

13830: TYPE t_array_source_37 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
13831:
13832: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
13833: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
13834: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
13835:
13836: l_array_source_2 t_array_source_2;
13837: l_array_source_3 t_array_source_3;
13838: l_array_source_4 t_array_source_4;

Line 13963: , CST_XLA_INV_LINES_V l2

13959: , l2.ACCOUNTING_LINE_TYPE_CODE source_6
13960: , l2.DISTRIBUTION_IDENTIFIER source_12
13961: , l2.CURRENCY_CODE source_16
13962: FROM xla_events_gt xet
13963: , CST_XLA_INV_LINES_V l2
13964: WHERE xet.event_id between x_first_event_id and x_last_event_id
13965: and xet.event_date between p_pad_start_date and p_pad_end_date
13966: and xet.event_class_code = C_EVENT_CLASS_CODE
13967: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id