[Home] [Help]
529: and jrlt.vendor_id <> p_po_vendor_id
530: and jrlt.vendor_site_id is not null
531: and not exists
532: (select '1'
533: from po_vendor_sites_all pvs
534: where pvs.vendor_id = jrlt.vendor_id
535: and pvs.vendor_site_id = jrlt.vendor_site_id
536: );
537:
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:
590:
591: cursor c_get_goods_received_date(p_vendor_id number, p_vendor_site_id number) is
592: select
593: decode(terms_date_basis, 'Goods Received', sysdate, null)
594: from po_vendor_sites_all
595: where vendor_id = p_vendor_id
596: and vendor_site_id = p_vendor_site_id;
597:
598: cursor c_get_inv_run_no is
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);
641: ln_batch_invoice_id NUMBER;
642: ln_batch_line_id NUMBER;
643: ln_line_number NUMBER;
644: ln_cm_line_number NUMBER; --added by eric for inclusive tax
645: ln_to_insert_line_number NUMBER; --added by eric for inclusive tax
646: ln_org_id po_vendor_sites_all.org_id%type; -- added by csahoo for bug#6139899
647: ln_lines_to_insert NUMBER default 1; --added by eric for inclusive tax on 20-dec-2007
648: ln_tax_line_amount NUMBER; --added by eric for inclusive tax on 20-dec-2007
649: orig_vndr_details_rec c_get_vendor_details%rowtype; --added by eric for inclusive tax on 20-dec-2007
650: ld_orig_goods_recv_date DATE; --added by eric for inclusive tax on 20-dec-2007