DBA Data[Home] [Help]

APPS.WMS_SHIPPING_TRANSACTION_PUB dependencies on MTL_MATERIAL_STATUSES_VL

Line 4979: from mtl_system_items_kfv msik, mtl_material_statuses_vl mst

4975: l_serial_status_enabled VARCHAR2(1);
4976: begin
4977: select nvl(msik.serial_status_enabled,'N'), nvl(msik.default_Serial_status_id, -1), mst.status_code
4978: into l_serial_status_enabled, l_serial_status_id, l_serial_status_code
4979: from mtl_system_items_kfv msik, mtl_material_statuses_vl mst
4980: where msik.organization_id = p_organization_id
4981: and msik.inventory_item_id = p_inventory_item_id
4982: and msik.default_serial_status_id = mst.status_id(+);
4983: