View: WSHFV_PICK_HEADER

View Text

SELECT PICKING_HEADER_ID
, SPH.CREATION_DATE
, SPH.CREATED_BY
, SPH.LAST_UPDATE_DATE
, SPH.LAST_UPDATED_BY
, SPH.LAST_UPDATE_LOGIN
, SPH.PROGRAM_APPLICATION_ID
, SPH.PROGRAM_ID
, SPH.PROGRAM_UPDATE_DATE
, SPH.REQUEST_ID
, SPH.BATCH_ID
, SPB.NAME BATCH_NAME
, SPH.ORDER_HEADER_ID
, SH.ORDER_NUMBER
, SPH.WAREHOUSE_ID
, ORG.ORGANIZATION_CODE
, SPH.SHIP_TO_SITE_USE_ID
, SU.LOCATION SHIP_TO
, SPH.STATUS_CODE
, SPH.PICKED_BY_ID
, SUBSTR(FU1.LAST_NAME|| DECODE( SPH.PICKED_BY_ID
, NULL
, NULL
, '
, ') ||FU1.MIDDLE_NAMES||' '||FU1.FIRST_NAME
, 1
, 50) PICKER_NAME
, SPH.PACKED_BY_ID
, SUBSTR(FU2.LAST_NAME|| DECODE( SPH.PACKED_BY_ID
, NULL
, NULL
, '
, ') ||FU2.MIDDLE_NAMES||' '||FU2.FIRST_NAME
, 1
, 50) PACKER_NAME
, SPH.WEIGHT_UNIT_CODE
, SPH.SHIP_METHOD_CODE
, SPH.DATE_RELEASED RELEASED_DATE
, SPH.DATE_SHIPPED
, SPH.DATE_CONFIRMED CONFIRMED_DATE
, SPH.ORG_ID
, HOU.NAME ORG_NAME
, SPH.SHIP_NOTICE_SENT_FLAG
, SPH.DELIVERY_ID
, WDL.NAME DELIVERY_NAME
FROM SO_PICKING_HEADERS_ALL SPH
, WSH_DELIVERIES WDL
, SO_PICKING_BATCHES SPB
, SO_HEADERS_ALL SH
, MTL_PARAMETERS ORG
, RA_SITE_USES SU
, PER_PEOPLE_X FU1
, PER_PEOPLE_X FU2
, HR_ORGANIZATION_UNITS HOU
WHERE WDL.DELIVERY_ID (+) = SPH.DELIVERY_ID
AND SPB.BATCH_ID (+) = SPH.BATCH_ID
AND SH.HEADER_ID (+) = SPH.ORDER_HEADER_ID
AND ORG.ORGANIZATION_ID (+) = SPH.WAREHOUSE_ID
AND SU.SITE_USE_ID (+) = SPH.SHIP_TO_SITE_USE_ID
AND FU1.PERSON_ID(+) = NVL(SPH.PICKED_BY_ID
, -99)
AND FU2.PERSON_ID(+) = NVL(SPH.PACKED_BY_ID
, -99)
AND HOU.ORGANIZATION_ID (+) = SPH.ORG_ID

Columns