SCC_ENTREG_VW_L

(SQL View)
 Index Back

Entity Registry


SELECT A.SCC_ENTITY_ID , B.LANGUAGE_CD , B.SCC_ENTITY_NAME , B.SCC_ENTITY_DESCR FROM PS_SCC_ENTITY_REG A , PS_SCC_ENT_REG_LNG B WHERE A.SCC_STATUS='A' AND A.SCC_RECNAME<>' ' AND A.SCC_ENTITY_ID = B.SCC_ENTITY_ID UNION SELECT A.SCC_ENTITY_ID , B.LANGUAGE_CD , B.SCC_ENTITY_NAME , B.SCC_ENTITY_DESCR FROM PS_SCC_ENTITY_REG A , PS_SCC_ENT_REG_LNG B WHERE A.SCC_STATUS='A' AND A.SCC_STG_RECNAME<>' ' AND A.SCC_ENTITY_ID = B.SCC_ENTITY_ID UNION SELECT A.SCC_ENTITY_ID , C.LANGUAGE_CD , C.SCC_ENTITY_NAME , C.SCC_ENTITY_DESCR FROM PS_SCC_ENTITY_REG A , PS_SCC_ETYPE_REC B , PS_SCC_ENT_REG_LNG C WHERE A.SCC_ENTITY_TYPE_ID=B.SCC_ENTITY_TYPE_ID AND A.SCC_STATUS='A' AND A.SCC_ENTITY_ID = C.SCC_ENTITY_ID

  • Related Language Record for SCC_ENTREG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCC_ENTITY_ID Character(40) VARCHAR2(40) NOT NULL Entitiy ID
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 SCC_ENTITY_NAME Character(30) VARCHAR2(30) NOT NULL Entitiy Name
    4 SCC_ENTITY_DESCR Character(254) VARCHAR2(254) NOT NULL Entitiy Description