DBA Data[Home] [Help]

APPS.PO_VERIFY_VENDOR_ELIGIBILITY dependencies on PON_BID_ITEM_PRICES

Line 160: WHERE vdr.doc_id IN (SELECT auction_header_id FROM pon_bid_item_prices WHERE po_header_id = p_document_id)

156: creation_date,
157: created_by,
158: last_update_login
159: FROM po_vendor_eligibility_h vdr
160: WHERE vdr.doc_id IN (SELECT auction_header_id FROM pon_bid_item_prices WHERE po_header_id = p_document_id)
161: AND vdr.doc_type = 'SOLICITATION'
162: AND vdr.vendor_id = (SELECT vendor_id FROM po_vendor_eligibility WHERE doc_id = p_document_id AND draft_id = p_draft_id)
163: AND Nvl(vdr.vendor_site_id,-99) = (SELECT Nvl(vendor_site_id,-99) FROM po_vendor_eligibility WHERE doc_id = p_document_id AND draft_id = p_draft_id);
164: