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

APPS.XLA_00707_AAD_S_000007_PKG dependencies on CST_XLA_RCV_HEADERS_V

Line 142054: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'

142050: WHEN 2 THEN 'CST_XLA_RCV_REF_V'
142051: WHEN 3 THEN 'CST_XLA_RCV_REF_V'
142052: WHEN 4 THEN 'CST_XLA_RCV_REF_V'
142053: WHEN 5 THEN 'CST_XLA_RCV_REF_V'
142054: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
142055: WHEN 7 THEN 'PO_DISTS_REF_V'
142056: WHEN 8 THEN 'CST_XLA_RCV_REF_V'
142057: WHEN 9 THEN 'CST_XLA_RCV_HEADERS_V'
142058: WHEN 10 THEN 'CST_XLA_RCV_REF_V'

Line 142057: WHEN 9 THEN 'CST_XLA_RCV_HEADERS_V'

142053: WHEN 5 THEN 'CST_XLA_RCV_REF_V'
142054: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
142055: WHEN 7 THEN 'PO_DISTS_REF_V'
142056: WHEN 8 THEN 'CST_XLA_RCV_REF_V'
142057: WHEN 9 THEN 'CST_XLA_RCV_HEADERS_V'
142058: WHEN 10 THEN 'CST_XLA_RCV_REF_V'
142059: WHEN 11 THEN 'CST_XLA_RCV_HEADERS_V'
142060: WHEN 12 THEN 'CST_XLA_RCV_HEADERS_V'
142061: WHEN 13 THEN 'CST_XLA_RCV_HEADERS_V'

Line 142059: WHEN 11 THEN 'CST_XLA_RCV_HEADERS_V'

142055: WHEN 7 THEN 'PO_DISTS_REF_V'
142056: WHEN 8 THEN 'CST_XLA_RCV_REF_V'
142057: WHEN 9 THEN 'CST_XLA_RCV_HEADERS_V'
142058: WHEN 10 THEN 'CST_XLA_RCV_REF_V'
142059: WHEN 11 THEN 'CST_XLA_RCV_HEADERS_V'
142060: WHEN 12 THEN 'CST_XLA_RCV_HEADERS_V'
142061: WHEN 13 THEN 'CST_XLA_RCV_HEADERS_V'
142062: WHEN 14 THEN 'PO_HEADERS_REF_V'
142063: WHEN 15 THEN 'PSA_CST_XLA_UPG_V'

Line 142060: WHEN 12 THEN 'CST_XLA_RCV_HEADERS_V'

142056: WHEN 8 THEN 'CST_XLA_RCV_REF_V'
142057: WHEN 9 THEN 'CST_XLA_RCV_HEADERS_V'
142058: WHEN 10 THEN 'CST_XLA_RCV_REF_V'
142059: WHEN 11 THEN 'CST_XLA_RCV_HEADERS_V'
142060: WHEN 12 THEN 'CST_XLA_RCV_HEADERS_V'
142061: WHEN 13 THEN 'CST_XLA_RCV_HEADERS_V'
142062: WHEN 14 THEN 'PO_HEADERS_REF_V'
142063: WHEN 15 THEN 'PSA_CST_XLA_UPG_V'
142064: WHEN 16 THEN 'CST_XLA_RCV_HEADERS_V'

Line 142061: WHEN 13 THEN 'CST_XLA_RCV_HEADERS_V'

142057: WHEN 9 THEN 'CST_XLA_RCV_HEADERS_V'
142058: WHEN 10 THEN 'CST_XLA_RCV_REF_V'
142059: WHEN 11 THEN 'CST_XLA_RCV_HEADERS_V'
142060: WHEN 12 THEN 'CST_XLA_RCV_HEADERS_V'
142061: WHEN 13 THEN 'CST_XLA_RCV_HEADERS_V'
142062: WHEN 14 THEN 'PO_HEADERS_REF_V'
142063: WHEN 15 THEN 'PSA_CST_XLA_UPG_V'
142064: WHEN 16 THEN 'CST_XLA_RCV_HEADERS_V'
142065:

