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_MC_RELATIONSHIPS_V

Line 2206: l_ata ahl_mc_relationships_v.ATA_MEANING%type;

2202: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
2203:
2204: --Local Variables for search results
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;

Line 2207: l_ata_desc ahl_mc_relationships_v.ATA_DESC%type;

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

Line 2210: l_position ahl_mc_relationships_v.position_ref_meaning%type;

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:
2214: x_return_status := FND_API.G_RET_STS_SUCCESS;

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 2439: l_ata ahl_mc_relationships_v.ATA_MEANING%type;

2435: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
2436:
2437: --Local Variables for search results
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;

Line 2440: l_pos_desc ahl_mc_relationships_v.position_ref_desc%type;

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

Line 2443: l_position ahl_mc_relationships_v.position_ref_meaning%type;

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:
2447: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;