APPS.PON_RESPONSE_PVT dependencies on PON_PF_SUPPLIER_FORMULA

Line 585: -- (1) apply BPF values by using pon_pf_supplier_formula

581:
582: -- RECALCULATE LINE-LEVEL PRICES
583: -- there are two steps to recalculating auction-currency transformed
584: -- bid price:
585: -- (1) apply BPF values by using pon_pf_supplier_formula
586: -- (2) apply SPF values by summing up all applicable SPF values from
587: -- pon_bid_price_elements table and adding to the result of (1)
588:
589: -- first, calculate v_is_spo_transformed flag

Line 605: FROM pon_pf_supplier_formula ppsf,

601: ppsf.unit_price*v_rate +
602: (ppsf.fixed_amount*v_rate / decode(v_is_spo_transformed,
603: 'Y', nvl(pbip.quantity, 1),
604: nvl(aip.quantity, 1)))
605: FROM pon_pf_supplier_formula ppsf,
606: pon_bid_headers pbh,
607: pon_auction_item_prices_all aip
608: WHERE ppsf.auction_header_id = pbip.auction_header_id
609: AND ppsf.line_number = pbip.line_number

Line 746: -- (1) apply BPF values by using pon_pf_supplier_formula

742:
743: -- RECALCULATE SHIPMENT-LEVEL PRICES
744: -- there are two steps to recalculating auction-currency transformed
745: -- shipment price:
746: -- (1) apply BPF values by using pon_pf_supplier_formula
747: -- (2) apply SPF values by summing up all applicable SPF values from
748: -- pon_bid_price_elements table and adding to the result of (1)
749:
750: -- NOTE: does not apply for spreadsheet upload, only if currency changed

Line 761: FROM pon_pf_supplier_formula ppsf,

757: ppsf.unit_price*v_rate +
758: (ppsf.fixed_amount*v_rate / decode(v_is_spo_transformed,
759: 'Y', nvl(pbip.quantity, 1),
760: nvl(aip.quantity, 1)))
761: FROM pon_pf_supplier_formula ppsf,
762: pon_bid_headers pbh,
763: pon_auction_item_prices_all aip,
764: pon_bid_item_prices pbip
765: WHERE pbip.bid_number = pbs.bid_number