VIEW: APPS.SO_PICKING_LINE_DET_OEXORRSO_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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