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

APPS.XLA_00707_AAD_S_000005_PKG dependencies on CST_XLA_RCV_REF_V

Line 147041: WHEN 1 THEN 'CST_XLA_RCV_REF_V'

147037: FROM (
147038: SELECT xet.event_id event_id
147039: , 0 line_number
147040: , CASE r
147041: WHEN 1 THEN 'CST_XLA_RCV_REF_V'
147042: WHEN 2 THEN 'CST_XLA_RCV_REF_V'
147043: WHEN 3 THEN 'CST_XLA_RCV_REF_V'
147044: WHEN 4 THEN 'CST_XLA_RCV_REF_V'
147045: WHEN 5 THEN 'CST_XLA_RCV_REF_V'

Line 147042: WHEN 2 THEN 'CST_XLA_RCV_REF_V'

147038: SELECT xet.event_id event_id
147039: , 0 line_number
147040: , CASE r
147041: WHEN 1 THEN 'CST_XLA_RCV_REF_V'
147042: WHEN 2 THEN 'CST_XLA_RCV_REF_V'
147043: WHEN 3 THEN 'CST_XLA_RCV_REF_V'
147044: WHEN 4 THEN 'CST_XLA_RCV_REF_V'
147045: WHEN 5 THEN 'CST_XLA_RCV_REF_V'
147046: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'

Line 147043: WHEN 3 THEN 'CST_XLA_RCV_REF_V'

147039: , 0 line_number
147040: , CASE r
147041: WHEN 1 THEN 'CST_XLA_RCV_REF_V'
147042: WHEN 2 THEN 'CST_XLA_RCV_REF_V'
147043: WHEN 3 THEN 'CST_XLA_RCV_REF_V'
147044: WHEN 4 THEN 'CST_XLA_RCV_REF_V'
147045: WHEN 5 THEN 'CST_XLA_RCV_REF_V'
147046: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
147047: WHEN 7 THEN 'PO_DISTS_REF_V'

Line 147044: WHEN 4 THEN 'CST_XLA_RCV_REF_V'

147040: , CASE r
147041: WHEN 1 THEN 'CST_XLA_RCV_REF_V'
147042: WHEN 2 THEN 'CST_XLA_RCV_REF_V'
147043: WHEN 3 THEN 'CST_XLA_RCV_REF_V'
147044: WHEN 4 THEN 'CST_XLA_RCV_REF_V'
147045: WHEN 5 THEN 'CST_XLA_RCV_REF_V'
147046: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
147047: WHEN 7 THEN 'PO_DISTS_REF_V'
147048: WHEN 8 THEN 'CST_XLA_RCV_REF_V'

Line 147045: WHEN 5 THEN 'CST_XLA_RCV_REF_V'

147041: WHEN 1 THEN 'CST_XLA_RCV_REF_V'
147042: WHEN 2 THEN 'CST_XLA_RCV_REF_V'
147043: WHEN 3 THEN 'CST_XLA_RCV_REF_V'
147044: WHEN 4 THEN 'CST_XLA_RCV_REF_V'
147045: WHEN 5 THEN 'CST_XLA_RCV_REF_V'
147046: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
147047: WHEN 7 THEN 'PO_DISTS_REF_V'
147048: WHEN 8 THEN 'CST_XLA_RCV_REF_V'
147049: WHEN 9 THEN 'CST_XLA_RCV_HEADERS_V'

Line 147048: WHEN 8 THEN 'CST_XLA_RCV_REF_V'

147044: WHEN 4 THEN 'CST_XLA_RCV_REF_V'
147045: WHEN 5 THEN 'CST_XLA_RCV_REF_V'
147046: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
147047: WHEN 7 THEN 'PO_DISTS_REF_V'
147048: WHEN 8 THEN 'CST_XLA_RCV_REF_V'
147049: WHEN 9 THEN 'CST_XLA_RCV_HEADERS_V'
147050: WHEN 10 THEN 'CST_XLA_RCV_REF_V'
147051: WHEN 11 THEN 'CST_XLA_RCV_HEADERS_V'
147052: WHEN 12 THEN 'CST_XLA_RCV_HEADERS_V'

Line 147050: WHEN 10 THEN 'CST_XLA_RCV_REF_V'

147046: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
147047: WHEN 7 THEN 'PO_DISTS_REF_V'
147048: WHEN 8 THEN 'CST_XLA_RCV_REF_V'
147049: WHEN 9 THEN 'CST_XLA_RCV_HEADERS_V'
147050: WHEN 10 THEN 'CST_XLA_RCV_REF_V'
147051: WHEN 11 THEN 'CST_XLA_RCV_HEADERS_V'
147052: WHEN 12 THEN 'CST_XLA_RCV_HEADERS_V'
147053: WHEN 13 THEN 'CST_XLA_RCV_HEADERS_V'
147054: WHEN 14 THEN 'PO_HEADERS_REF_V'

Line 147149: , CST_XLA_RCV_REF_V h3

147145: ELSE null
147146: END source_meaning
147147: FROM xla_events_gt xet
147148: , CST_XLA_RCV_HEADERS_V h1
147149: , CST_XLA_RCV_REF_V h3
147150: , PO_DISTS_REF_V h4
147151: , PO_HEADERS_REF_V h5
147152: , PSA_CST_XLA_UPG_V h6
147153: , fnd_lookup_values fvl12

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

147414: --
147415: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
147416: --
147417:
147418: TYPE t_array_source_6 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
147419: TYPE t_array_source_7 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
147420: TYPE t_array_source_8 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
147421: TYPE t_array_source_9 IS TABLE OF CST_XLA_RCV_REF_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
147422: TYPE t_array_source_10 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;

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

147415: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
147416: --
147417:
147418: TYPE t_array_source_6 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
147419: TYPE t_array_source_7 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
147420: TYPE t_array_source_8 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
147421: TYPE t_array_source_9 IS TABLE OF CST_XLA_RCV_REF_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
147422: TYPE t_array_source_10 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
147423: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

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

147416: --
147417:
147418: TYPE t_array_source_6 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
147419: TYPE t_array_source_7 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
147420: TYPE t_array_source_8 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
147421: TYPE t_array_source_9 IS TABLE OF CST_XLA_RCV_REF_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
147422: TYPE t_array_source_10 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
147423: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
147424: TYPE t_array_source_13 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

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

147417:
147418: TYPE t_array_source_6 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
147419: TYPE t_array_source_7 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
147420: TYPE t_array_source_8 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
147421: TYPE t_array_source_9 IS TABLE OF CST_XLA_RCV_REF_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
147422: TYPE t_array_source_10 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
147423: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
147424: TYPE t_array_source_13 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
147425: TYPE t_array_source_14 IS TABLE OF CST_XLA_RCV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;

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

147418: TYPE t_array_source_6 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
147419: TYPE t_array_source_7 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
147420: TYPE t_array_source_8 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
147421: TYPE t_array_source_9 IS TABLE OF CST_XLA_RCV_REF_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
147422: TYPE t_array_source_10 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
147423: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
147424: TYPE t_array_source_13 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
147425: TYPE t_array_source_14 IS TABLE OF CST_XLA_RCV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
147426: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 147425: TYPE t_array_source_14 IS TABLE OF CST_XLA_RCV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;

147421: TYPE t_array_source_9 IS TABLE OF CST_XLA_RCV_REF_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
147422: TYPE t_array_source_10 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
147423: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
147424: TYPE t_array_source_13 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
147425: TYPE t_array_source_14 IS TABLE OF CST_XLA_RCV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
147426: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
147427: TYPE t_array_source_16 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
147428: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
147429: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 147427: TYPE t_array_source_16 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

147423: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
147424: TYPE t_array_source_13 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
147425: TYPE t_array_source_14 IS TABLE OF CST_XLA_RCV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
147426: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
147427: TYPE t_array_source_16 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
147428: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
147429: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
147430: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
147431: TYPE t_array_source_23 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 147515: , CST_XLA_RCV_REF_V h3

147511: , h1.TRANSFER_TO_GL_INDICATOR source_38
147512: , fvl38.meaning source_38_meaning
147513: FROM xla_events_gt xet
147514: , CST_XLA_RCV_HEADERS_V h1
147515: , CST_XLA_RCV_REF_V h3
147516: , PO_DISTS_REF_V h4
147517: , PO_HEADERS_REF_V h5
147518: , PSA_CST_XLA_UPG_V h6
147519: , fnd_lookup_values fvl12

Line 162253: , CST_XLA_RCV_REF_V h3

162249: ELSE null
162250: END source_meaning
162251: FROM xla_events_gt xet
162252: , CST_XLA_RCV_HEADERS_V h1
162253: , CST_XLA_RCV_REF_V h3
162254: , PO_DISTS_REF_V h4
162255: , fnd_lookup_values fvl12
162256: , fnd_lookup_values fvl38
162257: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)

