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.WIP_WPS_COMMON dependencies on MTL_ITEM_QUANTITIES_VIEW

Line 2044: MTL_ITEM_QUANTITIES_VIEW MOQ,

2040: IS
2041: CURSOR qoh_net_cur IS
2042: SELECT NVL(SUM(QUANTITY),0)
2043: FROM MTL_SECONDARY_INVENTORIES MSS,
2044: MTL_ITEM_QUANTITIES_VIEW MOQ,
2045: MTL_SYSTEM_ITEMS MSI
2046: WHERE MOQ.ORGANIZATION_ID = p_organization_id
2047: AND MSI.ORGANIZATION_ID = p_organization_id
2048: AND MSS.ORGANIZATION_ID = p_organization_id

Line 2055: FROM MTL_ITEM_QUANTITIES_VIEW MOQ

2051: AND MSS.SECONDARY_INVENTORY_NAME = MOQ.SUBINVENTORY_CODE
2052: AND MSS.AVAILABILITY_TYPE = 1;
2053: CURSOR qoh_all_cur IS
2054: SELECT NVL(SUM(QUANTITY),0)
2055: FROM MTL_ITEM_QUANTITIES_VIEW MOQ
2056: WHERE MOQ.ORGANIZATION_ID = p_organization_id
2057: AND MOQ.INVENTORY_ITEM_ID = p_inventory_item_id;
2058:
2059: l_on_hand NUMBER := 0;