CDT_PASTSHIP_VW

(SQL View)
 Index Back

Sched Past Ship Date

Date Initials Issue Description 052704 twh F-KNANN-V59N4 Replace demand table references with IN_DEMAND

SELECT SC.SETID , OH.SOLD_TO_CUST_ID , OS.SHIP_TO_CUST_ID , OS.SHIP_FROM_BU , OS.SCHED_SHIP_DTTM , OL.PRODUCT_ID , OS.QTY_SCHEDULED , OH.BUSINESS_UNIT , OH.ORDER_NO FROM PS_ORD_SCHEDULE OS , PS_ORD_LINE OL , PS_ORD_HEADER OH , PS_SET_CNTRL_REC SC WHERE %Join(COMMON_KEYS, ORD_SCHEDULE OS, ORD_LINE OL) AND %Join(COMMON_KEYS, ORD_LINE OL, ORD_HEADER OH) AND OS.SCHED_SHIP_DTTM < %CurrentDateTimeIn AND SC.SETCNTRLVALUE = OH.BUSINESS_UNIT AND SC.RECNAME = 'CUST_SLD_VW' AND NOT EXISTS ( SELECT 'X' FROM PS_IN_DEMAND SH WHERE SH.BUSINESS_UNIT = OS.SHIP_FROM_BU AND SH.SOURCE_BUS_UNIT = OS.BUSINESS_UNIT AND SH.ORDER_NO = OS.ORDER_NO AND SH.ORDER_INT_LINE_NO = OS.ORDER_INT_LINE_NO AND SH.SCHED_LINE_NBR = OS.SCHED_LINE_NBR AND SH.DEMAND_SOURCE = 'OM' AND SH.IN_FULFILL_STATE IN ('60', '70'))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
3 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
4 SHIP_FROM_BU Character(5) VARCHAR2(5) NOT NULL Ship from INV BU
5 SCHED_SHIP_DTTM DateTime(26) TIMESTAMP Schedule Ship Datetime
6 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
7 QTY_SCHEDULED Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Scheduled
8 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
9 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop