Bills of Material Details Report

Bills of Material Details Report :

SELECT UNIQUE

MSI.SEGMENT1 " BILL NAME #",

MSI.DESCRIPTION " BILL DESC #",

MSI.PRIMARY_UNIT_OF_MEASURE "PRIMARY UOM #",

MSI.ITEM_TYPE "BILL TYPE #",

TO_CHAR(BBOM.CREATION_DATE,'DY DD-MON-YYYY HH:MI:SS AM') "BILL CREATION DATE #",

FU1.USER_NAME "BILL CREATED BY #",

TO_CHAR(BBOM.LAST_UPDATE_DATE,'DY DD-MON-YYYY HH:MI:SS AM') "BILL UPDATED DATE #",

FU2.USER_NAME "BILL LAST UPDATED BY #",

BIC.ITEM_NUM "ITEM NUMBER #",
BIC.OPERATION_SEQ_NUM "OPERATION SEQ NUMBER #",

MSI1.SEGMENT1 "COMPONENT ITEM NAME #",

MSI1.ITEM_TYPE "COMP TYPE #",

MSI1.DESCRIPTION "COMPONENT ITEM DESC #",

TO_CHAR(BIC.CREATION_DATE,'DY DD-MON-YYYY HH:MI:SS AM') "COMPONENT LINE CREATION DATE #",

FU3.USER_NAME "COMPONENT LINE CREATED BY #",

TO_CHAR(BIC.LAST_UPDATE_DATE,'DY DD-MON-YYYY HH:MI:SS AM') "COMPONENT LINE UPDATED DATE #",

FU4.USER_NAME "COMPON LINE LAST UPDATED BY #",

BIC.COMPONENT_QUANTITY "COMPONENT QUANTITY#",

TO_CHAR(BIC.DISABLE_DATE,'DY DD-MON-YYYY HH:MI:SS AM') "DISABLE DATE#"

FROM

APPS.BOM_BILL_OF_MATERIALS BBOM,

APPS.MTL_SYSTEM_ITEMS_B MSI,

APPS.BOM_INVENTORY_COMPONENTS BIC,

APPS.MTL_SYSTEM_ITEMS_B MSI1,

APPS.FND_USER FU1,

APPS.FND_USER FU2,

APPS.FND_USER FU3,

APPS.FND_USER FU4

WHERE

MSI.INVENTORY_ITEM_ID = BBOM.ASSEMBLY_ITEM_ID

AND BBOM.CREATED_BY=FU1.USER_ID

AND BBOM.LAST_UPDATED_BY=FU2.USER_ID

AND BIC.CREATED_BY=FU3.USER_ID

AND BIC.LAST_UPDATED_BY=FU4.USER_ID

AND MSI.ORGANIZATION_ID = BBOM.ORGANIZATION_ID

AND MSI.ORGANIZATION_ID = 121

AND MSI1.INVENTORY_ITEM_ID = BIC.COMPONENT_ITEM_ID

AND MSI1.ORGANIZATION_ID = 121

AND BBOM.BILL_SEQUENCE_ID = BIC.BILL_SEQUENCE_ID

AND BIC.DISABLE_DATE IS NULL

AND MSI.SEGMENT1 ='SRVS' -- Bill Name

ORDER BY

MSI.SEGMENT1,

BIC.ITEM_NUM,

BIC.OPERATION_SEQ_NUM