DBA Data[Home] [Help]

APPS.XLA_00707_AAD_S_000005_BC_PKG dependencies on CST_XLA_RCV_REF_V

Line 5972: WHEN 3 THEN 'CST_XLA_RCV_REF_V'

5968: , 0 line_number
5969: , CASE r
5970: WHEN 1 THEN 'PO_HEADERS_REF_V'
5971: WHEN 2 THEN 'PO_DISTS_REF_V'
5972: WHEN 3 THEN 'CST_XLA_RCV_REF_V'
5973: WHEN 4 THEN 'CST_XLA_RCV_REF_V'
5974: WHEN 5 THEN 'CST_XLA_RCV_REF_V'
5975: WHEN 6 THEN 'CST_XLA_RCV_REF_V'
5976: WHEN 7 THEN 'CST_XLA_RCV_HEADERS_V'

Line 5973: WHEN 4 THEN 'CST_XLA_RCV_REF_V'

5969: , CASE r
5970: WHEN 1 THEN 'PO_HEADERS_REF_V'
5971: WHEN 2 THEN 'PO_DISTS_REF_V'
5972: WHEN 3 THEN 'CST_XLA_RCV_REF_V'
5973: WHEN 4 THEN 'CST_XLA_RCV_REF_V'
5974: WHEN 5 THEN 'CST_XLA_RCV_REF_V'
5975: WHEN 6 THEN 'CST_XLA_RCV_REF_V'
5976: WHEN 7 THEN 'CST_XLA_RCV_HEADERS_V'
5977: WHEN 8 THEN 'PO_DISTS_REF_V'

Line 5974: WHEN 5 THEN 'CST_XLA_RCV_REF_V'

5970: WHEN 1 THEN 'PO_HEADERS_REF_V'
5971: WHEN 2 THEN 'PO_DISTS_REF_V'
5972: WHEN 3 THEN 'CST_XLA_RCV_REF_V'
5973: WHEN 4 THEN 'CST_XLA_RCV_REF_V'
5974: WHEN 5 THEN 'CST_XLA_RCV_REF_V'
5975: WHEN 6 THEN 'CST_XLA_RCV_REF_V'
5976: WHEN 7 THEN 'CST_XLA_RCV_HEADERS_V'
5977: WHEN 8 THEN 'PO_DISTS_REF_V'
5978: WHEN 9 THEN 'CST_XLA_RCV_REF_V'

Line 5975: WHEN 6 THEN 'CST_XLA_RCV_REF_V'

5971: WHEN 2 THEN 'PO_DISTS_REF_V'
5972: WHEN 3 THEN 'CST_XLA_RCV_REF_V'
5973: WHEN 4 THEN 'CST_XLA_RCV_REF_V'
5974: WHEN 5 THEN 'CST_XLA_RCV_REF_V'
5975: WHEN 6 THEN 'CST_XLA_RCV_REF_V'
5976: WHEN 7 THEN 'CST_XLA_RCV_HEADERS_V'
5977: WHEN 8 THEN 'PO_DISTS_REF_V'
5978: WHEN 9 THEN 'CST_XLA_RCV_REF_V'
5979: WHEN 10 THEN 'CST_XLA_RCV_HEADERS_V'

Line 5978: WHEN 9 THEN 'CST_XLA_RCV_REF_V'

5974: WHEN 5 THEN 'CST_XLA_RCV_REF_V'
5975: WHEN 6 THEN 'CST_XLA_RCV_REF_V'
5976: WHEN 7 THEN 'CST_XLA_RCV_HEADERS_V'
5977: WHEN 8 THEN 'PO_DISTS_REF_V'
5978: WHEN 9 THEN 'CST_XLA_RCV_REF_V'
5979: WHEN 10 THEN 'CST_XLA_RCV_HEADERS_V'
5980: WHEN 11 THEN 'CST_XLA_RCV_REF_V'
5981: WHEN 12 THEN 'PSA_CST_XLA_UPG_V'
5982: WHEN 13 THEN 'PO_HEADERS_REF_V'

Line 5980: WHEN 11 THEN 'CST_XLA_RCV_REF_V'

5976: WHEN 7 THEN 'CST_XLA_RCV_HEADERS_V'
5977: WHEN 8 THEN 'PO_DISTS_REF_V'
5978: WHEN 9 THEN 'CST_XLA_RCV_REF_V'
5979: WHEN 10 THEN 'CST_XLA_RCV_HEADERS_V'
5980: WHEN 11 THEN 'CST_XLA_RCV_REF_V'
5981: WHEN 12 THEN 'PSA_CST_XLA_UPG_V'
5982: WHEN 13 THEN 'PO_HEADERS_REF_V'
5983: WHEN 14 THEN 'CST_XLA_RCV_REF_V'
5984: WHEN 15 THEN 'CST_XLA_RCV_HEADERS_V'

