PTPG_COQUERY_VW

(SQL View)
 Index Back

SELECT A.CPQNAME , A.DESCR FROM PSCPQDEFN A WHERE A.OPRID = ' ' AND PT_REPORT_STATUS='A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description