PM_TABLES_VW

(SQL View)
 Index Back

PS Tables


SELECT RECNAME FROM PSRECDEFN A WHERE RECTYPE = 0 AND NOT EXISTS ( SELECT 'X' FROM PSPROJECTITEM B WHERE B.PROJECTNAME = 'PPLTOOLS' AND B.OBJECTTYPE = 0 AND B.OBJECTID1 = 1 AND A.RECNAME = B.OBJECTVALUE1 AND B.OBJECTVALUE1 NOT IN('SETID_TBL','SET_CNTRL_REC','SET_CNTRL_GROUP','SET_CNTRL_TBL', 'SET_CNTRL_TREE','REC_GROUP_REC','REC_GROUP_TBL')) AND RECNAME NOT IN ('PM_PS_REC', 'PM_PS_REC_WHERE', 'PM_PS_RECUP_WHE', 'PM_PS_DMO_REC', 'PM_PS_DMO_WHERE', 'PM_PS_TSTTBLS', 'PM_PS_TSTWHERE', 'PM_PS_TST_REC', 'PM_PS_TST_WHERE')

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