Oracle EBS-SQL (BOM-3):检查期间新增Bom数量.sql
--本周系统BOM汇总记录SELECT
ITM.SEGMENT1物料编码,
ITM.DESCRIPTION 物料描述,
bom2.CREATION_DATE 创建日期,
BOM2.ALTERNATE_BOM_DESIGNATOR替代项,
FU.description 操作者
FROM INV.MTL_SYSTEM_ITEMS_B ITM,
apps.BOM_BILL_OF_MATERIALS bom2 ,
applsys.fnd_userFU
WHERE
ITM.INVENTORY_ITEM_STATUS_CODE = 'Active' AND
EXISTS
(
SELECTCOM.COMPONENT_ITEM_ID
FROMapps.BOM_INVENTORY_COMPONENTS COM,
apps.BOM_BILL_OF_MATERIALS BOM
WHERE
ROWNUM=1 AND
COM.EFFECTIVITY_DATE<=SYSDATE AND
(COM.DISABLE_DATE IS NULL OR COM.DISABLE_DATE>SYSDATE)AND
BOM.BILL_SEQUENCE_ID=COM.BILL_SEQUENCE_ID AND
BOM.ASSEMBLY_ITEM_ID=ITM.INVENTORY_ITEM_ID AND
BOM.ORGANIZATION_ID=ITM.ORGANIZATION_ID) AND
ITM.ORGANIZATION_ID =x AND
bom2.ASSEMBLY_ITEM_ID=itm.inventory_item_id AND
bom2.ORGANIZATION_ID =x AND
FU.USER_ID=BOM2.CREATED_BY AND
(trunc(bom2.CREATION_DATE) Between to_date('20**-01-01','yyyy-mm-dd') AND to_date('20**-01-31','yyyy-mm-dd')
) --在此处输入时间范围（月－日－年）
页:
[1]