eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_AWARD_PKG dependencies on PON_BID_SHIPMENTS

Line 976: from pon_bid_shipments pbs, pon_auction_item_prices_all paip

972: THEN --{
973: l_award_shipment_number := -1;
974:
975: select nvl((select pbs.shipment_number
976: from pon_bid_shipments pbs, pon_auction_item_prices_all paip
977: where pbs.bid_number = l_rec.bid_number
978: and pbs.line_number = p_line_num
979: AND l_rec.award_quantity >= pbs.quantity
980: AND l_rec.award_quantity <= pbs.max_quantity

Line 1210: -- Api which takes the unit price from pon_bid_shipments according to awarded shipment number.

1206: END IF;
1207:
1208: --
1209: -- Price Tiers Changes. If quantity based price tiers are present call the upd_single_bid_item_prices_qt
1210: -- Api which takes the unit price from pon_bid_shipments according to awarded shipment number.
1211: --
1212:
1213: IF ( l_award_shipment_number IS NULL OR
1214: l_award_shipment_number = -1 ) THEN --{

Line 1420: pon_bid_shipments pbs

1416: pbs.per_unit_price_component+pbip.fixed_amount_component/p_award_quantity))
1417: INTO l_award_price
1418: FROM pon_bid_item_prices pbip,
1419: pon_auction_item_prices_all paip,
1420: pon_bid_shipments pbs
1421: WHERE pbip.bid_number = p_bid_number
1422: AND pbip.line_number = p_line_number
1423: AND paip.auction_header_id = pbip.auction_header_id
1424: AND paip.line_number = pbip.line_number

Line 4285: pon_bid_shipments pbs,

4281: pon_bid_item_prices bi,
4282: pon_auction_item_prices_all ai,
4283: pon_optimize_scenarios pos,
4284: pon_optimize_results por,
4285: pon_bid_shipments pbs,
4286: pon_bid_headers pbh
4287: WHERE
4288: por.scenario_id = pos.scenario_id
4289: AND