FO_ORD_APPL_VW (SQL View)	Index Back
Order search view App Applicant Order Serch view (Position of Interest)

FO_ORD_APPL_VW

(SQL View)

Order search view App

Applicant Order Serch view (Position of Interest)

SELECT A.BUSINESS_UNIT %Concat A.SO_ID %Concat %NumToChar(D.SO_LINE) ,A.BUSINESS_UNIT ,A.SO_ID ,D.SO_LINE ,A.DESCR ,D.DESCR ,A.USER_ORDER_TYPE ,C.NAME1 ,A.CUST_ID ,A.OWNERSHIP_ID ,B.SO_STATUS ,A.ASSIGNED_TO ,A.PROJECT_ID FROM PS_RS_SO_HDR A , PS_RS_SO_STATUS B , PS_CUSTOMER C , PS_RS_SO_LINE D WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.SO_ID = B.SO_ID AND B.LASTUPDDTTM = ( SELECT MAX(LASTUPDDTTM) FROM PS_RS_SO_STATUS B1 WHERE B.BUSINESS_UNIT = B1.BUSINESS_UNIT AND B.SO_ID = B1.SO_ID) AND C.SETID = ( SELECT SC.SETID FROM PS_SET_CNTRL_REC SC WHERE SC.SETCNTRLVALUE = A.BUSINESS_UNIT AND SC.REC_GROUP_ID = 'FS_23' AND SC.RECNAME = 'CUSTOMER') AND A.CUST_ID = C.CUST_ID AND A.SYSTEM_SOURCE = 'STF' AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.SO_ID = D.SO_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FO_JOBOPEN_GUID Character(36) VARCHAR2(36) NOT NULL Job Opening

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 SO_LINE Number(3,0) SMALLINT NOT NULL Line Number

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

6 DESCR_LN1 Character(50) VARCHAR2(50) NOT NULL Description Line 1

7 USER_ORDER_TYPE Character(5) VARCHAR2(5) NOT NULL User Order Type
Prompt Table: FO_ORDER_TYPE

8 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
Prompt Table: FO_CUST_AL_SCH3

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.
Prompt Table: FO_CUST_AL_SRCH

10 OWNERSHIP_ID Character(30) VARCHAR2(30) NOT NULL Owning Organization
Prompt Table: FO_ORD_BRNCH_VW

11 FO_ORDER_STATUS Character(1) VARCHAR2(1) NOT NULL Order Status
D=Draft
E=Ended
F=Filled
U=Unfilled

12 ASSIGNED_TO Character(30) VARCHAR2(30) NOT NULL Assigned To

13 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FO_JOBOPEN_GUID	Character(36)	VARCHAR2(36) NOT NULL	Job Opening
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	SO_LINE	Number(3,0)	SMALLINT NOT NULL	Line Number
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	DESCR_LN1	Character(50)	VARCHAR2(50) NOT NULL	Description Line 1
7	USER_ORDER_TYPE	Character(5)	VARCHAR2(5) NOT NULL	User Order Type Prompt Table: FO_ORDER_TYPE
8	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1 Prompt Table: FO_CUST_AL_SCH3
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. Prompt Table: FO_CUST_AL_SRCH
10	OWNERSHIP_ID	Character(30)	VARCHAR2(30) NOT NULL	Owning Organization Prompt Table: FO_ORD_BRNCH_VW
11	FO_ORDER_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Order Status D=Draft E=Ended F=Filled U=Unfilled
12	ASSIGNED_TO	Character(30)	VARCHAR2(30) NOT NULL	Assigned To
13	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField