[Home] [Help]
1255: WHERE RESOURCE_ID = x_id;
1256:
1257: -- To find the resource sequence nubmer from ahl_operation_resources
1258: CURSOR c_wo_dept (x_id IN NUMBER) IS
1259: SELECT --V.DEPARTMENT_ID, -- department should be from wip_operations
1260: V.ORGANIZATION_ID,
1261: WORKORDER_NAME, WIP_ENTITY_ID FROM
1262: AHL_VISITS_B V, AHL_VISIT_TASKS_B T, AHL_WORKORDERS W
1263: WHERE W.VISIT_TASK_ID = T.VISIT_TASK_ID AND T.VISIT_ID = V.VISIT_ID
1281: c_op_seq_num IN NUMBER)
1282: IS
1283: SELECT first_unit_start_date,
1284: last_unit_completion_date
1285: FROM wip_operations a, ahl_workorders b
1286: WHERE a.wip_entity_id = b.wip_entity_id
1287: AND workorder_id = c_workorder_id
1288: AND operation_seq_num = c_op_seq_num;*/
1289: --fix for bug number 6211089
1290: CURSOR wip_operation_dates (c_workorder_operation_id IN NUMBER)
1291: IS
1292: SELECT first_unit_start_date,
1293: last_unit_completion_date
1294: FROM wip_operations a, ahl_workorders b,ahl_workorder_operations c
1295: WHERE a.wip_entity_id = b.wip_entity_id
1296: AND b.workorder_id = c.workorder_id
1297: AND a.operation_seq_num = c.OPERATION_SEQUENCE_NUM
1298: AND c.workorder_operation_id = c_workorder_operation_id;
2395: c_op_seq_num IN NUMBER)
2396: IS
2397: SELECT first_unit_start_date,
2398: last_unit_completion_date, a.department_id
2399: FROM wip_operations a, ahl_workorders b
2400: WHERE a.wip_entity_id = b.wip_entity_id
2401: AND workorder_id = c_workorder_id
2402: AND operation_seq_num = c_op_seq_num;*/
2403:
2405: CURSOR wip_operation_dates (c_workorder_operation_id IN NUMBER)
2406: IS
2407: SELECT first_unit_start_date,
2408: last_unit_completion_date
2409: FROM wip_operations a, ahl_workorders b,ahl_workorder_operations c
2410: WHERE a.wip_entity_id = b.wip_entity_id
2411: AND b.workorder_id = c.workorder_id
2412: AND a.operation_seq_num = c.OPERATION_SEQUENCE_NUM
2413: AND c.workorder_operation_id = c_workorder_operation_id;