SCC_CAF_AT_VW_L

(SQL View)
 Index Back

Attrib Table View Related Rec


SELECT A.SCC_CAF_ATTRIB_NM , B.LANGUAGE_CD , B.DESCR , C.DESCR FROM PS_SCC_CAF_ATTRIBS A , PS_SCC_CAF_ATTR_LN B , PS_SCC_CAF_ATRTYLN C WHERE A.SCC_CAF_ATTR_TYPE = C.SCC_CAF_ATTR_TYPE AND A.SCC_CAF_ATTRIB_NM = B.SCC_CAF_ATTRIB_NM AND B.LANGUAGE_CD = C.LANGUAGE_CD UNION SELECT D.SCC_CAF_ATTRIB_NM , F.LANGUAGE_CD , F.DESCR , E.DESCR FROM PS_SCC_CAF_ATTRIBS D , PS_SCC_CAF_ATTRTYP E , PS_SCC_CAF_ATTR_LN F WHERE F.SCC_CAF_ATTRIB_NM = D.SCC_CAF_ATTRIB_NM AND D.SCC_CAF_ATTR_TYPE = E.SCC_CAF_ATTR_TYPE AND NOT EXISTS ( SELECT 'X' FROM PS_SCC_CAF_ATRTYLN H WHERE H.SCC_CAF_ATTR_TYPE = D.SCC_CAF_ATTR_TYPE AND H.LANGUAGE_CD = F.LANGUAGE_CD) UNION SELECT I.SCC_CAF_ATTRIB_NM , J.LANGUAGE_CD , I.DESCR , J.DESCR FROM PS_SCC_CAF_ATTRIBS I , PS_SCC_CAF_ATRTYLN J WHERE I.SCC_CAF_ATTR_TYPE = J.SCC_CAF_ATTR_TYPE AND NOT EXISTS ( SELECT 'X' FROM PS_SCC_CAF_ATTR_LN K WHERE I.SCC_CAF_ATTRIB_NM = K.SCC_CAF_ATTRIB_NM AND K.LANGUAGE_CD = J.LANGUAGE_CD)

  • Related Language Record for SCC_CAF_ATTR_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCC_CAF_ATTRIB_NM Character(20) VARCHAR2(20) NOT NULL Common Attribute
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 SCC_CAF_DESCR Character(30) VARCHAR2(30) NOT NULL Attribute Type