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_HEADERS_V

Line 147046: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_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'
147050: WHEN 10 THEN 'CST_XLA_RCV_REF_V'

Line 147049: WHEN 9 THEN 'CST_XLA_RCV_HEADERS_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'
147053: WHEN 13 THEN 'CST_XLA_RCV_HEADERS_V'

Line 147051: WHEN 11 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'
147055: WHEN 15 THEN 'PSA_CST_XLA_UPG_V'

Line 147052: WHEN 12 THEN 'CST_XLA_RCV_HEADERS_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'
147055: WHEN 15 THEN 'PSA_CST_XLA_UPG_V'
147056: WHEN 16 THEN 'CST_XLA_RCV_HEADERS_V'

Line 147053: WHEN 13 THEN 'CST_XLA_RCV_HEADERS_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'
147055: WHEN 15 THEN 'PSA_CST_XLA_UPG_V'
147056: WHEN 16 THEN 'CST_XLA_RCV_HEADERS_V'
147057:

Line 147056: WHEN 16 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'
147055: WHEN 15 THEN 'PSA_CST_XLA_UPG_V'
147056: WHEN 16 THEN 'CST_XLA_RCV_HEADERS_V'
147057:
147058: ELSE null
147059: END object_name
147060: , CASE r

Line 147148: , CST_XLA_RCV_HEADERS_V h1

147144:
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

Line 147423: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%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;
147427: TYPE t_array_source_16 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 147426: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%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;
147430: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 147428: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%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;
147432: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;

Line 147429: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%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;
147432: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
147433: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 147430: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%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;
147432: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
147433: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
147434:

Line 147433: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%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;
147432: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
147433: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
147434:
147435: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
147436: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
147437: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 147514: , CST_XLA_RCV_HEADERS_V h1

147510: , h6.CST_ENCUM_UPG_OPTION source_27
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

Line 162200: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'

