[Home] [Help]
91: -- N if not (buyer price factors handled by next sql)
92: UPDATE pon_bid_item_prices bl
93: SET bl.display_price_factors_flag =
94: nvl((SELECT 'Y'
95: FROM pon_price_elements apf
96: WHERE apf.auction_header_id = p_auc_header_id
97: AND apf.line_number = bl.line_number
98: AND apf.pf_type = 'SUPPLIER'
99: AND apf.price_element_type_id <> -10
478: p_userid, -- CREATED_BY
479: sysdate, -- LAST_UPDATE_DATE
480: p_userid, -- LAST_UPDATED_BY
481: apf.pf_type -- PF_TYPE
482: FROM pon_price_elements apf
483: WHERE apf.auction_header_id = p_auc_header_id
484: AND apf.pf_type = 'SUPPLIER' -- only supplier price factors
485: AND apf.line_number BETWEEN p_batch_start AND p_batch_end
486: AND NOT EXISTS
537: p_userid, -- CREATED_BY
538: sysdate, -- LAST_UPDATE_DATE
539: p_userid, -- LAST_UPDATED_BY
540: apf.pf_type -- PF_TYPE
541: FROM pon_price_elements apf,
542: pon_pf_supplier_values pf,
543: pon_bid_item_prices bl
544: WHERE apf.auction_header_id = p_auc_header_id
545: AND apf.pf_type = 'BUYER' -- only buyer pf that are to be displayed
1991: sysdate, -- LAST_UPDATE_DATE
1992: p_userid, -- LAST_UPDATED_BY
1993: apf.pf_type, -- PF_TYPE
1994: decode(p_rebid_flag, 'Y', bpf.bid_currency_value, null) -- OLD_BID_CURRENCY_VALUE
1995: FROM pon_price_elements apf,
1996: pon_bid_price_elements bpf,
1997: pon_bid_item_prices bl
1998: WHERE apf.auction_header_id = p_auc_header_id
1999: AND apf.pf_type = 'SUPPLIER' -- only for supplier price factors
2047: sysdate, -- LAST_UPDATE_DATE
2048: p_userid, -- LAST_UPDATED_BY
2049: apf.pf_type, -- PF_TYPE
2050: null -- OLD_BID_CURRENCY_VALUE
2051: FROM pon_price_elements apf,
2052: pon_pf_supplier_values pf,
2053: pon_bid_item_prices bl
2054: WHERE apf.auction_header_id = p_auc_header_id
2055: AND apf.pf_type = 'BUYER' -- only buyer pf that are to be displayed