DBA Data[Home] [Help]

APPS.PON_VALIDATE_ITEM_PRICES_INT dependencies on PON_BID_SHIPMENTS

Line 255: from pon_bid_shipments pbs

251: AND PAII.award_status = 'Y';
252:
253: UPDATE PON_AWARD_ITEMS_INTERFACE PAII
254: set AWARD_SHIPMENT_NUMBER = (select nvl(( select shipment_number
255: from pon_bid_shipments pbs
256: where pbs.bid_number = PAII.bid_number
257: and pbs.auction_line_number = PAII.AUCTION_LINE_NUMBER
258: and PAII.award_quantity >= pbs.quantity
259: and PAII.award_quantity <= pbs.max_quantity ),-1)