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 ) )
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 ) )
|
|
|