RESP_AG_VW

(SQL View)
 Index Back

Created for Bid Response AG

Created for Bid Response AG

SELECT A.BUSINESS_UNIT ,A.AUC_ID ,A.AUC_ROUND ,A.AUC_VERSION FROM PS_AUC_DISP_HDR B , PS_AUC_HDR A WHERE A.BUSINESS_UNIT =B.BUSINESS_UNIT AND A.AUC_ID = B.AUC_ID AND A.AUC_ROUND =B.AUC_ROUND AND A.AUC_VERSION = B.AUC_VERSION

  • Parent record: AUC_HDR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 AUC_ID Character(10) VARCHAR2(10) NOT NULL Event ID
    3 AUC_ROUND Number(5,0) INTEGER NOT NULL Event Round
    4 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version