AUC_RESP_ALN_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 , B.GRP_LINE_NBR , A.DESCR254_MIXED , A.ITM_SETID , A.INV_ITEM_ID , F.BUSINESS_UNIT_AM , F.UNIT_OF_MEASURE , a.conversion_rate , a.bpu_uom , a.bpu_qty , a.bpu_qty_min , D.bpu_resp_qty , E.AUC_BID_STATUS , 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 , %Round(D.AUC_PRICE ,4) , %Round(SUM(%DecMult(B.BID_SCORE, C.WEIGHTING)) ,7) , %Round(sum(%decMult(DECODE(C.PRICE_FLG, 'Y', 0, B.BID_SCORE), C.WEIGHTING)), 7) , %Round(sum(%decMult(DECODE(C.PRICE_FLG, 'Y', B.BID_SCORE, 0), C.WEIGHTING)), 3) , %Round(sum(b.bid_fctr_cost), 6) , %Round(SUM(DECODE(C.AUC_COST_APPLY, 'C', B.BID_FCTR_COST, 0)), 6) , %Round(SUM(DECODE(C.AUC_COST_APPLY, 'U', DECODE(B.PRICE_FLG, 'N', %DECDIV(B.BID_FCTR_COST, F.QTY_AUC), 0), 0)), 6) , G.NAME1 , F.AUC_BID_QTY_RULE , A.IS_NOBID 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 , PS_AUC_AWD_BIDNAME G 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 G.BUSINESS_UNIT = A.BUSINESS_UNIT AND G.AUC_ID = A.AUC_ID AND G.AUC_ROUND = A.AUC_ROUND AND G.AUC_VERSION = A.AUC_VERSION AND G.BIDNUM = A.BIDNUM AND G.BIDDER_SETID = A.BIDDER_SETID AND G.BIDDER_ID = A.BIDDER_ID AND G.BIDDER_TYPE = A.BIDDER_TYPE AND G.BIDDER_LOC = A.BIDDER_LOC 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, B.GRP_LINE_NBR, A.DESCR254_MIXED, A.ITM_SETID, A.INV_ITEM_ID, F.BUSINESS_UNIT_AM, F.UNIT_OF_MEASURE, a.conversion_rate , a.bpu_uom , a.bpu_qty , a.bpu_qty_min , D.bpu_resp_qty , a.bid_cntr_action, 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, G.NAME1, F.AUC_BID_QTY_RULE, 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 GRP_LINE_NBR Number(5,0) INTEGER NOT NULL Group Line Number
    12 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
    13 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
    14 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    15 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
    16 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage
    17 CONVERSION_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Conversion Rate
    18 BPU_UOM Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage
    19 BPU_QTY Number(16,4) DECIMAL(15,4) NOT NULL Bid Quantity
    20 BPU_QTY_MIN Number(16,4) DECIMAL(15,4) NOT NULL Requested Min Qty
    21 BPU_RESP_QTY Number(19,6) DECIMAL(18,6) NOT NULL Bid Response Quantity
    22 AUC_BID_STATUS Character(1) VARCHAR2(1) NOT NULL Bid Status
    D=Disqualified
    P=Posted
    S=Saved
    W=Disallowed
    X=Cancelled
    23 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
    G=Goods
    S=Services
    24 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
    25 AUC_USER_PRC_BRK Character(1) VARCHAR2(1) NOT NULL User Defined Price Breaks

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    27 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
    28 BID_PBK_QTY_TYPE Character(1) VARCHAR2(1) NOT NULL Price Break Order Quantity
    C=Cumulative Order Quantity
    I=Individual Order Quantity
    29 BID_PBK_BASE_QTY Number(16,4) DECIMAL(15,4) NOT NULL Price Brake Base Qty
    30 BID_PBK_BASE_PRICE Signed Number(20,6) DECIMAL(18,6) NOT NULL Base Price
    31 BID_CNTR_ACTION Character(1) VARCHAR2(1) NOT NULL Bid Counter Action
    A=Accept
    C=Counter
    W=Withdrawal
    32 AUC_BID_QTY Number(16,4) DECIMAL(15,4) NOT NULL Bid Quantity
    33 BID_QTY_MIN Number(16,4) DECIMAL(15,4) NOT NULL Requested Min Qty
    34 AUC_BID_AMT Number(16,4) DECIMAL(15,4) NOT NULL Line Bid Amount
    35 AUC_LN_BF_SCR_TTL Number(11,7) DECIMAL(10,7) NOT NULL Total Line Bid Factor Score
    36 AUC_TTL_SCR_NUM_LN Number(11,7) DECIMAL(10,7) NOT NULL Total Score Lines
    37 AUC_LN_BF_SCR Number(7,3) DECIMAL(6,3) NOT NULL Line Bid Factor Score
    38 BID_FCTR_COST Signed Number(20,6) DECIMAL(18,6) NOT NULL Bid Response Quantity
    39 SSO_LINE_COST Signed Number(18,6) DECIMAL(16,6) NOT NULL line cost
    40 SSO_COST Signed Number(18,6) DECIMAL(16,6) NOT NULL Cost
    41 AUC_BID_NAME Character(40) VARCHAR2(40) NOT NULL Bidder Name
    42 AUC_BID_QTY_RULE Character(2) VARCHAR2(2) NOT NULL Bid Quantity Rule
    MQ=Bid Up to Maximum Quantity
    NA=Quantity Not Applicable
    RQ=Requested Quantity Required
    XQ=Allow Extra Quantity to be Bid
    43 IS_NOBID Character(1) VARCHAR2(1) NOT NULL No Bid

    Y/N Table Edit