APPS.WMS_REPLENISHMENT_PVT dependencies on MTL_ITEM_SUB_INVENTORIES

Line 248: FROM MTL_ITEM_SUB_INVENTORIES MISI,

244: -- Get the source sub for destination location for the replenishment move order
245:
246: CURSOR c_get_source_sub IS
247: select MISI.SOURCE_SUBINVENTORY, MSISR.pick_uom_code, Nvl(MISI.max_minmax_quantity,0), NVL(MISI.FIXED_LOT_MULTIPLE, -1)
248: FROM MTL_ITEM_SUB_INVENTORIES MISI,
249: MTL_SECONDARY_INVENTORIES msi,
250: MTL_SECONDARY_INVENTORIES MSISR
251: WHERE MISI.organization_id = p_Org_id
252: AND MISI.SECONDARY_INVENTORY = MSI.SECONDARY_INVENTORY_NAME

Line 6124: from MTL_ITEM_SUB_INVENTORIES MISI,

6120: MSIB.PRIMARY_UOM_CODE,
6121: get_conversion_rate(MISI.INVENTORY_ITEM_id,
6122: MSI.PICK_UOM_CODE,
6123: MSIB.PRIMARY_UOM_CODE) AS CONVERSION_RATE
6124: from MTL_ITEM_SUB_INVENTORIES MISI,
6125: MTL_SECONDARY_INVENTORIES MSI,
6126: MTL_SYSTEM_ITEMS_B MSIB
6127: WHERE MISI.organization_id = P_Org_id
6128: and MISI.INVENTORY_ITEM_ID = P_Item_id

Line 6164: --from the item-subinventory table (MTL_ITEM_SUB_INVENTORIES).

6160: ELSE
6161: -- FIND THE TO_SUB BASED ON LOGIC BELOW
6162:
6163: -- 2.1- Get the item and find out possible destination-sub candidates
6164: --from the item-subinventory table (MTL_ITEM_SUB_INVENTORIES).
6165: -- Make sure that these subinventories have pick-uom defined as well.
6166:
6167: --2.2- Rank these subinventories in the decreasing order of pick-uom
6168: --conversion (with respect to primary UOM for the item) and 'Picking

Line 6991: from MTL_ITEM_SUB_INVENTORIES MISI,

6987: ORDER BY PICKING_ORDER;
6988:
6989: CURSOR c_trigger_parameters(P_ORG_ID NUMBER, p_item_id NUMBER, p_src_sub VARCHAR2, p_dest_sub VARCHAR2) IS
6990: SELECT MSI.PICK_UOM_CODE, MISI.FIXED_LOT_MULTIPLE
6991: from MTL_ITEM_SUB_INVENTORIES MISI,
6992: MTL_SECONDARY_INVENTORIES MSI
6993: where MISI.organization_id = p_org_id
6994: AND MISI.SOURCE_SUBINVENTORY = MSI.SECONDARY_INVENTORY_NAME
6995: AND MISI.ORGANIZATION_ID = MSI.ORGANIZATION_ID