Product: | WSM - Shop Floor Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.WSM_CO_PRODUCTS_V |
SELECT BCP.ROWID
, BCP.CO_PRODUCT_GROUP_ID
, BCP.CO_PRODUCT_ID
, BCP.COMPONENT_ID
, BCP.ORGANIZATION_ID
, BCP.COMPONENT_SEQUENCE_ID
, BCP.CREATION_DATE
, BCP.CREATED_BY
, BCP.LAST_UPDATE_DATE
, BCP.LAST_UPDATED_BY
, BCP.LAST_UPDATE_LOGIN
, BCP.EFFECTIVITY_DATE
, BCP.DISABLE_DATE
, BCP.PRIMARY_FLAG
, BCP.REVISION
, BCP.CHANGE_NOTICE
, BCP.USAGE_RATE
, BCP.SPLIT
, BCP.ATTRIBUTE_CATEGORY
, BCP.ATTRIBUTE1
, BCP.ATTRIBUTE2
, BCP.ATTRIBUTE3
, BCP.ATTRIBUTE4
, BCP.ATTRIBUTE5
, BCP.ATTRIBUTE6
, BCP.ATTRIBUTE7
, BCP.ATTRIBUTE8
, BCP.ATTRIBUTE9
, BCP.ATTRIBUTE10
, BCP.ATTRIBUTE11
, BCP.ATTRIBUTE12
, BCP.ATTRIBUTE13
, BCP.ATTRIBUTE14
, BCP.ATTRIBUTE15
, BCP.REQUEST_ID
, BCP.PROGRAM_APPLICATION_ID
, BCP.PROGRAM_ID
, BCP.PROGRAM_UPDATE_DATE
, MSI.DESCRIPTION
, BCP.IMPLEMENTATION_DATE
, BCP.BILL_SEQUENCE_ID
, BCP.ALTERNATE_DESIGNATOR
FROM MTL_SYSTEM_ITEMS MSI
, WSM_CO_PRODUCTS BCP
WHERE CO_PRODUCT_ID IS NOT NULL
AND BCP.CO_PRODUCT_ID = MSI.INVENTORY_ITEM_ID
AND BCP.ORGANIZATION_ID = MSI.ORGANIZATION_ID