PO_OPEN_ENC_SVW

(SQL View)
 Index Back

PO Open Encumbrance


SELECT H.BUSINESS_UNIT , H.PO_ID , H.PO_DT , H.VENDOR_ID , H.BUYER_ID , H.BUDGET_HDR_STATUS , B.FOREIGN_CURRENCY , B.BASE_CURRENCY , B.KK_TRAN_LN , MIN(B.LEDGER_GROUP) , B.FOREIGN_AMOUNT , B.MONETARY_AMOUNT FROM PS_PO_HDR H , ps_kk_shdr_poenc A , PS_KK_SOURCE_LN C , PS_KK_LIQUIDATION B WHERE H.BUSINESS_UNIT = A.BUSINESS_UNIT AND H.PO_ID = A.PO_ID AND A.KK_TRAN_ID = C.KK_TRAN_ID AND C.KK_TRAN_ID = B.KK_TRAN_ID AND C.KK_TRAN_DT = B.KK_TRAN_DT AND C.KK_TRAN_LN = B.KK_TRAN_LN AND H.PO_STATUS NOT IN ('C','X') AND H.BUDGET_HDR_STATUS = 'V' AND H.BUDGET_HDR_STS_NP = 'V' AND H.HOLD_STATUS <> 'Y' AND A.KK_SOURCE_TRAN = 'PO_POENC' AND A.KK_ROLLED_SEQ = 0 AND A.KK_TRAN_ID = C.KK_TRAN_ID AND B.FOREIGN_AMOUNT <> 0 AND B.MONETARY_AMOUNT <> 0 GROUP BY H.BUSINESS_UNIT, H.PO_ID, H.PO_DT, H.VENDOR_ID, H.BUYER_ID, H.BUDGET_HDR_STATUS, B.FOREIGN_CURRENCY ,B.BASE_CURRENCY, B.KK_TRAN_LN, B.FOREIGN_AMOUNT, B.MONETARY_AMOUNT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL 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 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
6 BUDGET_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Budget Checking Header Status
E=Error in Budget Check
I=Document In Processing
N=Not Budget Checked
P=Provisionally Valid
V=Valid
7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
8 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
9 KK_TRAN_LN Number(9,0) DECIMAL(9) NOT NULL Commitment Control Transaction Line number.
10 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
11 PO_ENCUM_NET Signed Number(28,3) DECIMAL(26,3) NOT NULL Outstanding PO Encumbrance
12 PO_ENCUM_NET_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Outstanding PO Encumbrance Bse