SETID_PRODUCTPRODUCT_IDLANGUAGE_CDRG_AFCTD_PTY_LN(SQL View) |
Index Back |
|---|---|
Affected Party ViewView of Affected parties for the Product identified with a Change Request. |
| SELECT DISTINCT A.SETID , A.PRODUCT_ID , F.LANGUAGE_CD , F.DESCR FROM PS_RF_INST_PROD A , PS_BO_NAME C , PS_RD_PERSON D , PS_RB_WORKER E , PS_DEPT_TBL_LANG F WHERE A.BO_ID_CONTACT = C.BO_ID AND A.ROLE_TYPE_ID_CNTCT = 4 AND D.BO_ID = A.BO_ID_CONTACT AND E.PERSON_ID = D.PERSON_ID AND E.SETID_DEPT = F.SETID (+) AND E.DEPTID = F.DEPTID (+) AND C.PRIMARY_IND = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID_PRODUCT |
Character(5) | VARCHAR2(5) NOT NULL | Product SetID |
| 2 | PRODUCT_ID |
Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR_DEPT | Character(30) | VARCHAR2(30) NOT NULL | Description |