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

2057: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
2058:
2059: --Local Variables for search results
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;

Line 2062: l_ata_desc ahl_mc_relationships_v.ATA_DESC%type;

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

Line 2065: l_position ahl_mc_relationships_v.position_ref_meaning%type;

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

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

2289: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
2290:
2291: --Local Variables for search results
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;

Line 2294: l_pos_desc ahl_mc_relationships_v.position_ref_desc%type;

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

Line 2297: l_position ahl_mc_relationships_v.position_ref_meaning%type;

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

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;