PSCPQCRITERIAVW

index back

SELECT OPRID ,CPQNAME ,CRTNUM ,COMBTYPE ,NEGATION ,LPARENLVL ,RPARENLVL ,CPQQRYALIAS ,QRYFLDNAME ,CONDTYPE , ' ' , ' ' ,EXPRTYPE , ' ' , CPQR1CRTQRYALIAS , CPQR1CRTFLDNAME , CPQR1CRTEXPNUM , CPQR2CRTQRYALIAS , CPQR2CRTFLDNAME , CPQR2CRTEXPNUM FROM PSCPQCRITERIA WHERE 1=0

PeopleSoft Field Name Field Type Column Type Description
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
CPQNAME Character(30) VARCHAR2(30) NOT NULL Composite Query
CRTNUM Number(3,0) SMALLINT NOT NULL Criteria Number
COMBTYPE Number(1,0) SMALLINT NOT NULL Combination Type
NEGATION Character(1) VARCHAR2(1) NOT NULL Negation
LPARENLVL Number(2,0) SMALLINT NOT NULL Left Paren Level
RPARENLVL Number(2,0) SMALLINT NOT NULL Right Paren Level
CPQQRYALIAS Character(30) VARCHAR2(30) NOT NULL Child Query Alias
QRYFLDNAME Character(30) VARCHAR2(30) NOT NULL Source Field
CONDTYPE Number(2,0) SMALLINT NOT NULL Condition Type
CPQQRYALIASRIGHT Character(30) VARCHAR2(30) NOT NULL Query Alias
CPQQRYFIELDRIGHT Character(30) VARCHAR2(30) NOT NULL Query Field
EXPRTYPE Number(2,0) SMALLINT NOT NULL Expression Type
EXPRESSIONTEXT Long Character CLOB Expression Text
CPQR1CRTQRYALIAS Character(30) VARCHAR2(30) NOT NULL Query Alias
CPQR1CRTFLDNAME Character(30) VARCHAR2(30) NOT NULL Query Field
CPQR1CRTEXPNUM Number(3,0) SMALLINT NOT NULL Right1 Criteria Expression No.
CPQR2CRTQRYALIAS Character(30) VARCHAR2(30) NOT NULL Query Alias
CPQR2CRTFLDNAME Character(30) VARCHAR2(30) NOT NULL Query Field
CPQR2CRTEXPNUM Number(3,0) SMALLINT NOT NULL Right1 Criteria Expression No.
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19