ORDENT_SCHNS_VW (SQL View)	Index Back
Ordent Not Ship View Ordent Not Ship View

ORDENT_SCHNS_VW

(SQL View)

Ordent Not Ship View

SELECT S.BUSINESS_UNIT , S.ORDER_NO , S.ORDER_INT_LINE_NO , S.SCHED_LINE_NBR , 'N' FROM PS_ORD_SCHEDULE S WHERE S.CS_STATUS NOT IN ('S') AND (S.DEMAND_SENT = 'N' OR EXISTS ( SELECT 'X' FROM PS_IN_DEMAND SH WHERE SH.BUSINESS_UNIT = S.SHIP_FROM_BU AND SH.SOURCE_BUS_UNIT = S.BUSINESS_UNIT AND SH.ORDER_NO = S.ORDER_NO AND SH.ORDER_INT_LINE_NO = S.ORDER_INT_LINE_NO AND SH.SCHED_LINE_NBR = S.SCHED_LINE_NBR AND SH.DEMAND_SOURCE = 'OM' AND SH.IN_FULFILL_STATE < '60'))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 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

3 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line

4 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number

5 SHIPPED_FLAG Character(1) VARCHAR2(1) NOT NULL Shipped
B=Both
N=No
Y=Yes

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	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
3	ORDER_INT_LINE_NO	Number(5,0)	INTEGER NOT NULL	Order Line
4	SCHED_LINE_NBR	Number(6,0)	INTEGER NOT NULL	Schedule Line Number
5	SHIPPED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Shipped B=Both N=No Y=Yes