APPS.JMF_SHIKYU_RPT_CFR_PVT dependencies on PO_VENDORS

Line 565: , lp_supplier_name_from po_vendors.vendor_name%TYPE

561: -- need to be cleared, how to know the restriction from the oem_inv_org and supplier/site
562: -- cursor for geting tp_inv_org_id using the specific oem_inv_org_id, supplier/site
563: CURSOR l_cur_get_tp_inv_org_info
564: ( lp_oem_inv_org_id mtl_interorg_parameters.from_organization_id%TYPE
565: , lp_supplier_name_from po_vendors.vendor_name%TYPE
566: , lp_supplier_name_to po_vendors.vendor_name%TYPE
567: , lp_supplier_site_code_from po_vendor_sites_all.vendor_site_code%TYPE
568: , lp_supplier_site_code_to po_vendor_sites_all.vendor_site_code%TYPE
569: )

Line 566: , lp_supplier_name_to po_vendors.vendor_name%TYPE

562: -- cursor for geting tp_inv_org_id using the specific oem_inv_org_id, supplier/site
563: CURSOR l_cur_get_tp_inv_org_info
564: ( lp_oem_inv_org_id mtl_interorg_parameters.from_organization_id%TYPE
565: , lp_supplier_name_from po_vendors.vendor_name%TYPE
566: , lp_supplier_name_to po_vendors.vendor_name%TYPE
567: , lp_supplier_site_code_from po_vendor_sites_all.vendor_site_code%TYPE
568: , lp_supplier_site_code_to po_vendor_sites_all.vendor_site_code%TYPE
569: )
570: IS

Line 576: ,po_vendors pv

572: ,mp.organization_code --tp_org_code
573: ,pv.vendor_id --supplier_id
574: ,pvs.vendor_site_id --supplier_site_id
575: FROM mtl_interorg_parameters mip
576: ,po_vendors pv
577: ,po_vendor_sites_all pvs
578: ,hr_organization_information hoi
579: ,mtl_parameters mp
580: WHERE mip.from_organization_id = lp_oem_inv_org_id

Line 604: l_supplier_id po_vendors.vendor_id%TYPE;

600: ,pvs.vendor_site_code)));
601:
602: l_tp_inv_org_id mtl_parameters.organization_id%TYPE;
603: l_tp_inv_org_code mtl_parameters.organization_code%TYPE;
604: l_supplier_id po_vendors.vendor_id%TYPE;
605: l_supplier_site_id po_vendor_sites_all.vendor_site_id%TYPE;
606:
607: l_api_name CONSTANT VARCHAR2(30) := 'get_onhand_components';
608:

Line 3286: ,po_vendors pv

3282: ,po_line_locations_all poloc
3283: ,rcv_transactions rcv
3284: ,mtl_parameters mp_oem
3285: ,mtl_parameters mp_tp
3286: ,po_vendors pv
3287: ,po_vendor_sites_all pvs
3288: ,po_headers_all ph
3289: ,po_vendor_contacts pvc
3290: ,mtl_system_items_vl item_v

Line 3929: ,po_vendors pv

3925: ,hr_organization_information hoi
3926: -- Amy added to fix bug 5583680 start
3927: ,hr_all_organization_units_tl oem_haoutl
3928: ,hr_organization_information tp_hoi
3929: ,po_vendors pv
3930: ,po_vendor_sites_all pvs
3931: -- Amy added to fix bug 5583680 end
3932: WHERE oola.header_id = ooha.header_id
3933: AND plla.po_line_id = pla.po_line_id