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_JOB_DTLS_SUBSTITUTIONS dependencies on WIP_DISCRETE_JOBS

Line 289: from wip_discrete_jobs

285:
286: /* bug#3669728 - begin */
287: select scheduled_start_date,scheduled_completion_date
288: into l_scheduled_start_date,l_scheduled_completion_date
289: from wip_discrete_jobs
290: where wip_entity_id = p_wip_entity_id
291: AND organization_id = p_organization_id;
292:
293: IF (cur_row.start_date is not null

Line 296: UPDATE wip_discrete_jobs

292:
293: IF (cur_row.start_date is not null
294: AND cur_row.start_date < l_scheduled_start_date)
295: THEN
296: UPDATE wip_discrete_jobs
297: set scheduled_start_date = cur_row.start_date
298: where wip_entity_id = p_wip_entity_id
299: AND organization_id = p_organization_id;
300: END IF;

Line 304: UPDATE wip_discrete_jobs

300: END IF;
301: IF (cur_row.completion_date is not null
302: AND cur_row.completion_date > l_scheduled_completion_date)
303: THEN
304: UPDATE wip_discrete_jobs
305: set scheduled_completion_date = cur_row.completion_date
306: where wip_entity_id = p_wip_entity_id
307: AND organization_id = p_organization_id;
308: END IF;

Line 597: from wip_discrete_jobs

593:
594: /* bug#3669728 - begin */
595: select scheduled_start_date,scheduled_completion_date
596: into l_scheduled_start_date,l_scheduled_completion_date
597: from wip_discrete_jobs
598: where wip_entity_id = p_wip_entity_id
599: AND organization_id = p_organization_id;
600:
601: IF (cur_row.start_date is not null

Line 604: UPDATE wip_discrete_jobs

600:
601: IF (cur_row.start_date is not null
602: AND cur_row.start_date < l_scheduled_start_date)
603: THEN
604: UPDATE wip_discrete_jobs
605: set scheduled_start_date = cur_row.start_date,
606: LAST_UPDATE_DATE=sysdate
607: where wip_entity_id = p_wip_entity_id
608: AND organization_id = p_organization_id;

Line 613: UPDATE wip_discrete_jobs

609: END IF;
610: IF (cur_row.completion_date is not null
611: AND cur_row.completion_date > l_scheduled_completion_date)
612: THEN
613: UPDATE wip_discrete_jobs
614: set scheduled_completion_date = cur_row.completion_date,
615: LAST_UPDATE_DATE=sysdate
616: where wip_entity_id = p_wip_entity_id
617: AND organization_id = p_organization_id;

Line 1767: FROM wip_discrete_jobs wdj,wip_job_schedule_interface we

1763:
1764: -- Bug 3484856 - select the status of job and load type from wjsi
1765: SELECT wdj.start_quantity, greatest(wdj.start_quantity - wdj.quantity_completed - wdj.quantity_scrapped, 0), wdj.status_type, we.load_type
1766: INTO l_scheduled_quantity, l_open_quantity,l_status_type, l_load_type
1767: FROM wip_discrete_jobs wdj,wip_job_schedule_interface we
1768: WHERE wdj.wip_entity_id = p_wip_entity_id
1769: AND wdj.organization_id = p_organization_id
1770: AND wdj.wip_entity_id = we.wip_entity_id (+)
1771: AND wdj.organization_id = we.organization_id (+)

Line 2137: from wip_discrete_jobs

2133: of job */
2134:
2135: select scheduled_start_date,scheduled_completion_date
2136: into l_scheduled_start_date,l_scheduled_completion_date
2137: from wip_discrete_jobs
2138: where wip_entity_id = p_wip_entity_id
2139: AND organization_id = p_organization_id;
2140:
2141: IF (cur_oper.first_unit_start_date is not null

Line 2144: UPDATE wip_discrete_jobs

2140:
2141: IF (cur_oper.first_unit_start_date is not null
2142: AND cur_oper.first_unit_start_date < l_scheduled_start_date)
2143: THEN
2144: UPDATE wip_discrete_jobs
2145: set scheduled_start_date = cur_oper.first_unit_start_date
2146: where wip_entity_id = p_wip_entity_id
2147: AND organization_id = p_organization_id;
2148: END IF;

Line 2152: UPDATE wip_discrete_jobs

2148: END IF;
2149: IF (cur_oper.last_unit_completion_date is not null
2150: AND cur_oper.last_unit_completion_date > l_scheduled_completion_date)
2151: THEN
2152: UPDATE wip_discrete_jobs
2153: set scheduled_completion_date = cur_oper.last_unit_completion_date
2154: where wip_entity_id = p_wip_entity_id
2155: AND organization_id = p_organization_id;
2156: END IF;

Line 2347: from wip_discrete_jobs

2343: /* Bug 3659006 -> modify the job start/end to allow operation FUSD/LUCD modification outsi
2344: de the start/end of job*/
2345: select scheduled_start_date,scheduled_completion_date
2346: into l_scheduled_start_date,l_scheduled_completion_date
2347: from wip_discrete_jobs
2348: where wip_entity_id = p_wip_entity_id
2349: AND organization_id = p_organization_id;
2350:
2351: IF (cur_oper.first_unit_start_date is not null

Line 2354: UPDATE wip_discrete_jobs

2350:
2351: IF (cur_oper.first_unit_start_date is not null
2352: AND cur_oper.first_unit_start_date < l_scheduled_start_date)
2353: THEN
2354: UPDATE wip_discrete_jobs
2355: set scheduled_start_date = cur_oper.first_unit_start_date
2356: where wip_entity_id = p_wip_entity_id
2357: AND organization_id = p_organization_id;
2358: END IF;

Line 2362: UPDATE wip_discrete_jobs

2358: END IF;
2359: IF (cur_oper.last_unit_completion_date is not null
2360: AND cur_oper.last_unit_completion_date > l_scheduled_completion_date)
2361: THEN
2362: UPDATE wip_discrete_jobs
2363: set scheduled_completion_date = cur_oper.last_unit_completion_date
2364: where wip_entity_id = p_wip_entity_id
2365: AND organization_id = p_organization_id;
2366: END IF;

Line 3171: FROM wip_discrete_jobs

3167: serialization_start_op
3168: INTO l_start_quantity,
3169: l_primary_item_id,
3170: l_serialization_start_op
3171: FROM wip_discrete_jobs
3172: WHERE wip_entity_id = p_wip_entity_id;
3173:
3174: --if the user did not provide enough serial numbers
3175: if(l_serialization_start_op is not null and