PO_POA_SRCH

(SQL View)
Index Back

SELECT A.BUSINESS_UNIT , A.PO_ID , A.EIP_CTL_ID , C.NAME1 , B.VNDR_LOC , A.ACKNOWLEGE_DT , A.PO_ACK_SOURCE , A.REVIEWED FROM PS_PO_HDR_EC A , PS_PO_HDR B , PS_VENDOR C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PO_ID = B.PO_ID AND A.PROCESS_FLG <> 'Y' AND B.VENDOR_SETID = C.SETID AND B.VENDOR_ID = C.VENDOR_ID

  • Related Language Record: PO_POA_SRCH_LNG
  • # 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 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
    4 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    5 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
    6 ACKNOWLEGE_DT Date(10) DATE Acknowledge Date
    7 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)
    8 REVIEWED Character(1) VARCHAR2(1) NOT NULL Review Complete
    N=No
    Y=Yes