APPS.WSH_USA_CATEGORIES_PVT dependencies on MTL_SYSTEM_ITEMS

Line 944: FROM mtl_system_items

940: wsp.export_screening_flag IN ('C','A') );
941: CURSOR C_specific_item_info(c_p_inventory_item_id number, c_p_organization_id number) IS
942: SELECT description, hazard_class_id, primary_uom_code, weight_uom_code,
943: unit_weight, volume_uom_code, unit_volume , decode(mtl_transactions_enabled_flag,'Y','Y','N') pickable_flag
944: FROM mtl_system_items
945: WHERE inventory_item_id = c_p_inventory_item_id
946: AND organization_id = c_p_organization_id;
947:
948: --Bug#8518110 : item sub. is enabled for backorder dds also

Line 968: from mtl_system_items

964:
965: --bug#6407943: Begin
966: CURSOR C_item_details(c_organization_id NUMBER,c_item_id NUMBER) IS
967: SELECT primary_uom_code
968: from mtl_system_items
969: where inventory_item_id = c_item_id
970: and organization_id = c_organization_id ;
971: l_create_reservation VARCHAR2(1):='Y';
972: l_primary_uom VARCHAR2(3);