DBA Data[Home] [Help]

APPS.PON_VALIDATE_ITEM_PRICES_INT dependencies on PON_BID_SHIPMENTS

Line 279: from pon_bid_shipments pbs

275: AND PAII.award_status = 'Y';
276:
277: UPDATE PON_AWARD_ITEMS_INTERFACE PAII
278: set AWARD_SHIPMENT_NUMBER = (select nvl(( select shipment_number
279: from pon_bid_shipments pbs
280: where pbs.bid_number = PAII.bid_number
281: and pbs.auction_line_number = PAII.AUCTION_LINE_NUMBER
282: and PAII.award_quantity >= pbs.quantity
283: and PAII.award_quantity <= pbs.max_quantity ),-1)