DBA Data[Home] [Help]

APPS.POS_AP_SUPPLIER_SITE_BO_PKG dependencies on AP_TERMS

Line 442: ap_terms terms

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:

Line 445: AND aps.terms_id = terms.term_id(+); -- Bug 12979867/16067074: OUTER Join ap_terms to get term's name

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