PO_APPR_HDR2_VW

(SQL View)
 Index Back

Approval PO Header VW

PO Header Approval view Modified for 28578183 and removed HOLD_STATUS = 'N'

SELECT DISTINCT A.BUSINESS_UNIT , A.PO_ID , A.EOAWSTEP_STATUS , MIN(%DatePart(A.DTTM_CREATED)) , A.OPRID , B.PO_DT , B.PO_STATUS , B.BUYER_ID , B.PO_REF , B.PO_TOTAL , B.CURRENCY_CD , B.VENDOR_SETID , B.VENDOR_ID , C.NAME1 , D.OPRDEFNDESC , '2' , E.BUDGET_HDR_STATUS FROM PS_PO_AW_ACTION_VW A , PS_PO_APPR_HDR_VW B , PS_VENDOR C , PSOPRDEFN D , PS_PO_HDR E WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PO_ID = B.PO_ID AND C.SETID = B.VENDOR_SETID AND C.VENDOR_ID = B.VENDOR_ID AND D.OPRID = E.BUYER_ID AND E.BUSINESS_UNIT = A.BUSINESS_UNIT AND E.PO_ID = A.PO_ID GROUP BY A.BUSINESS_UNIT , A.PO_ID , A.EOAWSTEP_STATUS , A.OPRID , B.PO_DT , B.PO_STATUS , B.BUYER_ID , B.PO_REF , B.PO_TOTAL , B.CURRENCY_CD , B.VENDOR_SETID , B.VENDOR_ID , C.NAME1 , D.OPRDEFNDESC, E.BUDGET_HDR_STATUS

  • Related Language Record: PO_APPR_LANG

  • Parent Record Of PO_APPR_LN2_VW

    • # 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_PM_NONVW

    2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
    3 EOAWSTEP_STATUS Character(1) VARCHAR2(1) NOT NULL Step Instance Status
    A=Approved
    B=Pushed back
    C=Auto Approved
    D=Denied
    E=Administrator denied
    F=Deleted
    G=Bypassed
    H=On Hold
    I=No Action Taken
    K=Skipped
    L=Terminated
    M=Administrator approved
    N=Not Active
    P=Pending
    R=No longer in role
    T=Terminated
    U=Auto approved
    X=Deleted
    Z=Pending Denial
    4 DATE_ROUTED Date(10) DATE Routed Date
    5 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    6 PO_DT Date(10) DATE Date
    7 PO_STATUS Character(2) VARCHAR2(2) NOT NULL PO Status
    A=Approved
    C=Complete
    D=Dispatched
    DA=Denied
    I=Initial
    LD=Line Denied
    O=Open
    PA=Pending Approval/Approved
    PX=Pending Cancel
    X=Canceled
    8 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
    9 PO_REF Character(30) VARCHAR2(30) NOT NULL Specifies the purchase order number associated with a receivables item.
    10 PO_TOTAL Signed Number(28,3) DECIMAL(26,3) NOT NULL PO Total
    11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    12 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
    13 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Prompt Table: VENDOR_VW

    14 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    15 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user
    16 PRIORITY_FLG Character(1) VARCHAR2(1) NOT NULL Priority Flag
    1=High
    2=Medium
    3=Low
    17 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