RF_SO_NOTE_LVW

(SQL View)
 Index Back

Resolution Note View

This is a view on RF_SO_NOTE that gives all resolution notes.

SELECT A.BUSINESS_UNIT , A.SO_ID , A.NOTE_SEQ_NBR ,A.LANGUAGE_CD , A.DESCRLONG FROM PS_RF_SO_NOTE_LANG A , PS_RF_SO_NOTE B WHERE B.RSLN_SEQ_NBR > 0 AND A.BUSINESS_UNIT=B.BUSINESS_UNIT AND A.SO_ID=B.SO_ID AND A.NOTE_SEQ_NBR=B.NOTE_SEQ_NBR

  • Related Language Record for RF_SO_NOTE_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 SO_ID Character(10) VARCHAR2(10) NOT NULL Service Order ID
    3 NOTE_SEQ_NBR Number(6,0) INTEGER NOT NULL Note ID

    Default Value: 1

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