DBA Data[Home] [Help]

APPS.JAI_RCV_THIRD_PARTY_PKG dependencies on PO_VENDORS

Line 575: from po_vendors

571: NULL payment_method_lookup_code, --commented the column by Sanjikum for Bug#4482462
572: /* added the null in the above line by csahoo 5620503 */
573: pay_group_lookup_code,
574: NULL org_id -- added by csahoo for bug#6139899
575: from po_vendors
576: where vendor_id = p_vendor_id;
577:
578: /* cbabu for Bug#5613772 */
579: cursor c_get_vendor_site_dtls (p_vendor_site_id number) is

Line 586: from po_vendor_sites_all a, po_vendors b

582: a.terms_id,
583: a.payment_method_lookup_code,
584: a.pay_group_lookup_code,
585: a.org_id -- added by csahoo for bug#6139899
586: from po_vendor_sites_all a, po_vendors b
587: where a.vendor_id = b.vendor_id
588: AND a.vendor_site_id = p_vendor_site_id;
589:
590:

Line 636: ln_vendor_id po_vendors.vendor_id%type;

632: ln_interface_line_id number;
633: ln_check_if_already_processed number;
634:
635:
636: ln_vendor_id po_vendors.vendor_id%type;
637: ln_vendor_site po_vendor_sites_all.vendor_site_id%type;
638: lv_currency fnd_currencies.currency_code%type;
639: lv_vendor_has_changed VARCHAR2(10);
640: lb_tp_taxes_processed VARCHAR2(10);