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_000019_PKG dependencies on CST_XLA_RCV_HEADERS_V

Line 313647: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'

313643: WHEN 2 THEN 'CST_XLA_RCV_REF_V'
313644: WHEN 3 THEN 'CST_XLA_RCV_REF_V'
313645: WHEN 4 THEN 'CST_XLA_RCV_REF_V'
313646: WHEN 5 THEN 'CST_XLA_RCV_REF_V'
313647: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
313648: WHEN 7 THEN 'PO_DISTS_REF_V'
313649: WHEN 8 THEN 'CST_XLA_RCV_REF_V'
313650: WHEN 9 THEN 'CST_XLA_RCV_HEADERS_V'
313651: WHEN 10 THEN 'CST_XLA_RCV_REF_V'

Line 313650: WHEN 9 THEN 'CST_XLA_RCV_HEADERS_V'

313646: WHEN 5 THEN 'CST_XLA_RCV_REF_V'
313647: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
313648: WHEN 7 THEN 'PO_DISTS_REF_V'
313649: WHEN 8 THEN 'CST_XLA_RCV_REF_V'
313650: WHEN 9 THEN 'CST_XLA_RCV_HEADERS_V'
313651: WHEN 10 THEN 'CST_XLA_RCV_REF_V'
313652: WHEN 11 THEN 'CST_XLA_RCV_HEADERS_V'
313653: WHEN 12 THEN 'CST_XLA_RCV_HEADERS_V'
313654: WHEN 13 THEN 'CST_XLA_RCV_HEADERS_V'

Line 313652: WHEN 11 THEN 'CST_XLA_RCV_HEADERS_V'

313648: WHEN 7 THEN 'PO_DISTS_REF_V'
313649: WHEN 8 THEN 'CST_XLA_RCV_REF_V'
313650: WHEN 9 THEN 'CST_XLA_RCV_HEADERS_V'
313651: WHEN 10 THEN 'CST_XLA_RCV_REF_V'
313652: WHEN 11 THEN 'CST_XLA_RCV_HEADERS_V'
313653: WHEN 12 THEN 'CST_XLA_RCV_HEADERS_V'
313654: WHEN 13 THEN 'CST_XLA_RCV_HEADERS_V'
313655: WHEN 14 THEN 'PO_HEADERS_REF_V'
313656: WHEN 15 THEN 'PSA_CST_XLA_UPG_V'

Line 313653: WHEN 12 THEN 'CST_XLA_RCV_HEADERS_V'

313649: WHEN 8 THEN 'CST_XLA_RCV_REF_V'
313650: WHEN 9 THEN 'CST_XLA_RCV_HEADERS_V'
313651: WHEN 10 THEN 'CST_XLA_RCV_REF_V'
313652: WHEN 11 THEN 'CST_XLA_RCV_HEADERS_V'
313653: WHEN 12 THEN 'CST_XLA_RCV_HEADERS_V'
313654: WHEN 13 THEN 'CST_XLA_RCV_HEADERS_V'
313655: WHEN 14 THEN 'PO_HEADERS_REF_V'
313656: WHEN 15 THEN 'PSA_CST_XLA_UPG_V'
313657: WHEN 16 THEN 'CST_XLA_RCV_HEADERS_V'

Line 313654: WHEN 13 THEN 'CST_XLA_RCV_HEADERS_V'

313650: WHEN 9 THEN 'CST_XLA_RCV_HEADERS_V'
313651: WHEN 10 THEN 'CST_XLA_RCV_REF_V'
313652: WHEN 11 THEN 'CST_XLA_RCV_HEADERS_V'
313653: WHEN 12 THEN 'CST_XLA_RCV_HEADERS_V'
313654: WHEN 13 THEN 'CST_XLA_RCV_HEADERS_V'
313655: WHEN 14 THEN 'PO_HEADERS_REF_V'
313656: WHEN 15 THEN 'PSA_CST_XLA_UPG_V'
313657: WHEN 16 THEN 'CST_XLA_RCV_HEADERS_V'
313658:

