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 190: l_visit_type fnd_lookup_values_vl.meaning%type;

186: --Local Variables for search results
187: l_rownum NUMBER;
188: l_visit_id NUMBER;
189: l_visit_num NUMBER;
190: l_visit_type fnd_lookup_values_vl.meaning%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;

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

205: l_sql_string := l_sql_string || ' HROU.name organization_name,BDPT.description department_name, ';
206: l_sql_string := l_sql_string || ' AHL_UTILITY_PVT.GET_UNIT_NAME(VST.ITEM_INSTANCE_ID) UNIT_NAME ';
207:
208: l_sql_string := l_sql_string || ' FROM ahl_visits_b vst, AHL_SIMULATION_PLANS_B ASML, ';
209: l_sql_string := l_sql_string || ' fnd_lookup_values_vl fndvt, MTL_SYSTEM_ITEMS_KFV MTSB, ';
210: l_sql_string := l_sql_string || ' CSI_ITEM_INSTANCES CSIS, HR_ALL_ORGANIZATION_UNITS HROU, ';
211: l_sql_string := l_sql_string || ' BOM_DEPARTMENTS BDPT ';
212:
213: l_sql_string := l_sql_string || ' WHERE vst.simulation_plan_id = asml.simulation_plan_id AND ';

Line 1276: l_code FND_LOOKUP_VALUES_VL.lookup_code%type;

1272: -- dynamic cursor
1273: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
1274:
1275: --Local Variables for search results
1276: l_code FND_LOOKUP_VALUES_VL.lookup_code%type;
1277: l_mean FND_LOOKUP_VALUES_VL.meaning%type;
1278: l_rownum NUMBER;
1279:
1280: BEGIN

Line 1277: l_mean FND_LOOKUP_VALUES_VL.meaning%type;

1273: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
1274:
1275: --Local Variables for search results
1276: l_code FND_LOOKUP_VALUES_VL.lookup_code%type;
1277: l_mean FND_LOOKUP_VALUES_VL.meaning%type;
1278: l_rownum NUMBER;
1279:
1280: BEGIN
1281:

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

1282: x_return_status := FND_API.G_RET_STS_SUCCESS;
1283:
1284: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
1285: l_sql_string := 'SELECT rownum , meaning,STATUS_CODE FROM ( select DISTINCT FND.MEANING meaning, SOR.NEXT_STATUS_CODE STATUS_CODE ';
1286: l_sql_string := l_sql_string || ' FROM AHL_STATUS_ORDER_RULES SOR, FND_LOOKUP_VALUES_VL FND ';
1287: l_sql_string := l_sql_string || ' where SOR.SYSTEM_STATUS_TYPE = ''AHL_JOB_STATUS'' AND FND.LOOKUP_TYPE(+)= ''AHL_JOB_STATUS'' ';
1288: l_sql_string := l_sql_string || ' AND FND.LOOKUP_CODE(+) = SOR.NEXT_STATUS_CODE ';
1289: --Get Dynamic Search Criteria
1290: l_criteria_tbl :=p_lov_input_rec.LovCriteriaTbl;

Line 3608: l_code FND_LOOKUP_VALUES_VL.lookup_code%type;

3604: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
3605:
3606: --Local Variables for search results
3607: l_rownum NUMBER;
3608: l_code FND_LOOKUP_VALUES_VL.lookup_code%type;
3609: l_mean FND_LOOKUP_VALUES_VL.meaning%type;
3610:
3611: BEGIN
3612:

Line 3609: l_mean FND_LOOKUP_VALUES_VL.meaning%type;

3605:
3606: --Local Variables for search results
3607: l_rownum NUMBER;
3608: l_code FND_LOOKUP_VALUES_VL.lookup_code%type;
3609: l_mean FND_LOOKUP_VALUES_VL.meaning%type;
3610:
3611: BEGIN
3612:
3613: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3614:
3615: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
3616: l_sql_string := 'SELECT * FROM ( SELECT Rownum RN, meaning,';
3617: l_sql_string := l_sql_string || ' lookup_code ';
3618: l_sql_string := l_sql_string || ' FROM FND_LOOKUP_VALUES_VL ';
3619: l_sql_string := l_sql_string || ' WHERE lookup_type=''AHL_REMOVAL_CODE'' ';
3620: l_sql_string := l_sql_string || ' and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate) ';
3621:
3622: --Get Dynamic Search Criteria

Line 3792: l_code FND_LOOKUP_VALUES_VL.lookup_code%type;

3788: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
3789:
3790: --Local Variables for search results
3791: l_rownum NUMBER;
3792: l_code FND_LOOKUP_VALUES_VL.lookup_code%type;
3793: l_mean FND_LOOKUP_VALUES_VL.meaning%type;
3794:
3795: BEGIN
3796:

Line 3793: l_mean FND_LOOKUP_VALUES_VL.meaning%type;

3789:
3790: --Local Variables for search results
3791: l_rownum NUMBER;
3792: l_code FND_LOOKUP_VALUES_VL.lookup_code%type;
3793: l_mean FND_LOOKUP_VALUES_VL.meaning%type;
3794:
3795: BEGIN
3796:
3797: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3798:
3799: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
3800: l_sql_string := 'SELECT * FROM ( SELECT Rownum RN, meaning,';
3801: l_sql_string := l_sql_string || ' lookup_code ';
3802: l_sql_string := l_sql_string || ' FROM FND_LOOKUP_VALUES_VL ';
3803: l_sql_string := l_sql_string || ' WHERE lookup_type=''REQUEST_RESOLUTION_CODE'' ';
3804: l_sql_string := l_sql_string || ' and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate) ';
3805:
3806: --Get Dynamic Search Criteria

Line 3976: l_code FND_LOOKUP_VALUES_VL.lookup_code%type;

3972: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
3973:
3974: --Local Variables for search results
3975: l_rownum NUMBER;
3976: l_code FND_LOOKUP_VALUES_VL.lookup_code%type;
3977: l_mean FND_LOOKUP_VALUES_VL.meaning%type;
3978:
3979: BEGIN
3980:

Line 3977: l_mean FND_LOOKUP_VALUES_VL.meaning%type;

3973:
3974: --Local Variables for search results
3975: l_rownum NUMBER;
3976: l_code FND_LOOKUP_VALUES_VL.lookup_code%type;
3977: l_mean FND_LOOKUP_VALUES_VL.meaning%type;
3978:
3979: BEGIN
3980:
3981: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3982:
3983: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
3984: l_sql_string := 'SELECT * FROM ( SELECT Rownum RN, description,';
3985: l_sql_string := l_sql_string || ' lookup_code ';
3986: l_sql_string := l_sql_string || ' FROM FND_LOOKUP_VALUES_VL fl ';
3987: l_sql_string := l_sql_string || ' WHERE lookup_type=''REQUEST_PROBLEM_CODE'' ';
3988: l_sql_string := l_sql_string || ' and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate) ';
3989: l_sql_string := l_sql_string || ' and enabled_flag = ''Y'' ';
3990: 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'') ';