[Home] [Help]
113: and wor.resource_seq_num = wjdi.resource_seq_num
114: and wor.resource_id = wjdi.resource_id_old))
115: or
116: (exists (select 1
117: from wip_sub_operation_resources wsor
118: where wsor.wip_entity_id = wjdi.wip_entity_id
119: and wsor.organization_id = wjdi.organization_id
120: and wsor.operation_seq_num = wjdi.operation_seq_num
121: and wsor.resource_seq_num = wjdi.resource_seq_num
162: and wor.resource_seq_num = wjdi.resource_seq_num
163: and wor.resource_id = wjdi.resource_id_old))
164: or
165: (exists (select 1
166: from wip_sub_operation_resources wsor
167: where wsor.wip_entity_id = wjdi.wip_entity_id
168: and wsor.organization_id = wjdi.organization_id
169: and wsor.operation_seq_num = wjdi.operation_seq_num
170: and wsor.resource_seq_num = wjdi.resource_seq_num
944: and wor.organization_id = wjdi.organization_id
945: and wor.operation_seq_num = wjdi.operation_seq_num
946: and wor.resource_seq_num = wjdi.resource_seq_num)
947: or exists (select 1
948: from wip_sub_operation_resources wsor
949: where wsor.wip_entity_id = wjdi.wip_entity_id
950: and wsor.organization_id = wjdi.organization_id
951: and wsor.operation_seq_num = wjdi.operation_seq_num
952: and wsor.resource_seq_num = wjdi.resource_seq_num)
1213: EXCEPTION
1214: WHEN NO_DATA_FOUND THEN
1215: select maximum_assigned_units
1216: into l_maximum_assigned_units
1217: from wip_sub_operation_resources
1218: where wip_entity_id = p_wip_entity_id
1219: and organization_id = p_organization_id
1220: and operation_seq_num = p_operation_seq_num
1221: and resource_seq_num = p_resource_seq_num;
1223:
1224: elsif (p_load_type = WIP_JOB_DETAILS.WIP_SUB_RES) then
1225: select maximum_assigned_units
1226: into l_maximum_assigned_units
1227: from wip_sub_operation_resources
1228: where wip_entity_id = p_wip_entity_id
1229: and organization_id = p_organization_id
1230: and operation_seq_num = p_operation_seq_num
1231: and resource_seq_num = p_resource_seq_num;
2180: )
2181: or ( --Bug 12937792. Replacement group null.
2182: --wjdi.replacement_group_num is not null and
2183: not exists (select 1
2184: from wip_sub_operation_resources wsor,
2185: wip_operation_resources wor
2186: where wsor.wip_entity_id = wjdi.wip_entity_id
2187: and wsor.organization_id = wjdi.organization_id
2188: and wsor.operation_seq_num = wjdi.operation_seq_num
2316: )
2317: or ( -- Bug 12937792. Replacement Group can be Null.
2318: wjdi.replacement_group_num is not null and
2319: not exists (select 1
2320: from wip_sub_operation_resources wsor,
2321: wip_operation_resources wor
2322: where wsor.wip_entity_id = wjdi.wip_entity_id
2323: and wsor.organization_id = wjdi.organization_id
2324: and wsor.operation_seq_num = wjdi.operation_seq_num
2927: replacement_group_num
2928: into sched_seq,
2929: sub_group,
2930: repl_group
2931: from wip_sub_operation_resources
2932: where wip_entity_id = p_wip_entity_id
2933: and repetitive_schedule_id is null
2934: and operation_seq_num = p_operation_seq_num
2935: and resource_seq_num = p_resource_seq_num;
2957: select 1
2958: into l_res_sub
2959: from dual
2960: where exists (select 1
2961: from wip_sub_operation_resources
2962: where wip_entity_id = p_wip_entity_id
2963: and operation_seq_num = p_operation_seq_num
2964: and substitute_group_num = sub_group
2965: and nvl(replacement_group_num,0) = nvl(sched_row.replacement_group_num,0));/*Bug 13045227*/
3085: replacement_group_num
3086: into sched_seq,
3087: sub_group,
3088: repl_group
3089: from wip_sub_operation_resources
3090: where wip_entity_id = p_wip_entity_id
3091: and repetitive_schedule_id is null
3092: and operation_seq_num = p_operation_seq_num
3093: and resource_seq_num = p_resource_seq_num;