RBQ_BORLREC_VW (SQL View)	Index Back
Records with BO and Role field Prompt Record for displaying Records with BO_ID and ROLE_TYPE_ID fields.

RBQ_BORLREC_VW

(SQL View)

Records with BO and Role field

Prompt Record for displaying Records with BO_ID and ROLE_TYPE_ID fields.

SELECT A.RECNAME FROM PSRECDEFN A , PSRECFIELDALL B , PSRECFIELDALL C WHERE A.RECNAME = B.RECNAME AND A.RECNAME = C.RECNAME AND B.FIELDNAME = 'BO_ID' AND C.FIELDNAME = 'ROLE_TYPE_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).