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 FND_LOOKUP_VALUES_VL

Line 157: l_visit_type fnd_lookup_values_vl.meaning%type;

153: --Local Variables for search results
154: l_rownum NUMBER;
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;

Line 176: l_sql_string := l_sql_string || ' fnd_lookup_values_vl fndvt, MTL_SYSTEM_ITEMS_KFV MTSB, ';

172: l_sql_string := l_sql_string || ' HROU.name organization_name,BDPT.description department_name, ';
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 ';

Line 1243: l_code FND_LOOKUP_VALUES_VL.lookup_code%type;

1239: -- dynamic cursor
1240: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
1241:
1242: --Local Variables for search results
1243: l_code FND_LOOKUP_VALUES_VL.lookup_code%type;
1244: l_mean FND_LOOKUP_VALUES_VL.meaning%type;
1245: l_rownum NUMBER;
1246:
1247: BEGIN

Line 1244: l_mean FND_LOOKUP_VALUES_VL.meaning%type;

1240: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
1241:
1242: --Local Variables for search results
1243: l_code FND_LOOKUP_VALUES_VL.lookup_code%type;
1244: l_mean FND_LOOKUP_VALUES_VL.meaning%type;
1245: l_rownum NUMBER;
1246:
1247: BEGIN
1248:

Line 1253: l_sql_string := l_sql_string || ' FROM AHL_STATUS_ORDER_RULES SOR, FND_LOOKUP_VALUES_VL FND ';

1249: x_return_status := FND_API.G_RET_STS_SUCCESS;
1250:
1251: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
1252: l_sql_string := 'SELECT rownum , meaning,STATUS_CODE FROM ( select DISTINCT FND.MEANING meaning, SOR.NEXT_STATUS_CODE STATUS_CODE ';
1253: l_sql_string := l_sql_string || ' FROM AHL_STATUS_ORDER_RULES SOR, FND_LOOKUP_VALUES_VL FND ';
1254: l_sql_string := l_sql_string || ' where SOR.SYSTEM_STATUS_TYPE = ''AHL_JOB_STATUS'' AND FND.LOOKUP_TYPE(+)= ''AHL_JOB_STATUS'' ';
1255: l_sql_string := l_sql_string || ' AND FND.LOOKUP_CODE(+) = SOR.NEXT_STATUS_CODE ';
1256: --Get Dynamic Search Criteria
1257: l_criteria_tbl :=p_lov_input_rec.LovCriteriaTbl;

Line 1423: l_code FND_LOOKUP_VALUES_VL.lookup_code%type;

1419: -- dynamic cursor
1420: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
1421:
1422: --Local Variables for search results
1423: l_code FND_LOOKUP_VALUES_VL.lookup_code%type;
1424: l_mean FND_LOOKUP_VALUES_VL.meaning%type;
1425: l_rownum NUMBER;
1426:
1427: BEGIN

Line 1424: l_mean FND_LOOKUP_VALUES_VL.meaning%type;

1420: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
1421:
1422: --Local Variables for search results
1423: l_code FND_LOOKUP_VALUES_VL.lookup_code%type;
1424: l_mean FND_LOOKUP_VALUES_VL.meaning%type;
1425: l_rownum NUMBER;
1426:
1427: BEGIN
1428:

Line 1433: l_sql_string := l_sql_string || ' FND_LOOKUP_VALUES_VL FND where lookup_type=''AHL_PRD_WO_HOLD_REASON'' ';

1429: x_return_status := FND_API.G_RET_STS_SUCCESS;
1430:
1431: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
1432: l_sql_string := 'SELECT rownum , meaning,lookup_code FROM ( select meaning , lookup_code from ';
1433: l_sql_string := l_sql_string || ' FND_LOOKUP_VALUES_VL FND where lookup_type=''AHL_PRD_WO_HOLD_REASON'' ';
1434: --Get Dynamic Search Criteria
1435: l_criteria_tbl :=p_lov_input_rec.LovCriteriaTbl;
1436: l_bind_index := 1;
1437:

Line 3754: l_code FND_LOOKUP_VALUES_VL.lookup_code%type;

3750: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
3751:
3752: --Local Variables for search results
3753: l_rownum NUMBER;
3754: l_code FND_LOOKUP_VALUES_VL.lookup_code%type;
3755: l_mean FND_LOOKUP_VALUES_VL.meaning%type;
3756:
3757: BEGIN
3758:

