VIEW: APPS.SO_LINE_DETAILS_VIEW_WIP_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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