Line 5983: WHEN 14 THEN 'CST_XLA_RCV_REF_V'

5979: WHEN 10 THEN 'CST_XLA_RCV_HEADERS_V'
5980: WHEN 11 THEN 'CST_XLA_RCV_REF_V'
5981: WHEN 12 THEN 'PSA_CST_XLA_UPG_V'
5982: WHEN 13 THEN 'PO_HEADERS_REF_V'
5983: WHEN 14 THEN 'CST_XLA_RCV_REF_V'
5984: WHEN 15 THEN 'CST_XLA_RCV_HEADERS_V'
5985:
5986: ELSE null
5987: END object_name

Line 6073: , CST_XLA_RCV_REF_V h3

6069: ELSE null
6070: END source_meaning
6071: FROM xla_events_gt xet
6072: , CST_XLA_RCV_HEADERS_V h1
6073: , CST_XLA_RCV_REF_V h3
6074: , PO_DISTS_REF_V h4
6075: , PO_HEADERS_REF_V h5
6076: , PSA_CST_XLA_UPG_V h6
6077: , fnd_lookup_values fvl13

Line 6329: TYPE t_array_source_7 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;

6325: --
6326:
6327: TYPE t_array_source_2 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
6328: TYPE t_array_source_3 IS TABLE OF PO_DISTS_REF_V.RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
6329: TYPE t_array_source_7 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
6330: TYPE t_array_source_8 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
6331: TYPE t_array_source_9 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
6332: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
6333: TYPE t_array_source_13 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 6330: TYPE t_array_source_8 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

6326:
6327: TYPE t_array_source_2 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
6328: TYPE t_array_source_3 IS TABLE OF PO_DISTS_REF_V.RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
6329: TYPE t_array_source_7 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
6330: TYPE t_array_source_8 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
6331: TYPE t_array_source_9 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
6332: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
6333: TYPE t_array_source_13 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
6334: TYPE t_array_source_14 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 6331: TYPE t_array_source_9 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

6327: TYPE t_array_source_2 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
6328: TYPE t_array_source_3 IS TABLE OF PO_DISTS_REF_V.RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
6329: TYPE t_array_source_7 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
6330: TYPE t_array_source_8 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
6331: TYPE t_array_source_9 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
6332: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
6333: TYPE t_array_source_13 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
6334: TYPE t_array_source_14 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
6335: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;

Line 6332: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;

6328: TYPE t_array_source_3 IS TABLE OF PO_DISTS_REF_V.RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
6329: TYPE t_array_source_7 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
6330: TYPE t_array_source_8 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
6331: TYPE t_array_source_9 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
6332: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
6333: TYPE t_array_source_13 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
6334: TYPE t_array_source_14 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
6335: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
6336: TYPE t_array_source_16 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 6335: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;

6331: TYPE t_array_source_9 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
6332: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
6333: TYPE t_array_source_13 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
6334: TYPE t_array_source_14 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
6335: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
6336: TYPE t_array_source_16 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
6337: TYPE t_array_source_17 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
6338: TYPE t_array_source_18 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
6339: TYPE t_array_source_19 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 6337: TYPE t_array_source_17 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

6333: TYPE t_array_source_13 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
6334: TYPE t_array_source_14 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
6335: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
6336: TYPE t_array_source_16 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
6337: TYPE t_array_source_17 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
6338: TYPE t_array_source_18 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
6339: TYPE t_array_source_19 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
6340: TYPE t_array_source_26 IS TABLE OF CST_XLA_RCV_REF_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
6341: TYPE t_array_source_37 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 6340: TYPE t_array_source_26 IS TABLE OF CST_XLA_RCV_REF_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

6336: TYPE t_array_source_16 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
6337: TYPE t_array_source_17 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
6338: TYPE t_array_source_18 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
6339: TYPE t_array_source_19 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
6340: TYPE t_array_source_26 IS TABLE OF CST_XLA_RCV_REF_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
6341: TYPE t_array_source_37 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
6342:
6343: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
6344: TYPE t_array_source_25 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 6415: , CST_XLA_RCV_REF_V h3

