APPS.JAI_RCV_THIRD_PARTY_PKG dependencies on PO_VENDOR_SITES_ALL

Line 554: from po_vendor_sites_all pvs

550: and jrlt.vendor_id <> p_po_vendor_id
551: and jrlt.vendor_site_id is not null
552: and not exists
553: (select '1'
554: from po_vendor_sites_all pvs
555: where pvs.vendor_id = jrlt.vendor_id
556: and pvs.vendor_site_id = jrlt.vendor_site_id
557: );
558:

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 615: from po_vendor_sites_all

611:
612: cursor c_get_goods_received_date(p_vendor_id number, p_vendor_site_id number) is
613: select
614: decode(terms_date_basis, 'Goods Received', sysdate, null)
615: from po_vendor_sites_all
616: where vendor_id = p_vendor_id
617: and vendor_site_id = p_vendor_site_id;
618:
619: cursor c_get_inv_run_no is

Line 676: ln_vendor_site po_vendor_sites_all.vendor_site_id%type;

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);
680: ln_batch_invoice_id NUMBER;

Line 685: ln_org_id po_vendor_sites_all.org_id%type; -- added by csahoo for bug#6139899

681: ln_batch_line_id NUMBER;
682: ln_line_number NUMBER;
683: ln_cm_line_number NUMBER; --added by eric for inclusive tax
684: ln_to_insert_line_number NUMBER; --added by eric for inclusive tax
685: ln_org_id po_vendor_sites_all.org_id%type; -- added by csahoo for bug#6139899
686: ln_lines_to_insert NUMBER default 1; --added by eric for inclusive tax on 20-dec-2007
687: ln_tax_line_amount NUMBER; --added by eric for inclusive tax on 20-dec-2007
688: orig_vndr_details_rec c_get_vendor_details%rowtype; --added by eric for inclusive tax on 20-dec-2007
689: ld_orig_goods_recv_date DATE; --added by eric for inclusive tax on 20-dec-2007