APPCLASS_PATHSAC_APPXROOT_VW(SQL View) |
Index Back |
|---|---|
SCM Arch AppPath non-root viewSupply Chain Architecture Application Path prompt view for non-root packages. Used by dynamic view SAC_APPPATH_VW. |
| SELECT DISTINCT %TrimSubstr(C.PACKAGEROOT,1,15) %Concat ':' %Concat C.QUALIFYPATH , C.PACKAGEROOT , C.QUALIFYPATH , P.DESCR FROM PSAPPCLASSDEFN C , PSPACKAGEDEFN P WHERE C.PACKAGEROOT = P.PACKAGEROOT AND C.QUALIFYPATH <> ':' AND C.QUALIFYPATH = %TrimSubstr(P.QUALIFYPATH,1,15) %Concat ':' %Concat P.PACKAGEID |
| # | 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 |