DBA Data[Home] [Help]

APPS.PO_VERIFY_VENDOR_ELIGIBILITY dependencies on PON_AUCTION_HEADERS_ALL_V

Line 66: FROM PON_AUCTION_HEADERS_ALL_V ah,

62: NULL performed_by,
63: NULL Error,
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

Line 126: FROM PON_AUCTION_HEADERS_ALL_V ah,

122: FROM po_vendor_eligibility vdr
123: WHERE vdr.doc_id = p_document_id
124: AND vdr.doc_type = p_document_type
125: AND (vdr.vendor_id , Nvl(vdr.vendor_site_id, -99)) NOT IN (SELECT bh.trading_partner_id , Nvl(bh.vendor_site_id,-99)
126: FROM PON_AUCTION_HEADERS_ALL_V ah,
127: PON_BID_HEADERS bh
128: WHERE ah.auction_header_id = p_document_id
129: AND ah.auction_header_id = bh.auction_header_id(+)
130: )