BU_GROUPPLANNER_CDPL_PO_PLNRGP_VW(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 PGI.BU_GROUP , A.BUSINESS_UNIT_IN , A.PLANNER_CD , B.NAME FROM PS_PL_PO_PLAN_ORD A , PS_PL_GROUP_IN PGI , PS_PLANNER_TBL B WHERE PGI.BUSINESS_UNIT = A.BUSINESS_UNIT_IN AND A.PLANNER_CD = B.PLANNER_CD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BU_GROUP |
Character(6) | VARCHAR2(6) NOT NULL | 08/16/01 EGS (CN#PL880-1.0): Added |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | PLANNER_CD |
Character(12) | VARCHAR2(12) NOT NULL | Planner Code |
| 4 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |