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.AHL_PRD_LOV_SERVICE_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 158: l_item MTL_SYSTEM_ITEMS_KFV.concatenated_segments%type;

154: l_rownum NUMBER;
155: l_visit_id NUMBER;
156: l_visit_num NUMBER;
157: l_visit_type fnd_lookup_values_vl.meaning%type;
158: l_item MTL_SYSTEM_ITEMS_KFV.concatenated_segments%type;
159: l_serial_number CSI_ITEM_INSTANCES.serial_number%type;
160: l_org HR_ALL_ORGANIZATION_UNITS.name%type;
161: l_dept BOM_DEPARTMENTS.description%type;
162: l_unit ahl_unit_config_headers.name%type;

Line 176: l_sql_string := l_sql_string || ' fnd_lookup_values_vl fndvt, MTL_SYSTEM_ITEMS_KFV MTSB, ';

172: l_sql_string := l_sql_string || ' HROU.name organization_name,BDPT.description department_name, ';
173: l_sql_string := l_sql_string || ' AHL_UTILITY_PVT.GET_UNIT_NAME(VST.ITEM_INSTANCE_ID) UNIT_NAME ';
174:
175: l_sql_string := l_sql_string || ' FROM ahl_visits_b vst, AHL_SIMULATION_PLANS_B ASML, ';
176: l_sql_string := l_sql_string || ' fnd_lookup_values_vl fndvt, MTL_SYSTEM_ITEMS_KFV MTSB, ';
177: l_sql_string := l_sql_string || ' CSI_ITEM_INSTANCES CSIS, HR_ALL_ORGANIZATION_UNITS HROU, ';
178: l_sql_string := l_sql_string || ' BOM_DEPARTMENTS BDPT ';
179:
180: l_sql_string := l_sql_string || ' WHERE vst.simulation_plan_id = asml.simulation_plan_id AND ';

Line 465: l_instance_num MTL_SYSTEM_ITEMS_KFV.concatenated_segments%type;

461: --Local Variables for search results
462: l_rownum NUMBER;
463: l_uc_header_id NUMBER;
464: l_uc_name AHL_UNIT_CONFIG_HEADERS.NAME%type;
465: l_instance_num MTL_SYSTEM_ITEMS_KFV.concatenated_segments%type;
466: l_serial_number CSI_ITEM_INSTANCES.INSTANCE_NUMBER%type;
467: l_item MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%type;
468:
469: BEGIN

Line 467: l_item MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%type;

463: l_uc_header_id NUMBER;
464: l_uc_name AHL_UNIT_CONFIG_HEADERS.NAME%type;
465: l_instance_num MTL_SYSTEM_ITEMS_KFV.concatenated_segments%type;
466: l_serial_number CSI_ITEM_INSTANCES.INSTANCE_NUMBER%type;
467: l_item MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%type;
468:
469: BEGIN
470:
471: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 481: l_sql_string := l_sql_string || ' MTL_SYSTEM_ITEMS_KFV I ';

477: l_sql_string := l_sql_string || ' C.SERIAL_NUMBER ';
478:
479: l_sql_string := l_sql_string || ' FROM AHL_UNIT_CONFIG_HEADERS U, ';
480: l_sql_string := l_sql_string || ' CSI_ITEM_INSTANCES C, ';
481: l_sql_string := l_sql_string || ' MTL_SYSTEM_ITEMS_KFV I ';
482:
483: l_sql_string := l_sql_string || ' WHERE U.csi_item_instance_id = C.instance_id ';
484: l_sql_string := l_sql_string || ' AND C.inventory_item_id = I.inventory_item_id ';
485: l_sql_string := l_sql_string || ' AND C.last_vld_organization_id = I.organization_id ';

Line 4541: l_item mtl_system_items_kfv.concatenated_segments%type;

4537: l_rownum NUMBER;
4538: l_instance csi_item_instances.instance_number%type;
4539: l_lot csi_item_instances.lot_number%type;
4540: l_serial csi_item_instances.serial_number%type;
4541: l_item mtl_system_items_kfv.concatenated_segments%type;
4542:
4543: BEGIN
4544:
4545: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4550: l_sql_string := l_sql_string || ' FROM csi_item_instances csi1,mtl_system_items_kfv ahl1 ';

