PNLGRPNAMELANGUAGE_CDHCSC_CLK_CMP_LN(SQL View) |
Index Back |
|---|---|
Component DescriptionRlated Language record of HCSC_CLK_CMP_VW |
| SELECT DISTINCT A.PNLGRPNAME ,B.LANGUAGE_CD , B.DESCR , C.XLATLONGNAME FROM PS_HCSC_CLK_CMPELG A , PSPNLGDEFNLANG B , PSXLATITEMLANG C WHERE A.PNLGRPNAME = B.PNLGRPNAME AND A.MARKET = B.MARKET AND C.FIELDNAME = 'OBJECTOWNERID' AND C.FIELDVALUE = A.HCSC_CLK_PROD_ID AND C.LANGUAGE_CD = B.LANGUAGE_CD AND A.PNLGRPNAME IN ( SELECT PNLGRPNAME FROM PS_HCSC_CLK_CEG_VW) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PNLGRPNAME |
Character(18) | VARCHAR2(18) NOT NULL | Component Name |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | HCSC_CLK_PRODNAME | Character(30) | VARCHAR2(30) NOT NULL | Product Name |