BI_OR_HD_LNT_VW

(SQL View)
 Index Back

BI order header std note view


SELECT A.BUSINESS_UNIT ,A.ORDER_NO ,A.SEQ_NUM ,LSNOTE.LANGUAGE_CD ,LSNOTE.TEXT254 FROM PS_ORD_NOTE A , PS_STD_NOTE_LANG LSNOTE , PS_STD_NOTE SNOTE , PS_STD_NOTE_DOC SDOC WHERE A.ORDER_INT_LINE_NO = 0 AND A.SCHED_LINE_NBR = 0 AND A.STD_NOTE_CD = LSNOTE.STD_NOTE_CD AND SDOC.DOCUMENT_CD = 'INVC' AND LSNOTE.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC WHERE SETCNTRLVALUE = A.BUSINESS_UNIT AND RECNAME = 'STD_NOTE_LANG') AND LSNOTE.SETID = SDOC.SETID AND LSNOTE.STD_NOTE_CD = SDOC.STD_NOTE_CD AND LSNOTE.EFFDT = SDOC.EFFDT AND %EffdtCheck(STD_NOTE_LANG, LSNOTE, %CurrentDateIn) AND SNOTE.SETID = LSNOTE.SETID AND SNOTE.STD_NOTE_CD = LSNOTE.STD_NOTE_CD AND SNOTE.EFFDT = LSNOTE.EFFDT AND SNOTE.EFF_STATUS = 'A'

  • Related Language Record for BI_OR_HD_SNT_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit
    2 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
    3 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 TEXT254 Character(254) VARCHAR2(254) NOT NULL Text