4546:
4547: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
4548: l_sql_string := 'SELECT * FROM ( SELECT Rownum RN, csi1.instance_number, csi1.lot_number,';
4549: l_sql_string := l_sql_string || ' csi1.serial_number, ahl1.concatenated_segments ';
4550: l_sql_string := l_sql_string || ' FROM csi_item_instances csi1,mtl_system_items_kfv ahl1 ';
4551: l_sql_string := l_sql_string || ' WHERE csi1.INV_MASTER_ORGANIZATION_ID=ahl1.organization_id ';
4552: l_sql_string := l_sql_string || ' and csi1.inventory_item_id=ahl1.inventory_item_id ';
4553: l_sql_string := l_sql_string || ' and csi1.INV_MASTER_ORGANIZATION_ID IN (SELECT master_organization_id ';
4554: l_sql_string := l_sql_string || ' FROM org_organization_definitions org, mtl_parameters mp WHERE org.organization_id = mp.organization_id AND NVL(operating_unit,mo_global.get_current_org_id()) = mo_global.get_current_org_id()) ';

Line 4773: l_uom mtl_system_items_kfv.primary_unit_of_measure%type;

4769: --Local Variables for search results
4770: l_rownum NUMBER;
4771: l_inv_item_id NUMBER;
4772: l_wo_id NUMBER;
4773: l_uom mtl_system_items_kfv.primary_unit_of_measure%type;
4774: l_desc mtl_system_items_kfv.description%type;
4775: l_item mtl_system_items_kfv.concatenated_segments%type;
4776: l_wo_id_input BOOLEAN;
4777:

Line 4774: l_desc mtl_system_items_kfv.description%type;

4770: l_rownum NUMBER;
4771: l_inv_item_id NUMBER;
4772: l_wo_id NUMBER;
4773: l_uom mtl_system_items_kfv.primary_unit_of_measure%type;
4774: l_desc mtl_system_items_kfv.description%type;
4775: l_item mtl_system_items_kfv.concatenated_segments%type;
4776: l_wo_id_input BOOLEAN;
4777:
4778: BEGIN

Line 4775: l_item mtl_system_items_kfv.concatenated_segments%type;

4771: l_inv_item_id NUMBER;
4772: l_wo_id NUMBER;
4773: l_uom mtl_system_items_kfv.primary_unit_of_measure%type;
4774: l_desc mtl_system_items_kfv.description%type;
4775: l_item mtl_system_items_kfv.concatenated_segments%type;
4776: l_wo_id_input BOOLEAN;
4777:
4778: BEGIN
4779:

Line 4785: l_sql_string1 := l_sql_string1 || ' from mtl_system_items_kfv mtl,mtl_parameters mtlp, ahl_workorders wo, ahl_visits_b VST ';

4781: l_wo_id_input := FALSE;
4782:
4783: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS when wo_id is not null
4784: l_sql_string1 := 'SELECT * FROM ( SELECT Rownum RN, mtl.concatenated_segments , mtl.description , mtl.primary_unit_of_measure, WO.workorder_id, mtl.inventory_item_id ';
4785: l_sql_string1 := l_sql_string1 || ' from mtl_system_items_kfv mtl,mtl_parameters mtlp, ahl_workorders wo, ahl_visits_b VST ';
4786: l_sql_string1 := l_sql_string1 || ' WHERE mtl.organization_id = mtlp.organization_id ';
4787: l_sql_string1 := l_sql_string1 || ' and mtlp.eam_enabled_flag = ''Y'' and mtl.organization_id = VST.organization_id ';
4788: l_sql_string1 := l_sql_string1 || ' and VST.visit_id = WO.visit_id ';
4789:

Line 4792: l_sql_string2 := l_sql_string2 || ' from mtl_system_items_kfv mtl,mtl_parameters mtlp ';

4788: l_sql_string1 := l_sql_string1 || ' and VST.visit_id = WO.visit_id ';
4789:
4790: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS when wo id is null
4791: l_sql_string2 := 'SELECT * FROM ( SELECT Rownum RN, mtl.concatenated_segments , mtl.description , mtl.primary_unit_of_measure, to_number(NULL), mtl.inventory_item_id ';
4792: l_sql_string2 := l_sql_string2 || ' from mtl_system_items_kfv mtl,mtl_parameters mtlp ';
4793: l_sql_string2 := l_sql_string2 || ' WHERE mtl.organization_id = mtlp.organization_id ';
4794: l_sql_string2 := l_sql_string2 || ' and mtlp.eam_enabled_flag = ''Y'' and mtl.organization_id IN (SELECT master_organization_id ';
4795: l_sql_string2 := l_sql_string2 || ' FROM org_organization_definitions org, mtl_parameters mp WHERE org.organization_id = mp.organization_id AND NVL(operating_unit,mo_global.get_current_org_id()) = mo_global.get_current_org_id()) ';
4796: