APPS.PON_OPT_PKG dependencies on PON_BID_ITEM_PRICES

Line 51: pon_bid_item_prices pbip

47: por.LAST_UPDATED_BY,
48: por.LAST_UPDATE_LOGIN,
49: pbip.FIXED_AMOUNT_COMPONENT AS FIXED_AMOUNT_COMPONENT
50: from pon_optimize_results por,pon_bid_shipments pbs,
51: pon_bid_item_prices pbip
52: where por.scenario_id =p_scenario_id
53: and pbs.bid_number = por.bid_number
54: and pbs.line_number = por.line_number
55: and pbs.shipment_number = por.award_shipment_number

Line 225: ,pon_bid_item_prices pbip

221: select sum(por.AWARD_QUANTITY * por.award_price) as scenario_total,
222: sum(por.award_quantity*nvl2(por.award_shipment_number,pbs.unit_price,pbip.unit_price)) as po_total
223: into l_po_total,l_scenario_total
224: from pon_optimize_results por,pon_bid_shipments pbs
225: ,pon_bid_item_prices pbip
226: where por.scenario_id = p_scenario_id
227: and pbs.bid_number(+) = por.bid_number
228: and pbs.line_number(+) = por.line_number
229: and pbs.shipment_number(+) = por.award_shipment_number