PSCPQFLDRELVW

index back

Composite Query

View for Composite Query based on PSCPQFLDREL record - with no data fetched
SELECT OPRID ,CPQNAME ,CPQQRYALIAS ,SELNUM ,CPQJOINCRITERIANUM ,CPQQRYFLDNAMEPAR ,CPQQRYFLDNAMECHILD ,CONDTYPE FROM PSCPQFLDREL 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
CPQQRYALIAS Character(30) VARCHAR2(30) NOT NULL Child Query Alias
SELNUM Number(2,0) SMALLINT NOT NULL Select Number
CPQJOINCRITERIANUM Number(3,0) SMALLINT NOT NULL Join Criteria Number
CPQQRYFLDNAMEPAR Character(30) VARCHAR2(30) NOT NULL Query Field
CPQQRYFLDNAMECHILD Character(30) VARCHAR2(30) NOT NULL Child Query Field Name
CONDTYPE Number(2,0) SMALLINT NOT NULL Condition Type
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19