DBA Data[Home] [Help]

APPS.PON_VALIDATE_ITEM_PRICES_INT dependencies on PON_AUCTION_ITEM_PRICES_ALL

Line 649: , pon_auction_item_prices_all ai

645: , bh.bid_status AS s_bid_status
646: , pv.end_date_active AS s_end_date_active
647: , ap.award_shipment_number as s_award_shipment_number
648: FROM pon_award_items_interface ap
649: , pon_auction_item_prices_all ai
650: , pon_bid_headers bh
651: , po_vendors pv
652: WHERE ap.batch_id = p_batch_id
653: AND ap.auction_header_id = ai.auction_header_id

Line 702: pon_auction_item_prices_all ai,

698: , l_login_id
699: , 'LINE_NUMBER'
700: , ai.document_disp_line_number
701: FROM PON_AWARD_ITEMS_INTERFACE paii,
702: pon_auction_item_prices_all ai,
703: pon_auction_headers_all ah,
704: po_line_types_tl pltt
705: WHERE paii.batch_id = p_batch_id
706: AND paii.award_status = 'Y'