View: ENG_WEB_SUB_COMPS_V

Product:	ENG - Engineering
Description:	Revised substitute components designed for use in Oracle self service web applications
Implementation/DBA Data:	APPS.ENG_WEB_SUB_COMPS_V

View Text

SELECT BSC.COMPONENT_SEQUENCE_ID
, ML.MEANING ACTION
, MSI.CONCATENATED_SEGMENTS SUBSTITUTE_COMPONENT
, MSI.PADDED_CONCATENATED_SEGMENTS
, BSC.SUBSTITUTE_ITEM_QUANTITY
, MSI.PRIMARY_UOM_CODE
, MSI.DESCRIPTION
FROM MTL_SYSTEM_ITEMS_KFV MSI
, MFG_LOOKUPS ML
, BOM_SUBSTITUTE_COMPONENTS BSC
, ENG_REVISED_ITEMS ERI
, BOM_INVENTORY_COMPONENTS BIC
WHERE BIC.COMPONENT_SEQUENCE_ID = BSC.COMPONENT_SEQUENCE_ID
AND BIC.REVISED_ITEM_SEQUENCE_ID = ERI.REVISED_ITEM_SEQUENCE_ID
AND BSC.CHANGE_NOTICE = ERI.CHANGE_NOTICE
AND MSI.INVENTORY_ITEM_ID = BSC.SUBSTITUTE_COMPONENT_ID
AND MSI.ORGANIZATION_ID = ERI.ORGANIZATION_ID
AND ML.LOOKUP_CODE = BSC.ACD_TYPE
AND ML.LOOKUP_TYPE = 'ENG_REF_DESIG_ACTION'

Columns