Friday, September 9, 2011

Peoplesoft Tables



-- To find navigation of a component
-- Navigation based off Process

SELECT PRCSPNL.PRCSNAME, MENUGROUP || ' > ' || MENULABEL || ' > ' || BARLABEL || ' > ' || ITEMLABEL "Path"
FROM PSMENUITEM MENU, PS_PRCSDEFNPNL PRCSPNL, PSMENUDEFN MNUDFN
WHERE MENU.PNLGRPNAME = PRCSPNL.PNLGRPNAME
AND MNUDFN.MENUNAME = MENU.MENUNAME
AND PRCSPNL.PRCSNAME = 'WCBCR008'
-- SQR Name starts with "PY026"


-- Navigation based off Panel

SELECT MENU.PNLGRPNAME, PNLGRP.MARKET, PNLGRP.ITEMNAME, PNLGRP.PNLNAME, MENUGROUP || ' > ' || MENULABEL || ' > ' || MENU.BARLABEL || ' > ' || MENU.ITEMLABEL "Path"
FROM PSMENUITEM MENU, PSMENUDEFN MNUDFN, PSPNLGROUP PNLGRP
WHERE MNUDFN.MENUNAME = MENU.MENUNAME
AND MENU.PNLGRPNAME = PNLGRP.PNLGRPNAME
AND PNLGRP.PNLNAME LIKE 'CUST_ADDRESS%'
-- Page Name ="BANK_TABLE_1"


-- Navigation based off PanelGroup

SELECT MENU.PNLGRPNAME, MENUGROUP || ' > ' || MENULABEL || ' > ' || BARLABEL || ' > ' || ITEMLABEL "Path"
FROM PSMENUITEM MENU, PSMENUDEFN MNUDFN
WHERE MNUDFN.MENUNAME = MENU.MENUNAME
AND MENU.PNLGRPNAME = 'CUSTOMER_GENERAL'

SELECT P3.PORTAL_LABEL || '>>'|| P2.PORTAL_LABEL || '>>'|| P1.PORTAL_LABEL || '>>'|| P.PORTAL_LABEL 'PATH'
, P.*
FROM PSPRSMDEFN P
, PSPRSMDEFN P1
, PSPRSMDEFN P2
, PSPRSMDEFN P3
WHERE P.PORTAL_URI_SEG2 = 'CUSTOMER_GENERAL'
AND P.PORTAL_PRNTOBJNAME = P1.PORTAL_OBJNAME
AND P1.PORTAL_PRNTOBJNAME = P2.PORTAL_OBJNAME
AND P2.PORTAL_PRNTOBJNAME = P3.PORTAL_OBJNAME
AND P.PORTAL_NAME = P1.PORTAL_NAME
AND P1.PORTAL_NAME = P2.PORTAL_NAME
AND P2.PORTAL_NAME = P3.PORTAL_NAME

--This query should find unused permission lists that could be deleted.
SELECT * FROM PSCLASSDEFN A
WHERE NOT EXISTS ( SELECT 'X' FROM PSUSERCLASSVW B WHERE A.CLASSID = B.CLASSID )
AND NOT EXISTS (SELECT 'X' FROM PSOPRDEFN B WHERE A.CLASSID = B.OPRCLASS)
AND NOT EXISTS (SELECT 'X' FROM PSOPRDEFN B WHERE A.CLASSID = B.PRCSPRFLCLS)
AND NOT EXISTS (SELECT 'X' FROM PSOPRDEFN B WHERE A.CLASSID = B.DEFAULTNAVHP)
AND NOT EXISTS (SELECT 'X' FROM PSOPRDEFN B WHERE A.CLASSID = B.ROWSECCLASS)
AND A.LASTUPDOPRID <> 'PPLSOFT'
ORDER BY CLASSID

--Reset user password with DataMover
SET LOG C:\TEMP\DM.LOG
UPDATE PSOPRDEFN SET OPERPSWD = 'SOMEPASSWORD',ENCRYPTED = 0 WHERE OPRID = 'KLIMEKL'

ENCRYPT_PASSWORD SOMEUSER

-- To insert multiple lines in oracle
INSERT INTO <TABLENAME>
(
SELECT 'ABBBA','122','9999' FROM DUAL UNION
SELECT 'ABABB','322','9999' FROM DUAL UNION
SELECT 'SBBSB','422','9999' FROM DUAL
)

--
Local rowset &rs1,&rs2
&rs1=GetLevel0()(1).GetRowset(Scroll.Record1)
for &i = 1 to &rs1.ActiveRowCount
&rs2=GetLevel0()(1).Record(&i).GetRowset(Scroll.Record2)
for &j = 1 to &rs2.ActiveRowCount
&rs2.getRow(&j).Record2.Field1.Value
End-For
End-For

-- Find keys in a record
SELECT * FROM PSKEYDEFN WHERE RECNAME ='CUST_ADDRESS' AND INDEXID ='_' ORDER BY RECNAME, KEYPOSN

-- ONLY QUERY YOU REQUIRE TO FIND ALL PEOPLESOFT TABLES USED?
SELECT RECNAME, RECDESCR FROM PSRECDEFN WHERE RECTYPE = 0 AND SQLTABLENAME <> ' ' ORDER BY RECDESCR , RECNAME

-- SQL Text Definition
SELECT * FROM PSSQLTEXTDEFN WHERE UPPER(SQLID) LIKE 'BCC_%'

-- Oracle Instance name
SELECT * FROM GLOBAL_NAME
--SELECT NAME FROM V$DATABASE

-- Process Monitor
SELECT * FROM PS_PMN_PRCSLIST WHERE PRCSNAME = 'WCBAR007'
DELETE FROM PSPRCSRQST WHERE PRCSINSTANCE = 4320

-- Translate VALUES
SELECT A.FIELDNAME, A.FIELDVALUE, A.EFFDT, A.EFF_STATUS, A.XLATLONGNAME, A.XLATSHORTNAME, A.LASTUPDDTTM, A.LASTUPDOPRID, A.SYNCID
FROM PSXLATITEM A
WHERE A.EFFDT =
(SELECT MAX(A_ED.EFFDT) FROM PSXLATITEM A_ED
WHERE A.FIELDNAME = A_ED.FIELDNAME
AND A.FIELDVALUE = A_ED.FIELDVALUE
AND A_ED.EFFDT <= getdate())
AND A.EFF_STATUS = 'A'
AND A.FIELDNAME = 'ACCESS_CD'
ORDER BY FIELDVALUE

-- SETID
SELECT SETID FROM PS_SET_CNTRL_REC WHERE RECNAME = 'GL_ACCOUNT_TBL' AND SETCNTRLVALUE = 'BRGL1'
SELECT * FROM PS_SET_CNTRL_REC WHERE RECNAME = 'TAX_CR_TBL'