Line 162584: , CST_XLA_RCV_REF_V h3

162580: , h1.TRANSFER_TO_GL_INDICATOR source_38
162581: , fvl38.meaning source_38_meaning
162582: FROM xla_events_gt xet
162583: , CST_XLA_RCV_HEADERS_V h1
162584: , CST_XLA_RCV_REF_V h3
162585: , PO_DISTS_REF_V h4
162586: , fnd_lookup_values fvl12
162587: , fnd_lookup_values fvl38
162588: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 163517: , CST_XLA_RCV_REF_V h3

163513: ELSE null
163514: END source_meaning
163515: FROM xla_events_gt xet
163516: , CST_XLA_RCV_HEADERS_V h1
163517: , CST_XLA_RCV_REF_V h3
163518: , PO_DISTS_REF_V h4
163519: , fnd_lookup_values fvl12
163520: , fnd_lookup_values fvl38
163521: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)

Line 163851: , CST_XLA_RCV_REF_V h3

163847: , h1.TRANSFER_TO_GL_INDICATOR source_38
163848: , fvl38.meaning source_38_meaning
163849: FROM xla_events_gt xet
163850: , CST_XLA_RCV_HEADERS_V h1
163851: , CST_XLA_RCV_REF_V h3
163852: , PO_DISTS_REF_V h4
163853: , fnd_lookup_values fvl12
163854: , fnd_lookup_values fvl38
163855: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 171045: WHEN 1 THEN 'CST_XLA_RCV_REF_V'

