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_REF_V

Line 142049: WHEN 1 THEN 'CST_XLA_RCV_REF_V'

142045: FROM (
142046: SELECT xet.event_id event_id
142047: , 0 line_number
142048: , CASE r
142049: WHEN 1 THEN 'CST_XLA_RCV_REF_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'

Line 142050: WHEN 2 THEN 'CST_XLA_RCV_REF_V'

142046: SELECT xet.event_id event_id
142047: , 0 line_number
142048: , CASE r
142049: WHEN 1 THEN 'CST_XLA_RCV_REF_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'

Line 142051: WHEN 3 THEN 'CST_XLA_RCV_REF_V'

142047: , 0 line_number
142048: , CASE r
142049: WHEN 1 THEN 'CST_XLA_RCV_REF_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'

Line 142052: WHEN 4 THEN 'CST_XLA_RCV_REF_V'

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

Line 142053: WHEN 5 THEN 'CST_XLA_RCV_REF_V'

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

Line 142056: WHEN 8 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'
142059: WHEN 11 THEN 'CST_XLA_RCV_HEADERS_V'
142060: WHEN 12 THEN 'CST_XLA_RCV_HEADERS_V'

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

Line 142157: , CST_XLA_RCV_REF_V h3

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
142161: , fnd_lookup_values fvl12

Line 142426: TYPE t_array_source_6 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;

142422: --
142423: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
142424: --
142425:
142426: TYPE t_array_source_6 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%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;

Line 142427: TYPE t_array_source_7 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

142423: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
142424: --
142425:
142426: TYPE t_array_source_6 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%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;

Line 142428: TYPE t_array_source_8 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

142424: --
142425:
142426: TYPE t_array_source_6 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%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;

Line 142429: TYPE t_array_source_9 IS TABLE OF CST_XLA_RCV_REF_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

142425:
142426: TYPE t_array_source_6 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%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;

Line 142430: TYPE t_array_source_10 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;

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

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

Line 142435: TYPE t_array_source_16 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%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;
142439: TYPE t_array_source_23 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 142523: , CST_XLA_RCV_REF_V h3

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
142527: , fnd_lookup_values fvl12

Line 157261: , CST_XLA_RCV_REF_V h3

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

Line 157592: , CST_XLA_RCV_REF_V h3

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

Line 158525: , CST_XLA_RCV_REF_V h3

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

Line 158859: , CST_XLA_RCV_REF_V h3

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

Line 163552: WHEN 1 THEN 'CST_XLA_RCV_REF_V'

163548: FROM (
163549: SELECT xet.event_id event_id
163550: , 0 line_number
163551: , CASE r
163552: WHEN 1 THEN 'CST_XLA_RCV_REF_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'

Line 163553: WHEN 2 THEN 'CST_XLA_RCV_REF_V'

163549: SELECT xet.event_id event_id
163550: , 0 line_number
163551: , CASE r
163552: WHEN 1 THEN 'CST_XLA_RCV_REF_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'

Line 163554: WHEN 3 THEN 'CST_XLA_RCV_REF_V'

163550: , 0 line_number
163551: , CASE r
163552: WHEN 1 THEN 'CST_XLA_RCV_REF_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'

Line 163555: WHEN 4 THEN 'CST_XLA_RCV_REF_V'

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

Line 163556: WHEN 5 THEN 'CST_XLA_RCV_REF_V'

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

Line 163559: WHEN 8 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'
163562: WHEN 11 THEN 'PSA_CST_XLA_PEA_UPG_V'
163563: WHEN 12 THEN 'CST_XLA_RCV_HEADERS_V'

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

Line 163660: , CST_XLA_RCV_REF_V h3

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
163664: , fnd_lookup_values fvl12

Line 163929: TYPE t_array_source_6 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;

163925: --
163926: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
163927: --
163928:
163929: TYPE t_array_source_6 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%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;

Line 163930: TYPE t_array_source_7 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

163926: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
163927: --
163928:
163929: TYPE t_array_source_6 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%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;

Line 163931: TYPE t_array_source_8 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

163927: --
163928:
163929: TYPE t_array_source_6 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%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;

Line 163932: TYPE t_array_source_9 IS TABLE OF CST_XLA_RCV_REF_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

163928:
163929: TYPE t_array_source_6 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%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;

Line 163933: TYPE t_array_source_10 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;

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

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

Line 163938: TYPE t_array_source_16 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%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;
163942: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 164026: , CST_XLA_RCV_REF_V h3

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
164030: , fnd_lookup_values fvl12