-- Message catalog
SELECT * FROM PSMSGCATDEFN WHERE MESSAGE_SET_NBR = 21000 AND MESSAGE_NBR IN (1065,1066,1067)

-- Query Access List
SELECT * FROM PSQRYACCLSTRECS WHERE RECNAME LIKE 'BCC_YTD_UP%'
--INSERT INTO PSQRYACCLSTRECS VALUES (7,'PPST13031','BCC_YTD_UP_TBL','YTD Final table')


-- Manage Abends
SELECT * FROM PS_AETEMPTBLMGR

-- Record Defn
SELECT * FROM PSRECDEFN WHERE UPPER(RECDESCR) LIKE '%SHA%'

-- Log output directory
SELECT PRCSOUTPUTDIR FROM PS_CDM_LIST WHERE PRCSINSTANCE = 5944

-- /***LevelNo|Iskey|RecordName|FieldName|ParentRecName***/
SELECT A.BCSCROLL || '|' || DECODE(B.FIELDNAME , NULL , 'FALSE' , 'TRUE') || '|' || A.RECNAME || '|' || A.FIELDNAME || '|' || NVL(C.PARENT
,' ') FIELDVAL FROM ( SELECT FIELDNAME ,RECNAME FROM PSKEYDEFN WHERE INDEXID='_' )B, PSBCITEM A, ( SELECT DISTINCT A.RECNAME PARENT
,B.RECNAME CHILD FROM PSBCITEM A ,( SELECT BCNAME ,RECNAME ,BCTYPE ,BCSCROLL -1 BCSCROLL FROM PSBCITEM WHERE BCTYPE=4) B WHERE B.BCNAME=A.BCNAME(+)
AND B.BCTYPE=A.BCTYPE(+) AND B.BCTYPE=4 AND A.RECNAME !=' ' AND B.BCSCROLL=A.BCSCROLL(+) AND B.BCNAME='BCC_DIM_MAP_CI') C
WHERE A.RECNAME=B.RECNAME(+)
AND A.FIELDNAME=B.FIELDNAME(+)
AND A.BCNAME = 'BCC_DIM_MAP_CI'
AND A.BCTYPE =4
AND A.RECNAME =C.CHILD
AND A.BCNAME ='BCC_DIM_MAP_CI'
ORDER BY BCSCROLL,SEQUENCE_NBR_6

--- Record suite History
SELECT * FROM PS_PF_RECSUITE_HIS WHERE RUN_CNTL_ID = 'test' AND JOB_ID = 'BCC_USD'

--- Role
Select
A.ROLENAME, -- 'ROLENAME,'
C.CLASSID, -- 'CLASSID(PL),'
D.MENUNAME, -- 'MENUNAME,'
D.BARNAME, -- 'BARNAME,'
D.BARITEMNAME, -- 'BARITEMNAME,'
D.PNLITEMNAME, -- 'PNLITEMNAME,'
F.PNLGRPNAME, -- 'PNLGRPNAME (Comp.),'
F.PNLNAME, -- 'PNLNAME (Page),'
D.DISPLAYONLY, -- 'DISPLAY,'
D.AUTHORIZEDACTIONS -- 'AUTH Actions'
FROM PSROLEDEFN A, PSROLECLASS B, PSCLASSDEFN C, PSAUTHITEM D, PSMENUITEM E, PSPNLGROUP F
WHERE A.ROLENAME = B.ROLENAME
AND B.CLASSID = C.CLASSID
AND C.CLASSID = D.CLASSID
AND D.MENUNAME = E.MENUNAME
AND D.BARNAME = E.BARNAME
AND E.ITEMNAME = F.ITEMNAME
AND E.PNLGRPNAME = F.PNLGRPNAME
AND A.ROLENAME = 'AM_ADD'
ORDER BY 1, 2, 3, 4, 5, 6, 7, 8, 9

---
SELECT * FROM PSRECDEFN WHERE LASTUPDDTTM = getdate() AND LASTUPDOPRID = 'DH99796'

SELECT * FROM PSRECDEFN WHERE LASTUPDOPRID = 'DH99796'

-- Portal registry
SELECT * FROM PSPRSMDEFN WHERE PORTAL_NAME = 'EMPLOYEE' AND
PORTAL_PRNTOBJNAME IN (SELECT PORTAL_OBJNAME FROM PSPRSMDEFN WHERE PORTAL_NAME = 'EMPLOYEE' AND PORTAL_PRNTOBJNAME = 'BCC_REFERENCE_DATA')
ORDER BY PORTAL_PRNTOBJNAME

-- Fields in Record
SELECT * FROM PSRECFIELDDB WHERE RECNAME = 'VOUCHER' ORDER BY FIELDNUM

-- SQL Script to get the Datamodel
SELECT
A.RECNAME,
A.FIELDNUM,
A.FIELDNAME,
C.LONGNAME AS Description,
DECODE(b.fieldtype,0,'Char',4,'Date',2,'Number',3,'Sign',1,'Long',6,'DtTm') "TYPE",
B.LENGTH,
DECODE(MOD(FLOOR(d.USEEDIT/1 ),2),1,'YES' ,'NO') KEY,
DECODE(MOD(FLOOR(d.USEEDIT/256 ),2),1,'YES' ,'NO') REQ,
A.EDITTABLE "EDIT/PROMPT TABLE",
DECODE(MOD(FLOOR(d.USEEDIT/512 ),2),1,'YES' ,'NO') XLAT,
DECODE(E.RECTYPE,0,'SQL Record',1,'SQL View','Other') "Record Type"
FROM PSRECFIELDDB A,
PSDBFIELD B,
PSDBFLDLABL C,
PSRECFIELDDB D,
PSRECDEFN E
WHERE A.FIELDNAME = B.FIELDNAME
AND A.FIELDNAME = C.FIELDNAME
AND C.DEFAULT_LABEL=1
AND D.RECNAME = A.RECNAME
AND D.FIELDNAME = A.FIELDNAME
AND A.RECNAME = E.RECNAME
AND A.RECNAME IN ( SELECT DISTINCT OBJECTVALUE1 FROM PSPROJECTITEM
WHERE OBJECTTYPE= 0
AND PROJECTNAME='BCC_P7_REL1')
AND E.RECTYPE IN (0, 1)
ORDER BY A.RECNAME, A.FIELDNUM

===================
CONTENT REFERENCE
If you do not see a folder or content Reference (Menu Item) in Left hand side navigation, (Applicable to 8.4x ) then you must check to see if the folder or content reference is not marked as hidden. Other reasons could be security. Here is a SQL to find out all the objects that are hidden.
To find all the folders which are hidden from Portal Navigation.
select * from PSPRSMSYSATTRVL where portal_name = 'EMPLOYEE' and PORTAL_ATTR_NAM = 'PORTAL_HIDE_FROM_NAV' and portal_Reftype = 'F'

