APPS.WSH_USA_CATEGORIES_PVT dependencies on MTL_SYSTEM_ITEMS

Line 922: FROM mtl_system_items

918: wsp.export_screening_flag IN ('C','A') );
919: CURSOR C_specific_item_info(c_p_inventory_item_id number, c_p_organization_id number) IS
920: SELECT description, hazard_class_id, primary_uom_code, weight_uom_code,
921: unit_weight, volume_uom_code, unit_volume , decode(mtl_transactions_enabled_flag,'Y','Y','N') pickable_flag
922: FROM mtl_system_items
923: WHERE inventory_item_id = c_p_inventory_item_id
924: AND organization_id = c_p_organization_id;
925:
926: CURSOR c_det_status IS

Line 945: from mtl_system_items

941:
942: --bug#6407943: Begin
943: CURSOR C_item_details(c_organization_id NUMBER,c_item_id NUMBER) IS
944: SELECT primary_uom_code
945: from mtl_system_items
946: where inventory_item_id = c_item_id
947: and organization_id = c_organization_id ;
948: l_create_reservation VARCHAR2(1):='Y';
949: l_primary_uom VARCHAR2(3);