FO_CSTO_SLF_SCH

(SQL View)

SELECT DISTINCT A.BUSINESS_UNIT , A.SO_ID , D.CUST_ID , G.OPRID , A.USER_ORDER_TYPE , A.OWNERSHIP_ID , B.SO_LINE , B.SO_LINE_STATUS , B.QTY_INTEGER , F.NAME1 FROM PS_RS_SO_HDR A , PS_RS_SO_LINE B , PS_CUSTOMER C , PS_CONTACT_CUST D , PS_CONTACT F , PSOPRALIAS G WHERE A.SYSTEM_SOURCE = 'STF' AND A.SO_ID = B.SO_ID AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND B.CUST_ID = C.CUST_ID AND A.MANAGER_CONTACT_ID = F.CONTACT_ID AND A.CUST_ID = D.CUST_ID AND G.OPRALIASTYPE = 'CNT' AND D.CUST_ID IN ( SELECT DISTINCT CUST_ID FROM PS_CONTACT_CUST WHERE CONTACT_ID = ( SELECT CONTACT_ID FROM PSOPRALIAS E WHERE E.OPRALIASTYPE = 'CNT' AND E.OPRID = G.OPRID))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 SO_ID Character(15) VARCHAR2(15) NOT NULL Service Order ID

3 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

5 USER_ORDER_TYPE Character(5) VARCHAR2(5) NOT NULL User Order Type

6 OWNERSHIP_ID Character(30) VARCHAR2(30) NOT NULL Owning Organization

7 SO_LINE Number(3,0) SMALLINT NOT NULL Line Number

8 SO_FO_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL Resource Request Status
A=Filled
C=Canceled
O=Unfilled

9 QTY_INTEGER Number(11,0) DECIMAL(11) NOT NULL Quantity Rounded to 0 Decimals

10 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	SO_ID	Character(15)	VARCHAR2(15) NOT NULL	Service Order ID
3	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
4	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
5	USER_ORDER_TYPE	Character(5)	VARCHAR2(5) NOT NULL	User Order Type
6	OWNERSHIP_ID	Character(30)	VARCHAR2(30) NOT NULL	Owning Organization
7	SO_LINE	Number(3,0)	SMALLINT NOT NULL	Line Number
8	SO_FO_LINE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Resource Request Status A=Filled C=Canceled O=Unfilled
9	QTY_INTEGER	Number(11,0)	DECIMAL(11) NOT NULL	Quantity Rounded to 0 Decimals
10	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1