select a.portal_objname,b.portal_label,b.portal_prntobjname,c.portal_labelfrom PSPRSMSYSATTRVL a,psprsmdefn b,psprsmdefn c where a.portal_name = 'EMPLOYEE' and a.PORTAL_ATTR_NAM = 'PORTAL_HIDE_FROM_NAV' and b.portal_Reftype = 'F' and a.portal_name = b.portal_name and a.portal_objname = b.portal_objnameand b.portal_name = c.portal_nameand b.portal_prntobjname = c.portal_objname

* To find all the content references which are hidden from Portal Navigation.
select * from PSPRSMSYSATTRVL where portal_name = 'EMPLOYEE' and PORTAL_ATTR_NAM = 'PORTAL_HIDE_FROM_NAV' and portal_Reftype = 'C'


select a.portal_objname,b.portal_label,b.portal_prntobjname,c.portal_labelfrom PSPRSMSYSATTRVL a,psprsmdefn b,psprsmdefn c where a.portal_name = 'EMPLOYEE' and a.PORTAL_ATTR_NAM = 'PORTAL_HIDE_FROM_NAV' and b.portal_Reftype = 'C' and a.portal_name = b.portal_name and a.portal_objname = b.portal_objnameand b.portal_name = c.portal_nameand b.portal_prntobjname = c.portal_objname

Replace EMPLOYEE with Your portal name.
Some of the Other names are.
CUSTOMER
DEMOSITE
EMPLOYEE
MOBILE
PORTAL
PS_SITETEMPLATE
SUPPLIER

Portal Content Reference/folder Attributes are stored in
PSPRSMSYSATTR
PSPRSMSYSATTRVL

* PSPRSMDEFN รข€” Content References and Folders
* PSPRUHTABPGLT รข€” Portal User HP Tab Pagelet
============
SELECT * FROM PSACCESSPRFL

-- Operator Defn
SELECT * FROM PSOPRDEFN

SELECT * FROM PSOPRDEFN

-- Server Status
SELECT * FROM PSSTATUS

-- PEOPLETOOLS PROJECTS
SELECT * FROM PSPROJECTDEFN WHERE LASTUPDDTTM > '5/25/2011 10:36:32 AM'

SELECT * FROM PSPROJECTDEFN WHERE PROJECTNAME LIKE 'WCB%' or PROJECTNAME LIKE 'PT84%'
SELECT * FROM PSPROJECTITEM WHERE PROJECTNAME LIKE 'PPL%' or PROJECTNAME LIKE 'PT84%'
SELECT * FROM PSPROJDEFNLANG WHERE PROJECTNAME LIKE 'PPL%' or PROJECTNAME LIKE 'PT84%'
SELECT * FROM PSPROJECTDEP WHERE PROJECTNAME LIKE 'PPL%' or PROJECTNAME LIKE 'PT84%'
SELECT * FROM PSPROJECTINC WHERE PROJECTNAME LIKE 'PPL%' or PROJECTNAME LIKE 'PT84%'
SELECT * FROM PSPROJECTMSG WHERE PROJECTNAME LIKE 'PPL%' or PROJECTNAME LIKE 'PT84%'
SELECT * FROM PSPROJECTSEC WHERE PROJECTNAME LIKE 'PPL%' or PROJECTNAME LIKE 'PT84%'

-- SYSTEM
SELECT * FROM PSOPTIONS

-- RECORDS AND INDEXES
SELECT * FROM PSRECDEFN
SELECT * FROM PSRECDEFNLANG
SELECT * FROM PSRECFIELD
SELECT * FROM PSINDEXDEFN
SELECT * FROM PSKEYDEFN
SELECT * FROM PSDDLMODEL
SELECT * FROM PSDDLDEFPARMS
SELECT * FROM PSSPCDDLPARM
SELECT * FROM PSRECDDLPARM
SELECT * FROM PSIDXDDLPARM
SELECT * FROM PSRECFIELDDB
SELECT * FROM PSRECTBLSPC


-- FIELDS
SELECT * FROM PSDBFIELD
SELECT * FROM PSDBFIELDLANG
SELECT * FROM PSDBFLDLABL
SELECT * FROM PSDBFLDLABLLANG

-- FIELD FORMATS
SELECT * FROM PSFMTDEFN
SELECT * FROM PSFMTITEM

-- TRANSLATES
SELECT * FROM PSXLATDEFN
SELECT * FROM PSXLATITEM
SELECT * FROM PSXLATITEMLANG

-- PAGES
SELECT * FROM PSPNLDEFN
SELECT * FROM PSPNLFIELD WHERE PNLNAME = 'BCC_VIEW_ERR_PG'
--UPDATE PSPNLFIELD SET PNLFIELDNAME = LABEL_ID WHERE PNLNAME = 'BCC_VIEW_ERR_PG' AND FIELDNUM >9
SELECT * FROM PSPNLTREECTRL
SELECT * FROM PSPNLHTMLAREA
SELECT * FROM PSPNLCNTRLDATA
SELECT * FROM PSPNLBTNDATA
SELECT * FROM PSPNLDEFNLANG
SELECT * FROM PSPNLFIELDLANG
SELECT * FROM PSPNLHTMLLANG
SELECT * FROM PSPNLBTNLANG
SELECT * FROM PSPNLACTIVEX

-- MENUS
SELECT * FROM PSMENUDEFN
SELECT * FROM PSMENUDEFNLANG
SELECT * FROM PSMENUITEM
SELECT * FROM PSMENUITEMLANG
SELECT * FROM PSXFERITEM

-- PANEL GROUPS COMPONENTS
SELECT * FROM PSPNLGRPDEFN
SELECT * FROM PSPNLGDEFNLANG
SELECT * FROM PSPNLGROUP
SELECT * FROM PSPNLGROUPLANG

-- PEOPLECODE
SELECT * FROM PSPCMPROG
SELECT * FROM PSPCMNAME

-- QUERIES
SELECT * FROM PSQRYDEFN WHERE QRYNAME='WCB_AP_505F_CHECK_LIST'
SELECT * FROM PSQRYDEFNLANG WHERE QRYNAME='WCB_AP_505F_CHECK_LIST'
SELECT * FROM PSQRYBIND WHERE QRYNAME='WCB_AP_505F_CHECK_LIST'
SELECT * FROM PSQRYBINDLANG WHERE QRYNAME='WCB_AP_505F_CHECK_LIST'
SELECT * FROM PSQRYCRITERIA WHERE QRYNAME='WCB_AP_505F_CHECK_LIST'
SELECT * FROM PSQRYEXPR WHERE QRYNAME='WCB_AP_505F_CHECK_LIST'
SELECT FLDNUM,QRYNAME,QRYFLDNAME,RECNAME,FIELDNAME FROM PSQRYFIELD WHERE QRYNAME IN ('158_AP_CHECK_INQUIRY_FAST', '158_AP_CHECK_INQUIRY', '158_AP_CHECKS_ISSUED_158', '158_AP_BY_CARRIER_RTS', '158_AP_BY_CARRIER_DETAIL_RTSC', '158_AP_BY_CARRIER_DETAIL_RTS', '158_AP_BY_CARRIER', '158_AP_BIW_PRQST_OUTSTAND', '158_AP_BIW_PAYREQUEST_TOTAL', '158_AP_BIW_PAYREQUEST', '158_AP_ACCTG_BY_CASEYR')
ORDER BY QRYNAME, FLDNUM

