VCHR_SRCH_DELVW

(SQL View)
Index Back

AP-Search view for delete

AP-Search view for deleting control groups

SELECT a.business_unit , a.voucher_id , a.entry_status , a.invoice_id , a.invoice_dt , a.vendor_setid , b.vendor_name_short , a.vendor_id , b.name1 FROM PS_VOUCHER a , ps_vendor b WHERE ((a.post_status_ap IN ('U', 'N') AND a.entry_status = 'P') OR (a.post_status_ap = 'U' AND a.entry_status = 'R') OR (a.entry_status = 'X' AND EXISTS ( SELECT 'X' FROM PS_KK_SOURCE_HDR d WHERE D.BUSINESS_UNIT= a.business_unit AND D.VOUCHER_ID = a.VOUCHER_ID))) AND a.vendor_setid = b.setid AND a.vendor_id = b.vendor_id AND a.in_process_flg = 'N' AND NOT EXISTS ( SELECT 'x' FROM ps_pymnt_vchr_xref c WHERE a.business_unit = c.business_unit AND a.voucher_id = c.voucher_id AND (c.pymnt_selct_status NOT IN ('N','X','C') OR (c.pymnt_selct_status IN ('N') AND c.net_selct_status IN ('S')) )) AND NOT EXISTS ( SELECT 'X' FROM PS_DISTRIB_LINE G WHERE a.business_unit = g.business_unit AND a.voucher_id = g.voucher_id AND g.kk_close_prior = 'Y') UNION SELECT B.business_unit , B.voucher_id , 'U' , B.invoice_id , B.invoice_dt , B.vendor_setid , ' ' , B.vendor_id , ' ' FROM ps_vchr_hdr_qv B , PS_BUS_UNIT_TBL_AP C WHERE B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.GRP_AP_ID <> 'NEXT'

  • Related Language Record: VCH_SCH_DELVW_L
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    Prompt Table: SP_BU_AP_NONVW

    2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
    3 ENTRY_STATUS Character(1) VARCHAR2(1) NOT NULL If translate values are added or changed, modify the following code to make sure the values appear accurately in the dropdown list in the search dialog: VCHR_SRCH_DEL.ENTRY_STATUS.SearchInit. Template Voucher status should not be visibile in the drop down.
    C=Complete
    D=Through batch defaults
    E=Edited by Batch Voucher Module
    L=Reviewed through Maintenance
    M=Modified
    O=Open
    P=Postable
    R=Recycle
    S=Scheduled for Payment
    T=Template Voucher
    X=Deleted
    4 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
    5 INVOICE_DT Date(10) DATE NOT NULL Invoice Date
    6 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
    7 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
    8 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Prompt Table: VENDOR_PRIM_VW

    9 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1