171041: FROM (
171042: SELECT xet.event_id event_id
171043: , 0 line_number
171044: , CASE r
171045: WHEN 1 THEN 'CST_XLA_RCV_REF_V'
171046: WHEN 2 THEN 'CST_XLA_RCV_REF_V'
171047: WHEN 3 THEN 'CST_XLA_RCV_REF_V'
171048: WHEN 4 THEN 'CST_XLA_RCV_REF_V'
171049: WHEN 5 THEN 'CST_XLA_RCV_REF_V'

Line 171046: WHEN 2 THEN 'CST_XLA_RCV_REF_V'

171042: SELECT xet.event_id event_id
171043: , 0 line_number
171044: , CASE r
171045: WHEN 1 THEN 'CST_XLA_RCV_REF_V'
171046: WHEN 2 THEN 'CST_XLA_RCV_REF_V'
171047: WHEN 3 THEN 'CST_XLA_RCV_REF_V'
171048: WHEN 4 THEN 'CST_XLA_RCV_REF_V'
171049: WHEN 5 THEN 'CST_XLA_RCV_REF_V'
171050: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'

Line 171047: WHEN 3 THEN 'CST_XLA_RCV_REF_V'

171043: , 0 line_number
171044: , CASE r
171045: WHEN 1 THEN 'CST_XLA_RCV_REF_V'
171046: WHEN 2 THEN 'CST_XLA_RCV_REF_V'
171047: WHEN 3 THEN 'CST_XLA_RCV_REF_V'
171048: WHEN 4 THEN 'CST_XLA_RCV_REF_V'
171049: WHEN 5 THEN 'CST_XLA_RCV_REF_V'
171050: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
171051: WHEN 7 THEN 'PO_DISTS_REF_V'

Line 171048: WHEN 4 THEN 'CST_XLA_RCV_REF_V'

171044: , CASE r
171045: WHEN 1 THEN 'CST_XLA_RCV_REF_V'
171046: WHEN 2 THEN 'CST_XLA_RCV_REF_V'
171047: WHEN 3 THEN 'CST_XLA_RCV_REF_V'
171048: WHEN 4 THEN 'CST_XLA_RCV_REF_V'
171049: WHEN 5 THEN 'CST_XLA_RCV_REF_V'
171050: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
171051: WHEN 7 THEN 'PO_DISTS_REF_V'
171052: WHEN 8 THEN 'CST_XLA_RCV_REF_V'

Line 171049: WHEN 5 THEN 'CST_XLA_RCV_REF_V'

171045: WHEN 1 THEN 'CST_XLA_RCV_REF_V'
171046: WHEN 2 THEN 'CST_XLA_RCV_REF_V'
171047: WHEN 3 THEN 'CST_XLA_RCV_REF_V'
171048: WHEN 4 THEN 'CST_XLA_RCV_REF_V'
171049: WHEN 5 THEN 'CST_XLA_RCV_REF_V'
171050: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
171051: WHEN 7 THEN 'PO_DISTS_REF_V'
171052: WHEN 8 THEN 'CST_XLA_RCV_REF_V'
171053: WHEN 9 THEN 'CST_XLA_RCV_HEADERS_V'

Line 171052: WHEN 8 THEN 'CST_XLA_RCV_REF_V'

171048: WHEN 4 THEN 'CST_XLA_RCV_REF_V'
171049: WHEN 5 THEN 'CST_XLA_RCV_REF_V'
171050: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
171051: WHEN 7 THEN 'PO_DISTS_REF_V'
171052: WHEN 8 THEN 'CST_XLA_RCV_REF_V'
171053: WHEN 9 THEN 'CST_XLA_RCV_HEADERS_V'
171054: WHEN 10 THEN 'CST_XLA_RCV_REF_V'
171055: WHEN 11 THEN 'PSA_CST_XLA_PEA_UPG_V'
171056: WHEN 12 THEN 'CST_XLA_RCV_HEADERS_V'

Line 171054: WHEN 10 THEN 'CST_XLA_RCV_REF_V'

171050: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
171051: WHEN 7 THEN 'PO_DISTS_REF_V'
171052: WHEN 8 THEN 'CST_XLA_RCV_REF_V'
171053: WHEN 9 THEN 'CST_XLA_RCV_HEADERS_V'
171054: WHEN 10 THEN 'CST_XLA_RCV_REF_V'
171055: WHEN 11 THEN 'PSA_CST_XLA_PEA_UPG_V'
171056: WHEN 12 THEN 'CST_XLA_RCV_HEADERS_V'
171057: WHEN 13 THEN 'CST_XLA_RCV_HEADERS_V'
171058: WHEN 14 THEN 'CST_XLA_RCV_HEADERS_V'

Line 171153: , CST_XLA_RCV_REF_V h3

171149: ELSE null
171150: END source_meaning
171151: FROM xla_events_gt xet
171152: , CST_XLA_RCV_HEADERS_V h1
171153: , CST_XLA_RCV_REF_V h3
171154: , PO_DISTS_REF_V h4
171155: , PO_HEADERS_REF_V h5
171156: , PSA_CST_XLA_PEA_UPG_V h6
171157: , fnd_lookup_values fvl12

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

171418: --
171419: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
171420: --
171421:
171422: TYPE t_array_source_6 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
171423: TYPE t_array_source_7 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
171424: TYPE t_array_source_8 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
171425: TYPE t_array_source_9 IS TABLE OF CST_XLA_RCV_REF_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
171426: TYPE t_array_source_10 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;

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

171419: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
171420: --
171421:
171422: TYPE t_array_source_6 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
171423: TYPE t_array_source_7 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
171424: TYPE t_array_source_8 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
171425: TYPE t_array_source_9 IS TABLE OF CST_XLA_RCV_REF_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
171426: TYPE t_array_source_10 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
171427: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

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

171420: --
171421:
171422: TYPE t_array_source_6 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
171423: TYPE t_array_source_7 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
171424: TYPE t_array_source_8 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
171425: TYPE t_array_source_9 IS TABLE OF CST_XLA_RCV_REF_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
171426: TYPE t_array_source_10 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
171427: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
171428: TYPE t_array_source_13 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

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

171421:
171422: TYPE t_array_source_6 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
171423: TYPE t_array_source_7 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
171424: TYPE t_array_source_8 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
171425: TYPE t_array_source_9 IS TABLE OF CST_XLA_RCV_REF_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
171426: TYPE t_array_source_10 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
171427: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
171428: TYPE t_array_source_13 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
171429: TYPE t_array_source_14 IS TABLE OF CST_XLA_RCV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;

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

171422: TYPE t_array_source_6 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
171423: TYPE t_array_source_7 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
171424: TYPE t_array_source_8 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
171425: TYPE t_array_source_9 IS TABLE OF CST_XLA_RCV_REF_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
171426: TYPE t_array_source_10 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
171427: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
171428: TYPE t_array_source_13 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
171429: TYPE t_array_source_14 IS TABLE OF CST_XLA_RCV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
171430: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 171429: TYPE t_array_source_14 IS TABLE OF CST_XLA_RCV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;

171425: TYPE t_array_source_9 IS TABLE OF CST_XLA_RCV_REF_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
171426: TYPE t_array_source_10 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
171427: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
171428: TYPE t_array_source_13 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
171429: TYPE t_array_source_14 IS TABLE OF CST_XLA_RCV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
171430: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
171431: TYPE t_array_source_16 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
171432: TYPE t_array_source_17 IS TABLE OF PSA_CST_XLA_PEA_UPG_V.CST_PEA_ENC_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
171433: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 171431: TYPE t_array_source_16 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

171427: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
171428: TYPE t_array_source_13 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
171429: TYPE t_array_source_14 IS TABLE OF CST_XLA_RCV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
171430: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
171431: TYPE t_array_source_16 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
171432: TYPE t_array_source_17 IS TABLE OF PSA_CST_XLA_PEA_UPG_V.CST_PEA_ENC_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
171433: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
171434: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
171435: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 171519: , CST_XLA_RCV_REF_V h3

171515: , h1.TRANSFER_TO_GL_INDICATOR source_38
171516: , fvl38.meaning source_38_meaning
171517: FROM xla_events_gt xet
171518: , CST_XLA_RCV_HEADERS_V h1
171519: , CST_XLA_RCV_REF_V h3
171520: , PO_DISTS_REF_V h4
171521: , PO_HEADERS_REF_V h5
171522: , PSA_CST_XLA_PEA_UPG_V h6
171523: , fnd_lookup_values fvl12