REC_MAPPING_VW

(SQL View)
 Index Back

SELECT A.BASE_RECNAME FROM PS_REC_MAPPING_TBL A , PSRECDEFN B WHERE A.REC_MAPPING_TYPE = 'RTB' AND A.BASE_RECNAME = B.RECNAME AND B.RECTYPE = 0 AND A.BASE_RECNAME NOT IN('JRNL_HEADER','JRNL_LN')

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