HCSC_CLK_CMP_VW

(SQL View)
 Index Back

Component Description

List of Components Enabled for Lock Down feature

SELECT DISTINCT A.PNLGRPNAME , B.DESCR , C.XLATLONGNAME FROM PS_HCSC_CLK_CMPELG A , PSPNLGRPDEFN B , PSXLATITEM C WHERE A.PNLGRPNAME = B.PNLGRPNAME AND A.MARKET = B.MARKET AND C.FIELDNAME = 'OBJECTOWNERID' AND C.FIELDVALUE = A.HCSC_CLK_PROD_ID AND A.PNLGRPNAME IN ( SELECT PNLGRPNAME FROM PS_HCSC_CLK_CEG_VW) UNION SELECT A.PNLGRPNAME , B.DESCR , C.XLATLONGNAME FROM PS_HCSC_CLK_LKOVRD A , PS_HCSC_CLK_CMPELG A1 , PSPNLGRPDEFN B , PSXLATITEM C WHERE A.PNLGRPNAME = B.PNLGRPNAME AND A.MARKET = B.MARKET AND C.FIELDNAME = 'OBJECTOWNERID' AND C.FIELDVALUE = A1.HCSC_CLK_PROD_ID AND A.PNLGRPNAME = A1.PNLGRPNAME AND A.MARKET = A1.MARKET AND A1.HCSC_CLK_ELIGLKDWN = 'Y'

  • Related Language Record: HCSC_CLK_CMP_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 HCSC_CLK_PRODNAME Character(30) VARCHAR2(30) NOT NULL Product Name