Product: | OE - Order Entry |
---|---|
Description: | |
Implementation/DBA Data: | APPS.SO_PICKING_LINE_DETAIL_VO_V |
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