SPM_SPLRCNT_VW

(SQL View)
 Index Back

Services Supplier Prov Contact


SELECT B.VENDOR_SETID , B.VENDOR_ID , B.LOCATION , B.PERSON_ID ,A.FIRST_NAME ,A.LAST_NAME ,A.NAME FROM PS_SPB_PERSON_TBL A , PS_SPB_SERVICE_PRV B , PSOPRALIAS C WHERE (B.SP_FUNCTION_TYPE = 'PRCT' OR B.SP_FUNCTION_TYPE = 'INDP') AND B.ACTIVE_FLG = 'Y' AND (A.SPRO_PERSON_TYPE = 'SP' OR A.SPRO_PERSON_TYPE = 'BH' OR A.SPRO_PERSON_TYPE = 'PC') AND A.PERSON_ID = B.PERSON_ID AND C.PERSON_ID = A.PERSON_ID AND C.OPRALIASTYPE = 'SPP' AND A.USER_ACC_STATUS <> '0'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VENDOR_SPRO_VW

3 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
4 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

Prompt Table: SPB_PERSON_TBL

5 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
6 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
7 NAME Character(50) VARCHAR2(50) NOT NULL Name