个性化经典案例.doc

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) =2) AND :OVERFLOW_AREA.ORDER_NUM NOT LIKE %WX 物件：RCV_CONTROL.INSPECTION_BUT 拒收不允许入库 条件：:RCV_TRANSACTION.LINE_CHKBOX = Y AND :OVERFLOW_AREA.PARENT_TRX_TYPE = Reject or :OVERFLOW_AREA.PARENT_TRX_TYPE = 拒绝 触发物件：RCV_TRANSACTION 自动带出来料数量 条件：:Q_RES.DISPLAY1 IS NULL 触发物件：Q_RES.DISPLAY1 物件：Q_RES.QUANTITY FQC输入结果个性化： 限制单号重复 条件：:Q_RES.DISPLAY1 IN (select character1 from QA_RESULTS_V WHERE NAME LIKE %FQA%) 触发物件：Q_RES.JOB_NAME 限制单号重复 条件：:Q_RES.DISPLAY1 IN (select character1 from QA_RESULTS_V WHERE NAME LIKE %FQA%) 触发物件：Q_RES.DISPLAY4 --》课别 限制单号重复 条件：:Q_RES.DISPLAY1 IN (select character1 from QA_RESULTS_V WHERE NAME LIKE %FQA%) 触发物件：Q_RES 自动编号 条件：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检验计划设定： 输入工单号码带出料号： 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); 工单发料个性化： 禁止半成品库人员操作其他仓库 条件：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 禁止半成品库人员操作其他仓库-行 条件：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.SUBINVE