Product: | WSM - Shop Floor Management |
---|---|
Description: | View to obtain the split percentage data of all co-product relationships in an OSFM organization |
Implementation/DBA Data: | APPS.WSM_COPRODUCT_SPLIT_PERC_V |
SELECT BCP.ROWID ROW_ID
, BCP.CO_PRODUCT_GROUP_ID
, BCP.CO_PRODUCT_ID
, BCP.ORGANIZATION_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.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
FROM MTL_SYSTEM_ITEMS MSI
, WSM_COPRODUCT_SPLIT_PERC BCP
WHERE BCP.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND BCP.CO_PRODUCT_ID = MSI.INVENTORY_ITEM_ID