APPS.OPI_DBI_WMS_STORAGE_UTZ_PKG dependencies on OPI_DBI_INV_VALUE_F

Line 728: -- inventory value fact, OPI_DBI_INV_VALUE_F. Need to specifically

724: l_stmt_id := 30;
725: -- Extract the weight/volume conversion rates for all
726: -- distinct item/org pairs that belong to WMS enabled discrete
727: -- manufacturing organizations and that are already present in the
728: -- inventory value fact, OPI_DBI_INV_VALUE_F. Need to specifically
729: -- filter out process organizations here, because we only
730: -- join to the inventory value fact which has data from both, discrete
731: -- and process organizations.
732: --

Line 895: FROM opi_dbi_inv_value_f fact,

891: use_hash (fact, mp) */
892: DISTINCT
893: fact.organization_id,
894: fact.inventory_item_id
895: FROM opi_dbi_inv_value_f fact,
896: mtl_parameters mp
897: WHERE mp.wms_enabled_flag = 'Y'
898: AND fact.organization_id = mp.organization_id
899: AND fact.source = C_DISCRETE_ORGS

Line 934: value fact, OPI_DBI_INV_VALUE_F, for WMS enabled, discrete

930: Set up conversion rates in the reporting UOM conversion rates facts
931: for the weight and volume measures.
932:
933: The conversion rates are set up for all items in the inventory
934: value fact, OPI_DBI_INV_VALUE_F, for WMS enabled, discrete
935: manufacturing organizations.
936:
937: Currently only interested in conversion rates for weights/volumes.
938:

Line 1267: -- inventory value fact, OPI_DBI_INV_VALUE_F. Need to specifically

1263: l_stmt_id := 30;
1264: -- Extract the weight/volume conversion rates for all
1265: -- distinct item/org pairs that belong to WMS enabled discrete
1266: -- manufacturing organizations and that are already present in the
1267: -- inventory value fact, OPI_DBI_INV_VALUE_F. Need to specifically
1268: -- filter out process organizations here, because we only
1269: -- join to the inventory value fact which has data from both, discrete
1270: -- and process organizations.
1271: --

Line 1443: FROM opi_dbi_inv_value_f fact,

1439: (SELECT /*+ use_hash (fact, mp) */
1440: DISTINCT
1441: fact.organization_id,
1442: fact.inventory_item_id
1443: FROM opi_dbi_inv_value_f fact,
1444: mtl_parameters mp
1445: WHERE mp.wms_enabled_flag = 'Y'
1446: AND fact.organization_id = mp.organization_id
1447: AND fact.source = C_DISCRETE_ORGS

Line 1615: value fact, OPI_DBI_INV_VALUE_F, for WMS enabled, discrete

1611: Set up conversion rates in the reporting UOM conversion rates facts
1612: for the weight and volume measures.
1613:
1614: The conversion rates are set up for all items in the inventory
1615: value fact, OPI_DBI_INV_VALUE_F, for WMS enabled, discrete
1616: manufacturing organizations.
1617:
1618: Currently only interested in conversion rates for weights/volumes.
1619: