VIEW: APPS.SO_PICKING_LINE_DETAIL_VO_V

Source

View Text - Preformatted

SELECT DISTINCT SPLD.ROWID ROW_ID , SPLD.PICKING_LINE_DETAIL_ID , SPLD.CREATION_DATE , SPLD.CREATED_BY , SPLD.LAST_UPDATE_DATE , SPLD.LAST_UPDATED_BY , SPLD.LAST_UPDATE_LOGIN , SPLD.PICKING_LINE_ID , SPL.INVENTORY_ITEM_ID , MSI.DESCRIPTION ITEM_DESCRIPTION , SPLD.REQUESTED_QUANTITY , SPLD.WAREHOUSE_ID , MP.ORGANIZATION_CODE WAREHOUSE , SPL.UNIT_CODE , SPLD.LOT_NUMBER , SPLD.REVISION , SPLD.SUBINVENTORY , SPLD.SEGMENT1 , SPLD.SEGMENT2 , SPLD.SEGMENT3 , SPLD.SEGMENT4 , SPLD.SEGMENT5 , SPLD.SEGMENT6 , SPLD.SEGMENT7 , SPLD.SEGMENT8 , SPLD.SEGMENT9 , SPLD.SEGMENT10 , SPLD.SEGMENT11 , SPLD.SEGMENT12 , SPLD.SEGMENT13 , SPLD.SEGMENT14 , SPLD.SEGMENT15 , SPLD.SEGMENT16 , SPLD.SEGMENT17 , SPLD.SEGMENT18 , SPLD.SEGMENT19 , SPLD.SEGMENT20 , SPLD.INVENTORY_LOCATION_SEGMENTS , SPLD.INVENTORY_LOCATION_ID , SPLD.DETAIL_TYPE_CODE , SPLD.CONTEXT , SPLD.ATTRIBUTE1 , SPLD.ATTRIBUTE2 , SPLD.ATTRIBUTE3 , SPLD.ATTRIBUTE4 , SPLD.ATTRIBUTE5 , SPLD.ATTRIBUTE6 , SPLD.ATTRIBUTE7 , SPLD.ATTRIBUTE8 , SPLD.ATTRIBUTE9 , SPLD.ATTRIBUTE10 , SPLD.ATTRIBUTE11 , SPLD.ATTRIBUTE12 , SPLD.ATTRIBUTE13 , SPLD.ATTRIBUTE14 , SPLD.ATTRIBUTE15 , SPLD.RELEASED_FLAG , SPLD.SCHEDULE_DATE , SPLD.AUTOSCHEDULED_FLAG , OE_QUERY.LOT_EXPIRATION(SPL.INVENTORY_ITEM_ID, SPLD.WAREHOUSE_ID, SPLD.LOT_NUMBER) LOT_EXPIRATION_DATE FROM ORG_FREIGHT ORGF, MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_VL MSI, SO_PICKING_LINES SPL, SO_PICKING_LINE_DETAILS SPLD WHERE SPL.PICKING_LINE_ID = SPLD.PICKING_LINE_ID AND MSI.INVENTORY_ITEM_ID = SPL.INVENTORY_ITEM_ID AND MSI.ORGANIZATION_ID = SPLD.WAREHOUSE_ID AND ORGF.ORGANIZATION_ID(+) = FND_PROFILE.VALUE('SO_ORGANIZATION_ID' ) AND ORGF.FREIGHT_CODE(+) = SPL.SHIP_METHOD_CODE AND MP.ORGANIZATION_ID(+) = SPLD.WAREHOUSE_ID

View Text - HTML Formatted

SELECT DISTINCT SPLD.ROWID ROW_ID
, SPLD.PICKING_LINE_DETAIL_ID
, SPLD.CREATION_DATE
, SPLD.CREATED_BY
, SPLD.LAST_UPDATE_DATE
, SPLD.LAST_UPDATED_BY
, SPLD.LAST_UPDATE_LOGIN
, SPLD.PICKING_LINE_ID
, SPL.INVENTORY_ITEM_ID
, MSI.DESCRIPTION ITEM_DESCRIPTION
, SPLD.REQUESTED_QUANTITY
, SPLD.WAREHOUSE_ID
, MP.ORGANIZATION_CODE WAREHOUSE
, SPL.UNIT_CODE
, SPLD.LOT_NUMBER
, SPLD.REVISION
, SPLD.SUBINVENTORY
, SPLD.SEGMENT1
, SPLD.SEGMENT2
, SPLD.SEGMENT3
, SPLD.SEGMENT4
, SPLD.SEGMENT5
, SPLD.SEGMENT6
, SPLD.SEGMENT7
, SPLD.SEGMENT8
, SPLD.SEGMENT9
, SPLD.SEGMENT10
, SPLD.SEGMENT11
, SPLD.SEGMENT12
, SPLD.SEGMENT13
, SPLD.SEGMENT14
, SPLD.SEGMENT15
, SPLD.SEGMENT16
, SPLD.SEGMENT17
, SPLD.SEGMENT18
, SPLD.SEGMENT19
, SPLD.SEGMENT20
, SPLD.INVENTORY_LOCATION_SEGMENTS
, SPLD.INVENTORY_LOCATION_ID
, SPLD.DETAIL_TYPE_CODE
, SPLD.CONTEXT
, SPLD.ATTRIBUTE1
, SPLD.ATTRIBUTE2
, SPLD.ATTRIBUTE3
, SPLD.ATTRIBUTE4
, SPLD.ATTRIBUTE5
, SPLD.ATTRIBUTE6
, SPLD.ATTRIBUTE7
, SPLD.ATTRIBUTE8
, SPLD.ATTRIBUTE9
, SPLD.ATTRIBUTE10
, SPLD.ATTRIBUTE11
, SPLD.ATTRIBUTE12
, SPLD.ATTRIBUTE13
, SPLD.ATTRIBUTE14
, SPLD.ATTRIBUTE15
, SPLD.RELEASED_FLAG
, SPLD.SCHEDULE_DATE
, SPLD.AUTOSCHEDULED_FLAG
, OE_QUERY.LOT_EXPIRATION(SPL.INVENTORY_ITEM_ID
, SPLD.WAREHOUSE_ID
, SPLD.LOT_NUMBER) LOT_EXPIRATION_DATE
FROM ORG_FREIGHT ORGF
, MTL_PARAMETERS MP
, MTL_SYSTEM_ITEMS_VL MSI
, SO_PICKING_LINES SPL
, SO_PICKING_LINE_DETAILS SPLD
WHERE SPL.PICKING_LINE_ID = SPLD.PICKING_LINE_ID
AND MSI.INVENTORY_ITEM_ID = SPL.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = SPLD.WAREHOUSE_ID
AND ORGF.ORGANIZATION_ID(+) = FND_PROFILE.VALUE('SO_ORGANIZATION_ID' )
AND ORGF.FREIGHT_CODE(+) = SPL.SHIP_METHOD_CODE
AND MP.ORGANIZATION_ID(+) = SPLD.WAREHOUSE_ID