[Home] [Help]
87:
88: IF (p_serial_number IS NOT NULL) THEN
89: /*SELECT DISTINCT(instance_id)
90: INTO x_serial_id
91: FROM BOM_DEPT_RES_INSTANCES BDRI, AHL_OPERATION_RESOURCES AOR, AHL_WORKORDERS_V AWO
92: WHERE BDRI.resource_id = AOR.resource_id
93: AND BDRI.department_id = AWO.department_id
94: AND AWO.workorder_id = p_workorder_id
95: AND AOR.operation_resource_id = p_oper_resrc_id
95: AND AOR.operation_resource_id = p_oper_resrc_id
96: AND BDRI.serial_number = p_serial_number;*/
97:
98: SELECT INSTANCE_ID INTO x_instance_id
99: FROM BOM_DEPT_RES_INSTANCES BDRI
100: WHERE BDRI.resource_id = p_resource_id
101: AND BDRI.serial_number = p_serial_number
102: AND BDRI.department_id in (
103: SELECT
167: -- assignments are only allowed for employees in the WOs dept.
168: SELECT DISTINCT(PF.employee_id)
169: INTO x_employee_id
170: FROM
171: bom_dept_res_instances bdri,
172: wip_operation_resources wor,
173: wip_operations wo
174: ,ahl_workorders awo, ahl_operation_resources aor
175: , mtl_employees_current_view pf
267: -- assignments are only allowed for employees in the WOs dept.
268: select distinct pf.employee_id, pf.full_name
269: INTO x_employee_id, x_employee_name
270: from
271: bom_dept_res_instances bdri,
272: wip_operation_resources wor,
273: wip_operations wo
274: ,ahl_workorders awo, ahl_operation_resources aor
275: , mtl_employees_current_view pf
1108: c_resource_id IN NUMBER,
1109: c_dept_id IN NUMBER)
1110: IS
1111: SELECT a.instance_id
1112: FROM BOM_DEPT_RES_INSTANCES A, BOM_RESOURCE_EMPLOYEES B
1113: WHERE A.INSTANCE_ID = B.INSTANCE_ID
1114: AND B.PERSON_ID = c_person_id
1115: AND A.RESOURCE_ID = c_resource_id
1116: AND A.DEPARTMENT_ID in (
2076: c_resource_id IN NUMBER,
2077: c_dept_id IN NUMBER)
2078: IS
2079: SELECT a.instance_id
2080: FROM BOM_DEPT_RES_INSTANCES A, BOM_RESOURCE_EMPLOYEES B
2081: WHERE A.INSTANCE_ID = B.INSTANCE_ID
2082: AND B.PERSON_ID = c_person_id
2083: AND A.RESOURCE_ID = c_resource_id
2084: AND A.DEPARTMENT_ID in (