PL_FROM_DT_VW

(SQL View)
Index Back

PLanning From Dates View

This search view is used to provide the user with a list of existing start dates found in the PL_SF_OP_HEADER table. 03/16/98 SCC CN#PL750-JOLVERA-0F6D8: Remove pl_valid_bu_vw as prompt table for bu.

SELECT DISTINCT BUSINESS_UNIT, NEW_START_DATE FROM PS_PL_SF_OP_HEADER

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

2 FROM_DT Date(10) DATE From Date