IQC 收料个性化
拒收时不能输入仓库
条件：:OVERFLOW_AREA.PARENT_TRX_TYPE='Reject' 物件：
RCV_TRANSACTION.SUBINVENTORY
防止重复检验
条件：(:RCV_TRANSACTION.DESTINATION_TYPE_CODE = 'INVENTORY' or :RCV_TRANSACTION.DESTINATION_TYPE_CODE = 'SHOP FLOOR' OR (SELECT LAST_DAY(SYSDATE) - SYSDATE FROM DUAL)
物件：RCV_CONTROL.INSPECTION_BUT
1. 拒收不允许入库
条件：:RCV_TRANSACTION.LINE_CHKBOX = 'Y' AND :OVERFLOW_AREA.PARENT_TRX_TYPE or :OVERFLOW_AREA.PARENT_TRX_TYPE = '拒绝' 触发物件：RCV_TRANSACTION
= 'Reject'
2. 自动带出来料数量
条件：:Q_RES.DISPLAY1 IS NULL 触发物件：Q_RES.DISPLAY1 物件：Q_RES.QUANTITY
FQC 输入结果个性化： 1. 限制单号重复
条件：:Q_RES.DISPLAY1 IN (select character1 from QA_RESULTS_V WHERE NAME LIKE '%FQA%')
触发物件：Q_RES.JOB_NAME
2. 限制单号重复
条件：:Q_RES.DISPLAY1 IN (select character1 from QA_RESULTS_V WHERE NAME LIKE '%FQA%')
触发物件：Q_RES.DISPLAY4 --》课别
3. 限制单号重复
条件：:Q_RES.DISPLAY1 IN (select character1 from QA_RESULTS_V WHERE NAME LIKE '%FQA%')
触发物件：Q_RES
4. 自动编号
条件：fnd_global.USER_NAME '%LIAOJIANXIU' AND :Q_RES.DISPLAY1 IS NULL 触发物件：Q_RES.DISPLAY1 物件：Q_RES.DISPLAY1
SQL ：=SELECT 'FE'||(MAX(SUBSTR(CHARACTER1, 3, 6)) + 1) CHARACTER1 FROM QA_RESULTS_V
WHERE NAME LIKE '内销FQA 检验计划'
AND LENGTH(SUBSTR(CHARACTER1, 3, 6)) = 5
FQC 检验计划设定：
1. 输入工单号码带出料号：
SQL ：select segment1 from mtl_system_items where INVENTORY_ITEM_ID IN ( select PRIMARY_ITEM_ID
from WIP_DISCRETE_JOBS WHERE WIP_ENTITY_ID LIKE
(select WIP_ENTITY_ID from WIP_ENTITIES WHERE WIP_ENTITY_NAME LIKE &JOB)) AND ORGANIZATION_ID IN (select ORGANIZATION_ID from WIP_ENTITIES WHERE WIP_ENTITY_NAME LIKE &JOB);
工单发料个性化：
1. 禁止半成品库人员操作其他仓库
条件：fnd_global.USER_NAME not like 'MIS%' and fnd_global.RESP_NAME like '%半成品库%' and (:WIPTXMAT.SUBINVENTORY not in ('TP104','TP204','TP304') or :WIPTXMAT.CRITERIA_SUB not in ('TP104','TP204','TP304') or :WIPTXMAT.SUBINVENTORY is null or :WIPTXMAT.CRITERIA_SUB is null) 触发物件：
WIPTXMAT
2. 禁止半成品库人员操作其他仓库-行
条件：fnd_global.USER_NAME not like 'MIS%' and fnd_global.RESP_NAME like '%半成品库%' and (:MTL_TRX_LINE.SUBINVENTORY_CODE not in ('TP104','TP204','TP304') or :MTL_TRX_LINE.SUBINVENTORY_CODE is null)
触发物件：
MTL_TRX_LINE
3. 半成品库\成品库不允许超量发
条件：fnd_global.RESP_NAME like '%成品库%' AND (:MTL_TRX_LINE.TRANSACTION_QUANTITY>:MTL_TRX_LINE.NUMBER_OF_LOTS_ENTERED OR :MTL_TRX_LINE.NUMBER_OF_LOTS_ENTERED IS NULL)
触发物件：
MTL_TRX_LINE
工单完工入库个性化
1. 完工入库时检查QA 检验结果，不能超过允收量
条件：not exists (select 1
from dual
where (select nvl(sum(QUANTITY),0)
from QA_RESULTS
where PLAN_ID=103
and WIP_ENTITY_ID=:WIPTXCMP.WIP_ENTITY_ID
and CHARACTER10 '退貨nvl(sum(PRIMARY_QUANTITY),0)+:MTL_TRX_LINE.PRIMARY_QUANTITY from MTL_MATERIAL_TRANSACTIONS mmt
where 1=1
and mmt.TRANSACTION_TYPE_ID in (17,44)
and mmt.TRANSACTION_SOURCE_ID=:WIPTXCMP.WIP_ENTITY_ID
and mmt.ORGANIZATION_ID=:MTL_TRX_LINE.ORGANIZATION_ID)>=0 )
触发物件：MTL_TRX_LINE ')-(select
在个性化中定义变量及调用变量
1. 先定义变量
所有条件预设
使用变量
MRP 工作台个性化
1. 非预设采购员不能从工作台发放采购申请
条件： NOT EXISTS (SELECT 1
FROM FND_USER FU
,MTL_SYSTEM_ITEMS_B MSI
WHERE 1=1
AND MSI.BUYER_ID=FU.EMPLOYEE_ID
and msi.PLANNING_MAKE_BUY_CODE=2
AND MSI.INVENTORY_ITEM_ID=:MRP_ORDERS.INVENTORY_ITEM_ID and msi.organization_id=:parameter.org_id
AND FU.USER_NAME=FND_GLOBAL.USER_NAME
union all
select
1
from MTL_SYSTEM_ITEMS_B MSI
where msi.PLANNING_MAKE_BUY_CODE=1
AND MSI.INVENTORY_ITEM_ID=:MRP_ORDERS.INVENTORY_ITEM_ID
and msi.organization_id=:parameter.org_id )
触发物件：MRP_ORDERS
IQC 收料个性化
拒收时不能输入仓库
条件：:OVERFLOW_AREA.PARENT_TRX_TYPE='Reject' 物件：
RCV_TRANSACTION.SUBINVENTORY
防止重复检验
条件：(:RCV_TRANSACTION.DESTINATION_TYPE_CODE = 'INVENTORY' or :RCV_TRANSACTION.DESTINATION_TYPE_CODE = 'SHOP FLOOR' OR (SELECT LAST_DAY(SYSDATE) - SYSDATE FROM DUAL)
物件：RCV_CONTROL.INSPECTION_BUT
1. 拒收不允许入库
条件：:RCV_TRANSACTION.LINE_CHKBOX = 'Y' AND :OVERFLOW_AREA.PARENT_TRX_TYPE or :OVERFLOW_AREA.PARENT_TRX_TYPE = '拒绝' 触发物件：RCV_TRANSACTION
= 'Reject'
2. 自动带出来料数量
条件：:Q_RES.DISPLAY1 IS NULL 触发物件：Q_RES.DISPLAY1 物件：Q_RES.QUANTITY
FQC 输入结果个性化： 1. 限制单号重复
条件：:Q_RES.DISPLAY1 IN (select character1 from QA_RESULTS_V WHERE NAME LIKE '%FQA%')
触发物件：Q_RES.JOB_NAME
2. 限制单号重复
条件：:Q_RES.DISPLAY1 IN (select character1 from QA_RESULTS_V WHERE NAME LIKE '%FQA%')
触发物件：Q_RES.DISPLAY4 --》课别
3. 限制单号重复
条件：:Q_RES.DISPLAY1 IN (select character1 from QA_RESULTS_V WHERE NAME LIKE '%FQA%')
触发物件：Q_RES
4. 自动编号
条件：fnd_global.USER_NAME '%LIAOJIANXIU' AND :Q_RES.DISPLAY1 IS NULL 触发物件：Q_RES.DISPLAY1 物件：Q_RES.DISPLAY1
SQL ：=SELECT 'FE'||(MAX(SUBSTR(CHARACTER1, 3, 6)) + 1) CHARACTER1 FROM QA_RESULTS_V
WHERE NAME LIKE '内销FQA 检验计划'
AND LENGTH(SUBSTR(CHARACTER1, 3, 6)) = 5
FQC 检验计划设定：
1. 输入工单号码带出料号：
SQL ：select segment1 from mtl_system_items where INVENTORY_ITEM_ID IN ( select PRIMARY_ITEM_ID
from WIP_DISCRETE_JOBS WHERE WIP_ENTITY_ID LIKE
(select WIP_ENTITY_ID from WIP_ENTITIES WHERE WIP_ENTITY_NAME LIKE &JOB)) AND ORGANIZATION_ID IN (select ORGANIZATION_ID from WIP_ENTITIES WHERE WIP_ENTITY_NAME LIKE &JOB);
工单发料个性化：
1. 禁止半成品库人员操作其他仓库
条件：fnd_global.USER_NAME not like 'MIS%' and fnd_global.RESP_NAME like '%半成品库%' and (:WIPTXMAT.SUBINVENTORY not in ('TP104','TP204','TP304') or :WIPTXMAT.CRITERIA_SUB not in ('TP104','TP204','TP304') or :WIPTXMAT.SUBINVENTORY is null or :WIPTXMAT.CRITERIA_SUB is null) 触发物件：
WIPTXMAT
2. 禁止半成品库人员操作其他仓库-行
条件：fnd_global.USER_NAME not like 'MIS%' and fnd_global.RESP_NAME like '%半成品库%' and (:MTL_TRX_LINE.SUBINVENTORY_CODE not in ('TP104','TP204','TP304') or :MTL_TRX_LINE.SUBINVENTORY_CODE is null)
触发物件：
MTL_TRX_LINE
3. 半成品库\成品库不允许超量发
条件：fnd_global.RESP_NAME like '%成品库%' AND (:MTL_TRX_LINE.TRANSACTION_QUANTITY>:MTL_TRX_LINE.NUMBER_OF_LOTS_ENTERED OR :MTL_TRX_LINE.NUMBER_OF_LOTS_ENTERED IS NULL)
触发物件：
MTL_TRX_LINE
工单完工入库个性化
1. 完工入库时检查QA 检验结果，不能超过允收量
条件：not exists (select 1
from dual
where (select nvl(sum(QUANTITY),0)
from QA_RESULTS
where PLAN_ID=103
and WIP_ENTITY_ID=:WIPTXCMP.WIP_ENTITY_ID
and CHARACTER10 '退貨nvl(sum(PRIMARY_QUANTITY),0)+:MTL_TRX_LINE.PRIMARY_QUANTITY from MTL_MATERIAL_TRANSACTIONS mmt
where 1=1
and mmt.TRANSACTION_TYPE_ID in (17,44)
and mmt.TRANSACTION_SOURCE_ID=:WIPTXCMP.WIP_ENTITY_ID
and mmt.ORGANIZATION_ID=:MTL_TRX_LINE.ORGANIZATION_ID)>=0 )
触发物件：MTL_TRX_LINE ')-(select
在个性化中定义变量及调用变量
1. 先定义变量
所有条件预设
使用变量
MRP 工作台个性化
1. 非预设采购员不能从工作台发放采购申请
条件： NOT EXISTS (SELECT 1
FROM FND_USER FU
,MTL_SYSTEM_ITEMS_B MSI
WHERE 1=1
AND MSI.BUYER_ID=FU.EMPLOYEE_ID
and msi.PLANNING_MAKE_BUY_CODE=2
AND MSI.INVENTORY_ITEM_ID=:MRP_ORDERS.INVENTORY_ITEM_ID and msi.organization_id=:parameter.org_id
AND FU.USER_NAME=FND_GLOBAL.USER_NAME
union all
select
1
from MTL_SYSTEM_ITEMS_B MSI
where msi.PLANNING_MAKE_BUY_CODE=1
AND MSI.INVENTORY_ITEM_ID=:MRP_ORDERS.INVENTORY_ITEM_ID
and msi.organization_id=:parameter.org_id )
触发物件：MRP_ORDERS