View: BOMBV_SUBSTITUTE_BOM_COMPS

Product:	BOM - Bills of Material
Description:	- Retrofitted
Implementation/DBA Data:	APPS.BOMBV_SUBSTITUTE_BOM_COMPS

View Text

SELECT CO.EFFECTIVITY_DATE START_EFFECTIVITY_DATE
, CO.OPERATION_SEQ_NUM OPERATION_SEQUENCE_NUMBER
, BI.ALTERNATE_BOM_DESIGNATOR ALTERNATE_BOM_CODE
, '_KF:INV:MSTK:SY2' "_KF:COMPONENT_ITEM_NAME"
, '_KF:INV:MTLL:SY1' "_KF:BILL_ITEM_NAME"
, PA.ORGANIZATION_CODE ORGANIZATION_CODE
, AL.NAME ORGANIZATION_NAME
, SU.SUBSTITUTE_ITEM_QUANTITY SUBSTITUTE_ITEM_QUANTITY
, '_LA:SU.ACD_TYPE:MFG_LOOKUPS:ECG_ACTION:MEANING'
, SU.SUBSTITUTE_COMPONENT_ID
, SU.COMPONENT_SEQUENCE_ID
, BI.ORGANIZATION_ID
, SU.CHANGE_NOTICE
, SU.LAST_UPDATE_DATE UPDATED_ON
, SU.LAST_UPDATED_BY UPDATED_BY
, SU.CREATION_DATE CREATED_ON
, SU.CREATED_BY
FROM BOM_INVENTORY_COMPONENTS CO
, MTL_SYSTEM_ITEMS SY3
, MTL_SYSTEM_ITEMS SY2
, MTL_SYSTEM_ITEMS SY1
, MTL_PARAMETERS PA
, HR_ALL_ORGANIZATION_UNITS AL
, BOM_BILL_OF_MATERIALS BI
, BOM_SUBSTITUTE_COMPONENTS SU
WHERE SU.SUBSTITUTE_COMPONENT_ID = SY3.INVENTORY_ITEM_ID
AND BI.ORGANIZATION_ID = SY3.ORGANIZATION_ID
AND BI.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND BI.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND CO.COMPONENT_ITEM_ID = SY2.INVENTORY_ITEM_ID
AND BI.ORGANIZATION_ID = SY2.ORGANIZATION_ID
AND BI.ASSEMBLY_ITEM_ID = SY1.INVENTORY_ITEM_ID
AND BI.ORGANIZATION_ID = SY1.ORGANIZATION_ID
AND CO.BILL_SEQUENCE_ID = BI.BILL_SEQUENCE_ID
AND SU.COMPONENT_SEQUENCE_ID = CO.COMPONENT_SEQUENCE_ID
AND '_SEC:BI.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns