RS_WC_FILTER_VW

(SQL View)

SELECT A.BUSINESS_UNIT , A.SO_ID , A.PROJECT_ID , B.PROJ_ROLE , A.CUST_ID FROM PS_RS_SO_HDR A , PS_RS_SO_LINE B , PS_RS_SO_STATUS C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.SO_ID = B.SO_ID AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.SO_ID = C.SO_ID AND C.SO_STATUS NOT IN ('C' ,'D','X') AND B.SO_LINE_STATUS = 'O'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_PC_NONVW

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

3 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role
Prompt Table: RS_PROJROLE_VW

4 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
Prompt Table: SP_PROJ_NONVW

5 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_PC_NONVW
2	SO_ID	Character(15)	VARCHAR2(15) NOT NULL	Service Order ID
3	PROJ_ROLE	Character(15)	VARCHAR2(15) NOT NULL	Project Role Prompt Table: RS_PROJROLE_VW
4	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: SP_PROJ_NONVW
5	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.