View: WSM_CO_PRODUCT_COMPONENTS_V

Product:	WSM - Shop Floor Management
Description:
Implementation/DBA Data:	APPS.WSM_CO_PRODUCT_COMPONENTS_V

View Text

SELECT BCP.ROWID
, BCP.CO_PRODUCT_GROUP_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.USAGE_RATE
, BCP.DUALITY_FLAG
, BCP.PLANNING_FACTOR
, BCP.COMPONENT_YIELD_FACTOR
, BCP.INCLUDE_IN_COST_ROLLUP
, BCP.WIP_SUPPLY_TYPE
, ML.MEANING
, BCP.SUPPLY_SUBINVENTORY
, BCP.SUPPLY_LOCATOR_ID
, BCP.COMPONENT_REMARKS
, BCP.COMP_ATTRIBUTE_CATEGORY
, BCP.COMP_ATTRIBUTE1
, BCP.COMP_ATTRIBUTE2
, BCP.COMP_ATTRIBUTE3
, BCP.COMP_ATTRIBUTE4
, BCP.COMP_ATTRIBUTE5
, BCP.COMP_ATTRIBUTE6
, BCP.COMP_ATTRIBUTE7
, BCP.COMP_ATTRIBUTE8
, BCP.COMP_ATTRIBUTE9
, BCP.COMP_ATTRIBUTE10
, BCP.COMP_ATTRIBUTE11
, BCP.COMP_ATTRIBUTE12
, BCP.COMP_ATTRIBUTE13
, BCP.COMP_ATTRIBUTE14
, BCP.COMP_ATTRIBUTE15
, BCP.REQUEST_ID
, BCP.PROGRAM_APPLICATION_ID
, BCP.PROGRAM_ID
, BCP.PROGRAM_UPDATE_DATE
, MSI.DESCRIPTION
, SUBSTR(WSMPCOGI.GET_ALTERNATE_DESIGNATOR (BCP.CO_PRODUCT_GROUP_ID)
, 1
, 10)
, MSI.INVENTORY_ASSET_FLAG
, MSI.LOCATION_CONTROL_CODE
, MSI.RESTRICT_LOCATORS_CODE
, DECODE ( MSI.RESTRICT_SUBINVENTORIES_CODE
, 1
, 'Y'
, 'N' )
, FCL.MEANING
, MSI.INVENTORY_ITEM_STATUS_CODE
FROM FND_COMMON_LOOKUPS FCL
, MFG_LOOKUPS ML
, MTL_SYSTEM_ITEMS MSI
, WSM_CO_PRODUCTS BCP
WHERE BCP.CO_PRODUCT_ID IS NULL
AND BCP.COMPONENT_ID = MSI.INVENTORY_ITEM_ID
AND BCP.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND ML.LOOKUP_TYPE ( + ) = 'WIP_SUPPLY'
AND ML.LOOKUP_CODE ( + ) = BCP.WIP_SUPPLY_TYPE
AND FCL.LOOKUP_TYPE ( + ) = 'ITEM_TYPE'
AND FCL.LOOKUP_CODE ( + ) = MSI.ITEM_TYPE

Columns