[Home] [Help]
190: where wip_entity_id = p_wip_entity_id;
191:
192: select resource_code, resource_type
193: into l_resource_code, l_resource_type
194: from bom_resources
195: where resource_id = p_resource_id;
196:
197: if( l_resource_type = 2 ) then /* for labor, try get the employee id and num */
198: select mec.employee_num
573: and process_status <> 4
574: and status_type = 1
575: and start_date is not null
576: and end_date is null
577: and resource_id in (select resource_id from bom_resources where resource_type = 2)
578: and (exclude_scheduled_flag is null or
579: exclude_scheduled_flag <>
580: nvl((select scheduled_flag from wip_operation_resources wor
581: where wor.wip_entity_id = t.wip_entity_id
592: select
593: decode(
594: ( select count(*)
595: from wip_resource_actual_times wrat,
596: bom_resources br,
597: wip_operation_resources wor
598: where wrat.wip_entity_id = p_wip_entity_id
599: and wrat.operation_seq_num = p_operation_seq_num
600: and wrat.resource_id = br.resource_id
613: /* max end date for yes/no labor resources */
614: cursor max_labor_end_date(p_scheduled_flag number) is
615: select max(wrat.end_date)
616: from wip_resource_actual_times wrat,
617: bom_resources br,
618: wip_operation_resources wor
619: where wrat.wip_entity_id = p_wip_entity_id
620: and wrat.operation_seq_num = p_operation_seq_num
621: and wrat.resource_id = br.resource_id
663: and operation_seq_num = p_operation_seq_num
664: and status_type = 1
665: and start_date is not null
666: and end_date is null
667: and resource_id in (select resource_id from bom_resources where resource_type = 1)
668: and ( select decode(scheduled_flag, 2, 1, scheduled_flag)
669: from wip_operation_resources wor
670: where wor.wip_entity_id = t.wip_entity_id
671: and wor.operation_seq_num = t.operation_seq_num
700: and operation_seq_num = p_operation_seq_num
701: and status_type = 1
702: and start_date is not null
703: and end_date is null
704: and resource_id in (select resource_id from bom_resources where resource_type = 1)
705: and ( select decode(scheduled_flag, 2, 1, scheduled_flag)
706: from wip_operation_resources wor
707: where wor.wip_entity_id = t.wip_entity_id
708: and wor.operation_seq_num = t.operation_seq_num
736: and operation_seq_num = p_operation_seq_num
737: and status_type = 1
738: and start_date is not null
739: and end_date is null
740: and resource_id in (select resource_id from bom_resources where resource_type = 1)
741: and ( select decode(scheduled_flag, 2, 1, scheduled_flag)
742: from wip_operation_resources wor
743: where wor.wip_entity_id = t.wip_entity_id
744: and wor.operation_seq_num = t.operation_seq_num
1002: wrat.uom_code,
1003: wrat.end_date,
1004: wrat.time_entry_mode
1005: from wip_resource_actual_times wrat,
1006: bom_resources br,
1007: wip_operation_resources wor
1008: where wrat.wip_entity_id = p_wip_entity_id
1009: and wrat.operation_seq_num = p_completed_op
1010: and wrat.resource_id = br.resource_id
1152: where wip_entity_id = p_wip_entity_id;
1153:
1154: select resource_code, resource_type
1155: into l_resource_code, l_resource_type
1156: from bom_resources
1157: where resource_id = l_resource_id;
1158:
1159: if( l_resource_type = 2 ) then /* for labor, try get the employee id and num */
1160:
2181: and wrat.status_type = 1
2182: and wrat.end_date is null;
2183:
2184: cursor resource_uom_cursor is select unit_of_measure
2185: from bom_resources br
2186: where br.resource_id = p_resource_id;
2187:
2188: cursor scheduled_flag_cursor is
2189: select scheduled_flag
2211: select wor.resource_id,
2212: wor.resource_seq_num,
2213: wor.uom_code
2214: from wip_operation_resources wor,
2215: bom_resources br
2216: where wor.wip_entity_id = p_wip_entity_id
2217: and wor.operation_seq_num = p_operation_seq_num
2218: and decode(wor.scheduled_flag, 2, 1, wor.scheduled_flag) =
2219: decode(c_scheduled_flag, 2, 1, c_scheduled_flag)