Select MSI1.Segment1          上层编码,

       MSI1.Description           上层描述,

       MSI2.Segment1            下层编码,

       MSI2.Description           下层描述,

       MSI2.PRIMARY_UOM_CODE  计量单位,

       BIC.COMPONENT_QUANTITY 装配定额,

       BIC.CREATION_DATE         建立日期,

       BIC.EFFECTIVITY_DATE     生效日期,

       BIC.LAST_UPDATE_DATE   更改日期,

       BIC.DISABLE_DATE           失效日期,

       FU.DESCRIPTION              更新者

  From INV.MTL_SYSTEM_ITEMS_B       MSI1,

       apps.BOM_BILL_OF_MATERIALS    BBOM,

       apps.BOM_INVENTORY_COMPONENTS BIC,

       applsys.fnd_user             FU,

       INV.MTL_SYSTEM_ITEMS_B       MSI2

 Where MSI1.Organization_Id = x

And  BBOM.ASSEMBLY_ITEM_ID = MSI1.INVENTORY_ITEM_ID And

 And BBOM.Organization_Id = MSI1.Organization_Id And

 And BIC.BILL_SEQUENCE_ID = BBOM.BILL_SEQUENCE_ID And

 And MSI2.INVENTORY_ITEM_ID(+) = BIC.COMPONENT_ITEM_ID And

 And MSI2.Organization_Id = x

 And BBOM.ALTERNATE_BOM_DESIGNATOR IS NULL AND

 And BIC.LAST_UPDATED_BY = FU.USER_ID

 And (trunc(BIC.LAST_UPDATE_DATE) BETWEEN to_date('20**-01-01','yyyy-mm-dd')

 And to_date('20**-01-31','yyyy-mm-dd'))  --在此输入起始和终止时间

 ORDER BY MSI1.SEGMENT1