AUC_RESP_LN_VW

(SQL View)
 Index Back

SELECT A.BUSINESS_UNIT , A.AUC_ID , A.AUC_ROUND , A.AUC_VERSION , A.BIDNUM , A.BIDDER_SETID , A.BIDDER_ID , A.BIDDER_TYPE , A.BIDDER_LOC , A.LINE_NBR , F.AUC_LINE_TYPE , F.AUC_GROUP_ID , E.RESP_BIDDER_NAME1 , A.DESCR254_MIXED , A.ITM_SETID , A.INV_ITEM_ID , F.BUSINESS_UNIT_AM , f.auc_line_status , F.UNIT_OF_MEASURE , F.QTY_AUC , f.price_reserve , a.conversion_rate , a.bpu_uom , a.bpu_qty , a.bpu_qty_min , D.bpu_resp_qty , D.BPU_PRICE_PGKEYD , (CASE f.AUC_BID_QTY_RULE WHEN 'NA' THEN 'Y' ELSE 'N' END) , E.AUC_BID_STATUS , E.auc_bid_version , F.PhYSICAL_NATURE , F.vat_svc_perfrm_flg , f.auc_user_prc_brk , f.auc_bidder_prc_brk , a.bid_pbk_resp_type , a.bid_pbk_qty_type , a.bid_pbk_base_qty , a.bid_pbk_base_price , a.bid_cntr_action , A.BID_QTY , A.BID_QTY_MIN , A.IS_NOBID , %Round(D.AUC_PRICE ,4) , %Round(D.AUC_PRICE ,4) , %Round(SUM(%DecMult((CASE B.GRP_LN_BF_NBR WHEN 0 THEN B.BID_SCORE ELSE (CASE B.PRICE_FLG WHEN 'Y' THEN 0 ELSE B.BID_SCORE END) END), C.WEIGHTING)) ,7) , %Round(SUM(CASE B.GRP_LN_BF_NBR WHEN 0 THEN B.BID_FCTR_COST ELSE (CASE B.PRICE_FLG WHEN 'Y' THEN 0 ELSE B.BID_FCTR_COST END) END), 4) FROM PS_RESP_LN A , PS_RESP_LN_FACTOR B , PS_AUC_LN_BID_FCTR C , PS_AUC_LN_COST_VW D , PS_RESP_HDR E , PS_AUC_LINE F WHERE B.AUC_ID = A.AUC_ID AND B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.AUC_ROUND = A.AUC_ROUND AND B.AUC_VERSION = A.AUC_VERSION AND B.BIDNUM = A.BIDNUM AND B.BIDDER_SETID = A.BIDDER_SETID AND B.BIDDER_ID = A.BIDDER_ID AND B.BIDDER_TYPE = A.BIDDER_TYPE AND B.BIDDER_LOC = A.BIDDER_LOC AND B.LINE_NBR = A.LINE_NBR AND C.AUC_ID = B.AUC_ID AND C.BUSINESS_UNIT = B.BUSINESS_UNIT AND C.AUC_ROUND = B.AUC_ROUND AND C.AUC_VERSION = B.AUC_VERSION AND C.LINE_NBR = B.LINE_NBR AND C.BID_FACTOR_NBR = B.BID_FACTOR_NBR AND D.BUSINESS_UNIT = A.BUSINESS_UNIT AND D.AUC_ID = A.AUC_ID AND D.AUC_ROUND = A.AUC_ROUND AND D.AUC_VERSION = A.AUC_VERSION AND D.BIDNUM = A.BIDNUM AND D.BIDDER_SETID = A.BIDDER_SETID AND D.BIDDER_ID = A.BIDDER_ID AND D.BIDDER_TYPE = A.BIDDER_TYPE AND D.BIDDER_LOC = A.BIDDER_LOC AND D.LINE_NBR = A.LINE_NBR AND E.BUSINESS_UNIT = A.BUSINESS_UNIT AND E.AUC_ID = A.AUC_ID AND E.AUC_ROUND = A.AUC_ROUND AND E.AUC_VERSION = A.AUC_VERSION AND E.BIDNUM = A.BIDNUM AND E.BIDDER_SETID = A.BIDDER_SETID AND E.BIDDER_ID = A.BIDDER_ID AND E.BIDDER_TYPE = A.BIDDER_TYPE AND E.BIDDER_LOC = A.BIDDER_LOC AND (E.AUC_BID_STATUS = 'P' OR E.AUC_BID_STATUS = 'D' OR E.AUC_BID_STATUS = 'W') AND F.AUC_ID = A.AUC_ID AND F.BUSINESS_UNIT = A.BUSINESS_UNIT AND F.AUC_ROUND = A.AUC_ROUND AND F.AUC_VERSION = A.AUC_VERSION AND F.LINE_NBR = A.LINE_NBR AND C.WEIGHTING > 0 GROUP BY A.BUSINESS_UNIT , A.AUC_ID, A.AUC_ROUND, A.AUC_VERSION , A.BIDNUM , A.BIDDER_SETID , A.BIDDER_ID , A.BIDDER_TYPE , A.BIDDER_LOC , A.LINE_NBR, F.AUC_LINE_TYPE, F.AUC_GROUP_ID,E.RESP_BIDDER_NAME1 , A.DESCR254_MIXED, A.ITM_SETID, A.INV_ITEM_ID, F.BUSINESS_UNIT_AM, f.auc_line_status, F.UNIT_OF_MEASURE, F.QTY_AUC, f.price_reserve, a.conversion_rate , a.bpu_uom , a.bpu_qty , a.bpu_qty_min , D.bpu_resp_qty, D.BPU_PRICE_PGKEYD, a.bid_cntr_action, F.AUC_BID_QTY_RULE, F.PhYSICAL_NATURE , F.vat_svc_perfrm_flg , f.auc_user_prc_brk, f.auc_bidder_prc_brk, a.bid_pbk_resp_type, a.bid_pbk_qty_type, a.bid_pbk_base_qty, a.bid_pbk_base_price, A.BID_QTY, A.BID_QTY_MIN, D.AUC_PRICE, E.AUC_BID_STATUS, e.auc_bid_version, A.IS_NOBID

  • 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

    Default Value: 1

    4 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version

    Default Value: 1

    5 BIDNUM Signed Number(6,0) DECIMAL(5) NOT NULL Bid ID
    6 BIDDER_SETID Character(5) VARCHAR2(5) NOT NULL Bidder Setid
    7 BIDDER_ID Character(15) VARCHAR2(15) NOT NULL Bidder ID
    8 BIDDER_TYPE Character(1) VARCHAR2(1) NOT NULL Bidder Type
    B=Bidder
    C=Customer
    P=Public
    U=Uploaded
    V=Supplier
    9 BIDDER_LOC Character(10) VARCHAR2(10) NOT NULL Bidder Location
    10 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
    11 AUC_LINE_TYPE Character(1) VARCHAR2(1) NOT NULL Event Line Type
    G=Group Line
    L=Line Item
    12 AUC_GROUP_ID Character(18) VARCHAR2(18) NOT NULL GroupID
    13 RESP_BIDDER_NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    14 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
    15 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
    16 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    17 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
    18 AUC_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL Event Line Status
    C=Closed
    O=Open
    19 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage
    20 AUC_REQ_QTY Number(16,4) DECIMAL(15,4) NOT NULL Event Quantity
    21 PRICE_RESERVE Number(16,5) DECIMAL(15,5) NOT NULL Reserve Price
    22 CONVERSION_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Conversion Rate
    23 BPU_UOM Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage
    24 BPU_QTY Number(16,4) DECIMAL(15,4) NOT NULL Bid Quantity
    25 BPU_QTY_MIN Number(16,4) DECIMAL(15,4) NOT NULL Requested Min Qty
    26 BPU_RESP_QTY Number(19,6) DECIMAL(18,6) NOT NULL Bid Response Quantity
    27 BPU_PRICE_PGKEYD Number(19,6) DECIMAL(18,6) NOT NULL Bid Response Price
    28 AMT_ONLY_FLG Character(1) VARCHAR2(1) NOT NULL Amount Only
    N=No
    Y=Yes
    29 AUC_BID_STATUS Character(1) VARCHAR2(1) NOT NULL Bid Status
    D=Disqualified
    P=Posted
    S=Saved
    W=Disallowed
    X=Cancelled
    30 AUC_BID_VERSION Number(5,0) INTEGER NOT NULL Event Bid Version
    31 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
    G=Goods
    S=Services
    32 VAT_SVC_PERFRM_FLG Character(1) VARCHAR2(1) NOT NULL Where VAT Services Physically Performed Flag
    1=Ship To Location
    2=Ship From Location
    3=Buyer's Location
    4=Supplier's Location
    33 AUC_USER_PRC_BRK Character(1) VARCHAR2(1) NOT NULL User Defined Price Breaks

    Y/N Table Edit

    Default Value: N

    34 AUC_BIDDER_PRC_BRK Character(1) VARCHAR2(1) NOT NULL Bidder defined price breaks

    Y/N Table Edit

    Default Value: N

    35 BID_PBK_RESP_TYPE Character(1) VARCHAR2(1) NOT NULL Price Break Response Type
    B=Bidder Defined Price Breaks
    N=No Price Breaks
    T=Both User/Bidder Price Breaks
    U=User Defined Price Breaks
    36 BID_PBK_QTY_TYPE Character(1) VARCHAR2(1) NOT NULL Price Break Order Quantity
    C=Cumulative Order Quantity
    I=Individual Order Quantity
    37 BID_PBK_BASE_QTY Number(16,4) DECIMAL(15,4) NOT NULL Price Brake Base Qty
    38 BID_PBK_BASE_PRICE Signed Number(20,6) DECIMAL(18,6) NOT NULL Base Price
    39 BID_CNTR_ACTION Character(1) VARCHAR2(1) NOT NULL Bid Counter Action
    A=Accept
    C=Counter
    W=Withdrawal
    40 AUC_BID_QTY Number(16,4) DECIMAL(15,4) NOT NULL Bid Quantity
    41 BID_QTY_MIN Number(16,4) DECIMAL(15,4) NOT NULL Requested Min Qty
    42 IS_NOBID Character(1) VARCHAR2(1) NOT NULL No Bid

    Y/N Table Edit

    43 AUC_BID_AMT Number(16,4) DECIMAL(15,4) NOT NULL Line Bid Amount
    44 AUC_BID_LN_AMT_TTL Number(18,5) DECIMAL(17,5) NOT NULL Total Line Amount
    45 AUC_LN_BF_SCR_TTL Number(11,7) DECIMAL(10,7) NOT NULL Total Line Bid Factor Score
    46 AUC_AWD_BID_CST Signed Number(16,2) DECIMAL(14,2) NOT NULL Total Bid Cost