SPB_RSSLR_LG_VW(SQL View) |
Index Back |
---|---|
Supplier by region/servicetypeSupplier by region/servicetype Related Language View |
SELECT A.SETID ,A.REGION_CD ,A.ROLE_TYPE , B.LANGUAGE_CD ,C.DESCRSHORT ,B.DESCR FROM PS_SPB_REGSER_SPLR A , PS_SPB_REGCD_LG_VW B , PS_SPB_ROLE_TYPE C , PS_SET_CNTRL_GROUP S , PS_SET_CNTRL_GROUP RT WHERE A.REGION_CD = B.REGION_CD AND A.ROLE_TYPE = C.ROLE_TYPE AND S.SETCNTRLVALUE = A.SETID AND S.REC_GROUP_ID = 'FS_37' AND S.SETID = B.SETID AND RT.SETCNTRLVALUE = A.SETID AND RT.REC_GROUP_ID = 'SP_04' AND RT.SETID = C.SETID AND A.SETID = C.SETID |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
2 | REGION_CD | Character(10) | VARCHAR2(10) NOT NULL |
Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
Prompt Table:
SPB_REGIONCD_VW
|
3 | ROLE_TYPE | Character(6) | VARCHAR2(6) NOT NULL |
Service Type
APR=Approver MGR=Manager OPR=Operator Prompt Table:
SPB_ROLE_TYPE_V
|
4 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |