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_REF_V

Line 313642: WHEN 1 THEN 'CST_XLA_RCV_REF_V'

313638: FROM (
313639: SELECT xet.event_id event_id
313640: , 0 line_number
313641: , CASE r
313642: WHEN 1 THEN 'CST_XLA_RCV_REF_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'

Line 313643: WHEN 2 THEN 'CST_XLA_RCV_REF_V'

313639: SELECT xet.event_id event_id
313640: , 0 line_number
313641: , CASE r
313642: WHEN 1 THEN 'CST_XLA_RCV_REF_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'

Line 313644: WHEN 3 THEN 'CST_XLA_RCV_REF_V'

313640: , 0 line_number
313641: , CASE r
313642: WHEN 1 THEN 'CST_XLA_RCV_REF_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'

Line 313645: WHEN 4 THEN 'CST_XLA_RCV_REF_V'

313641: , CASE r
313642: WHEN 1 THEN 'CST_XLA_RCV_REF_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'

Line 313646: WHEN 5 THEN 'CST_XLA_RCV_REF_V'

313642: WHEN 1 THEN 'CST_XLA_RCV_REF_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'

Line 313649: WHEN 8 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'
313652: WHEN 11 THEN 'CST_XLA_RCV_HEADERS_V'
313653: WHEN 12 THEN 'CST_XLA_RCV_HEADERS_V'

Line 313651: WHEN 10 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'
313655: WHEN 14 THEN 'PO_HEADERS_REF_V'

Line 313750: , CST_XLA_RCV_REF_V h3

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
313754: , fnd_lookup_values fvl85

Line 314019: TYPE t_array_source_79 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;

314015: --
314016: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
314017: --
314018:
314019: TYPE t_array_source_79 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%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;

Line 314020: TYPE t_array_source_80 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

314016: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
314017: --
314018:
314019: TYPE t_array_source_79 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%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;

Line 314021: TYPE t_array_source_81 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

314017: --
314018:
314019: TYPE t_array_source_79 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%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;

Line 314022: TYPE t_array_source_82 IS TABLE OF CST_XLA_RCV_REF_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

314018:
314019: TYPE t_array_source_79 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%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;

Line 314023: TYPE t_array_source_83 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;

314019: TYPE t_array_source_79 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%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;

Line 314026: TYPE t_array_source_87 IS TABLE OF CST_XLA_RCV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%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;
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;

Line 314028: TYPE t_array_source_89 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%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;
314032: TYPE t_array_source_96 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 314116: , CST_XLA_RCV_REF_V h3

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
314120: , fnd_lookup_values fvl85

Line 349286: , CST_XLA_RCV_REF_V h3

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
349290: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)

Line 349617: , CST_XLA_RCV_REF_V h3

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
349621: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 350550: , CST_XLA_RCV_REF_V h3

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
350554: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)

Line 350884: , CST_XLA_RCV_REF_V h3

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
350888: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 370413: WHEN 1 THEN 'CST_XLA_RCV_REF_V'

370409: FROM (
370410: SELECT xet.event_id event_id
370411: , 0 line_number
370412: , CASE r
370413: WHEN 1 THEN 'CST_XLA_RCV_REF_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'

Line 370414: WHEN 2 THEN 'CST_XLA_RCV_REF_V'

370410: SELECT xet.event_id event_id
370411: , 0 line_number
370412: , CASE r
370413: WHEN 1 THEN 'CST_XLA_RCV_REF_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'

Line 370415: WHEN 3 THEN 'CST_XLA_RCV_REF_V'

370411: , 0 line_number
370412: , CASE r
370413: WHEN 1 THEN 'CST_XLA_RCV_REF_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'

Line 370416: WHEN 4 THEN 'CST_XLA_RCV_REF_V'

370412: , CASE r
370413: WHEN 1 THEN 'CST_XLA_RCV_REF_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'

Line 370417: WHEN 5 THEN 'CST_XLA_RCV_REF_V'

370413: WHEN 1 THEN 'CST_XLA_RCV_REF_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'

Line 370420: WHEN 8 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'
370423: WHEN 11 THEN 'PSA_CST_XLA_PEA_UPG_V'
370424: WHEN 12 THEN 'CST_XLA_RCV_HEADERS_V'

Line 370422: WHEN 10 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'
370426: WHEN 14 THEN 'CST_XLA_RCV_HEADERS_V'

Line 370521: , CST_XLA_RCV_REF_V h3

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
370525: , fnd_lookup_values fvl85

Line 370790: TYPE t_array_source_79 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;

370786: --
370787: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
370788: --
370789:
370790: TYPE t_array_source_79 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%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;

Line 370791: TYPE t_array_source_80 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

370787: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
370788: --
370789:
370790: TYPE t_array_source_79 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%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;

Line 370792: TYPE t_array_source_81 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

370788: --
370789:
370790: TYPE t_array_source_79 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%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;

Line 370793: TYPE t_array_source_82 IS TABLE OF CST_XLA_RCV_REF_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

370789:
370790: TYPE t_array_source_79 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%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;

Line 370794: TYPE t_array_source_83 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;

370790: TYPE t_array_source_79 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%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;

Line 370797: TYPE t_array_source_87 IS TABLE OF CST_XLA_RCV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%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;
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;

Line 370799: TYPE t_array_source_89 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%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;
370803: TYPE t_array_source_94 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 370887: , CST_XLA_RCV_REF_V h3

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
370891: , fnd_lookup_values fvl85