eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JMF_SHIKYU_RPT_CFR_PVT dependencies on MTL_PARAMETERS

Line 541: FROM mtl_parameters mp

537: ) IS
538: SELECT mp.organization_id
539: ,mp.organization_code
540: ,haoutl.NAME
541: FROM mtl_parameters mp
542: ,hr_organization_information hoi
543: ,hr_all_organization_units haou
544: ,HR_ALL_ORGANIZATION_UNITS_TL haoutl
545: WHERE mp.organization_id = hoi.organization_id

Line 557: l_oem_inv_org_id mtl_parameters.organization_id%TYPE;

553: AND haoutl.NAME <= NVL(lp_oem_inv_org_name_to
554: ,haoutl.NAME)
555: AND haoutl.LANGUAGE = USERENV('LANG');
556:
557: l_oem_inv_org_id mtl_parameters.organization_id%TYPE;
558: l_oem_inv_org_code mtl_parameters.organization_code%TYPE;
559: l_oem_inv_org_name hr_all_organization_units_vl.NAME%TYPE;
560:
561: -- need to be cleared, how to know the restriction from the oem_inv_org and supplier/site

Line 558: l_oem_inv_org_code mtl_parameters.organization_code%TYPE;

554: ,haoutl.NAME)
555: AND haoutl.LANGUAGE = USERENV('LANG');
556:
557: l_oem_inv_org_id mtl_parameters.organization_id%TYPE;
558: l_oem_inv_org_code mtl_parameters.organization_code%TYPE;
559: l_oem_inv_org_name hr_all_organization_units_vl.NAME%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

Line 579: ,mtl_parameters mp

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
581: --AND mip.shikyu_enabled_flag = 'Y'
582: AND mip.subcontracting_type in ('B','C') -- 12.1 Buy/Sell Subcontracting Changes
583: AND mp.trading_partner_org_flag = 'Y' --hide for test as there is not data for this column!!!

Line 602: l_tp_inv_org_id mtl_parameters.organization_id%TYPE;

598: (pvs.vendor_site_code <=
599: NVL(lp_supplier_site_code_to
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:

Line 603: l_tp_inv_org_code mtl_parameters.organization_code%TYPE;

599: NVL(lp_supplier_site_code_to
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';

Line 3284: ,mtl_parameters mp_oem

3280: FROM jmf_shikyu_cfr_mid_temp cfr_mid
3281: ,jmf_subcontract_orders sub
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

Line 3285: ,mtl_parameters mp_tp

3281: ,jmf_subcontract_orders sub
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