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 CSI_ITEM_INSTANCES

Line 159: l_serial_number CSI_ITEM_INSTANCES.serial_number%type;

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;
163:

Line 177: l_sql_string := l_sql_string || ' CSI_ITEM_INSTANCES CSIS, HR_ALL_ORGANIZATION_UNITS HROU, ';

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 ';
181: l_sql_string := l_sql_string || ' ASML.PRIMARY_PLAN_FLAG = ''Y'' AND ';

Line 466: l_serial_number CSI_ITEM_INSTANCES.INSTANCE_NUMBER%type;

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

Line 480: l_sql_string := l_sql_string || ' CSI_ITEM_INSTANCES C, ';

476: l_sql_string := l_sql_string || ' I.CONCATENATED_SEGMENTS ITEM_NUMBER, ';
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 ';

Line 4538: l_instance csi_item_instances.instance_number%type;

4534: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
4535:
4536: --Local Variables for search results
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:

Line 4539: l_lot csi_item_instances.lot_number%type;

4535:
4536: --Local Variables for search results
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

Line 4540: l_serial csi_item_instances.serial_number%type;

4536: --Local Variables for search results
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:

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()) ';