IN_DEL_LNCNT_VW

(SQL View)
 Index Back

Delivery - Count of demand

Count of demand lines on a delivery

SELECT D.BUSINESS_UNIT , D.DELIVERY_ID , COUNT(*) , MIN(D.IN_FULFILL_STATE) , MAX(D.IN_FULFILL_STATE) FROM PS_IN_DEMAND D WHERE D.IN_FULFILL_STATE BETWEEN '10' AND '60' AND D.IN_PROCESS_DATE IS NOT NULL AND D.DELIVERY_ID > ' ' AND D.APPROVED_FLAG = 'Y' AND D.RESERVE_STATUS < '99' GROUP BY D.BUSINESS_UNIT, D.DELIVERY_ID

# 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 NBR_DEMAND_LINES Number(4,0) SMALLINT NOT NULL Number of Demand Lines
4 MIN_FULFILL_STATE Character(2) VARCHAR2(2) NOT NULL Inventory Fulfillment State
5 MAX_FULFILL_STATE Character(2) VARCHAR2(2) NOT NULL Inventory Fulfillment State