6411: , h1.TRANSFER_TO_GL_INDICATOR source_37
6412: , fvl37.meaning source_37_meaning
6413: FROM xla_events_gt xet
6414: , CST_XLA_RCV_HEADERS_V h1
6415: , CST_XLA_RCV_REF_V h3
6416: , PO_DISTS_REF_V h4
6417: , PO_HEADERS_REF_V h5
6418: , PSA_CST_XLA_UPG_V h6
6419: , fnd_lookup_values fvl13

Line 12158: WHEN 2 THEN 'CST_XLA_RCV_REF_V'

12154: SELECT xet.event_id event_id
12155: , 0 line_number
12156: , CASE r
12157: WHEN 1 THEN 'PO_HEADERS_REF_V'
12158: WHEN 2 THEN 'CST_XLA_RCV_REF_V'
12159: WHEN 3 THEN 'CST_XLA_RCV_REF_V'
12160: WHEN 4 THEN 'CST_XLA_RCV_REF_V'
12161: WHEN 5 THEN 'CST_XLA_RCV_REF_V'
12162: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'

Line 12159: WHEN 3 THEN 'CST_XLA_RCV_REF_V'

12155: , 0 line_number
12156: , CASE r
12157: WHEN 1 THEN 'PO_HEADERS_REF_V'
12158: WHEN 2 THEN 'CST_XLA_RCV_REF_V'
12159: WHEN 3 THEN 'CST_XLA_RCV_REF_V'
12160: WHEN 4 THEN 'CST_XLA_RCV_REF_V'
12161: WHEN 5 THEN 'CST_XLA_RCV_REF_V'
12162: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
12163: WHEN 7 THEN 'PO_DISTS_REF_V'

Line 12160: WHEN 4 THEN 'CST_XLA_RCV_REF_V'

12156: , CASE r
12157: WHEN 1 THEN 'PO_HEADERS_REF_V'
12158: WHEN 2 THEN 'CST_XLA_RCV_REF_V'
12159: WHEN 3 THEN 'CST_XLA_RCV_REF_V'
12160: WHEN 4 THEN 'CST_XLA_RCV_REF_V'
12161: WHEN 5 THEN 'CST_XLA_RCV_REF_V'
12162: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
12163: WHEN 7 THEN 'PO_DISTS_REF_V'
12164: WHEN 8 THEN 'CST_XLA_RCV_REF_V'

Line 12161: WHEN 5 THEN 'CST_XLA_RCV_REF_V'

12157: WHEN 1 THEN 'PO_HEADERS_REF_V'
12158: WHEN 2 THEN 'CST_XLA_RCV_REF_V'
12159: WHEN 3 THEN 'CST_XLA_RCV_REF_V'
12160: WHEN 4 THEN 'CST_XLA_RCV_REF_V'
12161: WHEN 5 THEN 'CST_XLA_RCV_REF_V'
12162: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
12163: WHEN 7 THEN 'PO_DISTS_REF_V'
12164: WHEN 8 THEN 'CST_XLA_RCV_REF_V'
12165: WHEN 9 THEN 'CST_XLA_RCV_HEADERS_V'

Line 12164: WHEN 8 THEN 'CST_XLA_RCV_REF_V'

12160: WHEN 4 THEN 'CST_XLA_RCV_REF_V'
12161: WHEN 5 THEN 'CST_XLA_RCV_REF_V'
12162: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
12163: WHEN 7 THEN 'PO_DISTS_REF_V'
12164: WHEN 8 THEN 'CST_XLA_RCV_REF_V'
12165: WHEN 9 THEN 'CST_XLA_RCV_HEADERS_V'
12166: WHEN 10 THEN 'CST_XLA_RCV_REF_V'
12167: WHEN 11 THEN 'PO_HEADERS_REF_V'
12168: WHEN 12 THEN 'CST_XLA_RCV_REF_V'

Line 12166: WHEN 10 THEN 'CST_XLA_RCV_REF_V'

12162: WHEN 6 THEN 'CST_XLA_RCV_HEADERS_V'
12163: WHEN 7 THEN 'PO_DISTS_REF_V'
12164: WHEN 8 THEN 'CST_XLA_RCV_REF_V'
12165: WHEN 9 THEN 'CST_XLA_RCV_HEADERS_V'
12166: WHEN 10 THEN 'CST_XLA_RCV_REF_V'
12167: WHEN 11 THEN 'PO_HEADERS_REF_V'
12168: WHEN 12 THEN 'CST_XLA_RCV_REF_V'
12169: WHEN 13 THEN 'PSA_CST_XLA_PEA_UPG_V'
12170: WHEN 14 THEN 'CST_XLA_RCV_HEADERS_V'

