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 WMS_LOADED_QUANTITIES_V

Line 93: FROM WMS_LOADED_QUANTITIES_V

89: BEGIN
90:
91: SELECT NVL ( SUM ( quantity ), 0 )
92: INTO l_loaded_sys_qty
93: FROM WMS_LOADED_QUANTITIES_V
94: WHERE inventory_item_id = p_inventory_item_id
95: AND organization_id = p_organization_id
96: AND subinventory_code = p_subinventory_code
97: AND locator_id = p_loc_id

Line 581: FROM WMS_LOADED_QUANTITIES_V

577: BEGIN
578:
579: SELECT NVL ( SUM ( quantity ), 0 )
580: INTO l_loaded_sys_qty
581: FROM WMS_LOADED_QUANTITIES_V
582: WHERE inventory_item_id = p_inventory_item_id
583: AND organization_id = p_organization_id
584: AND subinventory_code = p_subinventory_code
585: AND locator_id = p_loc_id

Line 866: FROM WMS_LOADED_QUANTITIES_V

862: AND NVL ( revision, 'XXX' ) = NVL ( p_revision, 'XXX' );
863:
864: SELECT NVL ( SUM ( quantity ), 0 )
865: INTO l_loaded_sys_qty
866: FROM WMS_LOADED_QUANTITIES_V
867: WHERE inventory_item_id = p_inventory_item_id
868: AND organization_id = p_organization_id
869: AND subinventory_code = p_subinventory
870: AND locator_id = p_locator_id