Line 313657: WHEN 16 THEN 'CST_XLA_RCV_HEADERS_V'

313653: WHEN 12 THEN 'CST_XLA_RCV_HEADERS_V'
313654: WHEN 13 THEN 'CST_XLA_RCV_HEADERS_V'
313655: WHEN 14 THEN 'PO_HEADERS_REF_V'
313656: WHEN 15 THEN 'PSA_CST_XLA_UPG_V'
313657: WHEN 16 THEN 'CST_XLA_RCV_HEADERS_V'
313658:
313659: ELSE null
313660: END object_name
313661: , CASE r

Line 313749: , CST_XLA_RCV_HEADERS_V h1

313745:
313746: ELSE null
313747: END source_meaning
313748: FROM xla_events_gt xet
313749: , CST_XLA_RCV_HEADERS_V h1
313750: , CST_XLA_RCV_REF_V h3
313751: , PO_DISTS_REF_V h4
313752: , PO_HEADERS_REF_V h5
313753: , PSA_CST_XLA_UPG_V h6

Line 314024: TYPE t_array_source_85 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

314020: TYPE t_array_source_80 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
314021: TYPE t_array_source_81 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
314022: TYPE t_array_source_82 IS TABLE OF CST_XLA_RCV_REF_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
314023: TYPE t_array_source_83 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
314024: TYPE t_array_source_85 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
314025: TYPE t_array_source_86 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
314026: TYPE t_array_source_87 IS TABLE OF CST_XLA_RCV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
314027: TYPE t_array_source_88 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
314028: TYPE t_array_source_89 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 314027: TYPE t_array_source_88 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

314023: TYPE t_array_source_83 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
314024: TYPE t_array_source_85 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
314025: TYPE t_array_source_86 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
314026: TYPE t_array_source_87 IS TABLE OF CST_XLA_RCV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
314027: TYPE t_array_source_88 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
314028: TYPE t_array_source_89 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
314029: TYPE t_array_source_92 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
314030: TYPE t_array_source_93 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
314031: TYPE t_array_source_94 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 314029: TYPE t_array_source_92 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

314025: TYPE t_array_source_86 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
314026: TYPE t_array_source_87 IS TABLE OF CST_XLA_RCV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
314027: TYPE t_array_source_88 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
314028: TYPE t_array_source_89 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
314029: TYPE t_array_source_92 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
314030: TYPE t_array_source_93 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
314031: TYPE t_array_source_94 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
314032: TYPE t_array_source_96 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
314033: TYPE t_array_source_100 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;

Line 314030: TYPE t_array_source_93 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

314026: TYPE t_array_source_87 IS TABLE OF CST_XLA_RCV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
314027: TYPE t_array_source_88 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
314028: TYPE t_array_source_89 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
314029: TYPE t_array_source_92 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
314030: TYPE t_array_source_93 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
314031: TYPE t_array_source_94 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
314032: TYPE t_array_source_96 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
314033: TYPE t_array_source_100 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
314034: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 314031: TYPE t_array_source_94 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

314027: TYPE t_array_source_88 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
314028: TYPE t_array_source_89 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
314029: TYPE t_array_source_92 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
314030: TYPE t_array_source_93 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
314031: TYPE t_array_source_94 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
314032: TYPE t_array_source_96 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
314033: TYPE t_array_source_100 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
314034: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
314035:

Line 314034: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

314030: TYPE t_array_source_93 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
314031: TYPE t_array_source_94 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
314032: TYPE t_array_source_96 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
314033: TYPE t_array_source_100 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
314034: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
314035:
314036: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
314037: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
314038: TYPE t_array_source_84 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 314115: , CST_XLA_RCV_HEADERS_V h1

314111: , h6.CST_ENCUM_UPG_OPTION source_100
314112: , h1.TRANSFER_TO_GL_INDICATOR source_114
314113: , fvl114.meaning source_114_meaning
314114: FROM xla_events_gt xet
314115: , CST_XLA_RCV_HEADERS_V h1
314116: , CST_XLA_RCV_REF_V h3
314117: , PO_DISTS_REF_V h4
314118: , PO_HEADERS_REF_V h5
314119: , PSA_CST_XLA_UPG_V h6

