BI_OR_HD_SNT_VW

(SQL View)
 Index Back

BI order header std note view


SELECT A.BUSINESS_UNIT , A.ORDER_NO , A.SEQ_NUM , SNOTE.NOTE_TYPE , SNOTE.STD_NOTE_CD , SNOTE.TEXT254 FROM PS_ORD_NOTE A , 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 = SNOTE.STD_NOTE_CD AND SDOC.DOCUMENT_CD = 'INVC' AND SNOTE.SETID= (SELECT SETID FROM PS_SET_CNTRL_REC WHERE SETCNTRLVALUE = A.BUSINESS_UNIT AND RECNAME = 'STD_NOTE') AND SNOTE.SETID = SDOC.SETID AND SNOTE.STD_NOTE_CD = SDOC.STD_NOTE_CD AND SNOTE.EFFDT = SDOC.EFFDT AND SNOTE.EFFDT = (SELECT MAX(EFFDT) FROM PS_STD_NOTE WHERE SETID=SNOTE.SETID AND STD_NOTE_CD = SNOTE.STD_NOTE_CD AND EFFDT <= %CURRENTDATEIN) AND SNOTE.EFF_STATUS='A'

  • Related Language Record: BI_OR_HD_LNT_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 NOTE_TYPE Character(10) VARCHAR2(10) NOT NULL Note Type
    5 STD_NOTE_CD Character(10) VARCHAR2(10) NOT NULL Standard Note Code
    6 TEXT254 Character(254) VARCHAR2(254) NOT NULL Text