检查装配件属性
应用 |
Oracle Purchasing |
层 Level |
Function |
||||||
函数名 Funcgtion Name |
MT_POXPOEPO/ 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 nvl(msi1.BUILD_IN_WIP_FLAG,'N') from apps.bom_bill_of_materials bbom, apps.bom_inventory_components bic, inv.mtl_system_items_b msi, inv.mtl_system_items_b msi1 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 NVL(BIC.DISABLE_DATE,SYSDATE+1) > SYSDATE and bbom.assembly_item_id = msi1.inventory_item_id and bbom.organization_id =msi1.organization_id and msi1.organization_id = FND_PROFILE.VALUE('MFG_ORGANIZATION_ID') and msi.organization_id =FND_PROFILE.VALUE('MFG_ORGANIZATION_ID') and msi.segment1 = :PO_LINES.ITEM_NUMBER and substr(msi.segment1,1,2)= '5h') ='N' and :PO_LINES.CREATED_BY IS NULL |
||||||||
处理模式 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 |
||||
处理模式 |
讯息提醒模式 |
||||||||
作业 |
讯息型态:显示 |
||||||||
讯息内容: 加工费对应的装配件属性为不可制造!请与数据维护人员联系! |