DBA Data[Home] [Help]

APPS.WMS_SHIPPING_TRANSACTION_PUB dependencies on MTL_MATERIAL_STATUSES_VL

Line 5139: from mtl_system_items_kfv msik, mtl_material_statuses_vl mst

5135: l_serial_status_enabled VARCHAR2(1);
5136: begin
5137: select nvl(msik.serial_status_enabled,'N'), nvl(msik.default_Serial_status_id, -1), mst.status_code
5138: into l_serial_status_enabled, l_serial_status_id, l_serial_status_code
5139: from mtl_system_items_kfv msik, mtl_material_statuses_vl mst
5140: where msik.organization_id = p_organization_id
5141: and msik.inventory_item_id = p_inventory_item_id
5142: and msik.default_serial_status_id = mst.status_id(+);
5143: