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 191: l_item MTL_SYSTEM_ITEMS_KFV.concatenated_segments%type;

187: l_rownum NUMBER;
188: l_visit_id NUMBER;
189: l_visit_num NUMBER;
190: l_visit_type fnd_lookup_values_vl.meaning%type;
191: l_item MTL_SYSTEM_ITEMS_KFV.concatenated_segments%type;
192: l_serial_number CSI_ITEM_INSTANCES.serial_number%type;
193: l_org HR_ALL_ORGANIZATION_UNITS.name%type;
194: l_dept BOM_DEPARTMENTS.description%type;
195: l_unit ahl_unit_config_headers.name%type;

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

205: l_sql_string := l_sql_string || ' HROU.name organization_name,BDPT.description department_name, ';
206: l_sql_string := l_sql_string || ' AHL_UTILITY_PVT.GET_UNIT_NAME(VST.ITEM_INSTANCE_ID) UNIT_NAME ';
207:
208: l_sql_string := l_sql_string || ' FROM ahl_visits_b vst, AHL_SIMULATION_PLANS_B ASML, ';
209: l_sql_string := l_sql_string || ' fnd_lookup_values_vl fndvt, MTL_SYSTEM_ITEMS_KFV MTSB, ';
210: l_sql_string := l_sql_string || ' CSI_ITEM_INSTANCES CSIS, HR_ALL_ORGANIZATION_UNITS HROU, ';
211: l_sql_string := l_sql_string || ' BOM_DEPARTMENTS BDPT ';
212:
213: l_sql_string := l_sql_string || ' WHERE vst.simulation_plan_id = asml.simulation_plan_id AND ';

Line 498: l_instance_num MTL_SYSTEM_ITEMS_KFV.concatenated_segments%type;

494: --Local Variables for search results
495: l_rownum NUMBER;
496: l_uc_header_id NUMBER;
497: l_uc_name AHL_UNIT_CONFIG_HEADERS.NAME%type;
498: l_instance_num MTL_SYSTEM_ITEMS_KFV.concatenated_segments%type;
499: l_serial_number CSI_ITEM_INSTANCES.INSTANCE_NUMBER%type;
500: l_item MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%type;
501:
502: BEGIN

Line 500: l_item MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%type;

496: l_uc_header_id NUMBER;
497: l_uc_name AHL_UNIT_CONFIG_HEADERS.NAME%type;
498: l_instance_num MTL_SYSTEM_ITEMS_KFV.concatenated_segments%type;
499: l_serial_number CSI_ITEM_INSTANCES.INSTANCE_NUMBER%type;
500: l_item MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%type;
501:
502: BEGIN
503:
504: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

510: l_sql_string := l_sql_string || ' C.SERIAL_NUMBER ';
511:
512: l_sql_string := l_sql_string || ' FROM AHL_UNIT_CONFIG_HEADERS U, ';
513: l_sql_string := l_sql_string || ' CSI_ITEM_INSTANCES C, ';
514: l_sql_string := l_sql_string || ' MTL_SYSTEM_ITEMS_KFV I ';
515:
516: l_sql_string := l_sql_string || ' WHERE U.csi_item_instance_id = C.instance_id ';
517: l_sql_string := l_sql_string || ' AND C.inventory_item_id = I.inventory_item_id ';
518: l_sql_string := l_sql_string || ' AND C.last_vld_organization_id = I.organization_id ';

Line 4395: l_item mtl_system_items_kfv.concatenated_segments%type;

4391: l_rownum NUMBER;
4392: l_instance csi_item_instances.instance_number%type;
4393: l_lot csi_item_instances.lot_number%type;
4394: l_serial csi_item_instances.serial_number%type;
4395: l_item mtl_system_items_kfv.concatenated_segments%type;
4396:
4397: BEGIN
4398:
4399: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

4400:
4401: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
4402: l_sql_string := 'SELECT * FROM ( SELECT Rownum RN, csi1.instance_number, csi1.lot_number,';
4403: l_sql_string := l_sql_string || ' csi1.serial_number, ahl1.concatenated_segments ';
4404: l_sql_string := l_sql_string || ' FROM csi_item_instances csi1,mtl_system_items_kfv ahl1 ';
4405: l_sql_string := l_sql_string || ' WHERE csi1.INV_MASTER_ORGANIZATION_ID=ahl1.organization_id ';
4406: l_sql_string := l_sql_string || ' and csi1.inventory_item_id=ahl1.inventory_item_id ';
4407: l_sql_string := l_sql_string || ' and csi1.INV_MASTER_ORGANIZATION_ID IN (SELECT master_organization_id ';
4408: 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 4627: l_uom mtl_system_items_kfv.primary_unit_of_measure%type;

4623: --Local Variables for search results
4624: l_rownum NUMBER;
4625: l_inv_item_id NUMBER;
4626: l_wo_id NUMBER;
4627: l_uom mtl_system_items_kfv.primary_unit_of_measure%type;
4628: l_desc mtl_system_items_kfv.description%type;
4629: l_item mtl_system_items_kfv.concatenated_segments%type;
4630: l_wo_id_input BOOLEAN;
4631:

Line 4628: l_desc mtl_system_items_kfv.description%type;

4624: l_rownum NUMBER;
4625: l_inv_item_id NUMBER;
4626: l_wo_id NUMBER;
4627: l_uom mtl_system_items_kfv.primary_unit_of_measure%type;
4628: l_desc mtl_system_items_kfv.description%type;
4629: l_item mtl_system_items_kfv.concatenated_segments%type;
4630: l_wo_id_input BOOLEAN;
4631:
4632: BEGIN

Line 4629: l_item mtl_system_items_kfv.concatenated_segments%type;

4625: l_inv_item_id NUMBER;
4626: l_wo_id NUMBER;
4627: l_uom mtl_system_items_kfv.primary_unit_of_measure%type;
4628: l_desc mtl_system_items_kfv.description%type;
4629: l_item mtl_system_items_kfv.concatenated_segments%type;
4630: l_wo_id_input BOOLEAN;
4631:
4632: BEGIN
4633:

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

4635: l_wo_id_input := FALSE;
4636:
4637: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS when wo_id is not null
4638: 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 ';
4639: l_sql_string1 := l_sql_string1 || ' from mtl_system_items_kfv mtl,mtl_parameters mtlp, ahl_workorders wo, ahl_visits_b VST ';
4640: l_sql_string1 := l_sql_string1 || ' WHERE mtl.organization_id = mtlp.organization_id ';
4641: l_sql_string1 := l_sql_string1 || ' and mtlp.eam_enabled_flag = ''Y'' and mtl.organization_id = VST.organization_id ';
4642: l_sql_string1 := l_sql_string1 || ' and VST.visit_id = WO.visit_id ';
4643:

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

4642: l_sql_string1 := l_sql_string1 || ' and VST.visit_id = WO.visit_id ';
4643:
4644: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS when wo id is null
4645: 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 ';
4646: l_sql_string2 := l_sql_string2 || ' from mtl_system_items_kfv mtl,mtl_parameters mtlp ';
4647: l_sql_string2 := l_sql_string2 || ' WHERE mtl.organization_id = mtlp.organization_id ';
4648: l_sql_string2 := l_sql_string2 || ' and mtlp.eam_enabled_flag = ''Y'' and mtl.organization_id IN (SELECT master_organization_id ';
4649: 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()) ';
4650: