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 593: from wip_discrete_jobs

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

Line 600: UPDATE wip_discrete_jobs

596:
597: IF (cur_row.start_date is not null
598: AND cur_row.start_date < l_scheduled_start_date)
599: THEN
600: UPDATE wip_discrete_jobs
601: set scheduled_start_date = cur_row.start_date
602: where wip_entity_id = p_wip_entity_id
603: AND organization_id = p_organization_id;
604: END IF;

Line 608: UPDATE wip_discrete_jobs

604: END IF;
605: IF (cur_row.completion_date is not null
606: AND cur_row.completion_date > l_scheduled_completion_date)
607: THEN
608: UPDATE wip_discrete_jobs
609: set scheduled_completion_date = cur_row.completion_date
610: where wip_entity_id = p_wip_entity_id
611: AND organization_id = p_organization_id;
612: END IF;

Line 1741: FROM wip_discrete_jobs wdj,wip_job_schedule_interface we

1737:
1738: -- Bug 3484856 - select the status of job and load type from wjsi
1739: SELECT wdj.start_quantity, greatest(wdj.start_quantity - wdj.quantity_completed - wdj.quantity_scrapped, 0), wdj.status_type, we.load_type
1740: INTO l_scheduled_quantity, l_open_quantity,l_status_type, l_load_type
1741: FROM wip_discrete_jobs wdj,wip_job_schedule_interface we
1742: WHERE wdj.wip_entity_id = p_wip_entity_id
1743: AND wdj.organization_id = p_organization_id
1744: AND wdj.wip_entity_id = we.wip_entity_id (+)
1745: AND wdj.organization_id = we.organization_id (+)

Line 2019: from wip_discrete_jobs

2015: of job */
2016:
2017: select scheduled_start_date,scheduled_completion_date
2018: into l_scheduled_start_date,l_scheduled_completion_date
2019: from wip_discrete_jobs
2020: where wip_entity_id = p_wip_entity_id
2021: AND organization_id = p_organization_id;
2022:
2023: IF (cur_oper.first_unit_start_date is not null

Line 2026: UPDATE wip_discrete_jobs

2022:
2023: IF (cur_oper.first_unit_start_date is not null
2024: AND cur_oper.first_unit_start_date < l_scheduled_start_date)
2025: THEN
2026: UPDATE wip_discrete_jobs
2027: set scheduled_start_date = cur_oper.first_unit_start_date
2028: where wip_entity_id = p_wip_entity_id
2029: AND organization_id = p_organization_id;
2030: END IF;

Line 2034: UPDATE wip_discrete_jobs

2030: END IF;
2031: IF (cur_oper.last_unit_completion_date is not null
2032: AND cur_oper.last_unit_completion_date > l_scheduled_completion_date)
2033: THEN
2034: UPDATE wip_discrete_jobs
2035: set scheduled_completion_date = cur_oper.last_unit_completion_date
2036: where wip_entity_id = p_wip_entity_id
2037: AND organization_id = p_organization_id;
2038: END IF;

Line 2224: from wip_discrete_jobs

2220: /* Bug 3659006 -> modify the job start/end to allow operation FUSD/LUCD modification outsi
2221: de the start/end of job*/
2222: select scheduled_start_date,scheduled_completion_date
2223: into l_scheduled_start_date,l_scheduled_completion_date
2224: from wip_discrete_jobs
2225: where wip_entity_id = p_wip_entity_id
2226: AND organization_id = p_organization_id;
2227:
2228: IF (cur_oper.first_unit_start_date is not null

Line 2231: UPDATE wip_discrete_jobs

2227:
2228: IF (cur_oper.first_unit_start_date is not null
2229: AND cur_oper.first_unit_start_date < l_scheduled_start_date)
2230: THEN
2231: UPDATE wip_discrete_jobs
2232: set scheduled_start_date = cur_oper.first_unit_start_date
2233: where wip_entity_id = p_wip_entity_id
2234: AND organization_id = p_organization_id;
2235: END IF;

Line 2239: UPDATE wip_discrete_jobs

2235: END IF;
2236: IF (cur_oper.last_unit_completion_date is not null
2237: AND cur_oper.last_unit_completion_date > l_scheduled_completion_date)
2238: THEN
2239: UPDATE wip_discrete_jobs
2240: set scheduled_completion_date = cur_oper.last_unit_completion_date
2241: where wip_entity_id = p_wip_entity_id
2242: AND organization_id = p_organization_id;
2243: END IF;

Line 3044: FROM wip_discrete_jobs

3040: serialization_start_op
3041: INTO l_start_quantity,
3042: l_primary_item_id,
3043: l_serialization_start_op
3044: FROM wip_discrete_jobs
3045: WHERE wip_entity_id = p_wip_entity_id;
3046:
3047: --if the user did not provide enough serial numbers
3048: if(l_serialization_start_op is not null and