View: SO_PICKING_LINES_VIEW_V

View Text

SELECT SPL.PICKING_LINE_ID PICKING_LINE_ID
, SPLD.PICK_SLIP_NUMBER PICK_SLIP_NUMBER
, SPL.SEQUENCE_NUMBER SEQUENCE_NUMBER
, SPL.UNIT_CODE UNIT_CODE
, DECODE(SPL.SHIPPED_QUANTITY
, ''
, 0
, SPL.SHIPPED_QUANTITY) SHIPPED_QUANTITY_DISP
, SPH.DATE_SHIPPED DATE_SHIPPED
, SPH.DATE_CONFIRMED DATE_CONFIRMED
, SPH.WAYBILL_NUM WAYBILL_NUM
, SPL.SHIP_METHOD_CODE SHIP_METHOD_CODE
, PB.NAME BATCH
, DECODE(PB.DATE_COMPLETED
, ''
, 'N'
, 'Y' ) BATCH_COMPLETE_FLAG
, SPH.NUMBER_OF_BOXES NUMBER_OF_BOXES
, SPL.REQUESTED_QUANTITY REQUESTED_QUANTITY
, MP.ORGANIZATION_CODE WAREHOUSE
, SPH.WEIGHT WEIGHT
, SPH.WEIGHT_UNIT_CODE WEIGHT_UNIT_CODE
, NVL(MSI.DESCRIPTION
, 'NO DESCRIPTION AVAILABLE' ) ITEM_DESC
, OE_QUERY.ITEM_CONC_SEG(SPL.INVENTORY_ITEM_ID
, FND_PROFILE.VALUE('SO_ORGANIZATION_ID' )) ITEM
, SPL.ORDER_LINE_ID ORDER_LINE_ID
, SL.HEADER_ID HEADER_ID
, SPH.BATCH_ID
, SPL.SCHEDULE_DATE
, DECODE(SPL.PICKING_HEADER_ID
, 0
, SPL.ORIGINAL_REQUESTED_QUANTITY - NVL(SPL.CANCELLED_QUANTITY
, 0)
, NULL) BACKORDERED_QUANTITY
, DECODE(SPL.PICKING_HEADER_ID
, 0
, OE_QUERY.PICKING_LINE_RESERVED_QTY( SPL.PICKING_LINE_ID)
, NULL) RESERVED_QUANTITY
, SPL.PICKING_HEADER_ID
, RSU.LOCATION SHIP_TO_LOCATION
, DECODE(SPL.PICKING_HEADER_ID
, 0
, OE_QUERY.SCHEDULE_STATUS( SPL.ORDER_LINE_ID)
, NULL) SCHEDULE_STATUS
, SPL.CREATION_DATE
, SPL.CREATED_BY
, SPL.LAST_UPDATE_DATE
, SPL.LAST_UPDATED_BY
, SPL.LAST_UPDATE_LOGIN
, SPL.ROWID ROW_ID
, SPH.STATUS_CODE PICKING_HEADER_STATUS
FROM SO_PICKING_LINES SPL
, SO_PICKING_HEADERS SPH
, SO_PICKING_BATCHES PB
, MTL_PARAMETERS MP
, ORG_FREIGHT ORGF
, MTL_SYSTEM_ITEMS_VL MSI
, SO_LINES SL
, RA_SITE_USES RSU
, SO_PICKING_LINE_DETAILS SPLD
WHERE SPH.PICKING_HEADER_ID(+) = SPL.PICKING_HEADER_ID
AND PB.BATCH_ID(+) = SPH.BATCH_ID
AND MP.ORGANIZATION_ID(+) = SPL.WAREHOUSE_ID
AND ORGF.ORGANIZATION_ID(+) = FND_PROFILE.VALUE('SO_ORGANIZATION_ID' )
AND ORGF.FREIGHT_CODE(+) = SPH.SHIP_METHOD_CODE
AND MSI.INVENTORY_ITEM_ID(+) = SPL.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID(+) = FND_PROFILE.VALUE('SO_ORGANIZATION_ID' )
AND SL.LINE_ID = SPL.ORDER_LINE_ID
AND RSU.SITE_USE_ID(+) = SPL.SHIP_TO_SITE_USE_ID
AND SPLD.PICKING_LINE_ID(+) = SPL.PICKING_LINE_ID

Columns