[Home] [Help]
1077: WHERE RESOURCE_ID = x_id;
1078:
1079: -- To find the resource sequence nubmer from ahl_operation_resources
1080: CURSOR c_wo_dept (x_id IN NUMBER) IS
1081: SELECT --V.DEPARTMENT_ID, -- department should be from wip_operations
1082: V.ORGANIZATION_ID,
1083: WORKORDER_NAME, WIP_ENTITY_ID FROM
1084: AHL_VISITS_B V, AHL_VISIT_TASKS_B T, AHL_WORKORDERS W
1085: WHERE W.VISIT_TASK_ID = T.VISIT_TASK_ID AND T.VISIT_ID = V.VISIT_ID
1103: c_op_seq_num IN NUMBER)
1104: IS
1105: SELECT first_unit_start_date,
1106: last_unit_completion_date
1107: FROM wip_operations a, ahl_workorders b
1108: WHERE a.wip_entity_id = b.wip_entity_id
1109: AND workorder_id = c_workorder_id
1110: AND operation_seq_num = c_op_seq_num;*/
1111: --fix for bug number 6211089
1112: CURSOR wip_operation_dates (c_workorder_operation_id IN NUMBER)
1113: IS
1114: SELECT first_unit_start_date,
1115: last_unit_completion_date
1116: FROM wip_operations a, ahl_workorders b,ahl_workorder_operations c
1117: WHERE a.wip_entity_id = b.wip_entity_id
1118: AND b.workorder_id = c.workorder_id
1119: AND a.operation_seq_num = c.OPERATION_SEQUENCE_NUM
1120: AND c.workorder_operation_id = c_workorder_operation_id;
2197: c_op_seq_num IN NUMBER)
2198: IS
2199: SELECT first_unit_start_date,
2200: last_unit_completion_date, a.department_id
2201: FROM wip_operations a, ahl_workorders b
2202: WHERE a.wip_entity_id = b.wip_entity_id
2203: AND workorder_id = c_workorder_id
2204: AND operation_seq_num = c_op_seq_num;*/
2205:
2207: CURSOR wip_operation_dates (c_workorder_operation_id IN NUMBER)
2208: IS
2209: SELECT first_unit_start_date,
2210: last_unit_completion_date
2211: FROM wip_operations a, ahl_workorders b,ahl_workorder_operations c
2212: WHERE a.wip_entity_id = b.wip_entity_id
2213: AND b.workorder_id = c.workorder_id
2214: AND a.operation_seq_num = c.OPERATION_SEQUENCE_NUM
2215: AND c.workorder_operation_id = c_workorder_operation_id;