BCNAMEPNLGRPNAMERBG_PNLGRP_VW(SQL View) |
Index Back |
|---|---|
Panlegroup VW |
| SELECT DISTINCT B.BCNAME , C.PNLGRPNAME FROM PSAUTHBUSCOMP A , PSBCDEFN B , PSPNLGRPDEFN C WHERE A.BCNAME = B.BCNAME AND B.BCPGNAME = C.PNLGRPNAME AND B.MARKET = C.MARKET |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BCNAME |
Character(30) | VARCHAR2(30) NOT NULL | Business Component Name (see PSBCDEFN). |
| 2 | PNLGRPNAME |
Character(18) | VARCHAR2(18) NOT NULL | Component Name |