APPS.WMS_TASK_LOAD dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 4801: AND lpn_id = p_lpn_id AND current_status = 3) = (SELECT Sum(primary_transaction_quantity) FROM mtl_onhand_quantities_detail

4797: SELECT '1' INTO l_check FROM DUAL WHERE (SELECT Count(1) FROM mtl_serial_numbers
4798: WHERE inventory_item_id = p_inventory_item_id
4799: AND current_organization_id = p_organization_id
4800: AND NVL(lot_number,'@@') = nvl(p_serial_lot_number,'@@')
4801: AND lpn_id = p_lpn_id AND current_status = 3) = (SELECT Sum(primary_transaction_quantity) FROM mtl_onhand_quantities_detail
4802: WHERE inventory_item_id = p_inventory_item_id
4803: AND NVL(lot_number,'@@') = nvl(p_serial_lot_number,'@@')
4804: AND lpn_id = p_lpn_id AND organization_id = p_organization_id );
4805:

Line 8460: FROM mtl_onhand_quantities_detail

8456: --/* Bug 9448490 Lot Substitution Project */ start
8457: CURSOR lot_substitution_alloc_csr IS
8458: SELECT NVL(SUM(primary_transaction_quantity),0)
8459: , lot_number , Nvl(Sum(secondary_transaction_quantity),0) --16267113
8460: FROM mtl_onhand_quantities_detail
8461: WHERE organization_id = p_org_id
8462: AND Nvl(containerized_flag, 2) = 1
8463: AND lpn_id = p_fromlpn_id
8464: AND subinventory_code = p_confirmed_sub

Line 11810: FROM mtl_onhand_quantities_detail

11806: -- bug 3983704
11807: -- get the packed qoh since the qty tree always return for both loosepack
11808: SELECT NVL(SUM(primary_transaction_quantity),0), NVL(SUM(secondary_transaction_quantity),0)
11809: INTO l_qoh, l_sqoh
11810: FROM mtl_onhand_quantities_detail
11811: WHERE lpn_id = p_fromlpn_id
11812: AND organization_id = p_org_id;
11813:
11814: IF l_fulfillment_base = 'S' THEN

Line 12098: FROM mtl_onhand_quantities_detail

12094: CURSOR lot_substitution_att IS
12095: SELECT NVL(SUM(primary_transaction_quantity),0)
12096: , NVL(SUM(transaction_quantity), 0)
12097: , lot_number
12098: FROM mtl_onhand_quantities_detail
12099: WHERE organization_id = p_org_id
12100: AND Nvl(containerized_flag, 2) = 2 -- different from lpn_match
12101: AND subinventory_code = p_confirmed_sub
12102: AND locator_id = p_confirmed_locator

Line 14864: FROM mtl_onhand_quantities_detail

14860:
14861: CURSOR lot_substitution_alloc_csr IS
14862: SELECT NVL(SUM(primary_transaction_quantity),0)
14863: , lot_number
14864: FROM mtl_onhand_quantities_detail
14865: WHERE organization_id = p_org_id
14866: AND Nvl(containerized_flag, 2) = 1 -- different from loose_match
14867: AND lpn_id = p_fromlpn_id
14868: AND subinventory_code = p_confirmed_sub

Line 14884: FROM mtl_onhand_quantities_detail

14880:
14881: CURSOR lot_substitution_loose_csr IS
14882: SELECT NVL(SUM(primary_transaction_quantity),0)
14883: , lot_number
14884: FROM mtl_onhand_quantities_detail
14885: WHERE organization_id = p_org_id
14886: AND Nvl(containerized_flag, 2) <> 1
14887: AND subinventory_code = p_confirmed_sub
14888: AND locator_id = p_confirmed_loc_id