Product: | WSM - Shop Floor Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.WSM_CO_PROD_COMP_SUBSTITUTES_V |
SELECT BCS.ROWID
, BCS.SUBSTITUTE_COMPONENT_ID
, BCS.CREATION_DATE
, BCS.CREATED_BY
, BCS.LAST_UPDATE_DATE
, BCS.LAST_UPDATED_BY
, BCS.LAST_UPDATE_LOGIN
, BCS.CO_PRODUCT_GROUP_ID
, BCS.SUBSTITUTE_ITEM_QUANTITY
, BCS.ATTRIBUTE_CATEGORY
, BCS.ATTRIBUTE1
, BCS.ATTRIBUTE2
, BCS.ATTRIBUTE3
, BCS.ATTRIBUTE4
, BCS.ATTRIBUTE5
, BCS.ATTRIBUTE6
, BCS.ATTRIBUTE7
, BCS.ATTRIBUTE8
, BCS.ATTRIBUTE9
, BCS.ATTRIBUTE10
, BCS.ATTRIBUTE11
, BCS.ATTRIBUTE12
, BCS.ATTRIBUTE13
, BCS.ATTRIBUTE14
, BCS.ATTRIBUTE15
, BCS.REQUEST_ID
, BCS.PROGRAM_APPLICATION_ID
, BCS.PROGRAM_ID
, BCS.PROGRAM_UPDATE_DATE
, MSI.PRIMARY_UOM_CODE
, MSI.DESCRIPTION
FROM MTL_SYSTEM_ITEMS MSI
, WSM_CO_PRODUCTS BCP
, WSM_CO_PROD_COMP_SUBSTITUTES BCS
WHERE BCP.CO_PRODUCT_ID IS NULL
AND BCP.CO_PRODUCT_GROUP_ID = BCS.CO_PRODUCT_GROUP_ID
AND MSI.ORGANIZATION_ID = BCP.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = BCS.SUBSTITUTE_COMPONENT_ID