View: WSM_COMPONENTS_V

Product:	WSM - Shop Floor Management
Description:	Coproducts components view.
Implementation/DBA Data:	APPS.WSM_COMPONENTS_V

View Text

SELECT BOM1.ASSEMBLY_ITEM_ID
, BIC.COMPONENT_ITEM_ID
, BOM1.ORGANIZATION_ID
, BIC.COMPONENT_QUANTITY
, DECODE(BIC.COMPONENT_YIELD_FACTOR
, 0
, 1
, BIC.COMPONENT_YIELD_FACTOR) COMPONENT_YIELD_FACTOR
, BOM1.ALTERNATE_BOM_DESIGNATOR
FROM MTL_SYSTEM_ITEMS MSI
, BOM_INVENTORY_COMPONENTS BIC
, BOM_BILL_OF_MATERIALS BOM1
, BOM_BILL_OF_MATERIALS BOM2
WHERE BIC.BILL_SEQUENCE_ID = BOM2.BILL_SEQUENCE_ID
AND BOM1.COMMON_BILL_SEQUENCE_ID = BOM2.BILL_SEQUENCE_ID /* CZH: I-OED-2
, SHOULD ALLOW COMPONET THAT IS EFFECTIVE AS OF BOM_REV_DATE */ /*AND BIC.EFFECTIVITY_DATE <= SYSDATE
AND NVL(DISABLE_DATE
, SYSDATE + 1) > SYSDATE */
AND MSI.ORGANIZATION_ID = BOM1.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = BOM1.ASSEMBLY_ITEM_ID
AND MSI.BUILD_IN_WIP_FLAG = 'Y'
AND MSI.PICK_COMPONENTS_FLAG = 'N'
AND BIC.IMPLEMENTATION_DATE IS NOT NULL

Columns