APPCLASS_PATHSAC_APPROOT_VW(SQL View) |
Index Back |
|---|---|
SCM Arch AppPath root viewSupply Chain Architecture Application Path prompt view for root packages. Used by dynamic view SAC_APPPATH_VW. |
| SELECT DISTINCT %TrimSubstr(C.PACKAGEROOT,1,15) , C.PACKAGEROOT , C.QUALIFYPATH , P.DESCR FROM PSAPPCLASSDEFN C , PSPACKAGEDEFN P WHERE C.PACKAGEROOT = P.PACKAGEROOT AND C.QUALIFYPATH = ':' AND P.QUALIFYPATH = '.' AND P.PACKAGEID = P.PACKAGEROOT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | APPCLASS_PATH |
Character(254) | VARCHAR2(254) NOT NULL | Application Class Full Path |
| 2 | PACKAGEROOT | Character(30) | VARCHAR2(30) NOT NULL | Root Package ID |
| 3 | QUALIFYPATH | Character(127) | VARCHAR2(127) NOT NULL | Qualified Package/Class Path |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |