PL_FROM_DT_VW(SQL View) |
Index Back |
---|---|
PLanning From Dates ViewThis 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 |