DBA Data[Home] [Help]

APPS.WMS_PICK_DROP_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1496: FROM mtl_system_items_kfv msik

1492: , msik.lot_control_code lot_control
1493: , msik.serial_number_control_code serial_control
1494: , msik.primary_uom_code primary_uom_code
1495: , NVL(msik.allowed_units_lookup_code,2) uom_lookup_code
1496: FROM mtl_system_items_kfv msik
1497: WHERE msik.organization_id = p_org_id
1498: AND msik.inventory_item_id = p_item_id;
1499:
1500: c_item_rec c_item_info%ROWTYPE;

Line 10322: FROM mtl_system_items_kfv msik

10318: ( p_org_id IN NUMBER
10319: , p_item_id IN NUMBER
10320: ) IS
10321: SELECT concatenated_segments
10322: FROM mtl_system_items_kfv msik
10323: WHERE msik.organization_id = p_org_id
10324: AND msik.inventory_item_id = p_item_id;
10325:
10326: