View: ENG_WEB_REF_DESIG_V

Product:	ENG - Engineering
Description:	Revised reference designators designed for use in Oracle self service web applications
Implementation/DBA Data:	APPS.ENG_WEB_REF_DESIG_V

View Text

SELECT BRD.COMPONENT_SEQUENCE_ID
, ML.MEANING ACTION
, BRD.COMPONENT_REFERENCE_DESIGNATOR
, BRD.REF_DESIGNATOR_COMMENT
FROM MFG_LOOKUPS ML
, BOM_REFERENCE_DESIGNATORS BRD
, ENG_REVISED_ITEMS ERI
, BOM_INVENTORY_COMPONENTS BIC
WHERE BRD.COMPONENT_SEQUENCE_ID = BIC.COMPONENT_SEQUENCE_ID
AND BIC.REVISED_ITEM_SEQUENCE_ID = ERI.REVISED_ITEM_SEQUENCE_ID
AND BRD.CHANGE_NOTICE = ERI.CHANGE_NOTICE
AND ML.LOOKUP_CODE = BRD.ACD_TYPE
AND ML.LOOKUP_TYPE = 'ENG_REF_DESIG_ACTION'

Columns