SELECT * FROM PSQRYFIELDLANG
SELECT * FROM PSQRYFLAGS WHERE QRYNAME='WCB_AP_505F_CHECK_LIST'
SELECT * FROM PSQRYLINK
SELECT * FROM PSQRYRECORD WHERE QRYNAME='WCB_AP_505F_CHECK_LIST'
SELECT * FROM PSQRYSELECT WHERE QRYNAME='WCB_AP_505F_CHECK_LIST'

-- TREE STRUCTURES
SELECT * FROM PSTREESTRCT WHERE TREE_STRCT_ID='ACCOUNT'
SELECT * FROM PSTREESTRCTLANG

-- TREES
SELECT * FROM PSTREEDEFN WHERE TREE_NAME = 'ACCOUNT'
SELECT * FROM PSTREEDEFNLANG
SELECT * FROM PSTREEBRANCH
SELECT * FROM PSTREELEAF
SELECT * FROM PSTREELEVEL
SELECT * FROM PSTREENODE WHERE TREE_NAME='ACCOUNT'
SELECT * FROM PSTREEPROMPT
SELECT * FROM PSTREESELCTL
SELECT * FROM PSTREESELNUM
````````
SELECT * FROM PSTREESELECT02
SELECT * FROM PSTREESELECT03
SELECT * FROM PSTREESELECT04
SELECT * FROM PSTREESELECT05
SELECT * FROM PSTREESELECT06
SELECT * FROM PSTREESELECT07
SELECT * FROM PSTREESELECT08
SELECT * FROM PSTREESELECT09
SELECT * FROM PSTREESELECT10
SELECT * FROM PSTREESELECT11
SELECT * FROM PSTREESELECT12
SELECT * FROM PSTREESELECT13
SELECT * FROM PSTREESELECT14
SELECT * FROM PSTREESELECT15
SELECT * FROM PSTREESELECT16
SELECT * FROM PSTREESELECT17
SELECT * FROM PSTREESELECT18
SELECT * FROM PSTREESELECT19
SELECT * FROM PSTREESELECT20
SELECT * FROM PSTREESELECT21
SELECT * FROM PSTREESELECT22
SELECT * FROM PSTREESELECT23
SELECT * FROM PSTREESELECT24
SELECT * FROM PSTREESELECT25
SELECT * FROM PSTREESELECT26
SELECT * FROM PSTREESELECT27
SELECT * FROM PSTREESELECT28
SELECT * FROM PSTREESELECT29
SELECT * FROM PSTREESELECT30

-- ACCESS GROUPS
SELECT * FROM PS_ACCESS_GRP_TBL
SELECT * FROM ACCESS_GRP_LANG

-- COLORS
SELECT * FROM PSCOLORDEFN

-- STYLES
SELECT * FROM PSSTYLEDEFN
SELECT * FROM PSSTYLEDEFNLANG

-- BUSINESS PROCESSES
SELECT * FROM PSBUSPROCDEFN
SELECT * FROM PSBUSPROCITEM
SELECT * FROM PSBUSPROCLANG
SELECT * FROM PSBUSPROCSEC
SELECT * FROM PSBUSPRIMG
SELECT * FROM PSBUSPITEMIMG
SELECT * FROM PSBUSPITEMLANG
SELECT * FROM PSBUSPRIMGLANG

-- ACTIVITIES
SELECT * FROM PSACTIVITYDEFN
SELECT * FROM PSACTIVITYLANG
SELECT * FROM PSACTIVIMG
SELECT * FROM PSACTIVIMGLANG
SELECT * FROM PSSTEPDEFN
SELECT * FROM PSEVENTDEFN
SELECT * FROM PSEVENTROUTE
SELECT * FROM PSMSGAGTDEFN
SELECT * FROM PSMAPEXPR
SELECT * FROM PSMAPFIELD
SELECT * FROM PSMAPLEVEL
SELECT * FROM PSMAPRECFIELD
SELECT * FROM PSMAPROLEBIND
SELECT * FROM PSMAPROLENAME

-- PROCESS DEFINITIONS
SELECT * FROM PS_PRCSDEFN WHERE PRCSNAME = 'WCBAR007'
SELECT * FROM PS_PRCSDEFNLANG
SELECT * FROM PS_PRCSDEFNGRP
SELECT * FROM PS_PRCSDEFNPNL WHERE PRCSNAME = 'WCBCR002'
SELECT * FROM PS_PRCSDEFNXFER
SELECT * FROM PS_PRCSDEFNNOTIFY
SELECT * FROM PS_PRCSDEFNCNTDIST
SELECT * FROM PS_PRCSDEFNMESSAGE
SELECT * FROM PS_PRCSDEFNMETA
SELECT * FROM PS_PRCSDEFNURL
SELECT * FROM PS_PRCSDEFNURL_LNG
SELECT * FROM PS_PRCSDEFNURLKEY

-- PROCESS SERVERS
SELECT * FROM PS_SERVERCLASS
SELECT * FROM PS_SERVERDEFN
SELECT * FROM PS_SERVERNOTIFY
SELECT * FROM PS_SERVERMESSAGE
SELECT * FROM PS_SERVEROPRTN
SELECT * FROM PS_SERVERCATEGORY

-- PROCESS TYPES
SELECT * FROM PS_PRCSTYPEDEFN
SELECT * FROM PS_PRCSTYPEDEFNLNG
SELECT * FROM PS_PRCSTYPEMETA

-- PROCESS JOBS
SELECT * FROM PS_PRCSJOBDEFN WHERE PRCSJOBNAME LIKE 'WCBJAR%'
SELECT * FROM PS_PRCSJOBDEFNLANG
SELECT * FROM PS_PRCSJOBGRP
SELECT * FROM PS_PRCSJOBITEM WHERE PRCSJOBNAME='ARSTMT'
SELECT * FROM PRCSJOBPNL
SELECT * FROM PS_PRCSJOBNOTIFY
SELECT * FROM PS_PRCSJOBCNTDIST
SELECT * FROM PS_PRCSJOBMESSAGE
SELECT * FROM PS_PRCSSEQUENCE
SELECT * FROM PS_PRCSOUTPUTLIST
SELECT * FROM PS_PRCSOUTDESTTYPE
SELECT * FROM PS_PRCSSYSTEM
SELECT * FROM PS_PRCSPURGELIST
SELECT * FROM PS_PRCS_CAT_TBL
SELECT * FROM PS_PRCS_CAT_LG_TBL

