DBA Data[Home] [Help]

APPS.WMS_PICK_DROP_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1637: FROM mtl_system_items_kfv msik

1633: , msik.lot_control_code lot_control
1634: , msik.serial_number_control_code serial_control
1635: , msik.primary_uom_code primary_uom_code
1636: , NVL(msik.allowed_units_lookup_code,2) uom_lookup_code
1637: FROM mtl_system_items_kfv msik
1638: WHERE msik.organization_id = p_org_id
1639: AND msik.inventory_item_id = p_item_id;
1640:
1641: c_item_rec c_item_info%ROWTYPE;

Line 10645: FROM mtl_system_items_kfv msik

10641: ( p_org_id IN NUMBER
10642: , p_item_id IN NUMBER
10643: ) IS
10644: SELECT concatenated_segments
10645: FROM mtl_system_items_kfv msik
10646: WHERE msik.organization_id = p_org_id
10647: AND msik.inventory_item_id = p_item_id;
10648:
10649: