SCC_TML_ERR_LVW

(SQL View)
 Index Back

SELECT A.SCC_TMPL_ID , B.SCC_TMPL_OBJ_ID , B.LANGUAGE_CD , F.SCC_TMPL_PAGE_NAME , C.SCC_TMPL_LBL , D.LBLTEXT , B.SCC_TMPL_LBL , E.LBLTEXT FROM PS_SCC_TMPL_PAGE A , PS_SCC_TML_PFLD_LN B , PS_SCC_TML_PGSC_LN C , PS_SCC_TMPL_TPS_LN D , PS_SCC_TMPL_TPO_LN E , PS_SCC_TML_PAGE_LN F , PS_SCC_TMPL G WHERE A.SCC_TMPL_PAGE_ID=C.SCC_TMPL_PAGE_ID AND A.SCC_TMPL_PAGE_ID=B.SCC_TMPL_PAGE_ID AND B.SCC_TMPL_SECT_ID=C.SCC_TMPL_SECT_ID AND A.SCC_TMPL_TP_PG_ID=D.SCC_TMPL_TP_PG_ID AND C.SCC_TMPL_SECT_ID=D.SCC_TMPL_SECT_ID AND B.SCC_TMPL_OBJ_ID=E.SCC_TMPL_OBJ_ID AND B.SCC_TMPL_SECT_ID=E.SCC_TMPL_SECT_ID AND A.SCC_TMPL_TP_PG_ID=E.SCC_TMPL_TP_PG_ID AND A.SCC_TMPL_PAGE_ID=F.SCC_TMPL_PAGE_ID AND A.SCC_TMPL_ID=G.SCC_TMPL_ID AND G.SCC_TMPL_TYPE_ID=D.SCC_TMPL_TYPE_ID AND G.SCC_TMPL_TYPE_ID=E.SCC_TMPL_TYPE_ID AND B.LANGUAGE_CD=C.LANGUAGE_CD AND C.LANGUAGE_CD=D.LANGUAGE_CD AND D.LANGUAGE_CD=E.LANGUAGE_CD AND E.LANGUAGE_CD=F.LANGUAGE_CD

  • Related Language Record for SCC_TMPL_ERR_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCC_TMPL_ID Number(15,0) DECIMAL(15) NOT NULL Template ID
    2 SCC_TMPL_OBJ_ID Character(34) VARCHAR2(34) NOT NULL Template Object
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 SCC_TMPL_PAGE_NAME Character(30) VARCHAR2(30) NOT NULL Page Name
    5 SCC_TMPL_SECT_LBL1 Character(60) VARCHAR2(60) NOT NULL Section Label
    6 SCC_TMPL_SECT_LBL2 Character(60) VARCHAR2(60) NOT NULL Section Label
    7 SCC_TMPL_LBL Character(60) VARCHAR2(60) NOT NULL New Label
    8 LBLTEXT Character(60) VARCHAR2(60) NOT NULL Label Text