APPS.AHL_PRD_LOV_SERVICE_PVT dependencies on BOM_DEPT_RES_INSTANCES

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

1028: x_return_status := FND_API.G_RET_STS_SUCCESS;
1029:
1030: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
1031: l_sql_string := 'SELECT rownum, A.* FROM ( SELECT DISTINCT bdri.resource_id ,pf.employee_num,pf.full_name, bdri.department_id,pf.employee_id ';
1032: l_sql_string := l_sql_string || ' FROM mtl_employees_current_view pf, bom_resource_employees bre, bom_dept_res_instances bdri ';
1033: l_sql_string := l_sql_string || ' WHERE bre.instance_id = bdri.instance_id ';
1034: l_sql_string := l_sql_string || ' and pf.employee_id=bre.person_id ';
1035: l_sql_string := l_sql_string || ' and pf.organization_id = bre.organization_id ';
1036: l_sql_string := l_sql_string || ' and sysdate between BRE.EFFECTIVE_START_DATE and BRE.EFFECTIVE_END_DATE ';

Line 2659: l_serial_num bom_dept_res_instances.SERIAL_NUMBER%type;

2655: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
2656:
2657: --Local Variables for search results
2658: l_rownum NUMBER;
2659: l_serial_num bom_dept_res_instances.SERIAL_NUMBER%type;
2660: l_instance_id NUMBER;
2661: l_dept_id NUMBER;
2662: l_res_id NUMBER;
2663:

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

2667:
2668: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
2669: l_sql_string := 'SELECT * FROM ( SELECT DISTINCT Rownum RN, bdri.SERIAL_NUMBER,';
2670: l_sql_string := l_sql_string || ' bdri.instance_id, bdri.department_id, bdri.resource_id ';
2671: l_sql_string := l_sql_string || ' FROM bom_dept_res_instances BDRI ';
2672: l_sql_string := l_sql_string || ' WHERE bdri.SERIAL_NUMBER is not null ';
2673:
2674: --Get Dynamic Search Criteria
2675: l_criteria_tbl :=p_lov_input_rec.LovCriteriaTbl;

Line 2889: l_serial_num bom_dept_res_instances.SERIAL_NUMBER%type;

2885: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
2886:
2887: --Local Variables for search results
2888: l_rownum NUMBER;
2889: l_serial_num bom_dept_res_instances.SERIAL_NUMBER%type;
2890: l_instance_id NUMBER;
2891: l_dept_id NUMBER;
2892: l_res_id NUMBER;
2893:

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

2897:
2898: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
2899: l_sql_string := 'SELECT * FROM ( SELECT DISTINCT Rownum RN, bdri.SERIAL_NUMBER,';
2900: l_sql_string := l_sql_string || ' bdri.instance_id, bdri.department_id, bdri.resource_id ';
2901: l_sql_string := l_sql_string || ' FROM bom_dept_res_instances BDRI ';
2902: l_sql_string := l_sql_string || ' WHERE bdri.SERIAL_NUMBER is not null ';
2903:
2904: --Get Dynamic Search Criteria
2905: l_criteria_tbl :=p_lov_input_rec.LovCriteriaTbl;

Line 3128: l_serial_num bom_dept_res_instances.SERIAL_NUMBER%type;

3124: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
3125:
3126: --Local Variables for search results
3127: l_rownum NUMBER;
3128: l_serial_num bom_dept_res_instances.SERIAL_NUMBER%type;
3129: l_instance_id NUMBER;
3130: l_dept_id NUMBER;
3131: l_res_id NUMBER;
3132:

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

3136:
3137: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
3138: l_sql_string := 'SELECT * FROM ( SELECT DISTINCT Rownum RN, bdri.SERIAL_NUMBER,';
3139: l_sql_string := l_sql_string || ' bdri.instance_id, bdri.department_id, bdri.resource_id ';
3140: l_sql_string := l_sql_string || ' FROM bom_dept_res_instances BDRI ';
3141: l_sql_string := l_sql_string || ' WHERE bdri.SERIAL_NUMBER is not null ';
3142:
3143: --Get Dynamic Search Criteria
3144: l_criteria_tbl :=p_lov_input_rec.LovCriteriaTbl;