ORGID_REC_VW

(SQL View)
 Index Back

EXT_ORG_ID-Having Records

This is a view for selecting all Record names which have the field 'EXT_ORG_ID' and are prompting against 'EXT_ORG_TBL' or values that are coming from EXT_ORG_TBL.EXT_ORG_ID.

SELECT A.RECNAME FROM PSRECFIELD A , PSRECDEFN B WHERE A.RECNAME = B.RECNAME AND (A.EDITTABLE = 'EXT_ORG_TBL' OR A.EDITTABLE = 'EXT_ORG_VW' OR A.EDITTABLE = 'EXT_ORG_SRCH' OR A.EDITTABLE = 'EXT_ORGSCHL_VW' OR A.EDITTABLE = 'AV_EXT_ORG_SRCH') AND B.RECTYPE = 0

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