FO_ORD_HOT_VW (SQL View)	Index Back
Order Hot List Order Hot List

FO_ORD_HOT_VW

(SQL View)

Order Hot List

SELECT H.OPRID , H.BUSINESS_UNIT , H.SO_ID , H.DATETIME_ADDED , O.DESCR , T.EMAILID , P.PHONE , C.SETID , C.CUST_ID , C.NAME1 , O.MANAGER_CONTACT_ID , T.NAME1 , O. OWNERSHIP_ID FROM PS_FO_ORD_HOT_TBL H , PS_RS_SO_HDR O , PS_CUSTOMER C , PS_CONTACT T , PS_CONTACT_PHN P WHERE H.BUSINESS_UNIT = O.BUSINESS_UNIT AND H.SO_ID = O.SO_ID AND C.SETID = ( SELECT C1.SETID FROM PS_SET_CNTRL_REC C1 WHERE C1.SETCNTRLVALUE = O.BUSINESS_UNIT AND C1.RECNAME = 'CUSTOMER') AND O.CUST_ID = C.CUST_ID AND C.SETID = T.SETID AND O.MANAGER_CONTACT_ID = T.CONTACT_ID AND %EffdtCheck(CONTACT, T, %CurrentDateIn) AND T.EFF_STATUS = 'A' AND T.SETID = P.SETID AND T.CONTACT_ID = P.CONTACT_ID AND P.PRIMARY_PHONE = 'Y' AND P.EFFDT = T.EFFDT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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

4 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description

6 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address

7 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone

8 CUST_SETID Character(5) VARCHAR2(5) NOT NULL Customer SetID

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

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

11 MANAGER_CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Order Contact

12 NAME2 Character(40) VARCHAR2(40) NOT NULL Name 2

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_PC_NONVW
3	SO_ID	Character(15)	VARCHAR2(15) NOT NULL	Service Order ID
4	DATETIME_ADDED	DateTime(26)	TIMESTAMP	DateTime Added
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	EMAILID	Character(70)	VARCHAR2(70) NOT NULL	A user's E-mail address
7	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
8	CUST_SETID	Character(5)	VARCHAR2(5) NOT NULL	Customer SetID
9	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.
10	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
11	MANAGER_CONTACT_ID	Character(15)	VARCHAR2(15) NOT NULL	Order Contact
12	NAME2	Character(40)	VARCHAR2(40) NOT NULL	Name 2
13	OWNERSHIP_ID	Character(30)	VARCHAR2(30) NOT NULL	Owning Organization