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 195: l_unit ahl_unit_config_headers.name%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;
196:
197: BEGIN
198:
199: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 497: l_uc_name AHL_UNIT_CONFIG_HEADERS.NAME%type;

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

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

508: l_sql_string := l_sql_string || ' U.NAME UC_NAME,C.INSTANCE_NUMBER , ';
509: l_sql_string := l_sql_string || ' I.CONCATENATED_SEGMENTS ITEM_NUMBER, ';
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 ';

Line 2064: l_unit ahl_unit_config_headers.name%type;

2060: l_rownum NUMBER;
2061: l_ata ahl_mc_relationships_v.ATA_MEANING%type;
2062: l_ata_desc ahl_mc_relationships_v.ATA_DESC%type;
2063: l_position_id NUMBER;
2064: l_unit ahl_unit_config_headers.name%type;
2065: l_position ahl_mc_relationships_v.position_ref_meaning%type;
2066:
2067: BEGIN
2068:

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

2069: x_return_status := FND_API.G_RET_STS_SUCCESS;
2070:
2071: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
2072: l_sql_string := 'SELECT * FROM ( SELECT DISTINCT Rownum RN, ATA_meaning, ATA_Desc, position_ref_meaning, position_key,uc.name ';
2073: l_sql_string := l_sql_string || ' from ahl_mc_relationships_v mc, ahl_unit_config_headers uc ';
2074: l_sql_string := l_sql_string || ' where uc.MASTER_CONFIG_ID = mc.mc_header_id AND ATA_meaning IS NOT NULL ';
2075:
2076: --Get Dynamic Search Criteria
2077: l_criteria_tbl :=p_lov_input_rec.LovCriteriaTbl;

Line 2296: l_unit ahl_unit_config_headers.name%type;

2292: l_rownum NUMBER;
2293: l_ata ahl_mc_relationships_v.ATA_MEANING%type;
2294: l_pos_desc ahl_mc_relationships_v.position_ref_desc%type;
2295: l_position_id NUMBER;
2296: l_unit ahl_unit_config_headers.name%type;
2297: l_position ahl_mc_relationships_v.position_ref_meaning%type;
2298:
2299: BEGIN
2300:

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

2301: x_return_status := FND_API.G_RET_STS_SUCCESS;
2302:
2303: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
2304: l_sql_string := 'SELECT * FROM ( SELECT DISTINCT Rownum RN, ATA_meaning, position_ref_desc, position_ref_meaning, position_key,uc.name ';
2305: l_sql_string := l_sql_string || ' from ahl_mc_relationships_v mc, ahl_unit_config_headers uc ';
2306: l_sql_string := l_sql_string || ' where uc.MASTER_CONFIG_ID = mc.mc_header_id ';
2307:
2308: --Get Dynamic Search Criteria
2309: l_criteria_tbl :=p_lov_input_rec.LovCriteriaTbl;