DBA Data[Home] [Help]

APPS.XLA_00707_AAD_S_000005_BC_PKG dependencies on PO_DISTS_REF_V

Line 5971: WHEN 2 THEN 'PO_DISTS_REF_V'

5967: SELECT xet.event_id event_id
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'

Line 5977: WHEN 8 THEN 'PO_DISTS_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'
5980: WHEN 11 THEN 'CST_XLA_RCV_REF_V'
5981: WHEN 12 THEN 'PSA_CST_XLA_UPG_V'

Line 6074: , PO_DISTS_REF_V h4

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
6078: , fnd_lookup_values fvl37

Line 6328: TYPE t_array_source_3 IS TABLE OF PO_DISTS_REF_V.RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;

6324: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%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;

Line 6334: TYPE t_array_source_14 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%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;
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;

Line 6416: , PO_DISTS_REF_V h4

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
6420: , fnd_lookup_values fvl37

Line 12163: WHEN 7 THEN 'PO_DISTS_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'
12166: WHEN 10 THEN 'CST_XLA_RCV_REF_V'
12167: WHEN 11 THEN 'PO_HEADERS_REF_V'

Line 12256: , PO_DISTS_REF_V h4

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
12260: , fnd_lookup_values fvl37

Line 12515: TYPE t_array_source_14 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%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;
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;

Line 12595: , PO_DISTS_REF_V h4

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
12599: , fnd_lookup_values fvl37

Line 13454: WHEN 2 THEN 'PO_DISTS_REF_V'

13450: SELECT xet.event_id event_id
13451: , 0 line_number
13452: , CASE r
13453: WHEN 1 THEN 'PO_HEADERS_REF_V'
13454: WHEN 2 THEN 'PO_DISTS_REF_V'
13455: WHEN 3 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
13456: WHEN 4 THEN 'CST_XLA_INV_REF_V'
13457: WHEN 5 THEN 'CST_XLA_INV_REF_V'
13458: WHEN 6 THEN 'CST_XLA_INV_REF_V'

Line 13462: WHEN 10 THEN 'PO_DISTS_REF_V'

13458: WHEN 6 THEN 'CST_XLA_INV_REF_V'
13459: WHEN 7 THEN 'CST_XLA_INV_REF_V'
13460: WHEN 8 THEN 'CST_XLA_INV_REF_V'
13461: WHEN 9 THEN 'CST_XLA_INV_HEADERS_V'
13462: WHEN 10 THEN 'PO_DISTS_REF_V'
13463: WHEN 11 THEN 'CST_XLA_INV_REF_V'
13464: WHEN 12 THEN 'CST_XLA_INV_REF_V'
13465: WHEN 13 THEN 'PSA_CST_XLA_UPG_V'
13466: WHEN 14 THEN 'PO_HEADERS_REF_V'

Line 13558: , PO_DISTS_REF_V h5

13554: FROM xla_events_gt xet
13555: , CST_XLA_INV_HEADERS_V h1
13556: , CST_XLA_INV_ORG_PARAMS_REF_V h3
13557: , CST_XLA_INV_REF_V h4
13558: , PO_DISTS_REF_V h5
13559: , PO_HEADERS_REF_V h6
13560: , PSA_CST_XLA_UPG_V h7
13561: , fnd_lookup_values fvl13
13562: , fnd_lookup_values fvl37

Line 13817: TYPE t_array_source_3 IS TABLE OF PO_DISTS_REF_V.RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;

13813: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
13814: --
13815:
13816: TYPE t_array_source_2 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
13817: TYPE t_array_source_3 IS TABLE OF PO_DISTS_REF_V.RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
13818: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
13819: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
13820: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
13821: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 13825: TYPE t_array_source_14 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

13821: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
13822: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
13823: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
13824: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
13825: TYPE t_array_source_14 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
13826: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
13827: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
13828: TYPE t_array_source_18 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
13829: TYPE t_array_source_19 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 13908: , PO_DISTS_REF_V h5

13904: FROM xla_events_gt xet
13905: , CST_XLA_INV_HEADERS_V h1
13906: , CST_XLA_INV_ORG_PARAMS_REF_V h3
13907: , CST_XLA_INV_REF_V h4
13908: , PO_DISTS_REF_V h5
13909: , PO_HEADERS_REF_V h6
13910: , PSA_CST_XLA_UPG_V h7
13911: , fnd_lookup_values fvl13
13912: , fnd_lookup_values fvl37