PM_TABLES_VW

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', 'PM_PS_SAAS_REC', 'PM_PS_SAS_WHERE', 'PM_PS_ADS_REC', 'PM_PS_ADS_WHERE')

PeopleSoft Field Name Field Type Column Type Description
RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19