APPS.AHL_PRD_RESOURCE_TRANX_PVT dependencies on MTL_EMPLOYEES_CURRENT_VIEW

Line 97: FROM mtl_employees_current_view pf, bom_resource_employees bre, bom_dept_res_instances bdri

93: --p_emp_num in number) -- fix for bug# 6032288.
94: p_emp_num in varchar2)
95: IS
96: SELECT 'x'
97: FROM mtl_employees_current_view pf, bom_resource_employees bre, bom_dept_res_instances bdri
98: --, ahl_pp_requirement_v aprv
99: WHERE --aprv.department_id = bdri.department_id
100: --and aprv.RESOURCE_ID= bdri.resource_id
101: --and

Line 685: FROM mtl_employees_current_view

681: */
682:
683: -- Bug# 4553747.
684: SELECT employee_id person_id, employee_num employee_number, full_name
685: FROM mtl_employees_current_view
686: WHERE UPPER(employee_num) LIKE UPPER(C_EMPLOYEE)
687: AND organization_id = c_org_id;
688:
689: l_emp_rec CurGetEmployee%Rowtype;

Line 1567: AHL_OPERATION_RESOURCES AOPR,AHL_DEPARTMENT_SHIFTS ADS, mtl_employees_current_view PEPF, BOM_RESOURCES BOMR, MFG_LOOKUPS MFGL

1563: AWOS.DEPARTMENT_NAME,
1564: AWOS.DEPARTMENT_ID,
1565: AWOS.ITEM_INSTANCE_ID
1566: FROM AHL_WORK_ASSIGNMENTS AWAS, AHL_WORKORDER_TASKS_V AWOS, AHL_WORKORDER_OPERATIONS AWOP,
1567: AHL_OPERATION_RESOURCES AOPR,AHL_DEPARTMENT_SHIFTS ADS, mtl_employees_current_view PEPF, BOM_RESOURCES BOMR, MFG_LOOKUPS MFGL
1568: WHERE AWAS.OPERATION_RESOURCE_ID = AOPR.OPERATION_RESOURCE_ID
1569: AND AWOP.WORKORDER_OPERATION_ID = AOPR.WORKORDER_OPERATION_ID
1570: AND AWOP.WORKORDER_ID = AWOS.WORKORDER_ID
1571: AND AWOS.DEPARTMENT_ID = ADS.DEPARTMENT_ID (+)