ORDSRCCD_ADVWLN

(SQL View)
 Index Back

Non auto-create src cds rlang.

This is the related language view for ORDSCRCD_ADD_VW.

SELECT A.SETID , A.SOURCE_CD , A.LANGUAGE_CD , A.DESCR FROM PS_ORD_SOURCE_LNG A , PS_ORD_SOURCE_CD S WHERE A.SOURCE_CD NOT IN ('CA', 'RCA') AND %EffdtCheck(ORD_SOURCE_LNG, A, %CurrentDateIn) AND S.SETID = A.SETID AND S.SOURCE_CD = A.SOURCE_CD AND S.EFFDT = A.EFFDT AND S.EFF_STATUS = 'A'

  • Related Language Record for ORDSRCCD_ADD_VW

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

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 SOURCE_CD Character(6) VARCHAR2(6) NOT NULL Source Code
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description