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 #",
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
