BI_HD_SNT_EC_VW

(SQL View)
 Index Back

Bill Header Std Notes View


SELECT HDR_NOTE.BUSINESS_UNIT , HDR_NOTE.INVOICE , HDR_NOTE.NOTES_SEQ_NUM , HDR_NOTE.NOTE_TYPE , STD_NOTE.TEXT254 , HDR_NOTE.STD_NOTE_CD FROM PS_STD_NOTE STD_NOTE , PS_BI_HDR_NOTE HDR_NOTE , PS_BI_HDR HDR WHERE HDR_NOTE.STD_NOTE_FLAG = 'Y' AND HDR_NOTE.INTERNAL_FLAG = 'N' AND HDR_NOTE.TEXT254 = ' ' AND HDR.BUSINESS_UNIT = HDR_NOTE.BUSINESS_UNIT AND HDR.INVOICE = HDR_NOTE.INVOICE AND HDR_NOTE.STD_NOTE_CD = STD_NOTE.STD_NOTE_CD AND HDR_NOTE.STD_NOTE_CD NOT IN (SELECT C.STD_NOTE_CD FROM PS_BI_CU_SNT_EC_VW C WHERE C.BUSINESS_UNIT = HDR_NOTE.BUSINESS_UNIT AND C.INVOICE = HDR_NOTE.INVOICE AND C.NOTE_TYPE = HDR_NOTE.NOTE_TYPE AND C.STD_NOTE_CD = HDR_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))) AND STD_NOTE.EFF_STATUS = 'A'

  • Related Language Record: BI_HD_SNL_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 NOTES_SEQ_NUM Number(3,0) SMALLINT NOT NULL Notes Sequence Num
    4 NOTE_TYPE Character(10) VARCHAR2(10) NOT NULL Note Type
    5 TEXT254 Character(254) VARCHAR2(254) NOT NULL Text
    6 STD_NOTE_CD Character(10) VARCHAR2(10) NOT NULL Standard Note Code