Line 142064: WHEN 16 THEN 'CST_XLA_RCV_HEADERS_V'

142060: WHEN 12 THEN 'CST_XLA_RCV_HEADERS_V'
142061: WHEN 13 THEN 'CST_XLA_RCV_HEADERS_V'
142062: WHEN 14 THEN 'PO_HEADERS_REF_V'
142063: WHEN 15 THEN 'PSA_CST_XLA_UPG_V'
142064: WHEN 16 THEN 'CST_XLA_RCV_HEADERS_V'
142065:
142066: ELSE null
142067: END object_name
142068: , CASE r

Line 142156: , CST_XLA_RCV_HEADERS_V h1

142152:
142153: ELSE null
142154: END source_meaning
142155: FROM xla_events_gt xet
142156: , CST_XLA_RCV_HEADERS_V h1
142157: , CST_XLA_RCV_REF_V h3
142158: , PO_DISTS_REF_V h4
142159: , PO_HEADERS_REF_V h5
142160: , PSA_CST_XLA_UPG_V h6

Line 142431: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

142427: TYPE t_array_source_7 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
142428: TYPE t_array_source_8 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
142429: TYPE t_array_source_9 IS TABLE OF CST_XLA_RCV_REF_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
142430: TYPE t_array_source_10 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
142431: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
142432: TYPE t_array_source_13 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
142433: TYPE t_array_source_14 IS TABLE OF CST_XLA_RCV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
142434: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
142435: TYPE t_array_source_16 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 142434: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

142430: TYPE t_array_source_10 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
142431: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
142432: TYPE t_array_source_13 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
142433: TYPE t_array_source_14 IS TABLE OF CST_XLA_RCV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
142434: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
142435: TYPE t_array_source_16 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
142436: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
142437: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
142438: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 142436: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

142432: TYPE t_array_source_13 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
142433: TYPE t_array_source_14 IS TABLE OF CST_XLA_RCV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
142434: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
142435: TYPE t_array_source_16 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
142436: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
142437: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
142438: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
142439: TYPE t_array_source_23 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
142440: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;

Line 142437: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

142433: TYPE t_array_source_14 IS TABLE OF CST_XLA_RCV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
142434: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
142435: TYPE t_array_source_16 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
142436: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
142437: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
142438: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
142439: TYPE t_array_source_23 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
142440: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
142441: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 142438: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

142434: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
142435: TYPE t_array_source_16 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
142436: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
142437: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
142438: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
142439: TYPE t_array_source_23 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
142440: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
142441: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
142442:

Line 142441: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

142437: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
142438: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
142439: TYPE t_array_source_23 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
142440: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
142441: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
142442:
142443: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
142444: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
142445: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 142522: , CST_XLA_RCV_HEADERS_V h1

142518: , h6.CST_ENCUM_UPG_OPTION source_27
142519: , h1.TRANSFER_TO_GL_INDICATOR source_38
142520: , fvl38.meaning source_38_meaning
142521: FROM xla_events_gt xet
142522: , CST_XLA_RCV_HEADERS_V h1
142523: , CST_XLA_RCV_REF_V h3
142524: , PO_DISTS_REF_V h4
142525: , PO_HEADERS_REF_V h5
142526: , PSA_CST_XLA_UPG_V h6

Line 157208: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'

