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 1665: from pon_bid_shipments pbs, pon_auction_item_prices_all paip

1661: THEN --{
1662: l_award_shipment_number := -1;
1663:
1664: select nvl((select pbs.shipment_number
1665: from pon_bid_shipments pbs, pon_auction_item_prices_all paip
1666: where pbs.bid_number = l_rec.bid_number
1667: and pbs.line_number = p_line_num
1668: AND l_rec.award_quantity >= pbs.quantity
1669: AND l_rec.award_quantity <= pbs.max_quantity

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

2292: END IF;
2293:
2294: --
2295: -- Price Tiers Changes. If quantity based price tiers are present call the upd_single_bid_item_prices_qt
2296: -- Api which takes the unit price from pon_bid_shipments according to awarded shipment number.
2297: --
2298:
2299: IF ( l_award_shipment_number IS NULL OR
2300: l_award_shipment_number = -1 ) THEN --{

Line 2520: pon_bid_shipments pbs

2516: pbs.per_unit_price_component+pbip.fixed_amount_component/p_award_quantity))
2517: INTO l_award_price
2518: FROM pon_bid_item_prices pbip,
2519: pon_auction_item_prices_all paip,
2520: pon_bid_shipments pbs
2521: WHERE pbip.bid_number = p_bid_number
2522: AND pbip.line_number = p_line_number
2523: AND paip.auction_header_id = pbip.auction_header_id
2524: AND paip.line_number = pbip.line_number

Line 5501: pon_bid_shipments pbs,

5497: pon_bid_item_prices bi,
5498: pon_auction_item_prices_all ai,
5499: pon_optimize_scenarios pos,
5500: pon_optimize_results por,
5501: pon_bid_shipments pbs,
5502: pon_bid_headers pbh
5503: WHERE
5504: por.scenario_id = pos.scenario_id
5505: AND