SP_BUPCIT_NONLV

(SQL View)
 Index Back

Intg Template GL Non-sec lang

This is the non-secured language view for SP_BUPCIT_NONVW

SELECT A.SETID , A.INTEGRATION_TMPL , A.BUSINESS_UNIT_GL , B.LANGUAGE_CD , B.DESCR , B.DESCRLONG FROM PS_PC_INT_TMPL_GL A , PS_PC_INTMPL_GL_LG B WHERE A.SETID = B.SETID AND A.INTEGRATION_TMPL = B.INTEGRATION_TMPL AND A.BUSINESS_UNIT_GL = B.BUSINESS_UNIT_GL

  • Related Language Record for SP_BUPCIT_CLSVW SP_BUPCIT_NONVW SP_BUPCIT_OPRVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SETID_TBL

    2 INTEGRATION_TMPL Character(15) VARCHAR2(15) NOT NULL Integration

    Prompt Table: PC_INT_TMPL

    3 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

    Prompt Table: SP_BU_GL_NONVW

    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRLONG Long Character CLOB Long Description