APPS.WIP_RESOURCE_VALIDATIONS dependencies on WIP_SUB_OPERATION_RESOURCES

Line 117: from wip_sub_operation_resources wsor

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

Line 166: from wip_sub_operation_resources wsor

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

Line 946: from wip_sub_operation_resources wsor

942: and wor.organization_id = wjdi.organization_id
943: and wor.operation_seq_num = wjdi.operation_seq_num
944: and wor.resource_seq_num = wjdi.resource_seq_num)
945: or exists (select 1
946: from wip_sub_operation_resources wsor
947: where wsor.wip_entity_id = wjdi.wip_entity_id
948: and wsor.organization_id = wjdi.organization_id
949: and wsor.operation_seq_num = wjdi.operation_seq_num
950: and wsor.resource_seq_num = wjdi.resource_seq_num)

Line 1205: from wip_sub_operation_resources

1201: and resource_seq_num = p_resource_seq_num;
1202: elsif (p_load_type = WIP_JOB_DETAILS.WIP_SUB_RES) then
1203: select maximum_assigned_units
1204: into l_maximum_assigned_units
1205: from wip_sub_operation_resources
1206: where wip_entity_id = p_wip_entity_id
1207: and organization_id = p_organization_id
1208: and operation_seq_num = p_operation_seq_num
1209: and resource_seq_num = p_resource_seq_num;

Line 2139: from wip_sub_operation_resources wsor,

2135: )
2136: )
2137: or ( wjdi.replacement_group_num is not null
2138: and not exists (select 1
2139: from wip_sub_operation_resources wsor,
2140: wip_operation_resources wor
2141: where wsor.wip_entity_id = wjdi.wip_entity_id
2142: and wsor.organization_id = wjdi.organization_id
2143: and wsor.operation_seq_num = wjdi.operation_seq_num

Line 2274: from wip_sub_operation_resources wsor,

2270: )
2271: )
2272: or ( wjdi.replacement_group_num is not null
2273: and not exists (select 1
2274: from wip_sub_operation_resources wsor,
2275: wip_operation_resources wor
2276: where wsor.wip_entity_id = wjdi.wip_entity_id
2277: and wsor.organization_id = wjdi.organization_id
2278: and wsor.operation_seq_num = wjdi.operation_seq_num

Line 2888: from wip_sub_operation_resources

2884: select 1
2885: into l_res_sub
2886: from dual
2887: where exists (select 1
2888: from wip_sub_operation_resources
2889: where wip_entity_id = p_wip_entity_id
2890: and operation_seq_num = p_operation_seq_num
2891: and substitute_group_num = sub_group
2892: and replacement_group_num = sched_row.replacement_group_num);

Line 3016: from wip_sub_operation_resources

3012: replacement_group_num
3013: into sched_seq,
3014: sub_group,
3015: repl_group
3016: from wip_sub_operation_resources
3017: where wip_entity_id = p_wip_entity_id
3018: and repetitive_schedule_id is null
3019: and operation_seq_num = p_operation_seq_num
3020: and resource_seq_num = p_resource_seq_num;