DBA Data[Home] [Help]

APPS.WSMPINVL dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1210: from mtl_system_items_kfv

1206: l_serial_ctrl := 0;
1207:
1208: select nvl(serial_number_control_code,2)
1209: into l_serial_ctrl
1210: from mtl_system_items_kfv
1211: WHERE organization_id = crec.organization_id
1212: AND inventory_item_id = crec.inventory_item_id;
1213:
1214: IF l_serial_ctrl <> 1 then

Line 1671: from mtl_system_items_kfv

1667: l_serial_ctrl := 0;
1668:
1669: select nvl(serial_number_control_code,2)
1670: into l_serial_ctrl
1671: from mtl_system_items_kfv
1672: WHERE organization_id = crec.organization_id
1673: AND inventory_item_id = crec.inventory_item_id;
1674:
1675: IF l_serial_ctrl <> 1 then