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.WMS_REPLENISHMENT_PVT dependencies on MTL_ITEM_SUB_INVENTORIES

Line 245: FROM MTL_ITEM_SUB_INVENTORIES MISI,

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

Line 2743: FROM MTL_ITEM_SUB_INVENTORIES MISI

2739: x_create_qty := 0;
2740: RETURN;
2741: END IF;
2742: select MISI.SOURCE_SUBINVENTORY into l_next_lvl_src_sub
2743: FROM MTL_ITEM_SUB_INVENTORIES MISI
2744: WHERE MISI.organization_id = p_organization_id
2745: and MISI.INVENTORY_ITEM_ID = p_inventory_item_id
2746: and MISI.source_type = 3 --(for Subinventory)
2747: and MISI.SECONDARY_INVENTORY = l_mo_source_sub

Line 6294: from MTL_ITEM_SUB_INVENTORIES MISI,

6290: MSIB.PRIMARY_UOM_CODE,
6291: get_conversion_rate(MISI.INVENTORY_ITEM_id,
6292: MSI.PICK_UOM_CODE,
6293: MSIB.PRIMARY_UOM_CODE) AS CONVERSION_RATE
6294: from MTL_ITEM_SUB_INVENTORIES MISI,
6295: MTL_SECONDARY_INVENTORIES MSI,
6296: MTL_SYSTEM_ITEMS_B MSIB
6297: WHERE MISI.organization_id = P_Org_id
6298: and MISI.INVENTORY_ITEM_ID = P_Item_id

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

6331: ELSE
6332: -- FIND THE TO_SUB BASED ON LOGIC BELOW
6333:
6334: -- 2.1- Get the item and find out possible destination-sub candidates
6335: --from the item-subinventory table (MTL_ITEM_SUB_INVENTORIES).
6336: -- Make sure that these subinventories have pick-uom defined as well.
6337:
6338: --2.2- Rank these subinventories in the decreasing order of pick-uom
6339: --conversion (with respect to primary UOM for the item) and 'Picking

Line 7166: from MTL_ITEM_SUB_INVENTORIES MISI,

7162: ORDER BY PICKING_ORDER;
7163:
7164: CURSOR c_trigger_parameters(P_ORG_ID NUMBER, p_item_id NUMBER, p_src_sub VARCHAR2, p_dest_sub VARCHAR2) IS
7165: SELECT MSI.PICK_UOM_CODE, MISI.FIXED_LOT_MULTIPLE
7166: from MTL_ITEM_SUB_INVENTORIES MISI,
7167: MTL_SECONDARY_INVENTORIES MSI
7168: where MISI.organization_id = p_org_id
7169: AND MISI.SOURCE_SUBINVENTORY = MSI.SECONDARY_INVENTORY_NAME
7170: AND MISI.ORGANIZATION_ID = MSI.ORGANIZATION_ID