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_OPP_CYC_COUNT dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 71: FROM MTL_ONHAND_QUANTITIES_DETAIL

67: BEGIN
68:
69: SELECT NVL ( SUM ( primary_transaction_quantity ), 0 )
70: INTO l_tot_qty
71: FROM MTL_ONHAND_QUANTITIES_DETAIL
72: WHERE inventory_item_id = p_inventory_item_id
73: AND organization_id = p_organization_id
74: AND subinventory_code = p_subinventory_code
75: AND locator_id = p_loc_id;

Line 549: FROM MTL_ONHAND_QUANTITIES_DETAIL

545: BEGIN
546:
547: SELECT NVL ( SUM ( primary_transaction_quantity ), 0 )
548: INTO l_tot_qty
549: FROM MTL_ONHAND_QUANTITIES_DETAIL
550: WHERE inventory_item_id = p_inventory_item_id
551: AND organization_id = p_organization_id
552: AND subinventory_code = p_subinventory_code
553: AND locator_id = p_loc_id

Line 854: FROM MTL_ONHAND_QUANTITIES_DETAIL

850: l_progress := '30';
851:
852: SELECT NVL ( SUM ( primary_transaction_quantity ), 0 )
853: INTO x_system_quantity
854: FROM MTL_ONHAND_QUANTITIES_DETAIL
855: WHERE inventory_item_id = p_inventory_item_id
856: AND organization_id = p_organization_id
857: AND subinventory_code = p_subinventory
858: AND locator_id = p_locator_id