GPTH_COM_FAX_VW (SQL View)	Index Back
Company Fax Company Fax

GPTH_COM_FAX_VW

(SQL View)

Company Fax

SELECT A.COMPANY , A.PHONE FROM PS_COMP_PHONE_TBL A WHERE A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_COMP_PHONE_TBL A_ED WHERE A.COMPANY = A_ED.COMPANY AND A_ED.EFFDT <= %CurrentDateIn) AND A.phone_type = 'FAX'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

2 FAX Character(24) VARCHAR2(24) NOT NULL Fax Number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
2	FAX	Character(24)	VARCHAR2(24) NOT NULL	Fax Number