GVT_ECS_OFFE_VW (SQL View)	Index Back
GVT ECS Off Cycle View 3 Used to track the assigning and usage of the ECS Schedule Numbers.

GVT_ECS_OFFE_VW

Used to track the assigning and usage of the ECS Schedule Numbers.

SELECT A.GVT_SCHEDULE_NO FROM PS_GVT_ECS_CONTROL A WHERE A.GVT_ECS_TRANS_TYPE IN ('03','08') AND A.OFF_CYCLE ='Y' AND A.GVT_ECS_DOS_NAME = ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GVT_SCHEDULE_NO Character(14) VARCHAR2(14) NOT NULL Schedule Number