-- PROCESS RECURRENCE
SELECT * FROM PS_PRCSRECUR
SELECT * FROM PS_PRCSRECURLANG
SELECT * FROM PS_PRCSRECURDATE
SELECT * FROM PS_PRCSRECUREXEMPT

-- PROCESS CONTROL
SELECT * FROM PS_SCHDLDEFN
SELECT * FROM PS_SCHDLDEFNLANG
SELECT * FROM PS_SCHDLITEM
SELECT * FROM PS_SCHDLMESSAGE
SELECT * FROM PS_SCHDLNODEPARM
SELECT * FROM PS_SCHDLNOTIFY
SELECT * FROM PS_SCHDLRPTDIST
SELECT * FROM PS_SCHDLTEXT

-- DIMENSIONS
SELECT * FROM DIMENSION
SELECT * FROM DIMENSION_LANG
SELECT * FROM DIM_CTRL_TBL
SELECT * FROM DIM_DATA_SRC
SELECT * FROM DIM_INPUT_FLD
SELECT * FROM DIM_ROLLUP
SELECT * FROM DIM_ROLLUP_LVL

-- ANALYSIS MODELS
SELECT * FROM ANALYSIS_MODEL
SELECT * FROM ANL_MOD_DAT_SRC
SELECT * FROM ANL_MOD_DIM
SELECT * FROM ANL_MOD_DIM_FLD

-- CUBE TEMPLATES
SELECT * FROM PS_ANALYSIS_DB
SELECT * FROM ANALYSIS_DB_DIM
SELECT * FROM ANL_DB_LANG
SELECT * FROM ANL_DB_QRY_ESS
SELECT * FROM CUBE_AGG_DEF
SELECT * FROM CUBE_AGG_DIM
SELECT * FROM CUBE_FILTER_ITM

-- BUSINESS INTERLINKS
SELECT * FROM PSIODEFN
SELECT * FROM PSIODEFNLANG
SELECT * FROM PSIOINPUTS
SELECT * FROM PSIOOUTPUTS
SELECT * FROM PSIOSETTINGS

-- SQL
SELECT * FROM PSSQLDEFN
SELECT * FROM PSSQLDESCR
SELECT * FROM PSSQLLANG
SELECT * FROM PSSQLTEXTDEFN

-- FILE LAYOUT DEFINITIONS
SELECT * FROM PSFLDDEFN
SELECT * FROM PSFLDFIELDDEFN
SELECT * FROM PSFLDSEGDEFN

-- BUSINESS COMPONENTS
SELECT * FROM PSBCDEFN
SELECT * FROM PSBCDEFNLANG
SELECT * FROM PSBCITEM
SELECT * FROM PSBCITEMLANG

-- APP ENGINE PROGRAMS
SELECT * FROM PSAEAPPLDEFN WHERE AE_APPLID='PO_POCANCEL'
SELECT * FROM PSAEAPPLLANG WHERE AE_APPLID='PO_POCANCEL'
SELECT * FROM PSAEAPPLSTATE WHERE AE_APPLID='PO_POCANCEL'
SELECT * FROM PSAEAPPLTEMPTBL WHERE AE_APPLID='PO_POCANCEL'

-- APP ENGINE SECTIONS
SELECT * FROM PSAESECTDEFN WHERE AE_APPLID='PO_POCANCEL'
SELECT * FROM PSAESECTDTLDEFN WHERE AE_APPLID='PO_POCANCEL'
SELECT * FROM PSAESTEPDEFN WHERE AE_APPLID='PO_POCANCEL'
SELECT * FROM PSAESTEPMSGDEFN WHERE AE_APPLID='PO_POCANCEL'
SELECT * FROM PSAESTMTDEFN WHERE AE_APPLID='PO_POCANCEL'
SELECT * FROM PS_AEINSTANCENBR WHERE AE_APPLID='PO_POCANCEL'
SELECT * FROM PS_AELOCKMGR WHERE AE_APPLID='PO_POCANCEL'

-- MESSAGE NODES
SELECT * FROM PSMSGNODEDEFN
SELECT * FROM PSNODEDEFNLANG
SELECT * FROM PSCONNECTSTRING
SELECT * FROM PSNODEURITEXT
SELECT * FROM PSNODECONPROP
SELECT * FROM PSNODCONPRPLANG
SELECT * FROM PSNODEPROP
SELECT * FROM PSNODEPROPLANG
SELECT * FROM PSNODESDOWN
SELECT * FROM PSTRUSTNODES


-- MESSAGE CHANNELS
SELECT * FROM PSCHNLDEFN
SELECT * FROM PSCHNLDEFNLANG
SELECT * FROM PSCHNLNODE
SELECT * FROM PSSUBCHNL

-- MESSAGE DEFINITIONS
SELECT * FROM PSMSGDEFN
SELECT * FROM PSMSGDEFNLANG
SELECT * FROM PSMSGFLDOVR
SELECT * FROM PSMSGREC
SELECT * FROM PSMSGVER

-- APPROVAL RULE SETS
SELECT * FROM APPR_HDR_LNG
SELECT * FROM APPR_RULE_AMT
SELECT * FROM APPR_RULE_DETL
SELECT * FROM APPR_RULE_FIELD
SELECT * FROM APPR_RULE_HDR
SELECT * FROM APPR_RULE_LN
SELECT * FROM APPR_RULE_QTY
SELECT * FROM APPR_RULE_ROLE
SELECT * FROM PSVAITEM
SELECT * FROM PSVAITEMIMG
SELECT * FROM PSVAITEMLANG

-- IMAGE AND HTMLCATALOG-- CONTENT
SELECT * FROM PSCONTDEFN
SELECT * FROM PSCONTDEFNLANG
SELECT * FROM PSCONTENT
SELECT * FROM PSCONTENTLANG

-- STYLE SHEETS
SELECT * FROM PSSTYLECLASS
SELECT * FROM PSSTYLECLASSFNT
SELECT * FROM PSSTYLSHEETDEFN
SELECT * FROM PSSTYLECLSLANG
SELECT * FROM PSSTYLEFNTLANG
SELECT * FROM PSSTYLEDFNLANG


-- LANGUAGES
SELECT * FROM PSLANGUAGES
SELECT * FROM PS_STRINGS_TBL
SELECT * FROM PS_STRINGS_LNG_TBL

-- SUBSCRIPTIONS
SELECT * FROM PSSUBDEFN

-- RECORD GROUP
SELECT * FROM PS_REC_GROUP_REC
SELECT * FROM PS_REC_GROUP_TBL

-- CHANGE CONTROL
SELECT * FROM PSCHGCTLHIST
SELECT * FROM PSCHGCTLLOCK

