DBA Data[Home] [Help]

APPS.JMF_SHIKYU_RPT_CFR_PVT dependencies on MTL_INTERORG_PARAMETERS

Line 564: ( lp_oem_inv_org_id mtl_interorg_parameters.from_organization_id%TYPE

560:
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

Line 575: FROM mtl_interorg_parameters mip

571: SELECT mip.to_organization_id --tp_org_id
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