View: BOM_SUB_COMPONENTS_VIEW

Product:	BOM - Bills of Material
Description:	Both implemented and unimplemented substitute components
Implementation/DBA Data:	APPS.BOM_SUB_COMPONENTS_VIEW

View Text

SELECT C.COMPONENT_SEQUENCE_ID
, B.SUBSTITUTE_COMPONENT_ID
, B.ACD_TYPE
, B.CHANGE_NOTICE
, B.SUBSTITUTE_ITEM_QUANTITY
, A.IMPLEMENTATION_DATE
, B.ATTRIBUTE_CATEGORY
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
, C.COMMON_COMPONENT_SEQUENCE_ID
, B.ENFORCE_INT_REQUIREMENTS
FROM BOM_INVENTORY_COMPONENTS A
, BOM_SUBSTITUTE_COMPONENTS B
, BOM_INVENTORY_COMPONENTS C
WHERE A.COMPONENT_SEQUENCE_ID = B.COMPONENT_SEQUENCE_ID
AND NVL(B.ACD_TYPE
, 1) <> 3
AND C.BILL_SEQUENCE_ID = A.BILL_SEQUENCE_ID
AND DECODE(C.IMPLEMENTATION_DATE
, NULL
, C.OLD_COMPONENT_SEQUENCE_ID
, C.COMPONENT_SEQUENCE_ID) = DECODE(A.IMPLEMENTATION_DATE
, NULL
, A.OLD_COMPONENT_SEQUENCE_ID
, A.COMPONENT_SEQUENCE_ID)
AND A.EFFECTIVITY_DATE = (SELECT MAX(C1.EFFECTIVITY_DATE)
FROM BOM_SUBSTITUTE_COMPONENTS S1
, BOM_INVENTORY_COMPONENTS C1
WHERE C1.COMPONENT_SEQUENCE_ID = S1.COMPONENT_SEQUENCE_ID
AND DECODE(C1.IMPLEMENTATION_DATE
, NULL
, C1.OLD_COMPONENT_SEQUENCE_ID
, C1.COMPONENT_SEQUENCE_ID) = DECODE(A.IMPLEMENTATION_DATE
, NULL
, A.OLD_COMPONENT_SEQUENCE_ID
, A.COMPONENT_SEQUENCE_ID)
AND C1.BILL_SEQUENCE_ID = C.BILL_SEQUENCE_ID
AND S1.SUBSTITUTE_COMPONENT_ID = B.SUBSTITUTE_COMPONENT_ID
AND C1.EFFECTIVITY_DATE <= C.EFFECTIVITY_DATE )

Columns