157204: FROM (
157205: SELECT xet.event_id event_id
157206: , 0 line_number
157207: , CASE r
157208: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
157209: WHEN 2 THEN 'PO_DISTS_REF_V'
157210: WHEN 3 THEN 'PO_DISTS_REF_V'
157211: WHEN 4 THEN 'PO_DISTS_REF_V'
157212: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'

Line 157212: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'

157208: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
157209: WHEN 2 THEN 'PO_DISTS_REF_V'
157210: WHEN 3 THEN 'PO_DISTS_REF_V'
157211: WHEN 4 THEN 'PO_DISTS_REF_V'
157212: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'
157213:
157214: ELSE null
157215: END object_name
157216: , CASE r

Line 157260: , CST_XLA_RCV_HEADERS_V h1

157256:
157257: ELSE null
157258: END source_meaning
157259: FROM xla_events_gt xet
157260: , CST_XLA_RCV_HEADERS_V h1
157261: , CST_XLA_RCV_REF_V h3
157262: , PO_DISTS_REF_V h4
157263: , fnd_lookup_values fvl12
157264: , fnd_lookup_values fvl38

Line 157528: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

157524: --
157525: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
157526: --
157527:
157528: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
157529: TYPE t_array_source_32 IS TABLE OF PO_DISTS_REF_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
157530: TYPE t_array_source_33 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
157531: TYPE t_array_source_34 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
157532: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 157532: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

157528: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
157529: TYPE t_array_source_32 IS TABLE OF PO_DISTS_REF_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
157530: TYPE t_array_source_33 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
157531: TYPE t_array_source_34 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
157532: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
157533:
157534: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
157535: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
157536: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 157591: , CST_XLA_RCV_HEADERS_V h1

157587: , h4.CURRENCY_CONVERSION_RATE source_34
157588: , h1.TRANSFER_TO_GL_INDICATOR source_38
157589: , fvl38.meaning source_38_meaning
157590: FROM xla_events_gt xet
157591: , CST_XLA_RCV_HEADERS_V h1
157592: , CST_XLA_RCV_REF_V h3
157593: , PO_DISTS_REF_V h4
157594: , fnd_lookup_values fvl12
157595: , fnd_lookup_values fvl38

Line 158467: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'

158463: FROM (
158464: SELECT xet.event_id event_id
158465: , 0 line_number
158466: , CASE r
158467: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
158468: WHEN 2 THEN 'PO_DISTS_REF_V'
158469: WHEN 3 THEN 'PO_DISTS_REF_V'
158470: WHEN 4 THEN 'PO_DISTS_REF_V'
158471: WHEN 5 THEN 'PO_DISTS_REF_V'

Line 158472: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'

158468: WHEN 2 THEN 'PO_DISTS_REF_V'
158469: WHEN 3 THEN 'PO_DISTS_REF_V'
158470: WHEN 4 THEN 'PO_DISTS_REF_V'
158471: WHEN 5 THEN 'PO_DISTS_REF_V'
158472: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
158473:
158474: ELSE null
158475: END object_name
158476: , CASE r

Line 158524: , CST_XLA_RCV_HEADERS_V h1

158520:
158521: ELSE null
158522: END source_meaning
158523: FROM xla_events_gt xet
158524: , CST_XLA_RCV_HEADERS_V h1
158525: , CST_XLA_RCV_REF_V h3
158526: , PO_DISTS_REF_V h4
158527: , fnd_lookup_values fvl12
158528: , fnd_lookup_values fvl38

Line 158792: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

158788: --
158789: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
158790: --
158791:
158792: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
158793: TYPE t_array_source_32 IS TABLE OF PO_DISTS_REF_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
158794: TYPE t_array_source_33 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
158795: TYPE t_array_source_34 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
158796: TYPE t_array_source_36 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 158797: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

158793: TYPE t_array_source_32 IS TABLE OF PO_DISTS_REF_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
158794: TYPE t_array_source_33 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
158795: TYPE t_array_source_34 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
158796: TYPE t_array_source_36 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
158797: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
158798:
158799: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
158800: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
158801: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 158858: , CST_XLA_RCV_HEADERS_V h1

158854: , h4.CURRENCY_CONVERSION_TYPE source_36
158855: , h1.TRANSFER_TO_GL_INDICATOR source_38
158856: , fvl38.meaning source_38_meaning
158857: FROM xla_events_gt xet
158858: , CST_XLA_RCV_HEADERS_V h1
158859: , CST_XLA_RCV_REF_V h3
158860: , PO_DISTS_REF_V h4
158861: , fnd_lookup_values fvl12
158862: , fnd_lookup_values fvl38

Line 163557: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'

163553: WHEN 2 THEN 'CST_XLA_RCV_REF_V'
163554: WHEN 3 THEN 'CST_XLA_RCV_REF_V'
163555: WHEN 4 THEN 'CST_XLA_RCV_REF_V'
163556: WHEN 5 THEN 'CST_XLA_RCV_REF_V'
163557: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
163558: WHEN 7 THEN 'PO_DISTS_REF_V'
163559: WHEN 8 THEN 'CST_XLA_RCV_REF_V'
163560: WHEN 9 THEN 'CST_XLA_RCV_HEADERS_V'
163561: WHEN 10 THEN 'CST_XLA_RCV_REF_V'

Line 163560: WHEN 9 THEN 'CST_XLA_RCV_HEADERS_V'

163556: WHEN 5 THEN 'CST_XLA_RCV_REF_V'
163557: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
163558: WHEN 7 THEN 'PO_DISTS_REF_V'
163559: WHEN 8 THEN 'CST_XLA_RCV_REF_V'
163560: WHEN 9 THEN 'CST_XLA_RCV_HEADERS_V'
163561: WHEN 10 THEN 'CST_XLA_RCV_REF_V'
163562: WHEN 11 THEN 'PSA_CST_XLA_PEA_UPG_V'
163563: WHEN 12 THEN 'CST_XLA_RCV_HEADERS_V'
163564: WHEN 13 THEN 'CST_XLA_RCV_HEADERS_V'

Line 163563: WHEN 12 THEN 'CST_XLA_RCV_HEADERS_V'

163559: WHEN 8 THEN 'CST_XLA_RCV_REF_V'
163560: WHEN 9 THEN 'CST_XLA_RCV_HEADERS_V'
163561: WHEN 10 THEN 'CST_XLA_RCV_REF_V'
163562: WHEN 11 THEN 'PSA_CST_XLA_PEA_UPG_V'
163563: WHEN 12 THEN 'CST_XLA_RCV_HEADERS_V'
163564: WHEN 13 THEN 'CST_XLA_RCV_HEADERS_V'
163565: WHEN 14 THEN 'CST_XLA_RCV_HEADERS_V'
163566: WHEN 15 THEN 'PO_HEADERS_REF_V'
163567: WHEN 16 THEN 'CST_XLA_RCV_HEADERS_V'

Line 163564: WHEN 13 THEN 'CST_XLA_RCV_HEADERS_V'

163560: WHEN 9 THEN 'CST_XLA_RCV_HEADERS_V'
163561: WHEN 10 THEN 'CST_XLA_RCV_REF_V'
163562: WHEN 11 THEN 'PSA_CST_XLA_PEA_UPG_V'
163563: WHEN 12 THEN 'CST_XLA_RCV_HEADERS_V'
163564: WHEN 13 THEN 'CST_XLA_RCV_HEADERS_V'
163565: WHEN 14 THEN 'CST_XLA_RCV_HEADERS_V'
163566: WHEN 15 THEN 'PO_HEADERS_REF_V'
163567: WHEN 16 THEN 'CST_XLA_RCV_HEADERS_V'
163568:

Line 163565: WHEN 14 THEN 'CST_XLA_RCV_HEADERS_V'

163561: WHEN 10 THEN 'CST_XLA_RCV_REF_V'
163562: WHEN 11 THEN 'PSA_CST_XLA_PEA_UPG_V'
163563: WHEN 12 THEN 'CST_XLA_RCV_HEADERS_V'
163564: WHEN 13 THEN 'CST_XLA_RCV_HEADERS_V'
163565: WHEN 14 THEN 'CST_XLA_RCV_HEADERS_V'
163566: WHEN 15 THEN 'PO_HEADERS_REF_V'
163567: WHEN 16 THEN 'CST_XLA_RCV_HEADERS_V'
163568:
163569: ELSE null

Line 163567: WHEN 16 THEN 'CST_XLA_RCV_HEADERS_V'

163563: WHEN 12 THEN 'CST_XLA_RCV_HEADERS_V'
163564: WHEN 13 THEN 'CST_XLA_RCV_HEADERS_V'
163565: WHEN 14 THEN 'CST_XLA_RCV_HEADERS_V'
163566: WHEN 15 THEN 'PO_HEADERS_REF_V'
163567: WHEN 16 THEN 'CST_XLA_RCV_HEADERS_V'
163568:
163569: ELSE null
163570: END object_name
163571: , CASE r

Line 163659: , CST_XLA_RCV_HEADERS_V h1

163655:
163656: ELSE null
163657: END source_meaning
163658: FROM xla_events_gt xet
163659: , CST_XLA_RCV_HEADERS_V h1
163660: , CST_XLA_RCV_REF_V h3
163661: , PO_DISTS_REF_V h4
163662: , PO_HEADERS_REF_V h5
163663: , PSA_CST_XLA_PEA_UPG_V h6

Line 163934: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

163930: TYPE t_array_source_7 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
163931: TYPE t_array_source_8 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
163932: TYPE t_array_source_9 IS TABLE OF CST_XLA_RCV_REF_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
163933: TYPE t_array_source_10 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
163934: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
163935: TYPE t_array_source_13 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
163936: TYPE t_array_source_14 IS TABLE OF CST_XLA_RCV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
163937: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
163938: TYPE t_array_source_16 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 163937: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

163933: TYPE t_array_source_10 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
163934: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
163935: TYPE t_array_source_13 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
163936: TYPE t_array_source_14 IS TABLE OF CST_XLA_RCV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
163937: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
163938: TYPE t_array_source_16 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
163939: TYPE t_array_source_17 IS TABLE OF PSA_CST_XLA_PEA_UPG_V.CST_PEA_ENC_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
163940: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
163941: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 163940: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

163936: TYPE t_array_source_14 IS TABLE OF CST_XLA_RCV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
163937: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
163938: TYPE t_array_source_16 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
163939: TYPE t_array_source_17 IS TABLE OF PSA_CST_XLA_PEA_UPG_V.CST_PEA_ENC_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
163940: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
163941: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
163942: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
163943: TYPE t_array_source_23 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
163944: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 163941: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

163937: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
163938: TYPE t_array_source_16 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
163939: TYPE t_array_source_17 IS TABLE OF PSA_CST_XLA_PEA_UPG_V.CST_PEA_ENC_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
163940: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
163941: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
163942: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
163943: TYPE t_array_source_23 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
163944: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
163945:

Line 163942: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

163938: TYPE t_array_source_16 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
163939: TYPE t_array_source_17 IS TABLE OF PSA_CST_XLA_PEA_UPG_V.CST_PEA_ENC_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
163940: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
163941: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
163942: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
163943: TYPE t_array_source_23 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
163944: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
163945:
163946: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 163944: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

163940: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
163941: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
163942: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
163943: TYPE t_array_source_23 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
163944: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
163945:
163946: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
163947: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
163948: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 164025: , CST_XLA_RCV_HEADERS_V h1

164021: , h5.PURCH_ENCUMBRANCE_TYPE_ID source_23
164022: , h1.TRANSFER_TO_GL_INDICATOR source_38
164023: , fvl38.meaning source_38_meaning
164024: FROM xla_events_gt xet
164025: , CST_XLA_RCV_HEADERS_V h1
164026: , CST_XLA_RCV_REF_V h3
164027: , PO_DISTS_REF_V h4
164028: , PO_HEADERS_REF_V h5
164029: , PSA_CST_XLA_PEA_UPG_V h6

Line 166510: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'

166506: FROM (
166507: SELECT xet.event_id event_id
166508: , 0 line_number
166509: , CASE r
166510: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
166511: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
166512: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
166513: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
166514: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'

Line 166511: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'

166507: SELECT xet.event_id event_id
166508: , 0 line_number
166509: , CASE r
166510: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
166511: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
166512: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
166513: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
166514: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'
166515: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'

Line 166512: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'

166508: , 0 line_number
166509: , CASE r
166510: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
166511: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
166512: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
166513: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
166514: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'
166515: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
166516:

Line 166513: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'

166509: , CASE r
166510: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
166511: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
166512: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
166513: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
166514: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'
166515: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
166516:
166517: ELSE null

Line 166514: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'

166510: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
166511: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
166512: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
166513: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
166514: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'
166515: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
166516:
166517: ELSE null
166518: END object_name

Line 166515: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'

166511: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
166512: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
166513: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
166514: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'
166515: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
166516:
166517: ELSE null
166518: END object_name
166519: , CASE r

Line 166567: , CST_XLA_RCV_HEADERS_V h1

166563:
166564: ELSE null
166565: END source_meaning
166566: FROM xla_events_gt xet
166567: , CST_XLA_RCV_HEADERS_V h1
166568: , fnd_lookup_values fvl12
166569: , fnd_lookup_values fvl38
166570: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
166571: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 166833: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

166829: --
166830: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
166831: --
166832:
166833: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
166834: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
166835: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
166836: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
166837: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 166834: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

166830: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
166831: --
166832:
166833: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
166834: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
166835: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
166836: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
166837: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
166838: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 166835: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

166831: --
166832:
166833: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
166834: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
166835: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
166836: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
166837: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
166838: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
166839:

Line 166836: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

166832:
166833: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
166834: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
166835: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
166836: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
166837: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
166838: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
166839:
166840: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 166837: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

166833: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
166834: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
166835: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
166836: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
166837: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
166838: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
166839:
166840: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
166841: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 166838: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

166834: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
166835: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
166836: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
166837: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
166838: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
166839:
166840: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
166841: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
166842: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 166899: , CST_XLA_RCV_HEADERS_V h1

166895: , h1.CURRENCY_CONVERSION_TYPE source_21
166896: , h1.TRANSFER_TO_GL_INDICATOR source_38
166897: , fvl38.meaning source_38_meaning
166898: FROM xla_events_gt xet
166899: , CST_XLA_RCV_HEADERS_V h1
166900: , fnd_lookup_values fvl12
166901: , fnd_lookup_values fvl38
166902: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
166903: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 167837: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'

167833: FROM (
167834: SELECT xet.event_id event_id
167835: , 0 line_number
167836: , CASE r
167837: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
167838: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
167839: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
167840: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
167841: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'

Line 167838: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'

167834: SELECT xet.event_id event_id
167835: , 0 line_number
167836: , CASE r
167837: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
167838: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
167839: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
167840: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
167841: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'
167842:

Line 167839: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'

167835: , 0 line_number
167836: , CASE r
167837: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
167838: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
167839: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
167840: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
167841: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'
167842:
167843: ELSE null

Line 167840: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'

167836: , CASE r
167837: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
167838: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
167839: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
167840: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
167841: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'
167842:
167843: ELSE null
167844: END object_name

Line 167841: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'

167837: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
167838: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
167839: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
167840: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
167841: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'
167842:
167843: ELSE null
167844: END object_name
167845: , CASE r

Line 167889: , CST_XLA_RCV_HEADERS_V h1

167885:
167886: ELSE null
167887: END source_meaning
167888: FROM xla_events_gt xet
167889: , CST_XLA_RCV_HEADERS_V h1
167890: , fnd_lookup_values fvl12
167891: , fnd_lookup_values fvl38
167892: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
167893: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 168155: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

168151: --
168152: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
168153: --
168154:
168155: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
168156: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
168157: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
168158: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
168159: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 168156: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

168152: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
168153: --
168154:
168155: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
168156: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
168157: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
168158: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
168159: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
168160:

Line 168157: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

168153: --
168154:
168155: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
168156: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
168157: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
168158: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
168159: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
168160:
168161: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 168158: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

168154:
168155: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
168156: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
168157: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
168158: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
168159: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
168160:
168161: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
168162: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 168159: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

168155: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
168156: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
168157: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
168158: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
168159: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
168160:
168161: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
168162: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
168163: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 168218: , CST_XLA_RCV_HEADERS_V h1

168214: , h1.CURRENCY_CONVERSION_RATE source_20
168215: , h1.TRANSFER_TO_GL_INDICATOR source_38
168216: , fvl38.meaning source_38_meaning
168217: FROM xla_events_gt xet
168218: , CST_XLA_RCV_HEADERS_V h1
168219: , fnd_lookup_values fvl12
168220: , fnd_lookup_values fvl38
168221: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
168222: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 169064: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'

169060: FROM (
169061: SELECT xet.event_id event_id
169062: , 0 line_number
169063: , CASE r
169064: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
169065: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
169066: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
169067: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
169068: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'

Line 169065: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'

169061: SELECT xet.event_id event_id
169062: , 0 line_number
169063: , CASE r
169064: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
169065: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
169066: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
169067: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
169068: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'
169069: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'

Line 169066: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'

169062: , 0 line_number
169063: , CASE r
169064: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
169065: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
169066: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
169067: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
169068: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'
169069: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
169070:

Line 169067: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'

169063: , CASE r
169064: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
169065: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
169066: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
169067: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
169068: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'
169069: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
169070:
169071: ELSE null

Line 169068: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'

169064: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
169065: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
169066: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
169067: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
169068: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'
169069: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
169070:
169071: ELSE null
169072: END object_name

Line 169069: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'

169065: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
169066: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
169067: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
169068: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'
169069: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
169070:
169071: ELSE null
169072: END object_name
169073: , CASE r

Line 169121: , CST_XLA_RCV_HEADERS_V h1

169117:
169118: ELSE null
169119: END source_meaning
169120: FROM xla_events_gt xet
169121: , CST_XLA_RCV_HEADERS_V h1
169122: , fnd_lookup_values fvl12
169123: , fnd_lookup_values fvl38
169124: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
169125: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 169387: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

169383: --
169384: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
169385: --
169386:
169387: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
169388: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
169389: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
169390: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
169391: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 169388: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

169384: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
169385: --
169386:
169387: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
169388: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
169389: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
169390: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
169391: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
169392: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 169389: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

169385: --
169386:
169387: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
169388: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
169389: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
169390: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
169391: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
169392: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
169393:

Line 169390: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

169386:
169387: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
169388: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
169389: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
169390: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
169391: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
169392: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
169393:
169394: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 169391: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

169387: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
169388: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
169389: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
169390: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
169391: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
169392: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
169393:
169394: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
169395: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 169392: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

169388: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
169389: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
169390: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
169391: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
169392: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
169393:
169394: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
169395: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
169396: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 169453: , CST_XLA_RCV_HEADERS_V h1

169449: , h1.CURRENCY_CONVERSION_TYPE source_21
169450: , h1.TRANSFER_TO_GL_INDICATOR source_38
169451: , fvl38.meaning source_38_meaning
169452: FROM xla_events_gt xet
169453: , CST_XLA_RCV_HEADERS_V h1
169454: , fnd_lookup_values fvl12
169455: , fnd_lookup_values fvl38
169456: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
169457: and xet.event_class_code = C_EVENT_CLASS_CODE