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 AHL_UNIT_CONFIG_HEADERS

Line 162: l_unit ahl_unit_config_headers.name%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:
164: BEGIN
165:
166: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 464: l_uc_name AHL_UNIT_CONFIG_HEADERS.NAME%type;

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

Line 479: l_sql_string := l_sql_string || ' FROM AHL_UNIT_CONFIG_HEADERS U, ';

475: l_sql_string := l_sql_string || ' U.NAME UC_NAME,C.INSTANCE_NUMBER , ';
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 ';

Line 2209: l_unit ahl_unit_config_headers.name%type;

2205: l_rownum NUMBER;
2206: l_ata ahl_mc_relationships_v.ATA_MEANING%type;
2207: l_ata_desc ahl_mc_relationships_v.ATA_DESC%type;
2208: l_position_id NUMBER;
2209: l_unit ahl_unit_config_headers.name%type;
2210: l_position ahl_mc_relationships_v.position_ref_meaning%type;
2211:
2212: BEGIN
2213:

Line 2218: l_sql_string := l_sql_string || ' from ahl_mc_relationships_v mc, ahl_unit_config_headers uc ';

2214: x_return_status := FND_API.G_RET_STS_SUCCESS;
2215:
2216: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
2217: l_sql_string := 'SELECT rownum, A.* FROM ( SELECT DISTINCT ATA_meaning, ATA_Desc, position_ref_meaning, position_key,uc.name ';
2218: l_sql_string := l_sql_string || ' from ahl_mc_relationships_v mc, ahl_unit_config_headers uc ';
2219: l_sql_string := l_sql_string || ' where uc.MASTER_CONFIG_ID = mc.mc_header_id AND ATA_meaning IS NOT NULL ';
2220:
2221: --Get Dynamic Search Criteria
2222: l_criteria_tbl :=p_lov_input_rec.LovCriteriaTbl;

Line 2442: l_unit ahl_unit_config_headers.name%type;

2438: l_rownum NUMBER;
2439: l_ata ahl_mc_relationships_v.ATA_MEANING%type;
2440: l_pos_desc ahl_mc_relationships_v.position_ref_desc%type;
2441: l_position_id NUMBER;
2442: l_unit ahl_unit_config_headers.name%type;
2443: l_position ahl_mc_relationships_v.position_ref_meaning%type;
2444:
2445: BEGIN
2446:

Line 2451: l_sql_string := l_sql_string || ' from ahl_mc_relationships_v mc, ahl_unit_config_headers uc ';

2447: x_return_status := FND_API.G_RET_STS_SUCCESS;
2448:
2449: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
2450: l_sql_string := 'SELECT * FROM ( SELECT DISTINCT Rownum RN, ATA_meaning, position_ref_desc, position_ref_meaning, position_key,uc.name ';
2451: l_sql_string := l_sql_string || ' from ahl_mc_relationships_v mc, ahl_unit_config_headers uc ';
2452: l_sql_string := l_sql_string || ' where uc.MASTER_CONFIG_ID = mc.mc_header_id ';
2453:
2454: --Get Dynamic Search Criteria
2455: l_criteria_tbl :=p_lov_input_rec.LovCriteriaTbl;