SPM_SUPINVAP_VW (SQL View)	Index Back
Services Supplier Prov Contact Services Supplier Prov Contact

SPM_SUPINVAP_VW

(SQL View)

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 , PS_ROLEXLATOPR D , PSROLEUSER E , PS_SPB_USRSTP_ROLE F 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 A.USER_ACC_STATUS <> '0' AND C.PERSON_ID = A.PERSON_ID AND C.OPRALIASTYPE = 'SPP' AND C.OPRID = D.OPRID AND D.ROLEUSER = E.ROLEUSER AND E.ROLENAME = F.ROLENAME AND F.SP_USER_TYPE = 'PC'

# 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

#	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