-- OBJECT CHANGE (RENAMES)
SELECT * FROM PSOBJCHNG

-- APP MESSAGING
SELECT * FROM PSAPMSGARCHPC
SELECT * FROM PSAPMSGARCHPD
SELECT * FROM PSAPMSGARCHPH
SELECT * FROM PSAPMSGARCHSC
SELECT * FROM PSAPMSGARCHTMP
SELECT * FROM PSAPMSGPUBATTR
SELECT * FROM PSAPMSGPUBCERR
SELECT * FROM PSAPMSGPUBCERRP
SELECT * FROM PSAPMSGPUBCLOCK
SELECT * FROM PSAPMSGPUBCON
SELECT * FROM PSAPMSGPUBCSYNC
SELECT * FROM PSAPMSGPUBDATA
SELECT * FROM PSAPMSGPUBERR
SELECT * FROM PSAPMSGPUBERRP
SELECT * FROM PSAPMSGPUBHDR
SELECT * FROM PSAPMSGPUBINST
SELECT * FROM PSAPMSGPUBLOCK
SELECT * FROM PSAPMSGPUBSYNC
SELECT * FROM PSAPMSGSUBCERR
SELECT * FROM PSAPMSGSUBCERRP
SELECT * FROM PSAPMSGSUBCLOCK
SELECT * FROM PSAPMSGSUBCON
SELECT * FROM PSAPMSGSUBCSYNC
SELECT * FROM PSAPMSGSUBPRCID
SELECT * FROM PSAPMSGXTB

-- URL DEFINITIONS
SELECT * FROM PSURLDEFN
SELECT * FROM PSURLDEFNLANG

-- PORTAL
SELECT * FROM PSPRSMDEFN
SELECT * FROM PSPRSMDEFNLANG
SELECT * FROM PSPRSMATTR
SELECT * FROM PSPRSMATTRLANG
SELECT * FROM PSPRSMATTRVAL
SELECT * FROM PSPRSMATTRVALNG
SELECT * FROM PSPRSMPERM
SELECT * FROM PSPRSMSYSATTR
SELECT * FROM PSPRSMSYSATTRVL
SELECT * FROM PSPRSMHPASGPGLT
SELECT * FROM PSPRSMSYNC
SELECT * FROM PSPRDMDEFN
SELECT * FROM PSPRDMDEFNLANG
SELECT * FROM PSPRDMCNTPRV
SELECT * FROM PSPRUHPERSPGLT

-- RELATIONSHIPS
SELECT * FROM PSRELATCONTACT
SELECT * FROM PSRELATIONLANG
SELECT * FROM PSRELATIONPROP
SELECT * FROM PSRELATIONSHIP
SELECT * FROM PSRELPROPLANG

-- APPLICATION PACKAGES
SELECT * FROM PSPACKAGEDEFN
SELECT * FROM PSPACKAGELANG
SELECT * FROM PSAPPCLASSDEFN

-- ARCHIVE TEMPLATES
SELECT * FROM PS_ARCH_PROJ
SELECT * FROM PS_ARCH_TBL
SELECT * FROM PS_ARCH_CTRL
SELECT * FROM PS_ARCH_OTH_CTRL
SELECT * FROM PS_ARCH_SQL_LNG

-- ARCHIVE OBJECTS
SELECT * FROM PSARCHOBJDEFN
SELECT * FROM PSARCHOBJLANG
SELECT * FROM PSARCHOBJREC

-- ARCHIVE TEMPLATES (TYPE 2)
SELECT * FROM PSARCHTEMPLATE
SELECT * FROM PSARCHTEMPLANG
SELECT * FROM PSARCHTEMPOBJ
SELECT * FROM PSARCHTEMPQRY
SELECT * FROM PSARCHTEMPAE

-- DIAGNOSTIC PLUGINS
SELECT * FROM PSDIAGREG

-- CONNECT STRINGS
SELECT * FROM PSCONN
SELECT * FROM PSCONNLANG
SELECT * FROM PSCONNPROP
SELECT * FROM PSCONNPROPLANG

-- FORMAT DEFINITIONS
SELECT * FROM PSCIREF
SELECT * FROM PSCIREFLANG
SELECT * FROM PSCIREFPROPERTY
SELECT * FROM PSCIREFENUM
SELECT * FROM PSCISYNCDEFN

-- EVALUATED NODE TRANSACTION
SELECT * FROM PSNODETRX
SELECT * FROM PSNODTRXCONPROP


-- EVALUATED RELATIONSHIP TRANSACTION
SELECT * FROM PSRELATIONTRX

-- MOBILE PAGE
SELECT * FROM PSMPDEFN
SELECT * FROM PSMPDEFNLANG
SELECT * FROM PSMPDEFNDEV
SELECT * FROM PSMPDEFNDEVLANG
SELECT * FROM PSMPCONTDEV
SELECT * FROM PSMPCONTDEVLANG
SELECT * FROM PSSYSTEMID
SELECT * FROM PSAUTHMP

-- DICTIONARY
SELECT * FROM PSSCDICTDEFN

-- MESSAGES
SELECT * FROM PSMSGSETDEFN
SELECT * FROM PSMSGSETLANG
SELECT * FROM PSMSGCATDEFN
SELECT * FROM PSMSGCATLANG

-- PROBLEM DEFINITIONS
SELECT * FROM PSOPTPRBTYPE
SELECT * FROM PSOPTPRBTYPELNG
SELECT * FROM PSOPTTRN
SELECT * FROM PSOPTTRNLNG
SELECT * FROM PSOPTTRNCTLG
SELECT * FROM PSOPTREC
SELECT * FROM PSOPTRECLNG
SELECT * FROM PSOPTFIELD

-- PORTAL REGISTRY USER FAVORITES
SELECT * FROM PSPRUFDEFN

-- PORTAL USER REGISTRY HOMEPAGE
SELECT * FROM PSPRUHDEFN
SELECT * FROM PSPRUHTAB
SELECT * FROM PSPRUHTABPGLT

-- SYSTEM PAUSE TIME
SELECT * FROM PSSPTDEFN
SELECT * FROM PSSPTIMES

-- TOOLBARS
SELECT * FROM PSTOOLBARDEFN
SELECT * FROM PSTOOLBARITEM

-- MAINTENANCE LOG
SELECT * FROM PS_MAINTENANCE_LOG

-- HOLIDAY DEFINITIONS
SELECT * FROM PSHOLIDAYDEFN

-- USERS
-- Note: PSOPRDEFN SELECT * FROM ed separately, see top of script
SELECT * FROM PSOPRALIAS
SELECT * FROM PSROLEUSER
SELECT * FROM PSUSERATTR
SELECT * FROM PSUSEREMAIL
SELECT * FROM PSUSERPRSNLOPTN
SELECT * FROM PS_ROLEXLATOPR
SELECT * FROM PS_ROLEXLATOPR_LNG
SELECT * FROM PS_RTE_CNTL_RUSER

