PL_PO_FR_PLR_VW(SQL View) |
Index Back |
---|---|
Plan/Purch From Dts by PlannerThis search view is used to provide the user with a list of existing start dates found in the PL_SF_OP_HEADER table. |
SELECT DISTINCT BUSINESS_UNIT_IN, PLANNER_CD, RELEASE_DATE FROM PS_PL_PO_PLAN_ORD |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
2 | PLANNER_CD | Character(12) | VARCHAR2(12) NOT NULL | Planner Code |
3 | FROM_DT | Date(10) | DATE | From Date |