DBA Data[Home] [Help]

APPS.JAI_RCV_THIRD_PARTY_PKG dependencies on PO_VENDORS

Line 596: from po_vendors

592: NULL payment_method_lookup_code, --commented the column by Sanjikum for Bug#4482462
593: /* added the null in the above line by csahoo 5620503 */
594: pay_group_lookup_code,
595: NULL org_id -- added by csahoo for bug#6139899
596: from po_vendors
597: where vendor_id = p_vendor_id;
598:
599: /* cbabu for Bug#5613772 */
600: cursor c_get_vendor_site_dtls (p_vendor_site_id number) is

Line 607: from po_vendor_sites_all a, po_vendors b

603: a.terms_id,
604: a.payment_method_lookup_code,
605: a.pay_group_lookup_code,
606: a.org_id -- added by csahoo for bug#6139899
607: from po_vendor_sites_all a, po_vendors b
608: where a.vendor_id = b.vendor_id
609: AND a.vendor_site_id = p_vendor_site_id;
610:
611:

Line 675: ln_vendor_id po_vendors.vendor_id%type;

671: ln_interface_line_id number;
672: ln_check_if_already_processed number;
673:
674:
675: ln_vendor_id po_vendors.vendor_id%type;
676: ln_vendor_site po_vendor_sites_all.vendor_site_id%type;
677: lv_currency fnd_currencies.currency_code%type;
678: lv_vendor_has_changed VARCHAR2(10);
679: lb_tp_taxes_processed VARCHAR2(10);