REV_EST_OPT_LVW (SQL View)	Index Back
Revenue Estimate Options View to use as prompt table to select CC_REV_BUCKET

REV_EST_OPT_LVW

(SQL View)

Revenue Estimate Options

View to use as prompt table to select CC_REV_BUCKET

SELECT A.ENTRY_USE_ID , B.CC_REV_BUCKET , C.LANGUAGE_CD , C.XLATSHORTNAME FROM PS_ENTRY_USE_TBL A , PS_REV_EST_OPT_TBL B , PSXLATITEMLANG C , PSXLATITEM D WHERE A.CC_REV_BUCKET_FLG = B.CC_REV_BUCKET_FLG AND B.CC_REV_BUCKET = C.FIELDVALUE AND C.FIELDNAME = 'CC_REV_BUCKET' AND C.FIELDNAME = D.FIELDNAME AND C.FIELDVALUE = D.FIELDVALUE AND C.EFFDT = D.EFFDT AND D.EFF_STATUS = 'A' AND D.EFFDT = ( SELECT MAX(E.EFFDT) FROM PSXLATITEM E WHERE E.FIELDNAME = D.FIELDNAME AND E.FIELDVALUE = D.FIELDVALUE AND E.EFF_STATUS = 'A' AND E.EFFDT <= %CurrentDateIn)

Related Language Record for REV_EST_OPT_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ENTRY_USE_ID Character(5) VARCHAR2(5) NOT NULL Specifies the System Function or type of processing associated with an entry type.

2 CC_REV_BUCKET Character(1) VARCHAR2(1) NOT NULL Inidcate which revenue bucket to update.
B=Both
C=Collected
N=None
R=Recognized

3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ENTRY_USE_ID	Character(5)	VARCHAR2(5) NOT NULL	Specifies the System Function or type of processing associated with an entry type.
2	CC_REV_BUCKET	Character(1)	VARCHAR2(1) NOT NULL	Inidcate which revenue bucket to update. B=Both C=Collected N=None R=Recognized
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	XLATSHORTNAME	Character(10)	VARCHAR2(10) NOT NULL	Translate Value Short Name