2719: IS
2720: SELECT
2721: WIOP.organization_id
2722: FROM
2723: WIP_OPERATIONS WIOP
2724: WHERE
2725: WIOP.wip_entity_id = p_wip_entity_id
2726: AND WIOP.operation_seq_num = p_operation_seq_num;
2727:
6005: WOP.status_code status_code,
6006: WOP.plan_id plan_id,
6007: WOP.collection_id collection_id
6008: FROM AHL_WORKORDER_OPERATIONS WOP,
6009: WIP_OPERATIONS WIP,
6010: AHL_WORKORDERS CWO
6011: WHERE WOP.operation_sequence_num = WIP.operation_seq_num
6012: AND WOP.workorder_id = CWO.workorder_id
6013: AND WIP.wip_entity_id = CWO.wip_entity_id
6054: WOP.status_code status_code,
6055: WOP.plan_id plan_id,
6056: WOP.collection_id collection_id
6057: FROM AHL_WORKORDER_OPERATIONS WOP,
6058: WIP_OPERATIONS WIP,
6059: AHL_WORKORDERS CWO
6060: WHERE WOP.operation_sequence_num = WIP.operation_seq_num
6061: AND WOP.workorder_id = CWO.workorder_id
6062: AND WIP.wip_entity_id = CWO.wip_entity_id
8341: WOP.collection_id collection_id,
8342: TSK.task_type_code
8343:
8344: FROM AHL_WORKORDER_OPERATIONS WOP,
8345: WIP_OPERATIONS WIP,
8346: AHL_WORKORDERS WO,
8347: AHL_VISIT_TASKS_B TSK
8348:
8349: WHERE WOP.operation_sequence_num = WIP.operation_seq_num
10410: CURSOR get_ue_operations( c_wip_entity_id NUMBER ) IS
10411: SELECT WOP.workorder_id workorder_id,
10412: WIP.operation_seq_num operation_seq_num
10413: FROM AHL_WORKORDER_OPERATIONS WOP,
10414: WIP_OPERATIONS WIP,
10415: AHL_WORKORDERS CWO
10416: WHERE WOP.operation_sequence_num = WIP.operation_seq_num
10417: AND WOP.workorder_id = CWO.workorder_id
10418: AND WIP.wip_entity_id = CWO.wip_entity_id