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_SECONDARY_INVENTORIES

Line 246: MTL_SECONDARY_INVENTORIES msi,

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
250: AND MISI.ORGANIZATION_ID = MSI.ORGANIZATION_ID

Line 247: MTL_SECONDARY_INVENTORIES MSISR

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
250: AND MISI.ORGANIZATION_ID = MSI.ORGANIZATION_ID
251: and MISI.INVENTORY_ITEM_ID = p_Item_id

Line 6295: MTL_SECONDARY_INVENTORIES MSI,

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
6299: AND MISI.SECONDARY_INVENTORY = MSI.SECONDARY_INVENTORY_NAME

Line 6326: FROM MTL_SECONDARY_INVENTORIES MSI

6322: IF x_to_subinventory_code IS NOT NULL THEN
6323: -- THIS SUB VALUE WAS SPECIFIED WHILE CREATING THE SO, JUST FIND THE UOM CODE
6324:
6325: SELECT PICK_UOM_CODE INTO x_repl_uom_code
6326: FROM MTL_SECONDARY_INVENTORIES MSI
6327: WHERE MSI.ORGANIZATION_ID = p_org_id
6328: and secondary_inventory_name = x_to_subinventory_code;
6329:
6330:

Line 7167: MTL_SECONDARY_INVENTORIES MSI

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
7171: AND nvl(MISI.SOURCE_SUBINVENTORY, '@@@') = NVL(p_src_sub , nvl(MISI.SOURCE_SUBINVENTORY,'@@@'))