BI_LN_SNL_EC_VW

(SQL View)
 Index Back

Bill Line Std Notes Lang View


SELECT LN.BUSINESS_UNIT , LN.INVOICE , LN.LINE_SEQ_NUM , LN.NOTES_SEQ_NUM , STD_NOTE.LANGUAGE_CD , LN.NOTE_TYPE , STD_NOTE.TEXT254 , LN.STD_NOTE_CD FROM PS_STD_NOTE_LANG STD_NOTE , PS_BI_LINE_NOTE LN , PS_BI_HDR HDR WHERE LN.STD_NOTE_FLAG = 'Y' AND LN.INTERNAL_FLAG = 'N' AND LN.TEXT254 = ' ' AND HDR.BUSINESS_UNIT = LN.BUSINESS_UNIT AND HDR.INVOICE = LN.INVOICE AND LN.STD_NOTE_CD = STD_NOTE.STD_NOTE_CD AND STD_NOTE.SETID = (SELECT SETID FROM PS_SET_CNTRL_REC WHERE SETCNTRLVALUE = HDR.BUSINESS_UNIT AND RECNAME = 'STD_NOTE') AND STD_NOTE.EFFDT = (SELECT MAX(EFFDT) FROM PS_STD_NOTE WHERE SETID = STD_NOTE.SETID AND STD_NOTE_CD = STD_NOTE.STD_NOTE_CD AND ((EFFDT <= %currentdatein and HDR.INVOICE_DT IS NULL) or (EFFDT <= HDR.INVOICE_DT and HDR.INVOICE_DT IS NOT NULL)))

  • Related Language Record for BI_LN_SNT_EC_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
    3 LINE_SEQ_NUM Number(5,0) INTEGER NOT NULL Sequence
    4 NOTES_SEQ_NUM Number(3,0) SMALLINT NOT NULL Notes Sequence Num
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 NOTE_TYPE Character(10) VARCHAR2(10) NOT NULL Note Type
    7 TEXT254 Character(254) VARCHAR2(254) NOT NULL Text
    8 STD_NOTE_CD Character(10) VARCHAR2(10) NOT NULL Standard Note Code