|
应用 |
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 |
||||
|
处理模式 |
讯息提醒模式 |
||||||||
|
作业 |
讯息型态:显示 |
||||||||
|
讯息内容: 加工费的子装配件存在有效的工艺路线! |
|||||||||