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_AUCTION_CREATE_PO_PKG dependencies on PON_BID_SHIPMENTS

Line 1997: FROM PON_BID_SHIPMENTS

1993: -- Quantity Based Price Tiers changes
1994: IF x_pdoi_line.award_shipment_number IS NOT NULL THEN
1995:
1996: SELECT BID_CURRENCY_UNIT_PRICE INTO x_price
1997: FROM PON_BID_SHIPMENTS
1998: WHERE LINE_NUMBER = x_pdoi_line.line_number
1999: AND AUCTION_HEADER_ID = x_pdoi_header.auction_header_id
2000: AND BID_NUMBER = p_bid_number
2001: AND SHIPMENT_NUMBER = x_pdoi_line.award_shipment_number;

Line 2514: pon_bid_shipments pbs

2510: pon_bid_item_prices pbip,
2511: mtl_units_of_measure mtluom,
2512: pon_bid_headers pbh,
2513: fnd_currencies fc,
2514: pon_bid_shipments pbs
2515: WHERE
2516: pbip.bid_number = p_bid_number and
2517: pbip.auction_header_id = p_auction_header_id and
2518: nvl(pbip.award_status, 'NO') = 'AWARDED' and

Line 2835: pon_bid_shipments pbs

2831: pon_bid_item_prices pbip,
2832: mtl_units_of_measure mtluom,
2833: pon_bid_headers pbh,
2834: fnd_currencies fc,
2835: pon_bid_shipments pbs
2836: WHERE pbip.bid_number = p_bid_number and
2837: pbip.auction_header_id = p_auction_header_id and
2838: nvl(pbip.award_status, 'NO') = 'AWARDED' and
2839: paip.auction_header_id = pbip.auction_header_id and

Line 2910: pon_bid_shipments pbs,

2906: pbs.auction_header_id, -- auction_header_id
2907: pbs.auction_line_number -- auction_line_number
2908: FROM pon_auction_item_prices_all paip,
2909: pon_bid_item_prices pbip,
2910: pon_bid_shipments pbs,
2911: po_lines_interface pli
2912: WHERE pbip.bid_number = p_bid_number and
2913: pbip.auction_header_id = p_auction_header_id and
2914: nvl(pbip.award_status, 'NO') = 'AWARDED' and

Line 3017: from pon_bid_price_differentials pbpd, pon_bid_shipments pbs

3013: (select pbpd.bid_number, pbpd.line_number,
3014: pbpd.shipment_number, pbs.auction_shipment_number,
3015: pbpd.price_differential_number, pbpd.price_type,
3016: pbpd.multiplier, pbpd.auction_header_id
3017: from pon_bid_price_differentials pbpd, pon_bid_shipments pbs
3018: where pbs.bid_number = p_bid_number
3019: and pbs.line_number = pbpd.line_number
3020: and pbs.shipment_number = pbpd.shipment_number) pbpd,
3021: pon_bid_shipments pbs,

Line 3021: pon_bid_shipments pbs,

3017: from pon_bid_price_differentials pbpd, pon_bid_shipments pbs
3018: where pbs.bid_number = p_bid_number
3019: and pbs.line_number = pbpd.line_number
3020: and pbs.shipment_number = pbpd.shipment_number) pbpd,
3021: pon_bid_shipments pbs,
3022: pon_auction_headers_all pah,
3023: po_lines_interface pli
3024: WHERE pbip.bid_number = p_bid_number
3025: AND nvl(pbip.award_status, 'NO') = 'AWARDED'