[Home] [Help]
782: and process_status <> 4
783: and status_type = 1
784: and start_date is not null
785: and end_date is null
786: and resource_id in (select resource_id from bom_resources where resource_type = 2)
787: and (exclude_scheduled_flag is null or
788: exclude_scheduled_flag <>
789: nvl((select scheduled_flag from wip_operation_resources wor
790: where wor.wip_entity_id = t.wip_entity_id
809: select
810: decode(
811: ( select count(*)
812: from wip_resource_actual_times wrat,
813: bom_resources br,
814: wip_operation_resources wor
815: where wrat.wip_entity_id = p_wip_entity_id
816: and wrat.operation_seq_num = p_operation_seq_num
817: and wrat.resource_id = br.resource_id
830: /* max end date for yes/no labor resources */
831: cursor max_labor_end_date(p_scheduled_flag number) is
832: select max(wrat.end_date)
833: from wip_resource_actual_times wrat,
834: bom_resources br,
835: wip_operation_resources wor
836: where wrat.wip_entity_id = p_wip_entity_id
837: and wrat.operation_seq_num = p_operation_seq_num
838: and wrat.resource_id = br.resource_id
894: and operation_seq_num = p_operation_seq_num
895: and status_type = 1
896: and start_date is not null
897: and end_date is null
898: and resource_id in (select resource_id from bom_resources where resource_type = 1)
899: and ( select decode(scheduled_flag, 2, 1, scheduled_flag)
900: from wip_operation_resources wor
901: where wor.wip_entity_id = t.wip_entity_id
902: and wor.operation_seq_num = t.operation_seq_num
931: and operation_seq_num = p_operation_seq_num
932: and status_type = 1
933: and start_date is not null
934: and end_date is null
935: and resource_id in (select resource_id from bom_resources where resource_type = 1)
936: and ( select decode(scheduled_flag, 2, 1, scheduled_flag)
937: from wip_operation_resources wor
938: where wor.wip_entity_id = t.wip_entity_id
939: and wor.operation_seq_num = t.operation_seq_num
967: and operation_seq_num = p_operation_seq_num
968: and status_type = 1
969: and start_date is not null
970: and end_date is null
971: and resource_id in (select resource_id from bom_resources where resource_type = 1)
972: and ( select decode(scheduled_flag, 2, 1, scheduled_flag)
973: from wip_operation_resources wor
974: where wor.wip_entity_id = t.wip_entity_id
975: and wor.operation_seq_num = t.operation_seq_num
1279: wrat.uom_code,
1280: wrat.end_date,
1281: wrat.time_entry_mode
1282: from wip_resource_actual_times wrat,
1283: bom_resources br,
1284: wip_operation_resources wor
1285: where wrat.wip_entity_id = p_wip_entity_id
1286: and wrat.operation_seq_num = p_completed_op
1287: and wrat.resource_id = br.resource_id
2784: and wrat.status_type = 1
2785: and wrat.end_date is null;
2786:
2787: cursor resource_uom_cursor is select unit_of_measure
2788: from bom_resources br
2789: where br.resource_id = p_resource_id;
2790:
2791: cursor scheduled_flag_cursor is
2792: select scheduled_flag
2814: select wor.resource_id,
2815: wor.resource_seq_num,
2816: wor.uom_code
2817: from wip_operation_resources wor,
2818: bom_resources br
2819: where wor.wip_entity_id = p_wip_entity_id
2820: and wor.operation_seq_num = p_operation_seq_num
2821: and decode(wor.scheduled_flag, 2, 1, wor.scheduled_flag) =
2822: decode(c_scheduled_flag, 2, 1, c_scheduled_flag)
3493:
3494: -- Modified for Bug 16528843.
3495: select br.resource_code, br.resource_type
3496: into l_resource_code, l_resource_type
3497: from bom_resources br
3498: where br.resource_id = p_resource_id;
3499:
3500: if (l_logLevel <= wip_constants.full_logging) then
3501: wip_logger.log('derive_insert_wcti Phase 30', l_retStatus);
3624: exception
3625: when no_data_found then
3626: select br.default_basis_type, br.standard_rate_flag, br.unit_of_measure,ca.activity_id, ca.activity
3627: into l_basis_type, l_standard_rate_flag, l_primary_uom,l_activity_id, l_activity_name
3628: from bom_resources br,cst_activities ca
3629: where br.resource_id = p_resource_id
3630: and br.default_activity_id = ca.activity_id (+)
3631: and nvl(ca.disable_date(+),sysdate+1) > sysdate
3632: and (ca.organization_id is null or ca.organization_id = p_organization_id);
3861: wo.first_unit_start_date,
3862: wo.last_unit_completion_date
3863: from wip_operations wo,
3864: wip_cost_txn_interface wti,
3865: bom_resources br
3866: where wti.group_id = x_group_id
3867: and wti.process_phase = 2
3868: and wti.process_status = 1
3869: and wti.transaction_type = 1
3936: into l_num_jobs
3937: from
3938: (select distinct wrat.wip_entity_id, wrat.operation_seq_num
3939: from wip_resource_actual_times wrat,
3940: bom_resources br
3941: where wrat.organization_id = p_org_id
3942: and wrat.employee_id = p_emp_id
3943: and wrat.start_date is not null
3944: and wrat.end_date is null
3981: wrat.operation_seq_num,
3982: wrat.start_date
3983: into l_wip_entity_id, l_op_seq_num, l_start_date
3984: from wip_resource_actual_times wrat,
3985: bom_resources br
3986: where wrat.organization_id = p_org_id
3987: and wrat.employee_id = p_emp_id
3988: and wrat.start_date is not null
3989: and wrat.end_date is null