DBA Data[Home] [Help]

APPS.PON_AUCTION_CREATE_PO_PKG dependencies on PON_BID_PRICE_DIFFERENTIALS

Line 3603: pon_bid_price_differentials pbpd,

3599: p_user_id, -- created_by
3600: fnd_global.login_id -- last_update_login
3601: FROM pon_price_differentials ppd,
3602: pon_bid_item_prices pbip,
3603: pon_bid_price_differentials pbpd,
3604: pon_auction_headers_all pah,
3605: po_lines_interface pli
3606: WHERE pbip.bid_number = p_bid_number
3607: AND nvl(pbip.award_status, 'NO') = 'AWARDED'

Line 3660: from pon_bid_price_differentials pbpd, pon_bid_shipments pbs

3656: (select pbpd.bid_number, pbpd.line_number,
3657: pbpd.shipment_number, pbs.auction_shipment_number,
3658: pbpd.price_differential_number, pbpd.price_type,
3659: pbpd.multiplier, pbpd.auction_header_id
3660: from pon_bid_price_differentials pbpd, pon_bid_shipments pbs
3661: where pbs.bid_number = p_bid_number
3662: and pbs.line_number = pbpd.line_number
3663: and pbs.shipment_number = pbpd.shipment_number) pbpd,
3664: pon_bid_shipments pbs,