PLANNER_CDSPL_PO_PLNR_VW2(SQL View) |
Index Back |
|---|---|
Purchasing Planner ViewThis search view is used to provide the user with a list of existing Planners found in the PL_SF_OP_HEADER table. |
| SELECT DISTINCT A.PLANNER_CD , B.NAME FROM PS_SPL_PO_MESSAGE A , PS_PLANNER_TBL B WHERE A.PLANNER_CD = B.PLANNER_CD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PLANNER_CD |
Character(12) | VARCHAR2(12) NOT NULL | Planner Code |
| 2 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |