VIEW: APPS.WSM_CO_PRODUCT_COMPONENTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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