SCP_POA_HIST2VW

(SQL View)
 Index Back

POA History record

POA History View based on SCP_POA_HIST_VW modified for BUYER epic

SELECT DISTINCT A.EIP_CTL_ID , A.BUSINESS_UNIT , A.PO_ID , A.PO_POA_STATUS , A.ACKNOWLEGE_DT , A.DATETIME_DISP , B.VENDOR_ID , B.VENDOR_SETID , A.PO_ACK_SOURCE , A.DATETIME_CREATE , A.RESPONDED_DTTM , B.VNDR_LOC , B.PO_STATUS , A.CHNG_ORD_BATCH , B.BUYER_ID , A.POA_HIST_TYPE , A.OPRID , CASE WHEN A.CHNG_ORD_BATCH > 0 THEN MCT.MESSAGE_TEXT || ' ' || %NUMTOCHAR(A.CHNG_ORD_BATCH) ELSE F.XLATLONGNAME END FROM PS_PO_POA_HDR_HIST A , PS_PO_HDR B , PSXLATITEM F , PSMSGCATDEFN MCT WHERE A.PO_ID = B.PO_ID AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND MCT.MESSAGE_SET_NBR = 10258 AND MCT.MESSAGE_NBR = 9 AND F.EFFDT = ( SELECT MAX(F_ED.EFFDT) FROM PSXLATITEM F_ED WHERE F.FIELDNAME = F_ED.FIELDNAME AND F.FIELDVALUE = F_ED.FIELDVALUE AND F_ED.EFFDT <= %CurrentDateIn ) AND B.PO_STATUS = F.FIELDVALUE AND F.FIELDNAME = 'PO_STATUS'

  • Related Language Record: SCP_POA_HIST2LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
    4 PO_POA_STATUS Character(3) VARCHAR2(3) NOT NULL 08/07/01 RML Created for Supplier Portal Acknowledgment
    BAC=Buyer Accepted
    CMP=EDX compare needed
    NEW=New
    SRP=Supplier Responded
    SRV=Supplier Review
    5 ACKNOWLEGE_DT Date(10) DATE Acknowledge Date
    6 DATETIME_DISP DateTime(26) TIMESTAMP Date and Time Dispatched
    7 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    8 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
    9 PO_ACK_SOURCE Character(3) VARCHAR2(3) NOT NULL Created on 08/09/01 CN#WV840-4.0 - Purchase Order Acknowledgment source used in PO_HDR_EC
    BUY=Online (Buyer)
    EDI=EDX
    SUP=Online (Supplier)
    10 DATETIME_CREATE DateTime(26) TIMESTAMP 02/2001 cel WV-802-1.0.
    11 RESPONDED_DTTM DateTime(26) TIMESTAMP Represents the date and time a designated operator reviewed and acknowledged an exposure limit vi
    12 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
    13 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
    14 CHNG_ORD_BATCH Number(3,0) SMALLINT NOT NULL Change Order Number
    15 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
    16 POA_HIST_TYPE Character(1) VARCHAR2(1) NOT NULL Submitted by
    B=Buyer
    S=Supplier
    17 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    18 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2