SETIDVENDOR_IDPrompt Table: VENDOR_SP_VW
EM=Email and Worklist
WL=WorkList Only
Default Value: EM
Default Value: SPM_SPLR_CNT_VW.PERSON_ID
Prompt Table:
SPM_SPLR_CNT_VW
Set Control Field: BUSINESS_UNIT
0=Internal
1=Primary
2=Secondary
3=Tertiary
SPM_BU_SNW_VW2(SQL View) |
Index Back |
|---|---|
Supplier Info by BU w/o Effdt |
| SELECT DISTINCT B.SETID ,B.VENDOR_ID , A.NOTIFY_BY , A.PERSON_ID , A.SPM_SOURCETYPE , A.SUBMITAL_LIMIT FROM PS_SPM_BU_SUPPLIER A , PS_VENDOR_SPRO_VW B , PS_SET_CNTRL_GROUP S WHERE A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_SPM_BU_SUPPLIER A_ED WHERE A.BUSINESS_UNIT = A_ED.BUSINESS_UNIT AND A.VENDOR_ID = A_ED.VENDOR_ID AND A_ED.EFFDT <= %CurrentDateIn) AND A.VENDOR_ID = B.VENDOR_ID AND A.BUSINESS_UNIT = S.SETCNTRLVALUE AND S.REC_GROUP_ID = 'FS_38' AND B.SETID = S.SETID AND A.EFF_STATUS = 'A' |
| # | 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_SP_VW |
| 3 | NOTIFY_BY | Character(4) | VARCHAR2(4) NOT NULL |
Notification Method
EM=Email and Worklist WL=WorkList Only Default Value: EM |
| 4 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL |
Person ID
Default Value: SPM_SPLR_CNT_VW.PERSON_ID Prompt Table:
SPM_SPLR_CNT_VW
|
| 5 | SPM_SOURCETYPE | Character(4) | VARCHAR2(4) NOT NULL |
Supplier Network Source Type
0=Internal 1=Primary 2=Secondary 3=Tertiary |
| 6 | SUBMITAL_LIMIT | Number(2,0) | SMALLINT NOT NULL | Submittal Limit |