APPS.AHL_PRD_UTIL_PKG dependencies on AHL_WORKORDER_OPERATIONS

Line 448: ahl_workorder_operations

444: IS
445: SELECT
446: 'X'
447: FROM
448: ahl_workorder_operations
449: WHERE
450: workorder_id = p_workorder_id AND
451: operation_sequence_num = p_op_seq_no AND
452: status_code = 1;

Line 850: ahl_workorder_operations

846: CURSOR c_validate_op_status(p_workorder_id IN NUMBER) IS
847: SELECT
848: 'X'
849: FROM
850: ahl_workorder_operations
851: WHERE
852: workorder_id = p_workorder_id AND
853: status_code in (0,2);
854:

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 1079: AHL_WORKORDER_OPERATIONS AWOP

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
1082: AND AOR.WORKORDER_OPERATION_ID = AWOP.WORKORDER_OPERATION_ID
1083: AND AWOP.workorder_id = p_workorder_id

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 1532: FROM AHL_WORKORDER_OPERATIONS_V AO

1528: -- query to retrieve min of assigned to all employees for an operation.
1529: CURSOR c_get_op_sched_start(p_workorder_id IN NUMBER,
1530: p_operation_seq_num IN NUMBER) IS
1531: SELECT SCHEDULED_START_DATE
1532: FROM AHL_WORKORDER_OPERATIONS_V AO
1533: WHERE AO.workorder_id = p_workorder_id
1534: AND AO.operation_sequence_num = p_operation_seq_num;
1535:
1536: l_employee_id NUMBER;

Line 1615: FROM AHL_WORKORDER_OPERATIONS_V AO

1611: -- query to retrieve min of assigned to all employees for an operation.
1612: CURSOR c_get_op_sched_end(p_workorder_id IN NUMBER,
1613: p_operation_seq_num IN NUMBER) IS
1614: SELECT SCHEDULED_END_DATE
1615: FROM AHL_WORKORDER_OPERATIONS_V AO
1616: WHERE AO.workorder_id = p_workorder_id
1617: AND AO.operation_sequence_num = p_operation_seq_num;
1618:
1619: l_employee_id NUMBER;

Line 1718: AHL_WORKORDER_OPERATIONS AWO,

1714: WIPO.department_id
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

Line 1742: AHL_WORKORDER_OPERATIONS AWO,

1738: WIPO.department_id
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

Line 1929: select plan_id,collection_id from ahl_workorder_operations where workorder_operation_id = P_workorder_operation_id;

1925: l_plan_id NUMBER;
1926: l_qa_status VARCHAR2(25);
1927:
1928: CURSOR get_qa_info_csr(P_workorder_operation_id NUMBER) IS
1929: select plan_id,collection_id from ahl_workorder_operations where workorder_operation_id = P_workorder_operation_id;
1930:
1931: begin
1932: OPEN get_qa_info_csr(P_workorder_operation_id);
1933: FETCH get_qa_info_csr INTO l_plan_id,l_qa_collection_id;