APPS.AHL_PRD_RESOURCE_TRANX_PVT dependencies on AHL_WORK_ASSIGNMENTS

Line 1566: FROM AHL_WORK_ASSIGNMENTS AWAS, AHL_WORKORDER_TASKS_V AWOS, AHL_WORKORDER_OPERATIONS AWOP,

1562: PEPF.FULL_NAME ,
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

Line 1963: FROM AHL_WORK_ASSIGNMENTS AWAS,

1959: APRV.UOM_CODE,
1960: APRV.DEPARTMENT_ID,
1961: BD.department_code,
1962: APRV.REQUIREMENT_ID
1963: FROM AHL_WORK_ASSIGNMENTS AWAS,
1964: AHL_PP_REQUIREMENT_V APRV,bom_departments BD
1965: WHERE AWAS.OPERATION_RESOURCE_ID = APRV.REQUIREMENT_ID
1966: AND APRV.DEPARTMENT_ID = BD.department_id
1967: AND APRV.JOB_ID = x_workorder_id

Line 1986: FROM AHL_WORK_ASSIGNMENTS AWAS,

1982: AWAS.INSTANCE_ID,
1983: APRV.DEPARTMENT_ID,
1984: BD.department_code,
1985: APRV.REQUIREMENT_ID
1986: FROM AHL_WORK_ASSIGNMENTS AWAS,
1987: AHL_PP_REQUIREMENT_V APRV,bom_departments BD
1988: WHERE AWAS.OPERATION_RESOURCE_ID = APRV.REQUIREMENT_ID
1989: AND APRV.DEPARTMENT_ID = BD.department_id
1990: AND APRV.JOB_ID = x_workorder_id

Line 2013: FROM AHL_WORK_ASSIGNMENTS AWAS

2009: AND APRV.DEPARTMENT_ID = BD.department_id
2010: AND APRV.OPERATION_SEQUENCE = x_operation_seq_num
2011: AND APRV.RESOURCE_TYPE_CODE <> 2
2012: AND NOT EXISTS (SELECT ASSIGNMENT_ID
2013: FROM AHL_WORK_ASSIGNMENTS AWAS
2014: WHERE AWAS.OPERATION_RESOURCE_ID = APRV.REQUIREMENT_ID);
2015:
2016: CURSOR c_get_resource_assgmt_data(x_workorder_id NUMBER,
2017: x_operation_seq_num NUMBER)

Line 2032: FROM AHL_WORK_ASSIGNMENTS AWAS,

2028: AWAS.INSTANCE_ID,
2029: APRV.DEPARTMENT_ID,
2030: BD.department_code,
2031: APRV.REQUIREMENT_ID
2032: FROM AHL_WORK_ASSIGNMENTS AWAS,
2033: AHL_PP_REQUIREMENT_V APRV ,bom_departments BD
2034: WHERE AWAS.OPERATION_RESOURCE_ID = APRV.REQUIREMENT_ID
2035: AND APRV.DEPARTMENT_ID = BD.department_id
2036: AND APRV.JOB_ID = x_workorder_id

Line 2057: FROM AHL_WORK_ASSIGNMENTS AWAS

2053: WHERE APRV.JOB_ID = x_workorder_id
2054: AND APRV.DEPARTMENT_ID = BD.department_id
2055: AND APRV.OPERATION_SEQUENCE = x_operation_seq_num
2056: AND NOT EXISTS (SELECT ASSIGNMENT_ID
2057: FROM AHL_WORK_ASSIGNMENTS AWAS
2058: WHERE AWAS.OPERATION_RESOURCE_ID = APRV.REQUIREMENT_ID);
2059:
2060: CURSOR c_get_emp_details(x_employee_id NUMBER)
2061: IS