APPS.AHL_PRD_RESOURCE_TRANX_PVT dependencies on AHL_WORK_ASSIGNMENTS

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

1604: PEPF.FULL_NAME ,
1605: AWOS.DEPARTMENT_NAME,
1606: AWOS.DEPARTMENT_ID,
1607: AWOS.ITEM_INSTANCE_ID
1608: FROM AHL_WORK_ASSIGNMENTS AWAS, AHL_WORKORDER_TASKS_V AWOS, AHL_WORKORDER_OPERATIONS AWOP,
1609: AHL_OPERATION_RESOURCES AOPR,AHL_DEPARTMENT_SHIFTS ADS, mtl_employees_current_view PEPF, BOM_RESOURCES BOMR, MFG_LOOKUPS MFGL
1610: WHERE AWAS.OPERATION_RESOURCE_ID = AOPR.OPERATION_RESOURCE_ID
1611: AND AWOP.WORKORDER_OPERATION_ID = AOPR.WORKORDER_OPERATION_ID
1612: AND AWOP.WORKORDER_ID = AWOS.WORKORDER_ID

Line 2005: FROM AHL_WORK_ASSIGNMENTS AWAS,

2001: APRV.UOM_CODE,
2002: APRV.DEPARTMENT_ID,
2003: BD.department_code,
2004: APRV.REQUIREMENT_ID
2005: FROM AHL_WORK_ASSIGNMENTS AWAS,
2006: AHL_PP_REQUIREMENT_V APRV,bom_departments BD
2007: WHERE AWAS.OPERATION_RESOURCE_ID = APRV.REQUIREMENT_ID
2008: AND APRV.DEPARTMENT_ID = BD.department_id
2009: AND APRV.JOB_ID = x_workorder_id

Line 2028: FROM AHL_WORK_ASSIGNMENTS AWAS,

2024: AWAS.INSTANCE_ID,
2025: APRV.DEPARTMENT_ID,
2026: BD.department_code,
2027: APRV.REQUIREMENT_ID
2028: FROM AHL_WORK_ASSIGNMENTS AWAS,
2029: AHL_PP_REQUIREMENT_V APRV,bom_departments BD
2030: WHERE AWAS.OPERATION_RESOURCE_ID = APRV.REQUIREMENT_ID
2031: AND APRV.DEPARTMENT_ID = BD.department_id
2032: AND APRV.JOB_ID = x_workorder_id

Line 2055: FROM AHL_WORK_ASSIGNMENTS AWAS

2051: AND APRV.DEPARTMENT_ID = BD.department_id
2052: AND APRV.OPERATION_SEQUENCE = x_operation_seq_num
2053: AND APRV.RESOURCE_TYPE_CODE <> 2
2054: AND NOT EXISTS (SELECT ASSIGNMENT_ID
2055: FROM AHL_WORK_ASSIGNMENTS AWAS
2056: WHERE AWAS.OPERATION_RESOURCE_ID = APRV.REQUIREMENT_ID);
2057:
2058: CURSOR c_get_resource_assgmt_data(x_workorder_id NUMBER,
2059: x_operation_seq_num NUMBER)

Line 2074: FROM AHL_WORK_ASSIGNMENTS AWAS,

2070: AWAS.INSTANCE_ID,
2071: APRV.DEPARTMENT_ID,
2072: BD.department_code,
2073: APRV.REQUIREMENT_ID
2074: FROM AHL_WORK_ASSIGNMENTS AWAS,
2075: AHL_PP_REQUIREMENT_V APRV ,bom_departments BD
2076: WHERE AWAS.OPERATION_RESOURCE_ID = APRV.REQUIREMENT_ID
2077: AND APRV.DEPARTMENT_ID = BD.department_id
2078: AND APRV.JOB_ID = x_workorder_id

Line 2099: FROM AHL_WORK_ASSIGNMENTS AWAS

2095: WHERE APRV.JOB_ID = x_workorder_id
2096: AND APRV.DEPARTMENT_ID = BD.department_id
2097: AND APRV.OPERATION_SEQUENCE = x_operation_seq_num
2098: AND NOT EXISTS (SELECT ASSIGNMENT_ID
2099: FROM AHL_WORK_ASSIGNMENTS AWAS
2100: WHERE AWAS.OPERATION_RESOURCE_ID = APRV.REQUIREMENT_ID);
2101:
2102: CURSOR c_get_emp_details(x_employee_id NUMBER)
2103: IS