-- ROLES
SELECT * FROM PSROLEDEFN
SELECT * FROM PSROLEDEFNLANG
SELECT * FROM PSROLECANGRANT
SELECT * FROM PSROLECLASS

-- PERMISSION LISTS
SELECT * FROM PSCLASSDEFN
SELECT * FROM PSAUTHBUSCOMP
SELECT * FROM PSAUTHCHNLMON
SELECT * FROM PSAUTHCUBE
SELECT * FROM PSAUTHITEM
SELECT * FROM PSAUTHOPTN
SELECT * FROM PSAUTHPRCS
SELECT * FROM PSAUTHSIGNON
SELECT * FROM PSPRCSPRFL
SELECT * FROM PS_MC_OPR_SECURITY
SELECT * FROM PS_MC_OPRID
SELECT * FROM PS_SCRTY_ACC_GRP
SELECT * FROM PS_SCRTY_QUERY

-- DEFINITION SECURITY
SELECT * FROM PSOBJGROUP
SELECT * FROM PSOPROBJ

-- PERSONALIZATIONS
SELECT * FROM PSUSEROPTNDEFN
SELECT * FROM PSUSEROPTNLANG
SELECT * FROM PSOPTNCATGRPLNG
SELECT * FROM PSOPTNCATGRPTBL
SELECT * FROM PSOPTNCATTBL
SELECT * FROM PSOPTNCATLANG

-- SECURITY OPTIONS
SELECT * FROM PSSECOPTIONS

-- SECURITY LINKS
SELECT * FROM PSUSEROTHER
SELECT * FROM PSUSERSELFOTHER
SELECT * FROM PSROLEOTHER
SELECT * FROM PSPERMLISTOTHER

-- USER ID TYPES
SELECT * FROM PSOPRALIASTYPE
SELECT * FROM PSOPRALIASFIELD

-- DELETE USER BYPASS TABLE
SELECT * FROM PS_BYPASS_TABLE

-- FORGOT EMAIL TEXT
SELECT * FROM PSPSWDEMAIL
SELECT * FROM PSPSWDEMAILLANG

-- PASSWORD HINTS
SELECT * FROM PSPSWDHINT
SELECT * FROM PSPSWDHINT_LANG

-- SIGNON PEOPLECODE
SELECT * FROM PSSIGNONPPC

-- DIRECTORY
SELECT * FROM PSDSDIR
SELECT * FROM PSDSSRVR
SELECT * FROM DSCONNECTID
SELECT * FROM PSDSEXT_INSTALL
SELECT * FROM PSDSSECMAPMAIN
SELECT * FROM PSDSSECMAPSRVR
SELECT * FROM DSUSRPRFLMAP
SELECT * FROM PSDSUSERPRFL
SELECT * FROM PSDSSECROLERULE
SELECT * FROM DSSRCH_SBR
SELECT * FROM DSSRCHATTR
SELECT * FROM DSSECFILTER
SELECT * FROM PT_WF_NOT_DSCFG

-- PEOPLETOOLS SYSTEM DATA
SELECT * FROM PSCERTDB
SELECT * FROM PSCRYPTALGCHAIN
SELECT * FROM PSCRYPTALGDEFN
SELECT * FROM PSCRYPTALGPARAM
SELECT * FROM PSCRYPTCHNDEFN
SELECT * FROM PSCRYPTDLLDEFN
SELECT * FROM PSTIMEZONE
SELECT * FROM PSTIMEZONELANG
SELECT * FROM PSDSTTIME
SELECT * FROM PSKEYDB
SELECT * FROM PSCHARSETS
SELECT * FROM PS_OLAP_ATTRIB_NAM
SELECT * FROM PS_VERTICAL_MARKET
SELECT * FROM PS_APP_DES_OBJECTS
SELECT * FROM PS_APP_DES_OBJ_PAR
SELECT * FROM PSPGEACCESSDESC
SELECT * FROM PSOBJSECDESC
SELECT * FROM PSOPTPARMTYPE
SELECT * FROM PSLOCALEDEFN
SELECT * FROM PSLOCALELANG
SELECT * FROM PSLOCALEOPTNDFN
SELECT * FROM PSCOLLATIONS
SELECT * FROM PS_CDM_FILE_EXT
SELECT * FROM PS_AEONLINEINST
SELECT * FROM PS_WL_TEMPLATE_GEN
SELECT * FROM PS_WL_TEMPL_GEN_TK
SELECT * FROM PSGATEWAY
SELECT * FROM PS_INSTALLATION_IB
SELECT * FROM PSRF_FLIST_TBL
SELECT * FROM PSRF_FLIST_LANG
SELECT * FROM PSRF_FVIEW_TBL
SELECT * FROM PSRF_FVIEW_LANG
SELECT * FROM PS_DECIMAL_POS_TBL
SELECT * FROM PS_WL_TEMPL_GNTKLN
SELECT * FROM PSACTIVEXLIC
SELECT * FROM PS_APPDES_OBJ_PERM
SELECT * FROM PSXMLSIGNINST
SELECT * FROM PS_TS_REC_KEYFLDS
SELECT * FROM PS_TS_REC_TXTFLDS
SELECT * FROM PS_TS_RECORDS
SELECT * FROM PS_MCF_INSTALL
SELECT * FROM PS_MCFIMNETWORKS
SELECT * FROM PSMCFRENPERMS
SELECT * FROM PSMCFSYSTEM
SELECT * FROM PS_MCFUQTASKCFG
SELECT * FROM PS_PINGOPTIONS
SELECT * FROM PSVERITYLOCALE
SELECT * FROM PS_PTP_TABLE1
SELECT * FROM PS_PTP_TABLE2
SELECT * FROM PS_PT_CTI_SWITCH
SELECT * FROM PS_WF_INSTSTATUS
SELECT * FROM PSIBWSDLADMIN
SELECT * FROM PSRENNAMETOPIC
SELECT * FROM PSTRANSFRM_TST

-- WEB Data
SELECT * FROM PSWEBPROFBROW
SELECT * FROM PSWEBPROFCOOK
SELECT * FROM PSWEBPROFDEF
SELECT * FROM PSWEBPROFILE
SELECT * FROM PSWEBPROFPROP
SELECT * FROM PSWEBPROFNVP

-- XML Service Info
SELECT * FROM PS_XMLSERVICEINFO