162196: FROM (
162197: SELECT xet.event_id event_id
162198: , 0 line_number
162199: , CASE r
162200: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
162201: WHEN 2 THEN 'PO_DISTS_REF_V'
162202: WHEN 3 THEN 'PO_DISTS_REF_V'
162203: WHEN 4 THEN 'PO_DISTS_REF_V'
162204: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'

Line 162204: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'

162200: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
162201: WHEN 2 THEN 'PO_DISTS_REF_V'
162202: WHEN 3 THEN 'PO_DISTS_REF_V'
162203: WHEN 4 THEN 'PO_DISTS_REF_V'
162204: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'
162205:
162206: ELSE null
162207: END object_name
162208: , CASE r

Line 162252: , CST_XLA_RCV_HEADERS_V h1

162248:
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

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

162516: --
162517: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
162518: --
162519:
162520: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
162521: TYPE t_array_source_32 IS TABLE OF PO_DISTS_REF_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
162522: TYPE t_array_source_33 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
162523: TYPE t_array_source_34 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
162524: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

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

162520: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
162521: TYPE t_array_source_32 IS TABLE OF PO_DISTS_REF_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
162522: TYPE t_array_source_33 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
162523: TYPE t_array_source_34 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
162524: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
162525:
162526: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
162527: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
162528: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 162583: , CST_XLA_RCV_HEADERS_V h1

162579: , h4.CURRENCY_CONVERSION_RATE source_34
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

Line 163459: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'

163455: FROM (
163456: SELECT xet.event_id event_id
163457: , 0 line_number
163458: , CASE r
163459: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
163460: WHEN 2 THEN 'PO_DISTS_REF_V'
163461: WHEN 3 THEN 'PO_DISTS_REF_V'
163462: WHEN 4 THEN 'PO_DISTS_REF_V'
163463: WHEN 5 THEN 'PO_DISTS_REF_V'

Line 163464: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'

163460: WHEN 2 THEN 'PO_DISTS_REF_V'
163461: WHEN 3 THEN 'PO_DISTS_REF_V'
163462: WHEN 4 THEN 'PO_DISTS_REF_V'
163463: WHEN 5 THEN 'PO_DISTS_REF_V'
163464: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
163465:
163466: ELSE null
163467: END object_name
163468: , CASE r

Line 163516: , CST_XLA_RCV_HEADERS_V h1

163512:
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

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

163780: --
163781: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
163782: --
163783:
163784: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
163785: TYPE t_array_source_32 IS TABLE OF PO_DISTS_REF_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
163786: TYPE t_array_source_33 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
163787: TYPE t_array_source_34 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
163788: TYPE t_array_source_36 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

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

163785: TYPE t_array_source_32 IS TABLE OF PO_DISTS_REF_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
163786: TYPE t_array_source_33 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
163787: TYPE t_array_source_34 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
163788: TYPE t_array_source_36 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
163789: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
163790:
163791: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
163792: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
163793: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 163850: , CST_XLA_RCV_HEADERS_V h1

163846: , h4.CURRENCY_CONVERSION_TYPE source_36
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

Line 171050: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_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'
171054: WHEN 10 THEN 'CST_XLA_RCV_REF_V'

Line 171053: WHEN 9 THEN 'CST_XLA_RCV_HEADERS_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'
171057: WHEN 13 THEN 'CST_XLA_RCV_HEADERS_V'

Line 171056: WHEN 12 THEN 'CST_XLA_RCV_HEADERS_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'
171059: WHEN 15 THEN 'PO_HEADERS_REF_V'
171060: WHEN 16 THEN 'CST_XLA_RCV_HEADERS_V'

Line 171057: WHEN 13 THEN 'CST_XLA_RCV_HEADERS_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'
171059: WHEN 15 THEN 'PO_HEADERS_REF_V'
171060: WHEN 16 THEN 'CST_XLA_RCV_HEADERS_V'
171061:

Line 171058: WHEN 14 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'
171059: WHEN 15 THEN 'PO_HEADERS_REF_V'
171060: WHEN 16 THEN 'CST_XLA_RCV_HEADERS_V'
171061:
171062: ELSE null

Line 171060: WHEN 16 THEN 'CST_XLA_RCV_HEADERS_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'
171059: WHEN 15 THEN 'PO_HEADERS_REF_V'
171060: WHEN 16 THEN 'CST_XLA_RCV_HEADERS_V'
171061:
171062: ELSE null
171063: END object_name
171064: , CASE r

Line 171152: , CST_XLA_RCV_HEADERS_V h1

171148:
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

Line 171427: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%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;
171431: TYPE t_array_source_16 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 171430: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%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;
171434: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 171433: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%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;
171436: TYPE t_array_source_23 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
171437: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 171434: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%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;
171436: TYPE t_array_source_23 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
171437: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
171438:

Line 171435: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%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;
171436: TYPE t_array_source_23 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
171437: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
171438:
171439: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 171437: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%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;
171436: TYPE t_array_source_23 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
171437: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
171438:
171439: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
171440: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
171441: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 171518: , CST_XLA_RCV_HEADERS_V h1

171514: , h5.PURCH_ENCUMBRANCE_TYPE_ID source_23
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

Line 174003: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'

173999: FROM (
174000: SELECT xet.event_id event_id
174001: , 0 line_number
174002: , CASE r
174003: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
174004: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
174005: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
174006: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
174007: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'

Line 174004: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'

174000: SELECT xet.event_id event_id
174001: , 0 line_number
174002: , CASE r
174003: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
174004: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
174005: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
174006: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
174007: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'
174008: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'

Line 174005: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'

174001: , 0 line_number
174002: , CASE r
174003: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
174004: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
174005: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
174006: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
174007: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'
174008: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
174009:

Line 174006: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'

174002: , CASE r
174003: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
174004: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
174005: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
174006: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
174007: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'
174008: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
174009:
174010: ELSE null

Line 174007: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'

174003: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
174004: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
174005: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
174006: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
174007: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'
174008: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
174009:
174010: ELSE null
174011: END object_name

Line 174008: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'

174004: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
174005: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
174006: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
174007: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'
174008: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
174009:
174010: ELSE null
174011: END object_name
174012: , CASE r

Line 174060: , CST_XLA_RCV_HEADERS_V h1

174056:
174057: ELSE null
174058: END source_meaning
174059: FROM xla_events_gt xet
174060: , CST_XLA_RCV_HEADERS_V h1
174061: , fnd_lookup_values fvl12
174062: , fnd_lookup_values fvl38
174063: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
174064: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

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

174322: --
174323: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
174324: --
174325:
174326: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
174327: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
174328: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
174329: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
174330: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

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

174323: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
174324: --
174325:
174326: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
174327: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
174328: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
174329: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
174330: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
174331: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

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

174324: --
174325:
174326: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
174327: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
174328: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
174329: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
174330: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
174331: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
174332:

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

174325:
174326: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
174327: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
174328: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
174329: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
174330: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
174331: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
174332:
174333: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

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

174326: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
174327: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
174328: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
174329: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
174330: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
174331: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
174332:
174333: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
174334: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

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

174327: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
174328: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
174329: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
174330: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
174331: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
174332:
174333: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
174334: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
174335: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 174392: , CST_XLA_RCV_HEADERS_V h1

174388: , h1.CURRENCY_CONVERSION_TYPE source_21
174389: , h1.TRANSFER_TO_GL_INDICATOR source_38
174390: , fvl38.meaning source_38_meaning
174391: FROM xla_events_gt xet
174392: , CST_XLA_RCV_HEADERS_V h1
174393: , fnd_lookup_values fvl12
174394: , fnd_lookup_values fvl38
174395: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
174396: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 176537: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'

176533: FROM (
176534: SELECT xet.event_id event_id
176535: , 0 line_number
176536: , CASE r
176537: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
176538: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
176539: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
176540: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
176541: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'

Line 176538: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'

176534: SELECT xet.event_id event_id
176535: , 0 line_number
176536: , CASE r
176537: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
176538: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
176539: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
176540: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
176541: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'
176542:

Line 176539: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'

176535: , 0 line_number
176536: , CASE r
176537: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
176538: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
176539: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
176540: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
176541: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'
176542:
176543: ELSE null

Line 176540: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'

176536: , CASE r
176537: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
176538: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
176539: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
176540: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
176541: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'
176542:
176543: ELSE null
176544: END object_name

Line 176541: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'

176537: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
176538: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
176539: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
176540: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
176541: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'
176542:
176543: ELSE null
176544: END object_name
176545: , CASE r

Line 176589: , CST_XLA_RCV_HEADERS_V h1

176585:
176586: ELSE null
176587: END source_meaning
176588: FROM xla_events_gt xet
176589: , CST_XLA_RCV_HEADERS_V h1
176590: , fnd_lookup_values fvl12
176591: , fnd_lookup_values fvl38
176592: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
176593: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

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

176851: --
176852: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
176853: --
176854:
176855: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
176856: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
176857: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
176858: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
176859: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

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

176852: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
176853: --
176854:
176855: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
176856: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
176857: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
176858: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
176859: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
176860:

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

176853: --
176854:
176855: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
176856: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
176857: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
176858: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
176859: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
176860:
176861: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

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

176854:
176855: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
176856: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
176857: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
176858: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
176859: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
176860:
176861: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
176862: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

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

176855: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
176856: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
176857: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
176858: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
176859: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
176860:
176861: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
176862: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
176863: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 176918: , CST_XLA_RCV_HEADERS_V h1

176914: , h1.CURRENCY_CONVERSION_RATE source_20
176915: , h1.TRANSFER_TO_GL_INDICATOR source_38
176916: , fvl38.meaning source_38_meaning
176917: FROM xla_events_gt xet
176918: , CST_XLA_RCV_HEADERS_V h1
176919: , fnd_lookup_values fvl12
176920: , fnd_lookup_values fvl38
176921: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
176922: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 177764: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'

177760: FROM (
177761: SELECT xet.event_id event_id
177762: , 0 line_number
177763: , CASE r
177764: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
177765: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
177766: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
177767: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
177768: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'

Line 177765: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'

177761: SELECT xet.event_id event_id
177762: , 0 line_number
177763: , CASE r
177764: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
177765: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
177766: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
177767: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
177768: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'
177769: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'

Line 177766: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'

177762: , 0 line_number
177763: , CASE r
177764: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
177765: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
177766: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
177767: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
177768: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'
177769: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
177770:

Line 177767: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'

177763: , CASE r
177764: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
177765: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
177766: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
177767: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
177768: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'
177769: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
177770:
177771: ELSE null

Line 177768: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'

177764: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
177765: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
177766: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
177767: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
177768: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'
177769: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
177770:
177771: ELSE null
177772: END object_name

Line 177769: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'

177765: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
177766: WHEN 3 THEN 'CST_XLA_RCV_HEADERS_V'
177767: WHEN 4 THEN 'CST_XLA_RCV_HEADERS_V'
177768: WHEN 5 THEN 'CST_XLA_RCV_HEADERS_V'
177769: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
177770:
177771: ELSE null
177772: END object_name
177773: , CASE r

Line 177821: , CST_XLA_RCV_HEADERS_V h1

177817:
177818: ELSE null
177819: END source_meaning
177820: FROM xla_events_gt xet
177821: , CST_XLA_RCV_HEADERS_V h1
177822: , fnd_lookup_values fvl12
177823: , fnd_lookup_values fvl38
177824: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
177825: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

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

178083: --
178084: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
178085: --
178086:
178087: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
178088: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
178089: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
178090: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
178091: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

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

178084: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
178085: --
178086:
178087: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
178088: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
178089: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
178090: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
178091: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
178092: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

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

178085: --
178086:
178087: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
178088: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
178089: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
178090: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
178091: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
178092: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
178093:

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

178086:
178087: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
178088: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
178089: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
178090: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
178091: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
178092: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
178093:
178094: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

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

178087: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
178088: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
178089: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
178090: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
178091: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
178092: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
178093:
178094: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
178095: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

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

178088: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
178089: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
178090: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
178091: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
178092: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
178093:
178094: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
178095: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
178096: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 178153: , CST_XLA_RCV_HEADERS_V h1

178149: , h1.CURRENCY_CONVERSION_TYPE source_21
178150: , h1.TRANSFER_TO_GL_INDICATOR source_38
178151: , fvl38.meaning source_38_meaning
178152: FROM xla_events_gt xet
178153: , CST_XLA_RCV_HEADERS_V h1
178154: , fnd_lookup_values fvl12
178155: , fnd_lookup_values fvl38
178156: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
178157: and xet.event_class_code = C_EVENT_CLASS_CODE