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 739: -- (1) apply BPF values by using pon_pf_supplier_formula

735:
736: -- RECALCULATE SHIPMENT-LEVEL PRICES
737: -- there are two steps to recalculating auction-currency transformed
738: -- shipment price:
739: -- (1) apply BPF values by using pon_pf_supplier_formula
740: -- (2) apply SPF values by summing up all applicable SPF values from
741: -- pon_bid_price_elements table and adding to the result of (1)
742:
743: -- NOTE: does not apply for spreadsheet upload, only if currency changed

Line 754: FROM pon_pf_supplier_formula ppsf,

750: ppsf.unit_price*v_rate +
751: (ppsf.fixed_amount*v_rate / decode(v_is_spo_transformed,
752: 'Y', nvl(pbip.quantity, 1),
753: nvl(aip.quantity, 1)))
754: FROM pon_pf_supplier_formula ppsf,
755: pon_bid_headers pbh,
756: pon_auction_item_prices_all aip,
757: pon_bid_item_prices pbip
758: WHERE pbip.bid_number = pbs.bid_number