View: BOM_BILL_ALTERNATES_V

Product:	BOM - Bills of Material
Description:	BOM_BILL_ALTERNATES_V resolves all foreign key references for the table BOM_BILL_ALTERNATES
Implementation/DBA Data:	APPS.BOM_BILL_ALTERNATES_V

View Text

SELECT BOM.ASSEMBLY_ITEM_ID
, BOM.ORGANIZATION_ID
, BOM.ALTERNATE_BOM_DESIGNATOR
, BOM.BILL_SEQUENCE_ID
, BOM.COMMON_BILL_SEQUENCE_ID
, BOM.ASSEMBLY_TYPE
, BAD.DESCRIPTION
FROM BOM_BILL_OF_MATERIALS BOM
, BOM_ALTERNATE_DESIGNATORS BAD
WHERE ( (BOM.ALTERNATE_BOM_DESIGNATOR IS NULL
AND BAD.ALTERNATE_DESIGNATOR_CODE IS NULL
AND BAD.ORGANIZATION_ID = -1) OR (BOM.ALTERNATE_BOM_DESIGNATOR = BAD.ALTERNATE_DESIGNATOR_CODE
AND BOM.ORGANIZATION_ID = BAD.ORGANIZATION_ID ) )

Columns