APPS.AHL_PRD_UTIL_PKG dependencies on AHL_OPERATION_RESOURCES

Line 1063: FROM AHL_WORKORDER_OPERATIONS WO, AHL_OPERATION_RESOURCES AOR,

1059: CURSOR c_get_total_hours_emp(p_employee_id IN NUMBER,
1060: p_workorder_id IN NUMBER,
1061: p_operation_seq_num IN NUMBER) IS
1062: SELECT SUM((AWAS.assign_end_date - AWAS.assign_start_date) * 24)
1063: FROM AHL_WORKORDER_OPERATIONS WO, AHL_OPERATION_RESOURCES AOR,
1064: AHL_WORK_ASSIGNMENTS AWAS, BOM_RESOURCES BOM
1065: WHERE WO.workorder_operation_id = AOR.workorder_operation_id
1066: AND AOR.operation_resource_id = AWAS.operation_resource_id
1067: AND BOM.resource_id = AOR.resource_id

Line 1077: FROM AHL_OPERATION_RESOURCES AOR,

1073: -- query to retrieve total hrs required for all employees for an operation.
1074: CURSOR c_get_total_hours_op(p_workorder_id IN NUMBER,
1075: p_operation_seq_num IN NUMBER) IS
1076: SELECT SUM(NVL(AOR.duration, 0))
1077: FROM AHL_OPERATION_RESOURCES AOR,
1078: BOM_RESOURCES BOMR,
1079: AHL_WORKORDER_OPERATIONS AWOP
1080: WHERE AOR.RESOURCE_ID = BOMR.RESOURCE_ID
1081: AND BOMR.resource_type = 2 -- Person

Line 1148: FROM AHL_WORKORDER_OPERATIONS WO, AHL_OPERATION_RESOURCES AOR,

1144: p_operation_seq_num IN NUMBER,
1145: p_resource_id IN NUMBER,
1146: p_resource_seq_num IN NUMBER ) IS
1147: SELECT SUM((AWAS.assign_end_date - AWAS.assign_start_date) * 24)
1148: FROM AHL_WORKORDER_OPERATIONS WO, AHL_OPERATION_RESOURCES AOR,
1149: AHL_WORK_ASSIGNMENTS AWAS, BOM_RESOURCES BOM
1150: WHERE WO.workorder_operation_id = AOR.workorder_operation_id
1151: AND AOR.operation_resource_id = AWAS.operation_resource_id
1152: AND BOM.resource_id = AOR.resource_id

Line 1165: FROM AHL_WORKORDER_OPERATIONS WO, AHL_OPERATION_RESOURCES AOR,

1161: p_operation_seq_num IN NUMBER,
1162: p_resource_id IN NUMBER,
1163: p_resource_seq_num IN NUMBER ) IS
1164: SELECT SUM((AWAS.assign_end_date - AWAS.assign_start_date) * 24)
1165: FROM AHL_WORKORDER_OPERATIONS WO, AHL_OPERATION_RESOURCES AOR,
1166: AHL_WORK_ASSIGNMENTS AWAS, BOM_RESOURCES BOM
1167: WHERE WO.workorder_operation_id = AOR.workorder_operation_id
1168: AND AOR.operation_resource_id = AWAS.operation_resource_id
1169: AND BOM.resource_id = AOR.resource_id

Line 1518: FROM WIP_Operation_Resources WOR, AHL_OPERATION_RESOURCES AOR,

1514: CURSOR c_get_assigned_start_emp(p_employee_id IN NUMBER,
1515: p_workorder_id IN NUMBER,
1516: p_operation_seq_num IN NUMBER) IS
1517: SELECT MIN(AWAS.ASSIGN_START_DATE)
1518: FROM WIP_Operation_Resources WOR, AHL_OPERATION_RESOURCES AOR,
1519: AHL_WORK_ASSIGNMENTS AWAS, AHL_WORKORDERS AW
1520: WHERE WOR.resource_id = AOR.resource_id
1521: AND WOR.RESOURCE_SEQ_NUM = AOR.RESOURCE_SEQUENCE_NUM
1522: AND AOR.operation_resource_id = AWAS.operation_resource_id

Line 1601: FROM WIP_Operation_Resources WOR, AHL_OPERATION_RESOURCES AOR,

1597: CURSOR c_get_assigned_end_emp(p_employee_id IN NUMBER,
1598: p_workorder_id IN NUMBER,
1599: p_operation_seq_num IN NUMBER) IS
1600: SELECT MAX(AWAS.ASSIGN_END_DATE)
1601: FROM WIP_Operation_Resources WOR, AHL_OPERATION_RESOURCES AOR,
1602: AHL_WORK_ASSIGNMENTS AWAS, AHL_WORKORDERS AW
1603: WHERE WOR.resource_id = AOR.resource_id
1604: AND WOR.RESOURCE_SEQ_NUM = AOR.RESOURCE_SEQUENCE_NUM
1605: AND AOR.operation_resource_id = AWAS.operation_resource_id

Line 1719: AHL_OPERATION_RESOURCES AOR

1715:
1716: FROM WIP_OPERATIONS WIPO,
1717: AHL_WORKORDERS AHLW,
1718: AHL_WORKORDER_OPERATIONS AWO,
1719: AHL_OPERATION_RESOURCES AOR
1720:
1721: WHERE WIPO.wip_entity_id = AHLW.wip_entity_id
1722: AND AHLW.workorder_id = AWO.workorder_id
1723: AND WIPO.operation_seq_num = AWO.operation_sequence_num

Line 1743: AHL_OPERATION_RESOURCES AOR

1739: FROM
1740: WIP_OPERATIONS WIPO,
1741: AHL_WORKORDERS AHLW,
1742: AHL_WORKORDER_OPERATIONS AWO,
1743: AHL_OPERATION_RESOURCES AOR
1744: WHERE
1745: WIPO.wip_entity_id = AHLW.wip_entity_id
1746: AND WIPO.operation_seq_num = AWO.operation_sequence_num
1747: AND AWO.workorder_id = AHLW.workorder_id