OPS_CTY_LNG_VW

(SQL View)
Index Back

Ops Type Language View

Ops Type Language View

SELECT A.OPS_TYPE_FRA ,A.LANGUAGE_CD ,A.DESCR ,A.OPS_DLG_TYPE_FRA FROM PS_OPS_SETUP_L_FRA A ,PS_OPS_SETUP_FRA B WHERE A.OPS_TYPE_FRA = B.OPS_TYPE_FRA AND B.USE_CONTRACT_FRA='Y'

  • Related Language Record for OPS_CTYPE_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPS_TYPE_FRA Character(10) VARCHAR2(10) NOT NULL OPSType (FRA)
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 OPS_DLG_TYPE_FRA Character(10) VARCHAR2(10) NOT NULL Delegate Code (FRA)