VIEW: APPS.SO_LINE_DETAILS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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