VIEW: APPS.WSM_CO_PROD_COMP_SUBSTITUTES_V

Source

View Text - Preformatted

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, bcp.basis_type 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

View Text - HTML Formatted

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
, BCP.BASIS_TYPE
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