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 249: MTL_SECONDARY_INVENTORIES msi,

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

Line 250: MTL_SECONDARY_INVENTORIES MSISR

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

Line 6125: MTL_SECONDARY_INVENTORIES MSI,

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

Line 6155: FROM MTL_SECONDARY_INVENTORIES MSI

6151: IF x_to_subinventory_code IS NOT NULL THEN
6152: -- THIS SUB VALUE WAS SPECIFIED WHILE CREATING THE SO, JUST FIND THE UOM CODE
6153:
6154: SELECT PICK_UOM_CODE INTO x_repl_uom_code
6155: FROM MTL_SECONDARY_INVENTORIES MSI
6156: WHERE MSI.ORGANIZATION_ID = p_org_id
6157: and secondary_inventory_name = x_to_subinventory_code;
6158:
6159:

Line 6992: MTL_SECONDARY_INVENTORIES MSI

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