eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_RESOURCE_VALIDATIONS dependencies on WIP_OPERATION_RESOURCES

Line 109: from wip_operation_resources wor

105: and wjdi.operation_seq_num = p_operation_seq_num
106: and wjdi.resource_seq_num = p_resource_seq_num
107: and wjdi.resource_id_old = p_resource_id_old
108: and not ( (exists (select 1
109: from wip_operation_resources wor
110: where wor.wip_entity_id = wjdi.wip_entity_id
111: and wor.organization_id = wjdi.organization_id
112: and wor.operation_seq_num = wjdi.operation_seq_num
113: and wor.resource_seq_num = wjdi.resource_seq_num

Line 158: from wip_operation_resources wor

154: and wjdi.operation_seq_num = p_operation_seq_num
155: and wjdi.resource_seq_num = p_resource_seq_num
156: and wjdi.resource_id_old = p_resource_id_old
157: and not ( (exists (select 1
158: from wip_operation_resources wor
159: where wor.wip_entity_id = wjdi.wip_entity_id
160: and wor.organization_id = wjdi.organization_id
161: and wor.operation_seq_num = wjdi.operation_seq_num
162: and wor.resource_seq_num = wjdi.resource_seq_num

Line 187: from wip_job_dtls_interface wjdi, wip_operation_resources wor

183: p_resource_id_old number) IS
184:
185: cursor c_invalid_wor_rows is
186: select interface_id
187: from wip_job_dtls_interface wjdi, wip_operation_resources wor
188: where wjdi.group_id = p_group_id
189: and wjdi.process_phase = wip_constants.ml_validation
190: and wjdi.process_status in (wip_constants.running,
191: wip_constants.warning)

Line 237: -- applied_resource_units in WIP_OPERATION_RESOURCES must be 0

233: );
234: l_error_exists boolean := false;
235: begin
236:
237: -- applied_resource_units in WIP_OPERATION_RESOURCES must be 0
238: for l_inv_row in c_invalid_wor_rows loop
239: l_error_exists := true;
240: fnd_message.set_name('WIP', 'WIP_JDI_RES_APPLIED');
241: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));

Line 266: from wip_operation_resources wor

262: and wjdi.load_type = wip_job_details.wip_resource
263: and wjdi.substitution_type = p_substitution_type
264: and wjdi.operation_seq_num = p_operation_seq_num
265: and exists (select 1
266: from wip_operation_resources wor
267: where wor.wip_entity_id = p_wip_entity_id
268: and wor.organization_id = p_organization_id
269: and wor.operation_seq_num = p_operation_seq_num
270: and wor.resource_seq_num = p_resource_seq_num

Line 757: from wip_operation_resources wor

753: and (wjdi.start_date is not null
754: or wjdi.completion_date is not null)
755: and exists
756: (select 1
757: from wip_operation_resources wor
758: where wor.wip_entity_id = wjdi.wip_entity_id
759: and wor.organization_id = wjdi.organization_id
760: and wor.operation_seq_num = wjdi.operation_seq_num
761: and wor.resource_seq_num = wjdi.resource_seq_num

Line 803: from wip_operation_resources wor

799: and (wjdi.start_date is not null
800: or wjdi.completion_date is not null)
801: and exists
802: (select 1
803: from wip_operation_resources wor
804: where wor.wip_entity_id = wjdi.wip_entity_id
805: and wor.organization_id = wjdi.organization_id
806: and wor.operation_seq_num = wjdi.operation_seq_num
807: and wor.resource_seq_num = wjdi.resource_seq_num

Line 940: from wip_operation_resources wor

936: and wjdi.operation_seq_num = p_operation_seq_num
937: and wjdi.resource_seq_num = p_resource_seq_num
938: and ( resource_seq_num <= 0
939: or exists (select 1
940: from wip_operation_resources wor
941: where wor.wip_entity_id = wjdi.wip_entity_id
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)

Line 995: from wip_operation_resources wor

991: and wjdi.operation_seq_num = p_operation_seq_num
992: and wjdi.resource_seq_num = p_resource_seq_num
993: and ( resource_seq_num <= 0
994: or exists (select 1
995: from wip_operation_resources wor
996: where wor.wip_entity_id = wjdi.wip_entity_id
997: and wor.organization_id = wjdi.organization_id
998: and wor.operation_seq_num = wjdi.operation_seq_num
999: and wor.resource_seq_num = wjdi.resource_seq_num)

Line 1197: from wip_operation_resources

1193: if (p_substitution_type = wip_job_details.wip_change) then
1194: if (p_load_type = WIP_JOB_DETAILS.WIP_RESOURCE) then
1195: select maximum_assigned_units
1196: into l_maximum_assigned_units
1197: from wip_operation_resources
1198: where wip_entity_id = p_wip_entity_id
1199: and organization_id = p_organization_id
1200: and operation_seq_num = p_operation_seq_num
1201: and resource_seq_num = p_resource_seq_num;

Line 1284: from wip_operation_resources

1280: if (p_resource_seq_num is null) then
1281: begin
1282: select nvl(max(resource_seq_num), 0)
1283: into x_res_seq_num_max
1284: from wip_operation_resources
1285: where wip_entity_id = p_wip_entity_id
1286: AND organization_id = p_organization_id
1287: AND operation_seq_num = p_operation_seq_num;
1288: exception

Line 1343: from wip_operation_resources

1339: if (x_schedule_seq_num = 0) then
1340: begin
1341: select schedule_seq_num
1342: into x_schedule_seq_num
1343: from wip_operation_resources
1344: where wip_entity_id = p_wip_entity_id
1345: AND organization_id = p_organization_id
1346: AND operation_seq_num = p_operation_seq_num
1347: AND resource_seq_num = p_parent_seq_num;

Line 1363: from wip_operation_resources

1359: elsif (p_substitution_type = wip_job_details.WIP_CHANGE) then
1360: begin
1361: select setup_id
1362: into x_setup_id
1363: from wip_operation_resources
1364: where wip_entity_id = p_wip_entity_id
1365: AND organization_id = p_organization_id
1366: AND operation_seq_num = p_operation_seq_num
1367: AND resource_seq_num = p_resource_seq_num;

Line 1708: wip_operation_resources. The second is to substitute a

1704: END Chng_Res_Info_Exist;
1705:
1706: /* jy - Checks the validity of rows that change resources. There are two types of
1707: transactions. The first is to just change an existing resource in
1708: wip_operation_resources. The second is to substitute a
1709: resource in WOR with one in WSOR. To indicate a substitution:
1710: 1) The substitution_group_num column must be either null or have the valid
1711: value for that res_seq_num/id.
1712: 2) The replacement_group_num must be a valid value in WSOR (if it is the

Line 2128: from wip_operation_resources wor

2124: and wjdi.resource_seq_num = p_resource_seq_num
2125: and wjdi.resource_id_old = p_resource_id_old
2126: and ( ( wjdi.substitute_group_num is not null
2127: and not exists (select 1
2128: from wip_operation_resources wor
2129: where wor.wip_entity_id = wjdi.wip_entity_id
2130: and wor.organization_id = wjdi.organization_id
2131: and wor.resource_id = wjdi.resource_id_old
2132: and wor.operation_seq_num = wjdi.operation_seq_num

Line 2140: wip_operation_resources wor

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
2144: and wor.wip_entity_id = wjdi.wip_entity_id

Line 2153: from wip_operation_resources wor

2149: and wsor.substitute_group_num = nvl(wjdi.substitute_group_num, wor.substitute_group_num)
2150: and wsor.replacement_group_num = wjdi.replacement_group_num
2151: )
2152: and not exists (select 1
2153: from wip_operation_resources wor
2154: where wor.wip_entity_id = wjdi.wip_entity_id
2155: and wor.organization_id = wjdi.organization_id
2156: and wor.resource_id = wjdi.resource_id_old
2157: and wor.operation_seq_num = wjdi.operation_seq_num

Line 2187: from wip_operation_resources wor

2183: and wjdi.resource_id_old = p_resource_id_old
2184: and ( wjdi.replacement_group_num is null
2185: or ( wjdi.replacement_group_num is not null
2186: and exists (select 1
2187: from wip_operation_resources wor
2188: where wor.wip_entity_id = wjdi.wip_entity_id
2189: and wor.organization_id = wjdi.organization_id
2190: and wor.resource_id = wjdi.resource_id_old
2191: and wor.operation_seq_num = wjdi.operation_seq_num

Line 2263: from wip_operation_resources wor

2259: and wjdi.resource_seq_num = p_resource_seq_num
2260: and wjdi.resource_id_old = p_resource_id_old
2261: and ( ( wjdi.substitute_group_num is not null
2262: and not exists (select 1
2263: from wip_operation_resources wor
2264: where wor.wip_entity_id = wjdi.wip_entity_id
2265: and wor.organization_id = wjdi.organization_id
2266: and wor.resource_id = wjdi.resource_id_old
2267: and wor.operation_seq_num = wjdi.operation_seq_num

Line 2275: wip_operation_resources wor

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
2279: and wor.wip_entity_id = wjdi.wip_entity_id

Line 2303: from wip_operation_resources wor

2299: for l_sub_row in c_sub_rows loop
2300: if l_sub_row.substitute_group_num is null then
2301: select wor.substitute_group_num
2302: into l_sub_group_temp
2303: from wip_operation_resources wor
2304: where wor.wip_entity_id = l_sub_row.wip_entity_id
2305: and wor.organization_id = l_sub_row.organization_id
2306: and wor.resource_id = l_sub_row.resource_id_old
2307: and wor.operation_seq_num = l_sub_row.operation_seq_num

Line 2342: from wip_operation_resources wor

2338: or wjdi.substitute_group_num < 0
2339: or wjdi.replacement_group_num is null
2340: or wjdi.replacement_group_num < 0
2341: or not exists (select 1
2342: from wip_operation_resources wor
2343: where wor.wip_entity_id = wjdi.wip_entity_id
2344: and wor.organization_id = wjdi.organization_id
2345: and wor.operation_seq_num = wjdi.operation_seq_num
2346: and wor.substitute_group_num = wjdi.substitute_group_num)

Line 2348: from wip_operation_resources wor

2344: and wor.organization_id = wjdi.organization_id
2345: and wor.operation_seq_num = wjdi.operation_seq_num
2346: and wor.substitute_group_num = wjdi.substitute_group_num)
2347: or exists (select 1
2348: from wip_operation_resources wor
2349: where wor.wip_entity_id = wjdi.wip_entity_id
2350: and wor.organization_id = wjdi.organization_id
2351: and wor.operation_seq_num = wjdi.operation_seq_num
2352: and wor.substitute_group_num = wjdi.substitute_group_num

Line 2394: from wip_operation_resources wor

2390: or wjdi.substitute_group_num < 0
2391: or wjdi.replacement_group_num is null
2392: or wjdi.replacement_group_num < 0
2393: or not exists (select 1
2394: from wip_operation_resources wor
2395: where wor.wip_entity_id = wjdi.wip_entity_id
2396: and wor.organization_id = wjdi.organization_id
2397: and wor.operation_seq_num = wjdi.operation_seq_num
2398: and wor.substitute_group_num = wjdi.substitute_group_num)

Line 2400: from wip_operation_resources wor

2396: and wor.organization_id = wjdi.organization_id
2397: and wor.operation_seq_num = wjdi.operation_seq_num
2398: and wor.substitute_group_num = wjdi.substitute_group_num)
2399: or exists (select 1
2400: from wip_operation_resources wor
2401: where wor.wip_entity_id = wjdi.wip_entity_id
2402: and wor.organization_id = wjdi.organization_id
2403: and wor.operation_seq_num = wjdi.operation_seq_num
2404: and wor.substitute_group_num = wjdi.substitute_group_num

Line 2837: from wip_operation_resources

2833: if (sched_row.substitute_group_num is not null) then
2834: begin
2835: select distinct replacement_group_num
2836: into repl_group
2837: from wip_operation_resources
2838: where wip_entity_id = p_wip_entity_id
2839: and repetitive_schedule_id is null
2840: and operation_seq_num = p_operation_seq_num
2841: and substitute_group_num = sched_row.substitute_group_num;

Line 2862: from wip_operation_resources

2858: replacement_group_num
2859: into sched_seq,
2860: sub_group,
2861: repl_group
2862: from wip_operation_resources
2863: where wip_entity_id = p_wip_entity_id
2864: and repetitive_schedule_id is null
2865: and operation_seq_num = p_operation_seq_num
2866: and resource_seq_num = p_resource_seq_num;

Line 2903: from wip_operation_resources

2899: if (l_res_sub = 0) then
2900: begin
2901: select distinct replacement_group_num
2902: into repl_group
2903: from wip_operation_resources
2904: where wip_entity_id = p_wip_entity_id
2905: and repetitive_schedule_id is null
2906: and operation_seq_num = p_operation_seq_num
2907: and substitute_group_num = sched_row.substitute_group_num;