[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
476: p_userid, -- CREATED_BY
477: sysdate, -- LAST_UPDATE_DATE
478: p_userid, -- LAST_UPDATED_BY
479: apf.pf_type -- PF_TYPE
480: FROM pon_price_elements apf
481: WHERE apf.auction_header_id = p_auc_header_id
482: AND apf.pf_type = 'SUPPLIER' -- only supplier price factors
483: AND apf.line_number BETWEEN p_batch_start AND p_batch_end
484: AND NOT EXISTS
533: p_userid, -- CREATED_BY
534: sysdate, -- LAST_UPDATE_DATE
535: p_userid, -- LAST_UPDATED_BY
536: apf.pf_type -- PF_TYPE
537: FROM pon_price_elements apf,
538: pon_pf_supplier_values pf,
539: pon_bid_item_prices bl
540: WHERE apf.auction_header_id = p_auc_header_id
541: AND apf.pf_type = 'BUYER' -- only buyer pf that are to be displayed
1757: sysdate, -- LAST_UPDATE_DATE
1758: p_userid, -- LAST_UPDATED_BY
1759: apf.pf_type, -- PF_TYPE
1760: decode(p_rebid_flag, 'Y', bpf.bid_currency_value, null) -- OLD_BID_CURRENCY_VALUE
1761: FROM pon_price_elements apf,
1762: pon_bid_price_elements bpf,
1763: pon_bid_item_prices bl
1764: WHERE apf.auction_header_id = p_auc_header_id
1765: AND apf.pf_type = 'SUPPLIER' -- only for supplier price factors
1811: sysdate, -- LAST_UPDATE_DATE
1812: p_userid, -- LAST_UPDATED_BY
1813: apf.pf_type, -- PF_TYPE
1814: null -- OLD_BID_CURRENCY_VALUE
1815: FROM pon_price_elements apf,
1816: pon_pf_supplier_values pf,
1817: pon_bid_item_prices bl
1818: WHERE apf.auction_header_id = p_auc_header_id
1819: AND apf.pf_type = 'BUYER' -- only buyer pf that are to be displayed