DBA Data[Home] [Help]

APPS.CSP_PICK_UTILS dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1618: FROM MTL_SYSTEM_ITEMS_KFV

1614: -- Check whether the item is under serial control and / or lot control.
1615: BEGIN
1616: SELECT nvl(lot_control_code, 1), nvl(serial_number_control_code,1)
1617: INTO l_item_lot_control_code, l_item_serial_control_code
1618: FROM MTL_SYSTEM_ITEMS_KFV
1619: WHERE inventory_item_id = l_csp_mtltxn_rec.inventory_item_id
1620: AND organization_id = l_csp_mtltxn_rec.organization_id;
1621:
1622: IF nvl(l_csp_mtltxn_rec.item_lot_control_code, 1) <> l_item_lot_control_code