应用 | Oracle Purchasing | 层 Level | Function | ||||||
函数名 Funcgtion Name | PO_POXPOEPO | 表单名 Form Name | POXPOEPO | ||||||
说明 Description | 检查是否存在工艺路线(加工费采购订单自动生成任务时进行的对应检查) | ||||||||
条件 Condition | 触发器事件 Tirgger Event | WHEN-VALIDATE-RECORD | |||||||
触发器对象 Tirgger Object | PO_LINES | ||||||||
条件 Condition | substr(:PO_LINES.ITEM_NUMBER,1,2) = '5h' AND (SELECT COUNT(BOR.ASSEMBLY_ITEM_ID) FROM BOM_BILL_OF_MATERIALS BBOM, BOM_INVENTORY_COMPONENTS BIC, INV.MTL_SYSTEM_ITEMS_B MSI, BOM_OPERATIONAL_ROUTINGS bor, bom.bom_operation_sequences bos WHERE BBOM.BILL_SEQUENCE_ID = BIC.BILL_SEQUENCE_ID AND BBOM.ORGANIZATION_ID = MSI.ORGANIZATION_ID AND MSI.INVENTORY_ITEM_ID = BIC.COMPONENT_ITEM_ID AND bos.routing_sequence_id = bor.routing_sequence_id AND trunc(nvl(bos.disable_date,SYSDATE+1)) > SYSDATE and trunc(nvl(bic.disable_date,SYSDATE+1)) > SYSDATE AND bor.Assembly_Item_Id = BBOM.ASSEMBLY_ITEM_ID AND BOR.ORGANIZATION_ID = BBOM.ORGANIZATION_ID AND MSI.ORGANIZATION_ID = *** (REMARK: 组织ID) AND MSI.SEGMENT1 =:PO_LINES.ITEM_NUMBER) >0 | ||||||||
处理模式 Processing Mode | Not in Enter-Query Mode | ||||||||
上下文 层/值 Contest Level/Value | Responsibility/***职责 | ||||||||
活动 Actions | 序号 seq | 特性 Type | 说明 Description | 语言 Language | 消息类型 Message Type | Error | |||
10 | Message | / | ALL | 消息文本 Message Type | 加工费的子装配件存在有效的工艺路线! | ||||
20 | Builtin | / | ALL | 内置类型 Builtin Type | RAISE FORM_TIRGGER_FAILURE | ||||
处理模式 | 讯息提醒模式 | ||||||||
作业 | 讯息型态:显示 | ||||||||
讯息内容: 加工费的子装配件存在有效的工艺路线! |