APPS.PO_VERIFY_VENDOR_ELIGIBILITY dependencies on PO_VENDORS

Line 38: PO_VENDORS vendor,

34: NULL Error,
35: NULL approved_without_check,
36: NULL Reason
37: FROM PO_HEADERS_MERGE_V hdr,
38: PO_VENDORS vendor,
39: PO_VENDOR_SITES_ALL vendor_sites,
40: PON_BID_HEADERS offer
41: WHERE hdr.po_header_id = p_document_id AND draft_id = -1
42: AND hdr.vendor_id = vendor.vendor_id(+)

Line 68: PO_VENDORS vendor

64: NULL approved_without_check,
65: NULL Reason
66: FROM PON_AUCTION_HEADERS_ALL_V ah,
67: PON_BID_HEADERS bh,
68: PO_VENDORS vendor
69: WHERE ah.auction_header_id = p_document_id
70: AND ah.auction_header_id = bh.auction_header_id
71: AND bh.trading_partner_id = vendor.vendor_id(+)
72: AND (p_document_id,p_document_type, bh.trading_partner_id, Nvl(bh.vendor_site_id,-99)) NOT IN (SELECT doc_id, doc_type, vdr_elgb.vendor_id, Nvl(vdr_elgb.vendor_site_id,-99) FROM po_vendor_eligibility vdr_elgb);

Line 94: FROM PON_BIDDING_PARTIES suppliers, PO_VENDORS vendor

90: NULL performed_by,
91: NULL Error,
92: NULL approved_without_check,
93: NULL Reason
94: FROM PON_BIDDING_PARTIES suppliers, PO_VENDORS vendor
95: WHERE suppliers.auction_header_id = p_document_id
96: AND suppliers.trading_partner_id = vendor.vendor_id(+)
97: AND (p_document_id, p_document_type, suppliers.trading_partner_id, Nvl(suppliers.vendor_site_id, -99)) NOT IN (SELECT doc_id, doc_type, vdr_elgb.vendor_id, Nvl(vdr_elgb.vendor_site_id,-99) FROM po_vendor_eligibility vdr_elgb);
98: