RSF_OPP_ND_X_VW (SQL View)	Index Back
Join Need to priority xlat Left outer join to get Need's priority char's xlat only when xlat exists. Allows report RSF1005 to run more easily.

RSF_OPP_ND_X_VW

(SQL View)

Join Need to priority xlat

Left outer join to get Need's priority char's xlat only when xlat exists. Allows report RSF1005 to run more easily.

SELECT A.OPPORTUNITY_ID , A.SEQ_NUM , A.DESCR100 , A.PRIORITY_CHAR , (A.REQUIRED_DATE) , (A.DATE_FULFILLED) , B.XLATSHORTNAME FROM PS_RSF_OPP_NEED A , PSXLATITEM B WHERE A.PRIORITY_CHAR = B.FIELDVALUE (+) AND B.FIELDNAME = 'PRIORITY_CHAR' AND %EffdtCheck(PSXLATITEM C, B, %CurrentDateIn) AND A.OPPORTUNITY_ID <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPPORTUNITY_ID Character(15) VARCHAR2(15) NOT NULL Opportunity ID
Default Value: NEXT

2 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

3 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description

4 PRIORITY_CHAR Character(1) VARCHAR2(1) NOT NULL Priority Char (1) field. PRIORITY is a Numeric field, so we could not provide any XLAT for that. So created this field.
1=Urgent Priority
2=High Priority
3=Medium Priority
4=Low Priority

5 REQUIRED_DATE Date(10) DATE Required By

6 DATE_FULFILLED Date(10) DATE Date When the Fulfillment was sent

7 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPPORTUNITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Opportunity ID Default Value: NEXT
2	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
3	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description
4	PRIORITY_CHAR	Character(1)	VARCHAR2(1) NOT NULL	Priority Char (1) field. PRIORITY is a Numeric field, so we could not provide any XLAT for that. So created this field. 1=Urgent Priority 2=High Priority 3=Medium Priority 4=Low Priority
5	REQUIRED_DATE	Date(10)	DATE	Required By
6	DATE_FULFILLED	Date(10)	DATE	Date When the Fulfillment was sent
7	XLATSHORTNAME	Character(10)	VARCHAR2(10) NOT NULL	Translate Value Short Name