APPS.AHL_PRD_LOV_SERVICE_PVT dependencies on BOM_DEPT_RES_INSTANCES

Line 1065: l_sql_string := l_sql_string || ' FROM mtl_employees_current_view pf, bom_resource_employees bre, bom_dept_res_instances bdri ';

1061: x_return_status := FND_API.G_RET_STS_SUCCESS;
1062:
1063: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
1064: l_sql_string := 'SELECT * FROM ( SELECT rownum RN, bdri.resource_id ,pf.employee_num,pf.full_name, bdri.department_id,pf.employee_id ';
1065: l_sql_string := l_sql_string || ' FROM mtl_employees_current_view pf, bom_resource_employees bre, bom_dept_res_instances bdri ';
1066: l_sql_string := l_sql_string || ' WHERE bre.instance_id = bdri.instance_id ';
1067: l_sql_string := l_sql_string || ' and pf.employee_id=bre.person_id ';
1068: l_sql_string := l_sql_string || ' and pf.organization_id = bre.organization_id ';
1069: l_sql_string := l_sql_string || ' and sysdate between BRE.EFFECTIVE_START_DATE and BRE.EFFECTIVE_END_DATE ';

Line 2513: l_serial_num bom_dept_res_instances.SERIAL_NUMBER%type;

2509: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
2510:
2511: --Local Variables for search results
2512: l_rownum NUMBER;
2513: l_serial_num bom_dept_res_instances.SERIAL_NUMBER%type;
2514: l_instance_id NUMBER;
2515: l_dept_id NUMBER;
2516: l_res_id NUMBER;
2517:

Line 2525: l_sql_string := l_sql_string || ' FROM bom_dept_res_instances BDRI ';

2521:
2522: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
2523: l_sql_string := 'SELECT * FROM ( SELECT DISTINCT Rownum RN, bdri.SERIAL_NUMBER,';
2524: l_sql_string := l_sql_string || ' bdri.instance_id, bdri.department_id, bdri.resource_id ';
2525: l_sql_string := l_sql_string || ' FROM bom_dept_res_instances BDRI ';
2526: l_sql_string := l_sql_string || ' WHERE bdri.SERIAL_NUMBER is not null ';
2527:
2528: --Get Dynamic Search Criteria
2529: l_criteria_tbl :=p_lov_input_rec.LovCriteriaTbl;

Line 2743: l_serial_num bom_dept_res_instances.SERIAL_NUMBER%type;

2739: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
2740:
2741: --Local Variables for search results
2742: l_rownum NUMBER;
2743: l_serial_num bom_dept_res_instances.SERIAL_NUMBER%type;
2744: l_instance_id NUMBER;
2745: l_dept_id NUMBER;
2746: l_res_id NUMBER;
2747:

Line 2755: l_sql_string := l_sql_string || ' FROM bom_dept_res_instances BDRI ';

2751:
2752: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
2753: l_sql_string := 'SELECT * FROM ( SELECT DISTINCT Rownum RN, bdri.SERIAL_NUMBER,';
2754: l_sql_string := l_sql_string || ' bdri.instance_id, bdri.department_id, bdri.resource_id ';
2755: l_sql_string := l_sql_string || ' FROM bom_dept_res_instances BDRI ';
2756: l_sql_string := l_sql_string || ' WHERE bdri.SERIAL_NUMBER is not null ';
2757:
2758: --Get Dynamic Search Criteria
2759: l_criteria_tbl :=p_lov_input_rec.LovCriteriaTbl;

Line 2982: l_serial_num bom_dept_res_instances.SERIAL_NUMBER%type;

2978: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
2979:
2980: --Local Variables for search results
2981: l_rownum NUMBER;
2982: l_serial_num bom_dept_res_instances.SERIAL_NUMBER%type;
2983: l_instance_id NUMBER;
2984: l_dept_id NUMBER;
2985: l_res_id NUMBER;
2986:

Line 2994: l_sql_string := l_sql_string || ' FROM bom_dept_res_instances BDRI ';

2990:
2991: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
2992: l_sql_string := 'SELECT * FROM ( SELECT DISTINCT Rownum RN, bdri.SERIAL_NUMBER,';
2993: l_sql_string := l_sql_string || ' bdri.instance_id, bdri.department_id, bdri.resource_id ';
2994: l_sql_string := l_sql_string || ' FROM bom_dept_res_instances BDRI ';
2995: l_sql_string := l_sql_string || ' WHERE bdri.SERIAL_NUMBER is not null ';
2996:
2997: --Get Dynamic Search Criteria
2998: l_criteria_tbl :=p_lov_input_rec.LovCriteriaTbl;