OPRIDBUSINESS_UNITPROPOSAL_IDVERSION_IDLANGUAGE_CDGM_PREFPROP_LVW(SQL View) |
Index Back |
|---|---|
Proposals lng viewProposals (my preferences) language view |
| SELECT DISTINCT LNG.OPRID , LNG.BUSINESS_UNIT , LNG.PROPOSAL_ID , LNG.VERSION_ID , LNG.LANGUAGE_CD , CUST.NAME1 , LNG.TITLE56 FROM PS_GM_PROP_SRCH A , PS_GM_PROP_SRCH_L LNG , PS_CUSTOMER CUST , PS_CUSTOMER_LANG CUST_LNG WHERE A.BUSINESS_UNIT =LNG.BUSINESS_UNIT AND A.PROPOSAL_ID =LNG.PROPOSAL_ID AND A.VERSION_ID = LNG.VERSION_ID AND A.OPRID = LNG.OPRID AND LNG.LANGUAGE_CD = CUST_LNG.LANGUAGE_CD AND CUST_LNG.CUST_ID = CUST.CUST_ID AND CUST_LNG.SETID = CUST.SETID AND CUST.SETID = ( SELECT REC.SETID FROM PS_SET_CNTRL_REC REC WHERE REC.RECNAME = 'CUSTOMER' AND A.BUSINESS_UNIT = REC.SETCNTRLVALUE ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | PROPOSAL_ID |
Character(25) | VARCHAR2(25) NOT NULL | Proposal ID |
| 4 | VERSION_ID |
Character(7) | VARCHAR2(7) NOT NULL | Version ID |
| 5 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 6 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 7 | TITLE56 | Character(56) | VARCHAR2(56) NOT NULL | TITLE56 |