eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_VERIFY_VENDOR_ELIGIBILITY dependencies on PON_BID_HEADERS

Line 40: PON_BID_HEADERS offer

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(+)
43: AND vendor.vendor_id = vendor_sites.vendor_id(+)
44: AND hdr.vendor_site_id = vendor_sites.vendor_site_id

Line 67: PON_BID_HEADERS bh,

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
71: AND bh.trading_partner_id = vendor.vendor_id(+)

Line 127: PON_BID_HEADERS bh

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: )
131: AND (vdr.vendor_id , Nvl(vdr.vendor_site_id, -99)) NOT IN (SELECT suppliers.trading_partner_id , Nvl(suppliers.vendor_site_id,-99)

Line 873: --AND vendor_id IN (SELECT trading_partner_id FROM pon_bid_headers WHERE auction_header_id = p_auction_header_id AND award_status IN ('AWARDED','PARTIAL'));

869: ELSE 'NOTRUN' END) supplierstatus
870: FROM po_vendor_eligibility
871: WHERE doc_id = p_auction_header_id
872: AND doc_type = 'SOLICITATION'
873: --AND vendor_id IN (SELECT trading_partner_id FROM pon_bid_headers WHERE auction_header_id = p_auction_header_id AND award_status IN ('AWARDED','PARTIAL'));
874: AND ((vendor_id IN (SELECT trading_partner_id FROM pon_bid_headers WHERE auction_header_id = p_auction_header_id))
875: OR
876: (vendor_id IN (SELECT trading_partner_id FROM PON_BIDDING_PARTIES WHERE auction_header_id = p_auction_header_id)));
877:

Line 874: AND ((vendor_id IN (SELECT trading_partner_id FROM pon_bid_headers WHERE auction_header_id = p_auction_header_id))

870: FROM po_vendor_eligibility
871: WHERE doc_id = p_auction_header_id
872: AND doc_type = 'SOLICITATION'
873: --AND vendor_id IN (SELECT trading_partner_id FROM pon_bid_headers WHERE auction_header_id = p_auction_header_id AND award_status IN ('AWARDED','PARTIAL'));
874: AND ((vendor_id IN (SELECT trading_partner_id FROM pon_bid_headers WHERE auction_header_id = p_auction_header_id))
875: OR
876: (vendor_id IN (SELECT trading_partner_id FROM PON_BIDDING_PARTIES WHERE auction_header_id = p_auction_header_id)));
877:
878: l_no_rec VARCHAR2(1):='Y';