PO_APPR_LN1_VW

(SQL View)
 Index Back

PO Approval Line with Approver

Purchase Order Approval Line view with line wise approver id.

SELECT L.BUSINESS_UNIT , L.PO_ID , L.LINE_NBR , L.CANCEL_STATUS , L.DESCR254_MIXED , L.INV_ITEM_ID , SUM (S.QTY_PO) , AVG(S.PRICE_PO) , SUM (S.MERCHANDISE_AMT) , S.CURRENCY_CD , L.UNIT_OF_MEASURE , L.RECV_REQ , L.ORIG_INV_ITEM_ID , L.DESCR254_MIXED2 , C.EOAWORIG_OPRID FROM PS_PO_LINE L , PS_PO_LINE_SHIP S , PS_PO_AW A , PS_EOAW_STEPINST B , PS_EOAW_USERINST C WHERE L.BUSINESS_UNIT = S.BUSINESS_UNIT AND L.PO_ID = S.PO_ID AND L.LINE_NBR = S.LINE_NBR AND L.BUSINESS_UNIT = A.BUSINESS_UNIT AND L.PO_ID = A.PO_ID AND L.LINE_NBR = A.LINE_NBR AND A.EOAWTHREAD_ID=( SELECT MAX(D.EOAWTHREAD_ID) FROM PS_PO_AW D WHERE D.EOAWPRCS_ID=A.EOAWPRCS_ID AND D.EOAWDEFN_ID=A.EOAWDEFN_ID AND D.BUSINESS_UNIT=A.BUSINESS_UNIT AND D.PO_ID=A.PO_ID AND D.LINE_NBR=A.LINE_NBR) AND B.EOAWTHREAD_ID=A.EOAWTHREAD_ID AND A.EOAWPRCS_ID=B.EOAWPRCS_ID AND A.EOAWDEFN_ID=B.EOAWDEFN_ID AND C.EOAWSTEP_INSTANCE=B.EOAWSTEP_INSTANCE AND S.CANCEL_STATUS <> 'X' GROUP BY L.BUSINESS_UNIT, L.PO_ID, L.LINE_NBR, L.CANCEL_STATUS , L.DESCR254_MIXED , S.CURRENCY_CD , L.UNIT_OF_MEASURE, L.INV_ITEM_ID,L.RECV_REQ,L.ORIG_INV_ITEM_ID,L.DESCR254_MIXED2,C.EOAWORIG_OPRID

  • Parent record: PO_APPR_HDR_VW

    • # 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 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
    4 CANCEL_STATUS Character(1) VARCHAR2(1) NOT NULL Cancel Status
    A=Active
    C=Closed
    D=Denied
    H=Hold
    O=Open
    P=Pending Approval
    X=Canceled
    5 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
    6 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    7 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity
    8 PRICE_PO Signed Number(17,5) DECIMAL(15,5) NOT NULL Purchase Order Price
    9 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
    10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    11 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage
    12 RECV_REQ Character(1) VARCHAR2(1) NOT NULL Receiving Required
    N=Optional
    X=Do Not
    Y=Required
    13 ORIG_INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Used to identify the original item ordered, in case an item substitution has taken place.
    14 DESCR254_MIXED2 Character(254) VARCHAR2(254) NOT NULL Long Description
    15 EOAWORIG_OPRID Character(30) VARCHAR2(30) NOT NULL User ID