EM_FCTR_LOC_VW

(SQL View)
Index Back

Supplier Location View

View of supplier location descriptions.

SELECT DISTINCT C.SETID , C.VENDOR_ID , A.NAME1 , C.VNDR_LOC , C.EFFDT , B.DESCR FROM PS_VENDOR A , PS_VNDR_LOC_SCROL B , PS_VENDOR_LOC C WHERE B.SETID = A.SETID AND B.VENDOR_ID = A.VENDOR_ID AND C.SETID = A.SETID AND C.VENDOR_ID = A.VENDOR_ID AND C.VNDR_LOC = B.VNDR_LOC AND C.EFFDT = ( SELECT MAX(I.EFFDT) FROM PS_VENDOR_LOC I WHERE I.SETID = C.SETID AND I.VENDOR_ID = C.VENDOR_ID AND I.VNDR_LOC = C.VNDR_LOC AND I.EFFDT <= %CurrentDateIn) AND C.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
2 EM_FACTOR_ID Character(10) VARCHAR2(10) NOT NULL If EM_FACTOR_FLAG = "Y", then Factor ID is entered into this field. Factor relationship has to be established in advance. This will be used during Voucher Build to default the Remit To Vendor information.
3 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
4 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

Prompt Table: EM_VNDR_LOC_VW

5 EFFDT Date(10) DATE Effective Date

Default Value: %date

6 DESCR Character(30) VARCHAR2(30) NOT NULL Description