VIEW: APPS.WSM_CO_PRODUCTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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