View: SO_PICKING_LINE_DET_OEXORRSO_V

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

View Text

SELECT SOPLD.ATTRIBUTE1
, SOPLD.ATTRIBUTE10
, SOPLD.ATTRIBUTE11
, SOPLD.ATTRIBUTE12
, SOPLD.ATTRIBUTE13
, SOPLD.ATTRIBUTE14
, SOPLD.ATTRIBUTE15
, SOPLD.ATTRIBUTE2
, SOPLD.ATTRIBUTE3
, SOPLD.ATTRIBUTE4
, SOPLD.ATTRIBUTE5
, SOPLD.ATTRIBUTE6
, SOPLD.ATTRIBUTE7
, SOPLD.ATTRIBUTE8
, SOPLD.ATTRIBUTE9
, SOPLD.AUTOSCHEDULED_FLAG
, SOPLD.CONTEXT
, SOPLD.CREATED_BY
, SOPLD.CREATION_DATE
, SOPLD.CUSTOMER_REQUESTED_LOT_FLAG
, SOPLD.DELIVERY
, SOPLD.DEMAND_CLASS_CODE
, SOPLD.DEMAND_ID
, SOPLD.DETAIL_TYPE_CODE
, SOPLD.INVENTORY_LOCATION_ID
, SOPLD.INVENTORY_LOCATION_SEGMENTS
, SOPLD.LAST_UPDATED_BY
, SOPLD.LAST_UPDATE_DATE
, SOPLD.LAST_UPDATE_LOGIN
, SOPLD.LATEST_ACCEPTABLE_DATE
, SOPLD.LOT_NUMBER
, SOPLD.PICKING_LINE_DETAIL_ID
, SOPLD.PICKING_LINE_ID
, SOPLD.PROGRAM_APPLICATION_ID
, SOPLD.PROGRAM_ID
, SOPLD.PROGRAM_UPDATE_DATE
, SOPLD.RELEASED_FLAG
, SOPLD.REQUESTED_QUANTITY
, SOPLD.REQUEST_ID
, SOPLD.RESERVABLE_FLAG
, SOPLD.REVISION
, SOPLD.SCHEDULE_DATE
, SOPLD.SCHEDULE_LEVEL
, SOPLD.SCHEDULE_STATUS_CODE
, SOPLD.SEGMENT1
, SOPLD.SEGMENT10
, SOPLD.SEGMENT11
, SOPLD.SEGMENT12
, SOPLD.SEGMENT13
, SOPLD.SEGMENT14
, SOPLD.SEGMENT15
, SOPLD.SEGMENT16
, SOPLD.SEGMENT17
, SOPLD.SEGMENT18
, SOPLD.SEGMENT19
, SOPLD.SEGMENT2
, SOPLD.SEGMENT20
, SOPLD.SEGMENT3
, SOPLD.SEGMENT4
, SOPLD.SEGMENT5
, SOPLD.SEGMENT6
, SOPLD.SEGMENT7
, SOPLD.SEGMENT8
, SOPLD.SEGMENT9
, SOPLD.SERIAL_NUMBER
, SOPLD.SHIPPED_QUANTITY
, SOPLD.SUBINVENTORY
, SOPLD.SUPPLY_SOURCE_HEADER_ID
, SOPLD.SUPPLY_SOURCE_TYPE
, SOPLD.TRANSACTABLE_FLAG
, SOPLD.UPDATE_FLAG
, SOPLD.WAREHOUSE_ID
, SOPLD.WIP_COMPLETED_QUANTITY
, SOPLD.WIP_RESERVED_QUANTITY
, SOPLD.ROWID ROW_ID
, MTLP.ORGANIZATION_CODE WAREHOUSE
, DECODE(MTL.REVISION_QTY_CONTROL_CODE
, 2
, 'Y'
, 'N') REVISION_CONTROL_FLAG
, DECODE(MTL.LOT_CONTROL_CODE
, 2
, 'Y'
, 3
, 'Y'
, 'N') LOT_CONTROL_FLAG
, NVL(MTL.INVENTORY_ASSET_FLAG
, 'Y') INVENTORY_ASSET_FLAG
, MTLKFV.CONCATENATED_SEGMENTS ITEM
, MTLKFV.DESCRIPTION ITEM_DESCRIPTION
, NVL(MTL.RESTRICT_SUBINVENTORIES_CODE
, 2) RESTRICT_SUBINVENTORIES_CODE
, LUP.MEANING SCHEDULE_STATUS
, MTL.SO_TRANSACTIONS_FLAG SO_TRANSACTIONS_FLAG
, MTL.RESERVABLE_TYPE RESERVABLE_TYPE
, MTL.ATP_FLAG ATP_FLAG
, SOPLD.DPW_ASSIGNED_FLAG
, SOPLD.DELIVERY_ID
, SOPLD.DEPARTURE_ID
, SOPLD.LOAD_SEQ_NUMBER
, SOPLD.MASTER_CONTAINER_ITEM_ID
, SOPLD.DETAIL_CONTAINER_ITEM_ID
FROM SO_PICKING_LINE_DETAILS SOPLD
, MTL_SYSTEM_ITEMS_KFV MTLKFV
, MTL_SYSTEM_ITEMS MTL
, MTL_PARAMETERS MTLP
, SO_LOOKUPS LUP
WHERE OE_QUERY.PICKING_LINE_ITEM_ID(SOPLD.PICKING_LINE_ID) = MTLKFV.INVENTORY_ITEM_ID
AND MTLKFV.ORGANIZATION_ID = FND_PROFILE.VALUE('SO_ORGANIZATION_ID')
AND OE_QUERY.PICKING_LINE_ITEM_ID(SOPLD.PICKING_LINE_ID) = MTL.INVENTORY_ITEM_ID (+)
AND SOPLD.WAREHOUSE_ID = MTL.ORGANIZATION_ID (+)
AND SOPLD.WAREHOUSE_ID = MTLP.ORGANIZATION_ID (+)
AND LUP.LOOKUP_TYPE(+) = 'SCHEDULE STATUS'
AND LUP.LOOKUP_CODE(+) = SOPLD.SCHEDULE_STATUS_CODE

Columns