IN_DELCNTWV_VW

(SQL View)
 Index Back

Delivery Container Wt/Vol

This view returns the sum of weights and volumes of containers in a delivery.

SELECT DISTINCT D.BUSINESS_UNIT , D.DELIVERY_ID , OUTR.SHIP_CNTR_ID , %Round(%DecMult(OUTR.SHIP_HEIGHT, %DecMult(OUTR.SHIP_LENGTH, OUTR.SHIP_WIDTH)), 4) , CASE OUTR.UNIT_MEASR_WT_USER WHEN ' ' THEN OUTR.GROSS_WEIGHT ELSE OUTR.GROSS_WEIGHT_USER END , OUTR.UNIT_MEASURE_VOL , CASE OUTR.UNIT_MEASR_WT_USER WHEN ' ' THEN OUTR.UNIT_MEASURE_WT ELSE OUTR.UNIT_MEASR_WT_USER END , C.SETID FROM PS_SHIP_CNTR_HDR OUTR , PS_SHIP_CNTR_HDR INNR , PS_SHIP_CNTR_INV DETL , PS_IN_DEMAND D , PS_IN_DELIVERY V , PS_SET_CNTRL_REC C WHERE %Join(COMMON_KEYS, IN_DEMAND D, SHIP_CNTR_INV DETL) AND D.IN_FULFILL_STATE BETWEEN '10' AND '60' AND D.IN_PROCESS_DATE IS NOT NULL AND D.DELIVERY_ID > ' ' AND V.BUSINESS_UNIT = D.BUSINESS_UNIT AND V.DELIVERY_ID = D.DELIVERY_ID AND V.DELIVERY_STATUS IN ('20','60','70') AND INNR.BUSINESS_UNIT = DETL.BUSINESS_UNIT AND INNR.SHIP_CNTR_ID = DETL.SHIP_CNTR_ID AND OUTR.BUSINESS_UNIT = INNR.BUSINESS_UNIT AND OUTR.SHIP_CNTR_ID = INNR.OUTER_MOST_CNTR_ID AND OUTR.SHIP_CNTR_ID = OUTR.OUTER_MOST_CNTR_ID AND C.SETCNTRLVALUE = D.BUSINESS_UNIT AND C.RECNAME = 'MASTER_ITEM_TBL'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 DELIVERY_ID Character(10) VARCHAR2(10) NOT NULL Delivery ID
3 SHIP_CNTR_ID Character(20) VARCHAR2(20) NOT NULL Shipping Container ID
4 SHIPPING_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL Shipping Volume
5 SHIPPING_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Shipping Weight
6 UNIT_MEASURE_VOL Character(3) VARCHAR2(3) NOT NULL Volume UOM
7 UNIT_MEASURE_WT Character(3) VARCHAR2(3) NOT NULL Weight UOM
8 SETID_INV_ITEM Character(5) VARCHAR2(5) NOT NULL Inv Items SETID