View: SO_LINE_DETAILS_VIEW_WIP_V

Product:	OE - Order Entry
Description:
Implementation/DBA Data:	APPS.SO_LINE_DETAILS_VIEW_WIP_V

View Text

SELECT SLD.LINE_DETAIL_ID
, WIP.WIP_ENTITY_NAME WIP_ENTITY_NAME
, OE_QUERY.ITEM_CONC_SEG(SLD.INVENTORY_ITEM_ID
, FND_PROFILE.VALUE( 'SO_ORGANIZATION_ID' )) ITEM
, SLD.WIP_RESERVED_QUANTITY
, SLD.WIP_COMPLETED_QUANTITY
, SLD.SCHEDULE_STATUS_CODE
, UOM.UOM_CODE UOM_CODE
, NVL(MSI.DESCRIPTION
, 'NO DESCRIPTION AVAILABLE' ) ITEM_DESC
, SLD.SUPPLY_SOURCE_HEADER_ID
, SLD.LINE_ID
, SLD.CREATION_DATE
, SLD.CREATED_BY
, SLD.LAST_UPDATE_DATE
, SLD.LAST_UPDATED_BY
, SLD.LAST_UPDATE_LOGIN
, SLD.ROWID ROW_ID
FROM SO_LINE_DETAILS SLD
, MTL_UNITS_OF_MEASURE UOM
, MTL_SYSTEM_ITEMS_VL MSI
, WIP_ENTITIES WIP
WHERE UOM.UOM_CODE = NVL( SLD.UNIT_CODE
, 'EA' )
AND MSI.INVENTORY_ITEM_ID(+) = SLD.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID(+) = FND_PROFILE.VALUE('SO_ORGANIZATION_ID' )
AND WIP.WIP_ENTITY_ID(+) = SLD.SUPPLY_SOURCE_HEADER_ID

Columns