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 HR_ALL_ORGANIZATION_UNITS_VL

Line 535: , lp_oem_inv_org_name_from hr_all_organization_units_vl.NAME%TYPE

531: -- cursor for the OEM inventory organization,to get the org_id,org_code,org_name
532: -- refer to the org_name from and to condition
533: CURSOR l_cur_get_oem_inv_org_info
534: (lp_ou_id hr_all_organization_units.organization_id%TYPE
535: , lp_oem_inv_org_name_from hr_all_organization_units_vl.NAME%TYPE
536: , lp_oem_inv_org_name_to hr_all_organization_units_vl.NAME%TYPE
537: ) IS
538: SELECT mp.organization_id
539: ,mp.organization_code

Line 536: , lp_oem_inv_org_name_to hr_all_organization_units_vl.NAME%TYPE

532: -- refer to the org_name from and to condition
533: CURSOR l_cur_get_oem_inv_org_info
534: (lp_ou_id hr_all_organization_units.organization_id%TYPE
535: , lp_oem_inv_org_name_from hr_all_organization_units_vl.NAME%TYPE
536: , lp_oem_inv_org_name_to hr_all_organization_units_vl.NAME%TYPE
537: ) IS
538: SELECT mp.organization_id
539: ,mp.organization_code
540: ,haoutl.NAME

Line 559: l_oem_inv_org_name hr_all_organization_units_vl.NAME%TYPE;

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
563: CURSOR l_cur_get_tp_inv_org_info