PL_PO_FR_PLR_VW

(SQL View)
Index Back

Plan/Purch From Dts by Planner

This 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