Line 349233: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'

349229: FROM (
349230: SELECT xet.event_id event_id
349231: , 0 line_number
349232: , CASE r
349233: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
349234: WHEN 2 THEN 'PO_DISTS_REF_V'
349235: WHEN 3 THEN 'PO_DISTS_REF_V'
349236: WHEN 4 THEN 'PO_DISTS_REF_V'
349237: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'

Line 349237: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'

349233: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
349234: WHEN 2 THEN 'PO_DISTS_REF_V'
349235: WHEN 3 THEN 'PO_DISTS_REF_V'
349236: WHEN 4 THEN 'PO_DISTS_REF_V'
349237: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'
349238:
349239: ELSE null
349240: END object_name
349241: , CASE r

Line 349285: , CST_XLA_RCV_HEADERS_V h1

349281:
349282: ELSE null
349283: END source_meaning
349284: FROM xla_events_gt xet
349285: , CST_XLA_RCV_HEADERS_V h1
349286: , CST_XLA_RCV_REF_V h3
349287: , PO_DISTS_REF_V h4
349288: , fnd_lookup_values fvl85
349289: , fnd_lookup_values fvl114

Line 349553: TYPE t_array_source_85 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

349549: --
349550: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
349551: --
349552:
349553: TYPE t_array_source_85 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
349554: TYPE t_array_source_105 IS TABLE OF PO_DISTS_REF_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
349555: TYPE t_array_source_106 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
349556: TYPE t_array_source_107 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
349557: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 349557: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

349553: TYPE t_array_source_85 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
349554: TYPE t_array_source_105 IS TABLE OF PO_DISTS_REF_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
349555: TYPE t_array_source_106 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
349556: TYPE t_array_source_107 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
349557: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
349558:
349559: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
349560: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
349561: TYPE t_array_source_84 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 349616: , CST_XLA_RCV_HEADERS_V h1

349612: , h4.CURRENCY_CONVERSION_RATE source_107
349613: , h1.TRANSFER_TO_GL_INDICATOR source_114
349614: , fvl114.meaning source_114_meaning
349615: FROM xla_events_gt xet
349616: , CST_XLA_RCV_HEADERS_V h1
349617: , CST_XLA_RCV_REF_V h3
349618: , PO_DISTS_REF_V h4
349619: , fnd_lookup_values fvl85
349620: , fnd_lookup_values fvl114

Line 350492: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'

350488: FROM (
350489: SELECT xet.event_id event_id
350490: , 0 line_number
350491: , CASE r
350492: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
350493: WHEN 2 THEN 'PO_DISTS_REF_V'
350494: WHEN 3 THEN 'PO_DISTS_REF_V'
350495: WHEN 4 THEN 'PO_DISTS_REF_V'
350496: WHEN 5 THEN 'PO_DISTS_REF_V'

Line 350497: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'

350493: WHEN 2 THEN 'PO_DISTS_REF_V'
350494: WHEN 3 THEN 'PO_DISTS_REF_V'
350495: WHEN 4 THEN 'PO_DISTS_REF_V'
350496: WHEN 5 THEN 'PO_DISTS_REF_V'
350497: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
350498:
350499: ELSE null
350500: END object_name
350501: , CASE r

Line 350549: , CST_XLA_RCV_HEADERS_V h1

350545:
350546: ELSE null
350547: END source_meaning
350548: FROM xla_events_gt xet
350549: , CST_XLA_RCV_HEADERS_V h1
350550: , CST_XLA_RCV_REF_V h3
350551: , PO_DISTS_REF_V h4
350552: , fnd_lookup_values fvl85
350553: , fnd_lookup_values fvl114

Line 350817: TYPE t_array_source_85 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

350813: --
350814: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
350815: --
350816:
350817: TYPE t_array_source_85 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
350818: TYPE t_array_source_105 IS TABLE OF PO_DISTS_REF_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
350819: TYPE t_array_source_106 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
350820: TYPE t_array_source_107 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
350821: TYPE t_array_source_109 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 350822: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

350818: TYPE t_array_source_105 IS TABLE OF PO_DISTS_REF_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
350819: TYPE t_array_source_106 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
350820: TYPE t_array_source_107 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
350821: TYPE t_array_source_109 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
350822: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
350823:
350824: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
350825: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
350826: TYPE t_array_source_84 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 350883: , CST_XLA_RCV_HEADERS_V h1

350879: , h4.CURRENCY_CONVERSION_TYPE source_109
350880: , h1.TRANSFER_TO_GL_INDICATOR source_114
350881: , fvl114.meaning source_114_meaning
350882: FROM xla_events_gt xet
350883: , CST_XLA_RCV_HEADERS_V h1
350884: , CST_XLA_RCV_REF_V h3
350885: , PO_DISTS_REF_V h4
350886: , fnd_lookup_values fvl85
350887: , fnd_lookup_values fvl114

Line 370418: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'

370414: WHEN 2 THEN 'CST_XLA_RCV_REF_V'
370415: WHEN 3 THEN 'CST_XLA_RCV_REF_V'
370416: WHEN 4 THEN 'CST_XLA_RCV_REF_V'
370417: WHEN 5 THEN 'CST_XLA_RCV_REF_V'
370418: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
370419: WHEN 7 THEN 'PO_DISTS_REF_V'
370420: WHEN 8 THEN 'CST_XLA_RCV_REF_V'
370421: WHEN 9 THEN 'CST_XLA_RCV_HEADERS_V'
370422: WHEN 10 THEN 'CST_XLA_RCV_REF_V'

Line 370421: WHEN 9 THEN 'CST_XLA_RCV_HEADERS_V'

370417: WHEN 5 THEN 'CST_XLA_RCV_REF_V'
370418: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
370419: WHEN 7 THEN 'PO_DISTS_REF_V'
370420: WHEN 8 THEN 'CST_XLA_RCV_REF_V'
370421: WHEN 9 THEN 'CST_XLA_RCV_HEADERS_V'
370422: WHEN 10 THEN 'CST_XLA_RCV_REF_V'
370423: WHEN 11 THEN 'PSA_CST_XLA_PEA_UPG_V'
370424: WHEN 12 THEN 'CST_XLA_RCV_HEADERS_V'
370425: WHEN 13 THEN 'CST_XLA_RCV_HEADERS_V'

Line 370424: WHEN 12 THEN 'CST_XLA_RCV_HEADERS_V'

370420: WHEN 8 THEN 'CST_XLA_RCV_REF_V'
370421: WHEN 9 THEN 'CST_XLA_RCV_HEADERS_V'
370422: WHEN 10 THEN 'CST_XLA_RCV_REF_V'
370423: WHEN 11 THEN 'PSA_CST_XLA_PEA_UPG_V'
370424: WHEN 12 THEN 'CST_XLA_RCV_HEADERS_V'
370425: WHEN 13 THEN 'CST_XLA_RCV_HEADERS_V'
370426: WHEN 14 THEN 'CST_XLA_RCV_HEADERS_V'
370427: WHEN 15 THEN 'PO_HEADERS_REF_V'
370428: WHEN 16 THEN 'CST_XLA_RCV_HEADERS_V'

Line 370425: WHEN 13 THEN 'CST_XLA_RCV_HEADERS_V'

370421: WHEN 9 THEN 'CST_XLA_RCV_HEADERS_V'
370422: WHEN 10 THEN 'CST_XLA_RCV_REF_V'
370423: WHEN 11 THEN 'PSA_CST_XLA_PEA_UPG_V'
370424: WHEN 12 THEN 'CST_XLA_RCV_HEADERS_V'
370425: WHEN 13 THEN 'CST_XLA_RCV_HEADERS_V'
370426: WHEN 14 THEN 'CST_XLA_RCV_HEADERS_V'
370427: WHEN 15 THEN 'PO_HEADERS_REF_V'
370428: WHEN 16 THEN 'CST_XLA_RCV_HEADERS_V'
370429:

Line 370426: WHEN 14 THEN 'CST_XLA_RCV_HEADERS_V'

370422: WHEN 10 THEN 'CST_XLA_RCV_REF_V'
370423: WHEN 11 THEN 'PSA_CST_XLA_PEA_UPG_V'
370424: WHEN 12 THEN 'CST_XLA_RCV_HEADERS_V'
370425: WHEN 13 THEN 'CST_XLA_RCV_HEADERS_V'
370426: WHEN 14 THEN 'CST_XLA_RCV_HEADERS_V'
370427: WHEN 15 THEN 'PO_HEADERS_REF_V'
370428: WHEN 16 THEN 'CST_XLA_RCV_HEADERS_V'
370429:
370430: ELSE null

Line 370428: WHEN 16 THEN 'CST_XLA_RCV_HEADERS_V'

370424: WHEN 12 THEN 'CST_XLA_RCV_HEADERS_V'
370425: WHEN 13 THEN 'CST_XLA_RCV_HEADERS_V'
370426: WHEN 14 THEN 'CST_XLA_RCV_HEADERS_V'
370427: WHEN 15 THEN 'PO_HEADERS_REF_V'
370428: WHEN 16 THEN 'CST_XLA_RCV_HEADERS_V'
370429:
370430: ELSE null
370431: END object_name
370432: , CASE r

Line 370520: , CST_XLA_RCV_HEADERS_V h1

370516:
370517: ELSE null
370518: END source_meaning
370519: FROM xla_events_gt xet
370520: , CST_XLA_RCV_HEADERS_V h1
370521: , CST_XLA_RCV_REF_V h3
370522: , PO_DISTS_REF_V h4
370523: , PO_HEADERS_REF_V h5
370524: , PSA_CST_XLA_PEA_UPG_V h6

Line 370795: TYPE t_array_source_85 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

370791: TYPE t_array_source_80 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
370792: TYPE t_array_source_81 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
370793: TYPE t_array_source_82 IS TABLE OF CST_XLA_RCV_REF_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
370794: TYPE t_array_source_83 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
370795: TYPE t_array_source_85 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
370796: TYPE t_array_source_86 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
370797: TYPE t_array_source_87 IS TABLE OF CST_XLA_RCV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
370798: TYPE t_array_source_88 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
370799: TYPE t_array_source_89 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 370798: TYPE t_array_source_88 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

370794: TYPE t_array_source_83 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
370795: TYPE t_array_source_85 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
370796: TYPE t_array_source_86 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
370797: TYPE t_array_source_87 IS TABLE OF CST_XLA_RCV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
370798: TYPE t_array_source_88 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
370799: TYPE t_array_source_89 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
370800: TYPE t_array_source_90 IS TABLE OF PSA_CST_XLA_PEA_UPG_V.CST_PEA_ENC_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
370801: TYPE t_array_source_92 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
370802: TYPE t_array_source_93 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 370801: TYPE t_array_source_92 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

370797: TYPE t_array_source_87 IS TABLE OF CST_XLA_RCV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
370798: TYPE t_array_source_88 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
370799: TYPE t_array_source_89 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
370800: TYPE t_array_source_90 IS TABLE OF PSA_CST_XLA_PEA_UPG_V.CST_PEA_ENC_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
370801: TYPE t_array_source_92 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
370802: TYPE t_array_source_93 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
370803: TYPE t_array_source_94 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
370804: TYPE t_array_source_96 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
370805: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 370802: TYPE t_array_source_93 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

370798: TYPE t_array_source_88 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
370799: TYPE t_array_source_89 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
370800: TYPE t_array_source_90 IS TABLE OF PSA_CST_XLA_PEA_UPG_V.CST_PEA_ENC_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
370801: TYPE t_array_source_92 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
370802: TYPE t_array_source_93 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
370803: TYPE t_array_source_94 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
370804: TYPE t_array_source_96 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
370805: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
370806:

Line 370803: TYPE t_array_source_94 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

370799: TYPE t_array_source_89 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
370800: TYPE t_array_source_90 IS TABLE OF PSA_CST_XLA_PEA_UPG_V.CST_PEA_ENC_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
370801: TYPE t_array_source_92 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
370802: TYPE t_array_source_93 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
370803: TYPE t_array_source_94 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
370804: TYPE t_array_source_96 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
370805: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
370806:
370807: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 370805: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

370801: TYPE t_array_source_92 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
370802: TYPE t_array_source_93 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
370803: TYPE t_array_source_94 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
370804: TYPE t_array_source_96 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
370805: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
370806:
370807: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
370808: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
370809: TYPE t_array_source_84 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 370886: , CST_XLA_RCV_HEADERS_V h1

370882: , h5.PURCH_ENCUMBRANCE_TYPE_ID source_96
370883: , h1.TRANSFER_TO_GL_INDICATOR source_114
370884: , fvl114.meaning source_114_meaning
370885: FROM xla_events_gt xet
370886: , CST_XLA_RCV_HEADERS_V h1
370887: , CST_XLA_RCV_REF_V h3
370888: , PO_DISTS_REF_V h4
370889: , PO_HEADERS_REF_V h5
370890: , PSA_CST_XLA_PEA_UPG_V h6

Line 375642: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'

375638: FROM (
375639: SELECT xet.event_id event_id
375640: , 0 line_number
375641: , CASE r
375642: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
375643: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
375644: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
375645: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
375646: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'

Line 375643: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'

375639: SELECT xet.event_id event_id
375640: , 0 line_number
375641: , CASE r
375642: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
375643: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
375644: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
375645: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
375646: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'
375647: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'

Line 375644: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'

375640: , 0 line_number
375641: , CASE r
375642: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
375643: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
375644: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
375645: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
375646: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'
375647: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
375648:

Line 375645: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'

375641: , CASE r
375642: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
375643: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
375644: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
375645: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
375646: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'
375647: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
375648:
375649: ELSE null

Line 375646: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'

375642: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
375643: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
375644: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
375645: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
375646: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'
375647: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
375648:
375649: ELSE null
375650: END object_name

Line 375647: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'

375643: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
375644: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
375645: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
375646: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'
375647: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
375648:
375649: ELSE null
375650: END object_name
375651: , CASE r

Line 375699: , CST_XLA_RCV_HEADERS_V h1

375695:
375696: ELSE null
375697: END source_meaning
375698: FROM xla_events_gt xet
375699: , CST_XLA_RCV_HEADERS_V h1
375700: , fnd_lookup_values fvl85
375701: , fnd_lookup_values fvl114
375702: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
375703: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 375965: TYPE t_array_source_85 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

375961: --
375962: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
375963: --
375964:
375965: TYPE t_array_source_85 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
375966: TYPE t_array_source_88 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
375967: TYPE t_array_source_92 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
375968: TYPE t_array_source_93 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
375969: TYPE t_array_source_94 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 375966: TYPE t_array_source_88 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

375962: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
375963: --
375964:
375965: TYPE t_array_source_85 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
375966: TYPE t_array_source_88 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
375967: TYPE t_array_source_92 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
375968: TYPE t_array_source_93 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
375969: TYPE t_array_source_94 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
375970: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 375967: TYPE t_array_source_92 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

375963: --
375964:
375965: TYPE t_array_source_85 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
375966: TYPE t_array_source_88 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
375967: TYPE t_array_source_92 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
375968: TYPE t_array_source_93 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
375969: TYPE t_array_source_94 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
375970: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
375971:

Line 375968: TYPE t_array_source_93 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

375964:
375965: TYPE t_array_source_85 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
375966: TYPE t_array_source_88 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
375967: TYPE t_array_source_92 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
375968: TYPE t_array_source_93 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
375969: TYPE t_array_source_94 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
375970: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
375971:
375972: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 375969: TYPE t_array_source_94 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

375965: TYPE t_array_source_85 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
375966: TYPE t_array_source_88 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
375967: TYPE t_array_source_92 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
375968: TYPE t_array_source_93 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
375969: TYPE t_array_source_94 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
375970: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
375971:
375972: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
375973: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 375970: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

375966: TYPE t_array_source_88 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
375967: TYPE t_array_source_92 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
375968: TYPE t_array_source_93 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
375969: TYPE t_array_source_94 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
375970: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
375971:
375972: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
375973: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
375974: TYPE t_array_source_84 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 376031: , CST_XLA_RCV_HEADERS_V h1

376027: , h1.CURRENCY_CONVERSION_TYPE source_94
376028: , h1.TRANSFER_TO_GL_INDICATOR source_114
376029: , fvl114.meaning source_114_meaning
376030: FROM xla_events_gt xet
376031: , CST_XLA_RCV_HEADERS_V h1
376032: , fnd_lookup_values fvl85
376033: , fnd_lookup_values fvl114
376034: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
376035: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 378247: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'

378243: FROM (
378244: SELECT xet.event_id event_id
378245: , 0 line_number
378246: , CASE r
378247: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
378248: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
378249: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
378250: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
378251: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'

Line 378248: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'

378244: SELECT xet.event_id event_id
378245: , 0 line_number
378246: , CASE r
378247: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
378248: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
378249: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
378250: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
378251: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'
378252:

Line 378249: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'

378245: , 0 line_number
378246: , CASE r
378247: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
378248: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
378249: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
378250: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
378251: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'
378252:
378253: ELSE null

Line 378250: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'

378246: , CASE r
378247: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
378248: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
378249: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
378250: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
378251: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'
378252:
378253: ELSE null
378254: END object_name

Line 378251: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'

378247: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
378248: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
378249: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
378250: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
378251: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'
378252:
378253: ELSE null
378254: END object_name
378255: , CASE r

Line 378299: , CST_XLA_RCV_HEADERS_V h1

378295:
378296: ELSE null
378297: END source_meaning
378298: FROM xla_events_gt xet
378299: , CST_XLA_RCV_HEADERS_V h1
378300: , fnd_lookup_values fvl85
378301: , fnd_lookup_values fvl114
378302: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
378303: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 378565: TYPE t_array_source_85 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

378561: --
378562: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
378563: --
378564:
378565: TYPE t_array_source_85 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
378566: TYPE t_array_source_88 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
378567: TYPE t_array_source_92 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
378568: TYPE t_array_source_93 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
378569: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 378566: TYPE t_array_source_88 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

378562: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
378563: --
378564:
378565: TYPE t_array_source_85 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
378566: TYPE t_array_source_88 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
378567: TYPE t_array_source_92 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
378568: TYPE t_array_source_93 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
378569: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
378570:

Line 378567: TYPE t_array_source_92 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

378563: --
378564:
378565: TYPE t_array_source_85 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
378566: TYPE t_array_source_88 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
378567: TYPE t_array_source_92 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
378568: TYPE t_array_source_93 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
378569: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
378570:
378571: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 378568: TYPE t_array_source_93 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

378564:
378565: TYPE t_array_source_85 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
378566: TYPE t_array_source_88 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
378567: TYPE t_array_source_92 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
378568: TYPE t_array_source_93 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
378569: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
378570:
378571: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
378572: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 378569: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

378565: TYPE t_array_source_85 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
378566: TYPE t_array_source_88 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
378567: TYPE t_array_source_92 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
378568: TYPE t_array_source_93 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
378569: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
378570:
378571: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
378572: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
378573: TYPE t_array_source_84 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 378628: , CST_XLA_RCV_HEADERS_V h1

378624: , h1.CURRENCY_CONVERSION_RATE source_93
378625: , h1.TRANSFER_TO_GL_INDICATOR source_114
378626: , fvl114.meaning source_114_meaning
378627: FROM xla_events_gt xet
378628: , CST_XLA_RCV_HEADERS_V h1
378629: , fnd_lookup_values fvl85
378630: , fnd_lookup_values fvl114
378631: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
378632: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 379474: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'

379470: FROM (
379471: SELECT xet.event_id event_id
379472: , 0 line_number
379473: , CASE r
379474: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
379475: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
379476: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
379477: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
379478: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'

Line 379475: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'

379471: SELECT xet.event_id event_id
379472: , 0 line_number
379473: , CASE r
379474: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
379475: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
379476: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
379477: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
379478: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'
379479: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'

Line 379476: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'

379472: , 0 line_number
379473: , CASE r
379474: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
379475: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
379476: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
379477: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
379478: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'
379479: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
379480:

Line 379477: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'

379473: , CASE r
379474: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
379475: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
379476: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
379477: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
379478: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'
379479: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
379480:
379481: ELSE null

Line 379478: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'

379474: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
379475: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
379476: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
379477: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
379478: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'
379479: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
379480:
379481: ELSE null
379482: END object_name

Line 379479: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'

379475: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
379476: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
379477: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
379478: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'
379479: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
379480:
379481: ELSE null
379482: END object_name
379483: , CASE r

Line 379531: , CST_XLA_RCV_HEADERS_V h1

379527:
379528: ELSE null
379529: END source_meaning
379530: FROM xla_events_gt xet
379531: , CST_XLA_RCV_HEADERS_V h1
379532: , fnd_lookup_values fvl85
379533: , fnd_lookup_values fvl114
379534: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
379535: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 379797: TYPE t_array_source_85 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

379793: --
379794: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
379795: --
379796:
379797: TYPE t_array_source_85 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
379798: TYPE t_array_source_88 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
379799: TYPE t_array_source_92 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
379800: TYPE t_array_source_93 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
379801: TYPE t_array_source_94 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 379798: TYPE t_array_source_88 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

379794: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
379795: --
379796:
379797: TYPE t_array_source_85 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
379798: TYPE t_array_source_88 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
379799: TYPE t_array_source_92 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
379800: TYPE t_array_source_93 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
379801: TYPE t_array_source_94 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
379802: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 379799: TYPE t_array_source_92 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

379795: --
379796:
379797: TYPE t_array_source_85 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
379798: TYPE t_array_source_88 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
379799: TYPE t_array_source_92 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
379800: TYPE t_array_source_93 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
379801: TYPE t_array_source_94 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
379802: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
379803:

Line 379800: TYPE t_array_source_93 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

379796:
379797: TYPE t_array_source_85 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
379798: TYPE t_array_source_88 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
379799: TYPE t_array_source_92 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
379800: TYPE t_array_source_93 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
379801: TYPE t_array_source_94 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
379802: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
379803:
379804: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 379801: TYPE t_array_source_94 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

379797: TYPE t_array_source_85 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
379798: TYPE t_array_source_88 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
379799: TYPE t_array_source_92 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
379800: TYPE t_array_source_93 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
379801: TYPE t_array_source_94 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
379802: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
379803:
379804: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
379805: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 379802: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

379798: TYPE t_array_source_88 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
379799: TYPE t_array_source_92 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
379800: TYPE t_array_source_93 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
379801: TYPE t_array_source_94 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
379802: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
379803:
379804: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
379805: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
379806: TYPE t_array_source_84 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 379863: , CST_XLA_RCV_HEADERS_V h1

379859: , h1.CURRENCY_CONVERSION_TYPE source_94
379860: , h1.TRANSFER_TO_GL_INDICATOR source_114
379861: , fvl114.meaning source_114_meaning
379862: FROM xla_events_gt xet
379863: , CST_XLA_RCV_HEADERS_V h1
379864: , fnd_lookup_values fvl85
379865: , fnd_lookup_values fvl114
379866: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
379867: and xet.event_class_code = C_EVENT_CLASS_CODE