438: 'SUPP_ADDR_SITE_LEVEL')) BULK COLLECT
439: INTO x_ap_supplier_sites_bo
440: FROM ap_supplier_sites_all aps,
441: ap_suppliers ap,
442: ap_terms terms
443: WHERE ap.party_id = l_party_id
444: AND aps.vendor_id = ap.vendor_id
445: AND aps.terms_id = terms.term_id(+); -- Bug 12979867/16067074: OUTER Join ap_terms to get term's name
446:
441: ap_suppliers ap,
442: ap_terms terms
443: WHERE ap.party_id = l_party_id
444: AND aps.vendor_id = ap.vendor_id
445: AND aps.terms_id = terms.term_id(+); -- Bug 12979867/16067074: OUTER Join ap_terms to get term's name
446:
447: --Commented by BVAMSI on 07/Oct/2010 as it is already handled in the above Select query
448: /*
449: FOR i IN x_ap_supplier_sites_bo.first .. x_ap_supplier_sites_bo.last LOOP