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 PO_VENDOR_ELIGIBILITY

Line 46: AND (p_document_id,p_document_type,p_draft_id, hdr.vendor_id, hdr.vendor_site_id) NOT IN (SELECT doc_id, doc_type, draft_id, vdr_elgb.vendor_id, vdr_elgb.vendor_site_id FROM po_vendor_eligibility vdr_elgb);

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
45: AND hdr.po_header_id = offer.po_header_id(+)
46: AND (p_document_id,p_document_type,p_draft_id, hdr.vendor_id, hdr.vendor_site_id) NOT IN (SELECT doc_id, doc_type, draft_id, vdr_elgb.vendor_id, vdr_elgb.vendor_site_id FROM po_vendor_eligibility vdr_elgb);
47:
48: CURSOR c_pon_new_suppliers IS
49: SELECT p_document_id doc_id,
50: p_document_type doc_type,

Line 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);

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);
73:
74:
75:
76: CURSOR c_pon_bidding_parties IS

Line 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);

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:
99: CURSOR c_pon_movetohistory IS
100: SELECT doc_id,
101: doc_type,

Line 122: FROM po_vendor_eligibility vdr

118: last_updated_by,
119: creation_date,
120: created_by,
121: last_update_login
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,

Line 159: FROM po_vendor_eligibility_h vdr

155: last_updated_by,
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);

Line 162: AND vdr.vendor_id = (SELECT vendor_id FROM po_vendor_eligibility WHERE doc_id = p_document_id AND draft_id = p_draft_id)

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:
165: BEGIN
166:

Line 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);

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:
165: BEGIN
166:
167: IF p_doc_type_class = 'PO' THEN

Line 171: INSERT INTO po_vendor_eligibility

