VIEW: APPS.WSM_COPRODUCT_SPLIT_PERC_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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