SPB_SUP_NET_VW

(SQL View)
Index Back

Network Roster Work Record

Suppler Network Roster Work Record

SELECT B.BUSINESS_UNIT , B.VENDOR_ID , V.NAME1 , VS.SPB_SUPPLIER_TYPE , B.EFF_STATUS , B.SPM_SOURCETYPE FROM PS_SPM_BU_SUPPLIER B , PS_VENDOR V , PS_VENDOR_SPRO VS , PS_SET_CNTRL_GROUP S WHERE %EffdtCheck(SPM_BU_SUPPLIER B_S, B, %CurrentDateIn) AND V.VENDOR_ID = B.VENDOR_ID AND VS.VENDOR_ID = B.VENDOR_ID AND B.BUSINESS_UNIT = S.SETCNTRLVALUE AND S.REC_GROUP_ID = 'FS_38' AND S.SETID = V.SETID AND VS.SETID = V.SETID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: BUS_UNIT_SP_VW

2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VENDOR_SPRO_VW

3 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
4 SPB_SUPPLIER_TYPE Character(1) VARCHAR2(1) NOT NULL Supplier Type
B=Both
D=Deliverable
R=Resource
5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

6 SPM_SOURCETYPE Character(4) VARCHAR2(4) NOT NULL Supplier Network Source Type
0=Internal
1=Primary
2=Secondary
3=Tertiary