Line 3755: l_mean FND_LOOKUP_VALUES_VL.meaning%type;

3751:
3752: --Local Variables for search results
3753: l_rownum NUMBER;
3754: l_code FND_LOOKUP_VALUES_VL.lookup_code%type;
3755: l_mean FND_LOOKUP_VALUES_VL.meaning%type;
3756:
3757: BEGIN
3758:
3759: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3764: l_sql_string := l_sql_string || ' FROM FND_LOOKUP_VALUES_VL ';

3760:
3761: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
3762: l_sql_string := 'SELECT * FROM ( SELECT Rownum RN, meaning,';
3763: l_sql_string := l_sql_string || ' lookup_code ';
3764: l_sql_string := l_sql_string || ' FROM FND_LOOKUP_VALUES_VL ';
3765: l_sql_string := l_sql_string || ' WHERE lookup_type=''AHL_REMOVAL_CODE'' ';
3766: l_sql_string := l_sql_string || ' and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate) ';
3767:
3768: --Get Dynamic Search Criteria

Line 3938: l_code FND_LOOKUP_VALUES_VL.lookup_code%type;

3934: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
3935:
3936: --Local Variables for search results
3937: l_rownum NUMBER;
3938: l_code FND_LOOKUP_VALUES_VL.lookup_code%type;
3939: l_mean FND_LOOKUP_VALUES_VL.meaning%type;
3940:
3941: BEGIN
3942:

Line 3939: l_mean FND_LOOKUP_VALUES_VL.meaning%type;

3935:
3936: --Local Variables for search results
3937: l_rownum NUMBER;
3938: l_code FND_LOOKUP_VALUES_VL.lookup_code%type;
3939: l_mean FND_LOOKUP_VALUES_VL.meaning%type;
3940:
3941: BEGIN
3942:
3943: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3948: l_sql_string := l_sql_string || ' FROM FND_LOOKUP_VALUES_VL ';

3944:
3945: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
3946: l_sql_string := 'SELECT * FROM ( SELECT Rownum RN, meaning,';
3947: l_sql_string := l_sql_string || ' lookup_code ';
3948: l_sql_string := l_sql_string || ' FROM FND_LOOKUP_VALUES_VL ';
3949: l_sql_string := l_sql_string || ' WHERE lookup_type=''REQUEST_RESOLUTION_CODE'' ';
3950: l_sql_string := l_sql_string || ' and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate) ';
3951:
3952: --Get Dynamic Search Criteria

Line 4122: l_code FND_LOOKUP_VALUES_VL.lookup_code%type;

4118: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
4119:
4120: --Local Variables for search results
4121: l_rownum NUMBER;
4122: l_code FND_LOOKUP_VALUES_VL.lookup_code%type;
4123: l_mean FND_LOOKUP_VALUES_VL.meaning%type;
4124:
4125: BEGIN
4126:

Line 4123: l_mean FND_LOOKUP_VALUES_VL.meaning%type;

4119:
4120: --Local Variables for search results
4121: l_rownum NUMBER;
4122: l_code FND_LOOKUP_VALUES_VL.lookup_code%type;
4123: l_mean FND_LOOKUP_VALUES_VL.meaning%type;
4124:
4125: BEGIN
4126:
4127: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4132: l_sql_string := l_sql_string || ' FROM FND_LOOKUP_VALUES_VL fl ';

4128:
4129: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
4130: l_sql_string := 'SELECT * FROM ( SELECT Rownum RN, description,';
4131: l_sql_string := l_sql_string || ' lookup_code ';
4132: l_sql_string := l_sql_string || ' FROM FND_LOOKUP_VALUES_VL fl ';
4133: l_sql_string := l_sql_string || ' WHERE lookup_type=''REQUEST_PROBLEM_CODE'' ';
4134: l_sql_string := l_sql_string || ' and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate) ';
4135: l_sql_string := l_sql_string || ' and enabled_flag = ''Y'' ';
4136: l_sql_string := l_sql_string || ' and ((NOT EXISTS (SELECT 1 FROM CS_SR_PROB_CODE_MAPPING_V WHERE INCIDENT_TYPE_ID = FND_PROFILE.Value(''AHL_PRD_SR_TYPE'') ';