167: IF p_doc_type_class = 'PO' THEN
168:
169: FOR c IN c_po_supplier LOOP
170:
171: INSERT INTO po_vendor_eligibility
172: (
173: id ,
174: doc_id ,
175: doc_type ,

Line 197: VALUES(po_vendor_eligibility_s.NEXTVAL,

193: creation_date ,
194: created_by ,
195: last_update_login
196: )
197: VALUES(po_vendor_eligibility_s.NEXTVAL,
198: c.doc_id,
199: c.doc_type,
200: c.draft_id,
201: c.select_flag,

Line 226: INSERT INTO po_vendor_eligibility_h

222: END LOOP;
223:
224: FOR c IN sol_vendor_check_history LOOP
225:
226: INSERT INTO po_vendor_eligibility_h
227: (
228: id ,
229: doc_id ,
230: doc_type ,

Line 252: VALUES (po_vendor_eligibility_s.NEXTVAL,

248: creation_date ,
249: created_by ,
250: last_update_login
251: )
252: VALUES (po_vendor_eligibility_s.NEXTVAL,
253: c.doc_id,
254: c.doc_type,
255: c.draft_id,
256: c.select_flag,

Line 286: INSERT INTO po_vendor_eligibility

282: FOR c IN c_pon_new_suppliers LOOP
283:
284:
285:
286: INSERT INTO po_vendor_eligibility
287: (
288: id ,
289: doc_id ,
290: doc_type ,

Line 312: VALUES(po_vendor_eligibility_s.NEXTVAL,

308: creation_date ,
309: created_by ,
310: last_update_login
311: )
312: VALUES(po_vendor_eligibility_s.NEXTVAL,
313: c.doc_id,
314: c.doc_type,
315: c.draft_id,
316: c.select_flag,

Line 342: INSERT INTO po_vendor_eligibility

338:
339: FOR c IN c_pon_bidding_parties LOOP
340:
341:
342: INSERT INTO po_vendor_eligibility
343: (
344: id ,
345: doc_id ,
346: doc_type ,

Line 368: VALUES(po_vendor_eligibility_s.NEXTVAL,

364: creation_date ,
365: created_by ,
366: last_update_login
367: )
368: VALUES(po_vendor_eligibility_s.NEXTVAL,
369: c.doc_id,
370: c.doc_type,
371: c.draft_id,
372: c.select_flag,

Line 397: INSERT INTO po_vendor_eligibility_h

393: END LOOP;
394:
395: FOR c IN c_pon_movetohistory LOOP
396:
397: INSERT INTO po_vendor_eligibility_h
398: (
399: id ,
400: doc_id ,
401: doc_type ,

Line 423: VALUES (po_vendor_eligibility_s.NEXTVAL,

419: creation_date ,
420: created_by ,
421: last_update_login
422: )
423: VALUES (po_vendor_eligibility_s.NEXTVAL,
424: c.doc_id,
425: c.doc_type,
426: c.draft_id,
427: c.select_flag,

Line 447: DELETE FROM po_vendor_eligibility

443: c.creation_date,
444: c.created_by,
445: c.last_update_login);
446:
447: DELETE FROM po_vendor_eligibility
448: WHERE doc_id = c.doc_id
449: AND doc_type = c.doc_type
450: AND vendor_id = c.vendor_id
451: AND Nvl(vendor_site_code,'aa') = Nvl(c.vendor_site_code,'aa');

Line 621: FROM po_vendor_eligibility

617: IS
618:
619: CURSOR c_get_selected_suppliers IS
620: SELECT id , eligibility_status , supplier_name , vendor_site_code , duns_number , tin_number, vendor_site_id, vendor_id
621: FROM po_vendor_eligibility
622: WHERE doc_id = p_document_id
623: AND doc_type = p_document_type
624: AND Nvl(draft_id,-1) = Nvl(p_draft_id, -1)
625: AND select_flag = 'Y'

Line 629: FROM po_vendor_eligibility

625: AND select_flag = 'Y'
626: AND p_doc_type_class = 'SOURCING'
627: UNION
628: SELECT id , eligibility_status , supplier_name , vendor_site_code , duns_number , tin_number, vendor_site_id, vendor_id
629: FROM po_vendor_eligibility
630: WHERE doc_id = p_document_id
631: AND doc_type = p_document_type
632: AND Nvl(draft_id,-1) = Nvl(p_draft_id, -1)
633: AND p_doc_type_class = 'PO';

Line 649: FROM po_Vendor_eligibility

645: l_message varchar2(10);
646:
647: CURSOR get_error(p_id NUMBER) IS
648: SELECT error
649: FROM po_Vendor_eligibility
650: WHERE id = p_id;
651:
652: l_error VARCHAR2(4000);
653: l_fnd_lob_seq NUMBER;

Line 661: INSERT INTO po_vendor_eligibility_h

657:
658: FOR c IN c_get_selected_suppliers LOOP
659:
660: IF c.eligibility_status IS NOT NULL OR l_error IS NOT NULL THEN
661: INSERT INTO po_vendor_eligibility_h
662: (
663: id ,
664: doc_id ,
665: doc_type ,

Line 689: SELECT po_vendor_eligibility_h_s.NEXTVAL,

685: creation_date ,
686: created_by ,
687: last_update_login
688: )
689: SELECT po_vendor_eligibility_h_s.NEXTVAL,
690: doc_id,
691: doc_type,
692: draft_id,
693: select_flag,

Line 714: FROM po_vendor_eligibility

710: last_updated_by,
711: creation_date,
712: created_by,
713: last_update_login
714: FROM po_vendor_eligibility
715: WHERE id = c.id;
716:
717: END IF;
718:

Line 808: UPDATE po_vendor_eligibility

804:
805:
806: l_lookup_code:=get_lookup_value('SUBMITTED');
807:
808: UPDATE po_vendor_eligibility
809: SET eligibility_status = l_lookup_code,
810: received_date = SYSDATE,
811: performed_by = Fnd_Global.User_Id,
812: file_id_request = l_fnd_lob_seq,

Line 870: FROM po_vendor_eligibility

866: WHEN eligibility_status = l_eligible AND Trunc((SYSDATE - received_Date)*24) <= l_epls_timeframe THEN 'ELIGIBLE'
867: WHEN approved_without_check = 'Y' THEN 'APPROVED'
868: WHEN eligibility_status = l_ineligible AND Trunc((SYSDATE - received_Date)*24) <= l_epls_timeframe THEN 'INELIGIBLE'
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))

Line 965: FROM po_vendor_eligibility vdr, po_vendor_sites_all site

961: FROM TABLE (XMLSEQUENCE (EXTRACT (l_result_xml,'*//results/results'))) a ;
962:
963: CURSOR c_get_vendor_site_details(p_id VARCHAR2) IS
964: SELECT CITY,COUNTRY,vdr.DUNS_NUMBER,PROVINCE,STATE,ADDRESS_LINE1,ADDRESS_LINE2,ZIP,SUPPLIER_NAME
965: FROM po_vendor_eligibility vdr, po_vendor_sites_all site
966: WHERE id = to_number(p_id)
967: AND vdr.vendor_site_id = site.vendor_site_id;
968:
969: l_fnd_lob_seq NUMBER;

Line 1009: UPDATE po_vendor_eligibility

1005: null,
1006: null,
1007: 'text');
1008:
1009: UPDATE po_vendor_eligibility
1010: SET file_id_response = l_fnd_lob_seq
1011: WHERE id = l_id;
1012: COMMIT;
1013:

Line 1083: UPDATE po_vendor_eligibility

1079: l_lookup_code:=get_lookup_value(l_supplier_status);
1080:
1081:
1082:
1083: UPDATE po_vendor_eligibility
1084: SET eligibility_status = l_lookup_code,
1085: received_date = SYSDATE,
1086: -- performed_by = Fnd_Global.User_Id,
1087: last_update_date = SYSDATE,

Line 1181: FROM po_vendor_eligibility

1177: RETURN VARCHAR2
1178: is
1179: CURSOR cur IS
1180: SELECT 'Y'
1181: FROM po_vendor_eligibility
1182: WHERE eligibility_status = 'Submitted'
1183: AND RECEIVED_DATE < (SYSDATE - (1/24))
1184: AND doc_id = p_po_header_id
1185: AND doc_type = p_document_type