VCHR_PO_VW2

(SQL View)
 Index Back

Voucher PO Header Prompt


SELECT a.business_unit , a.po_id , a.po_dt , b.vendor_id , a.vendor_setid , b.name1 , a.origin , a.pymnt_terms_cd , a.currency_cd FROM ps_po_hdr_fs a , ps_vendor b WHERE a.vendor_setid = b.setid AND a.vendor_id = b.vendor_id AND ((a.po_status IN ('D','X','PX')) OR ((a.chng_ord_batch > 0) AND (a.po_status IN ('D','X','PX'))) OR (a.po_status = 'C')) AND a.ers_action = 'N' AND a.in_process_flg = 'N' AND a.mid_roll_status = 'N' AND A.BUDGET_HDR_STATUS = 'V' AND A.BUDGET_HDR_STS_NP = 'V' AND EXISTS ( SELECT 'X' FROM PS_PO_LINE_DIST_FS WHERE BUSINESS_UNIT = A.BUSINESS_UNIT AND PO_ID = A.PO_ID AND DST_ACCT_TYPE = 'DST' AND KK_CLOSE_FLAG <> 'Y' ) AND EXISTS( SELECT 'X' FROM PS_PO_LINE_FS PO_LN WHERE PO_LN.BUSINESS_UNIT = A.BUSINESS_UNIT AND PO_LN.PO_ID = A.PO_ID AND PO_LN.PO_GROUP_ID = ' ' AND PO_LN.cancel_status <> 'X') AND NOT EXISTS ( SELECT 'X' FROM PS_RECV_LN_SHIP_FS F WHERE F.BUSINESS_UNIT_PO = A.BUSINESS_UNIT AND F.PO_ID = A.PO_ID AND F.SERIAL_CONTROL = 'Y' AND F.SERIAL_STATUS = 'I' AND F.recv_ship_status <> 'X')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
3 PO_DT Date(10) DATE Date
4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
5 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
6 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
7 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin
8 PYMNT_TERMS_CD Character(5) VARCHAR2(5) NOT NULL Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
9 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency