View: SO_LINE_DETAILS_V

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

View Text

SELECT D.ROWID ROW_ID
, D.LINE_DETAIL_ID
, D.CREATION_DATE
, D.CREATED_BY
, D.LAST_UPDATE_DATE
, D.LAST_UPDATED_BY
, D.LAST_UPDATE_LOGIN
, D.LINE_ID
, D.INVENTORY_ITEM_ID
, D.INCLUDED_ITEM_FLAG
, D.COMPONENT_SEQUENCE_ID
, D.COMPONENT_CODE
, D.COMPONENT_RATIO
, D.SHIPPABLE_FLAG
, D.TRANSACTABLE_FLAG
, D.RESERVABLE_FLAG
, D.UNIT_CODE
, D.RELEASED_FLAG
, D.REQUIRED_FOR_REVENUE_FLAG
, D.QUANTITY
, D.WAREHOUSE_ID
, D.DEMAND_CLASS_CODE
, D.SCHEDULE_DATE
, D.REVISION
, D.LOT_NUMBER
, D.SUBINVENTORY
, D.CUSTOMER_REQUESTED_LOT_FLAG
, D.SCHEDULE_STATUS_CODE
, D.RECEIPT_STATUS_CODE
, D.SCHEDULE_LEVEL_CODE
, D.QUANTITY_SVRID
, D.WAREHOUSE_SVRID
, D.DEMAND_CLASS_SVRID
, D.DATE_SVRID
, D.REVISION_SVRID
, D.LOT_SVRID
, D.SUBINVENTORY_SVRID
, D.CUSTOMER_REQUESTED_SVRID
, D.DF_SVRID
, D.CONTEXT
, D.ATTRIBUTE1
, D.ATTRIBUTE2
, D.ATTRIBUTE3
, D.ATTRIBUTE4
, D.ATTRIBUTE5
, D.ATTRIBUTE6
, D.ATTRIBUTE7
, D.ATTRIBUTE8
, D.ATTRIBUTE9
, D.ATTRIBUTE10
, D.ATTRIBUTE11
, D.ATTRIBUTE12
, D.ATTRIBUTE13
, D.ATTRIBUTE14
, D.ATTRIBUTE15
, D.DELIVERY
, D.WIP_RESERVED_QUANTITY
, D.WIP_COMPLETED_QUANTITY
, D.SUPPLY_SOURCE_TYPE
, D.SUPPLY_SOURCE_HEADER_ID
, D.UPDATE_FLAG
, D.INVENTORY_LOCATION_ID
, D.CONFIGURATION_ITEM_FLAG
, D.LATEST_ACCEPTABLE_DATE
, D.LATEST_ACCEPTABLE_DATE_SVRID
, MTLP.ORGANIZATION_CODE WAREHOUSE
, DECODE(MTLT.REVISION_QTY_CONTROL_CODE
, 2
, 'Y'
, 'N' ) REVISION_CONTROL_FLAG
, DECODE(MTLT.LOT_CONTROL_CODE
, 2
, 'Y'
, 3
, 'Y'
, 'N') LOT_CONTROL_FLAG
, NVL(MTLT.INVENTORY_ASSET_FLAG
, 'Y' ) INVENTORY_ASSET_FLAG
, MTLV.CONCATENATED_SEGMENTS ITEM
, MTLVL.DESCRIPTION ITEM_DESCRIPTION
, NVL(MTLT.RESTRICT_SUBINVENTORIES_CODE
, 2) RESTRICT_SUBINVENTORIES_CODE
, LUP.MEANING SCHEDULE_STATUS
, LUP1.MEANING RECEIPT_STATUS
, D.DEP_PLAN_REQUIRED_FLAG
, D.DPW_ASSIGNED_FLAG
, D.DELIVERY_ID
, D. DEPARTURE_ID
, D. CUSTOMER_ITEM_ID
, D.LOAD_SEQ_NUMBER
, D.MASTER_CONTAINER_ITEM_ID
, D.DETAIL_CONTAINER_ITEM_ID
FROM SO_LINE_DETAILS D
, MTL_SYSTEM_ITEMS_KFV MTLV
, MTL_SYSTEM_ITEMS MTLT
, MTL_SYSTEM_ITEMS_VL MTLVL
, MTL_PARAMETERS MTLP
, SO_LOOKUPS LUP
, SO_LOOKUPS LUP1
WHERE D.INVENTORY_ITEM_ID = MTLV.INVENTORY_ITEM_ID
AND MTLV.ORGANIZATION_ID = FND_PROFILE.VALUE('SO_ORGANIZATION_ID')
AND D.INVENTORY_ITEM_ID = MTLT.INVENTORY_ITEM_ID (+)
AND D.WAREHOUSE_ID = MTLT.ORGANIZATION_ID (+)
AND D.WAREHOUSE_ID = MTLP.ORGANIZATION_ID (+)
AND MTLVL.INVENTORY_ITEM_ID = MTLV.INVENTORY_ITEM_ID
AND MTLVL.ORGANIZATION_ID = MTLV.ORGANIZATION_ID
AND LUP.LOOKUP_TYPE(+) = 'SCHEDULE STATUS'
AND LUP.LOOKUP_CODE(+) = D.SCHEDULE_STATUS_CODE
AND LUP1.LOOKUP_TYPE(+) = 'RECEIPT STATUS'
AND LUP1.LOOKUP_CODE(+) = D.RECEIPT_STATUS_CODE

Columns