SCC_ENTP_VW2_L

(SQL View)
 Index Back

ER


SELECT A.SCC_ENTITY_ID , C.SCC_PROP_NAME , C.LANGUAGE_CD , B.SCC_ENTITY_NAME , C.SCC_PROP_LABEL , C.SCC_PROP_DESCR FROM PS_SCC_ENT_PROPS A , PS_SCC_ENT_REG_LNG B , PS_SCC_ENT_PROP_LN C , PS_SSR_ITEM_ATTR D WHERE A.SCC_ENTITY_ID=B.SCC_ENTITY_ID AND A.SCC_PROP_TYPE='60' AND A.SCC_PROP_NAME= D.SSR_ITEM_ATTR AND A.SCC_ENTITY_ID = c.SCC_ENTITY_ID AND B.LANGUAGE_CD = C.LANGUAGE_CD UNION ALL SELECT A1.SCC_ENTITY_ID , C1.SCC_PROP_NAME , C1.LANGUAGE_CD , B1.SCC_ENTITY_NAME , C1.SCC_PROP_LABEL , C1.SCC_PROP_DESCR FROM PS_SCC_ENT_PROPS A1 , PS_scc_entity_reg B1 , PS_SCC_ENT_PROP_LN C1 , PS_SSR_ITEM_ATTR D1 WHERE A1.SCC_ENTITY_ID=B1.SCC_ENTITY_ID AND A1.SCC_PROP_TYPE='60' AND A1.SCC_PROP_NAME= D1.SSR_ITEM_ATTR AND A1.SCC_ENTITY_ID = C1.SCC_ENTITY_ID AND NOT EXISTS ( SELECT 'X' FROM PS_SCC_ENT_REG_LNG BB1 WHERE B1.SCC_ENTITY_ID = BB1.SCC_ENTITY_ID AND BB1.LANGUAGE_CD = C1.LANGUAGE_CD) UNION ALL SELECT A2.SCC_ENTITY_ID , A2.SCC_PROP_NAME , C2.LANGUAGE_CD , C2.SCC_ENTITY_NAME , A2.SCC_PROP_LABEL , A2.SCC_PROP_DESCR FROM PS_SCC_ENT_PROPS A2 , PS_scc_entity_reg B2 , PS_SCC_ENT_REG_LNG C2 , PS_SSR_ITEM_ATTR D2 WHERE A2.SCC_ENTITY_ID=B2.SCC_ENTITY_ID AND A2.SCC_PROP_TYPE='60' AND A2.SCC_PROP_NAME= D2.SSR_ITEM_ATTR AND A2.SCC_ENTITY_ID = C2.SCC_ENTITY_ID AND NOT EXISTS ( SELECT 'X' FROM PS_SCC_ENT_PROP_LN BB2 WHERE B2.SCC_ENTITY_ID = BB2.SCC_ENTITY_ID AND BB2.LANGUAGE_CD = C2.LANGUAGE_CD)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SCC_ENTITY_ID Character(40) VARCHAR2(40) NOT NULL Entitiy ID
2 SCC_PROP_NAME Character(50) VARCHAR2(50) NOT NULL Property Name
3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
4 SCC_ENTITY_NAME Character(30) VARCHAR2(30) NOT NULL Entitiy Name
5 SCC_PROP_LABEL Character(50) VARCHAR2(50) NOT NULL Label
6 SCC_PROP_DESCR Long Character CLOB Description