RBQ_BOREC_VW

(SQL View)
 Index Back

Records with BO field.

Prompt Record for displaying Records with BO_ID field.

SELECT A.RECNAME FROM PSRECDEFN A , PSRECFIELDALL B WHERE A.RECNAME = B.RECNAME AND B.FIELDNAME LIKE 'BO_ID%' AND A.RECTYPE IN (0 , 1 , 5 , 6)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).