Line 12168: WHEN 12 THEN 'CST_XLA_RCV_REF_V'

12164: WHEN 8 THEN 'CST_XLA_RCV_REF_V'
12165: WHEN 9 THEN 'CST_XLA_RCV_HEADERS_V'
12166: WHEN 10 THEN 'CST_XLA_RCV_REF_V'
12167: WHEN 11 THEN 'PO_HEADERS_REF_V'
12168: WHEN 12 THEN 'CST_XLA_RCV_REF_V'
12169: WHEN 13 THEN 'PSA_CST_XLA_PEA_UPG_V'
12170: WHEN 14 THEN 'CST_XLA_RCV_HEADERS_V'
12171:
12172: ELSE null

Line 12255: , CST_XLA_RCV_REF_V h3

12251: ELSE null
12252: END source_meaning
12253: FROM xla_events_gt xet
12254: , CST_XLA_RCV_HEADERS_V h1
12255: , CST_XLA_RCV_REF_V h3
12256: , PO_DISTS_REF_V h4
12257: , PO_HEADERS_REF_V h5
12258: , PSA_CST_XLA_PEA_UPG_V h6
12259: , fnd_lookup_values fvl13

Line 12510: TYPE t_array_source_7 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;

12506: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
12507: --
12508:
12509: TYPE t_array_source_2 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
12510: TYPE t_array_source_7 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
12511: TYPE t_array_source_8 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
12512: TYPE t_array_source_9 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
12513: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
12514: TYPE t_array_source_13 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 12511: TYPE t_array_source_8 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

12507: --
12508:
12509: TYPE t_array_source_2 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
12510: TYPE t_array_source_7 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
12511: TYPE t_array_source_8 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
12512: TYPE t_array_source_9 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
12513: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
12514: TYPE t_array_source_13 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
12515: TYPE t_array_source_14 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 12512: TYPE t_array_source_9 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

12508:
12509: TYPE t_array_source_2 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
12510: TYPE t_array_source_7 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
12511: TYPE t_array_source_8 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
12512: TYPE t_array_source_9 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
12513: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
12514: TYPE t_array_source_13 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
12515: TYPE t_array_source_14 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
12516: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;

Line 12513: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;

12509: TYPE t_array_source_2 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
12510: TYPE t_array_source_7 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
12511: TYPE t_array_source_8 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
12512: TYPE t_array_source_9 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
12513: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
12514: TYPE t_array_source_13 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
12515: TYPE t_array_source_14 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
12516: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
12517: TYPE t_array_source_16 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 12516: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;

12512: TYPE t_array_source_9 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
12513: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
12514: TYPE t_array_source_13 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
12515: TYPE t_array_source_14 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
12516: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
12517: TYPE t_array_source_16 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
12518: TYPE t_array_source_17 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12519: TYPE t_array_source_19 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
12520: TYPE t_array_source_26 IS TABLE OF CST_XLA_RCV_REF_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 12518: TYPE t_array_source_17 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

12514: TYPE t_array_source_13 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
12515: TYPE t_array_source_14 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
12516: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
12517: TYPE t_array_source_16 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
12518: TYPE t_array_source_17 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12519: TYPE t_array_source_19 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
12520: TYPE t_array_source_26 IS TABLE OF CST_XLA_RCV_REF_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
12521: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_PEA_UPG_V.CST_PEA_ENC_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
12522: TYPE t_array_source_37 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 12520: TYPE t_array_source_26 IS TABLE OF CST_XLA_RCV_REF_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

12516: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
12517: TYPE t_array_source_16 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
12518: TYPE t_array_source_17 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12519: TYPE t_array_source_19 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
12520: TYPE t_array_source_26 IS TABLE OF CST_XLA_RCV_REF_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
12521: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_PEA_UPG_V.CST_PEA_ENC_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
12522: TYPE t_array_source_37 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
12523:
12524: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 12594: , CST_XLA_RCV_REF_V h3

12590: , h1.TRANSFER_TO_GL_INDICATOR source_37
12591: , fvl37.meaning source_37_meaning
12592: FROM xla_events_gt xet
12593: , CST_XLA_RCV_HEADERS_V h1
12594: , CST_XLA_RCV_REF_V h3
12595: , PO_DISTS_REF_V h4
12596: , PO_HEADERS_REF_V h5
12597: , PSA_CST_XLA_PEA_UPG_V h6
12598: , fnd_lookup_values fvl13