-- EDI OBJECTS
SELECT * FROM PS_ECACTIONCDS
SELECT * FROM PS_ECACTIONS
SELECT * FROM PS_ECCVTPROFILE
SELECT * FROM PS_ECENTITYCDS
SELECT * FROM PS_ECEXTPARTNER
SELECT * FROM PS_ECEXTTPLINK
SELECT * FROM PS_ECGENERAL
SELECT * FROM PS_ECINMAPFILE
SELECT * FROM PS_ECINMAPFLD
SELECT * FROM PS_ECINMAPFLDCVT
SELECT * FROM PS_ECINMAPREC
SELECT * FROM PS_ECINMAPRECFLD
SELECT * FROM PS_ECINTLINK
SELECT * FROM PS_ECINTPARTNER
SELECT * FROM PS_ECMAPDEFN
SELECT * FROM PS_ECMAPPROFILE
SELECT * FROM PS_ECNAMES
SELECT * FROM PS_ECOUTMAPCVT
SELECT * FROM PS_ECOUTMAPFLD
SELECT * FROM PS_ECOUTMAPREC
SELECT * FROM PS_ECOUTMAPWHERE
SELECT * FROM PS_ECPRIEVENTCDS
SELECT * FROM PS_ECPRODFLTS
SELECT * FROM PS_ECPROMAP
SELECT * FROM PS_ECPROTRANS
SELECT * FROM PS_ECSECEVENTCDS
SELECT * FROM PS_ECTPALIAS
SELECT * FROM PS_ECTPCVT
SELECT * FROM PS_ECTPCVT_HDR
SELECT * FROM PS_ECTPCVT_LN
SELECT * FROM PS_ECTPPROFILE
SELECT * FROM PS_ECTRANS
SELECT * FROM PS_ECTRANSOPTION
SELECT * FROM PS_ECTRANSOPVAL


-- SDK Data
SELECT * FROM PS_SDK_AMORT_PREF
SELECT * FROM PS_SDK_BUS_EXP_DTL
SELECT * FROM PS_SDK_BUS_EXP_PER
SELECT * FROM PS_SDK_COMPANY_TBL
SELECT * FROM PS_SDK_COUNTRY_TBL
SELECT * FROM PS_SDK_CURR_CD_TBL
SELECT * FROM PS_SDK_DEPT_TBL
SELECT * FROM PS_SDK_EM_MAILLST
SELECT * FROM PS_SDK_EM_RCVMSGS
SELECT * FROM PS_SDK_EM_SNDEMAIL
SELECT * FROM PS_SDK_FILEUTL_AET
SELECT * FROM PS_SDK_INSTALL
SELECT * FROM PS_SDK_INTL_FLG_CD
SELECT * FROM PS_SDK_JOB
SELECT * FROM PS_SDK_LOCH_TBL
SELECT * FROM PS_SDK_PERS_DATA
SELECT * FROM PS_SDK_POS_DATA
SELECT * FROM PS_SDK_PSTREENODE
SELECT * FROM PS_SDK_RP_INPUT
SELECT * FROM PS_SDK_RP_PO
SELECT * FROM PS_SDK_RP_POLINE
SELECT * FROM PS_SDK_RP_QUERYWRK
SELECT * FROM PS_SDK_RP_RESULT
SELECT * FROM PS_SDK_RP_SALORDER
SELECT * FROM PS_SDK_RP_SITE
SELECT * FROM PS_SDK_RP_SOQRY1
SELECT * FROM PS_SDK_RP_SOQRY2
SELECT * FROM PS_SDK_RT_TYPE_TBL
SELECT * FROM PS_SDK_RUNCNTL
SELECT * FROM PS_SDK_SCRTY_DEPT
SELECT * FROM PS_SDK_SM
SELECT * FROM PS_SDK_SM_CONCATE
SELECT * FROM PS_SDK_SRCHSPREF
SELECT * FROM PS_SDK_SRCH_SAVE
SELECT * FROM PS_SDK_STOCK
SELECT * FROM PS_SDK_STOCKXCHG
SELECT * FROM PS_SDK_STOCK_PRF
SELECT * FROM PS_SDK_UPS_COST
SELECT * FROM PS_SDK_UPS_CST_RES
SELECT * FROM PS_SDK_UPS_TIME

-- Performance Monitor Data
SELECT * FROM PSPMCONTEXTDEFN
SELECT * FROM PSPMEVENTDEFN
SELECT * FROM PSPMEVENTSET
SELECT * FROM PSPMMETRICDEFN
SELECT * FROM PSPMMETRICVALUE
SELECT * FROM PSPMMONITORGBL
SELECT * FROM PSPMSYSDEFAULTS
SELECT * FROM PSPMTABLEMAP
SELECT * FROM PSPMTRANSDEFN
SELECT * FROM PSPMTRANSSET
SELECT * FROM PSPMTRANSSET_LN

-- Mathematical Model
SELECT * FROM PSOPTMODEL
SELECT * FROM PSOPTMODELLNG
SELECT * FROM PSOPTINDEX
SELECT * FROM PSOPTOBJECTIVE
SELECT * FROM PSOPTINDEXSET
SELECT * FROM PSOPTSLICESET
SELECT * FROM PSOPTPRED
SELECT * FROM PSOPTLINEXP
SELECT * FROM PSOPTCONSEXP
SELECT * FROM PSOPTVARARRAY
SELECT * FROM PSOPTPARARRAY
SELECT * FROM PSOPTREGION
SELECT * FROM PSOPTCONARRAY
SELECT * FROM PSOPTSETDIM
SELECT * FROM PSOPTSLICEDIM
SELECT * FROM PSOPTPREDDIM
SELECT * FROM PSOPTVAREXPDIM
SELECT * FROM PSOPTPARAEXPDIM
SELECT * FROM PSOPTVARSDIM
SELECT * FROM PSOPTPARSDIM
SELECT * FROM PSOPTREGIONDIM

-- File Reference
SELECT * FROM PSFILEREDEFN

-- File Reference Type code
SELECT * FROM PSTYPECODEDEFN


SELECT PRCSPNL.PRCSNAME, MENUGROUP || ' > ' || MENULABEL || ' > ' || BARLABEL || ' > ' || ITEMLABEL "Path"
FROM PSMENUITEM MENU, PS_PRCSDEFNPNL PRCSPNL, PSMENUDEFN MNUDFN
WHERE MENU.PNLGRPNAME = PRCSPNL.PNLGRPNAME
AND MNUDFN.MENUNAME = MENU.MENUNAME
AND PRCSPNL.PRCSNAME = 'WCBCR017'


SELECT * FROM PSPROJECTITEM WHERE PROJECTNAME=''

SELECT * FROM PS_WCB_AR_STMT_RD

SELECT * FROM PS_CUSTOMER WHERE CUST_ID IN ('1320839','1320841')



SELECT B.BUSINESS_UNIT
FROM (PS_CART_GROUP_INV A LEFT OUTER JOIN PS_CART_ATTRIB_INV B ON A.CART_GROUP = B.CART_GROUP )


SELECT * FROM PS_VOUCHER WHERE PO_ID LIKE '0000045626'

SELECT * FROM PS_VENDOR