CS_DOC_H_ADHLVW

(SQL View)
 Index Back

Adhoc Language view


SELECT ADH.CS_DOC_ID , H.LANGUAGE_CD , H.DESCR60 FROM PS_CS_DOC_ADH_KEYS ADH , PS_CS_DOC_HDR_LANG H , PS_CS_DOC_FILES F WHERE ADH.CS_DOC_ID = H.CS_DOC_ID AND H.CS_DOC_ID = F.CS_DOC_ID AND F.CS_DOC_TYPE IN ('001', '002')

  • Related Language Record for CS_DOC_H_ADH_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CS_DOC_ID Character(25) VARCHAR2(25) NOT NULL Document ID
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description