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_REQUIREMENT_VALIDATIONS dependencies on WIP_JOB_DTLS_INTERFACE

Line 13: from wip_job_dtls_interface wjdi

9: p_operation_seq_num in number) IS
10:
11: cursor c_invalid_rows is
12: select interface_id
13: from wip_job_dtls_interface wjdi
14: where wjdi.group_id = p_group_id
15: and wjdi.process_phase = wip_constants.ml_validation
16: and wjdi.process_status in (wip_constants.running,
17: wip_constants.warning)

Line 44: update wip_job_dtls_interface wjdi

40: end if;
41: end loop;
42:
43: if(l_error_exists) then
44: update wip_job_dtls_interface wjdi
45: set process_status = wip_constants.error
46: where group_id = p_group_id
47: and process_phase = wip_constants.ml_validation
48: and process_status in (wip_constants.running,

Line 76: from wip_job_dtls_interface wjdi,

72: wjdi.wip_entity_id,
73: wjdi.operation_seq_num,
74: msik.concatenated_segments item_name,
75: wjdi.inventory_item_id_old
76: from wip_job_dtls_interface wjdi,
77: wip_entities we,
78: mtl_system_items_kfv msik
79: where wjdi.group_id = p_group_id
80: and wjdi.process_phase = wip_constants.ml_validation

Line 124: update wip_job_dtls_interface wjdi

120: end if;
121: end loop;
122:
123: if(l_error_exists) then
124: update wip_job_dtls_interface wjdi
125: set process_status = wip_constants.error
126: where group_id = p_group_id
127: and process_phase = wip_constants.ml_validation
128: and process_status in (wip_constants.running,

Line 158: from wip_job_dtls_interface wjdi

154: x_exist number := 0;
155:
156: cursor c_invalid_wro_rows is
157: select interface_id
158: from wip_job_dtls_interface wjdi
159: where wjdi.group_id = p_group_id
160: and wjdi.process_phase = wip_constants.ml_validation
161: and wjdi.process_status in (wip_constants.running,
162: wip_constants.warning)

Line 179: from wip_job_dtls_interface wjdi

175: and wro.quantity_issued <> 0);
176:
177: cursor c_invalid_mmtt_rows is
178: select interface_id
179: from wip_job_dtls_interface wjdi
180: where wjdi.group_id = p_group_id
181: and wjdi.process_phase = wip_constants.ml_validation
182: and wjdi.process_status in (wip_constants.running,
183: wip_constants.warning)

Line 199: from wip_job_dtls_interface wjdi

195: and mmtt.inventory_item_id = wjdi.inventory_item_id_old);
196:
197: cursor c_invalid_mmt_rows is
198: select interface_id
199: from wip_job_dtls_interface wjdi
200: where wjdi.group_id = p_group_id
201: and wjdi.process_phase = wip_constants.ml_validation
202: and wjdi.process_status in (wip_constants.running,
203: wip_constants.warning)

Line 238: update wip_job_dtls_interface wjdi

234: end if;
235: end loop;
236:
237: if(l_error_exists) then
238: update wip_job_dtls_interface wjdi
239: set process_status = wip_constants.error
240: where group_id = p_group_id
241: and process_phase = wip_constants.ml_validation
242: and process_status in (wip_constants.running,

Line 276: update wip_job_dtls_interface wjdi

272: end if;
273: end loop;
274:
275: if(l_error_exists) then
276: update wip_job_dtls_interface wjdi
277: set process_status = wip_constants.error
278: where group_id = p_group_id
279: and process_phase = wip_constants.ml_validation
280: and process_status in (wip_constants.running,

Line 313: update wip_job_dtls_interface wjdi

309: end if;
310: end loop;
311:
312: if(l_error_exists) then
313: update wip_job_dtls_interface wjdi
314: set process_status = wip_constants.error
315: where group_id = p_group_id
316: and process_phase = wip_constants.ml_validation
317: and process_status in (wip_constants.running,

Line 359: FROM WIP_JOB_DTLS_INTERFACE

355: mps_date_required, attribute_category, attribute1,
356: attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,
357: attribute8,attribute9,attribute10,attribute11,attribute12,
358: attribute13,attribute14,attribute15
359: FROM WIP_JOB_DTLS_INTERFACE
360: WHERE group_id = p_group_id
361: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
362: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
363: AND wip_entity_id = p_wip_entity_id

Line 420: from wip_job_dtls_interface wjdi

416: p_substitution_type in number,
417: p_operation_seq_num in number) IS
418: cursor c_invalid_rows is
419: select interface_id
420: from wip_job_dtls_interface wjdi
421: where wjdi.group_id = p_group_id
422: and wjdi.process_phase = wip_constants.ml_validation
423: and wjdi.process_status in (wip_constants.running,
424: wip_constants.warning)

Line 452: update wip_job_dtls_interface wjdi

448: end if;
449: end loop;
450:
451: if(l_error_exists) then
452: update wip_job_dtls_interface wjdi
453: set process_status = wip_constants.error
454: where group_id = p_group_id
455: and process_phase = wip_constants.ml_validation
456: and process_status in (wip_constants.running,

Line 480: from wip_job_dtls_interface wjdi

476: p_operation_seq_num in number,
477: p_inventory_item_id_new in number) IS
478: cursor c_invalid_rows is
479: select interface_id
480: from wip_job_dtls_interface wjdi
481: where wjdi.group_id = p_group_id
482: and wjdi.process_phase = wip_constants.ml_validation
483: and wjdi.process_status in (wip_constants.running,
484: wip_constants.warning)

Line 500: from wip_job_dtls_interface wjdi2

496: and wro.organization_id = wjdi.organization_id
497: and wro.operation_seq_num = wjdi.operation_seq_num
498: and wro.inventory_item_id = wjdi.inventory_item_id_new)
499: or exists (select 1
500: from wip_job_dtls_interface wjdi2
501: where wjdi.interface_id <> wjdi2.interface_id
502: and wjdi.group_id = wjdi2.group_id
503: and wjdi.wip_entity_id = wjdi2.wip_entity_id
504: and wjdi.organization_id = wjdi2.organization_id

Line 528: update wip_job_dtls_interface wjdi

524: end if;
525: end loop;
526:
527: if(l_error_exists) then
528: update wip_job_dtls_interface wjdi
529: set process_status = wip_constants.error
530: where group_id = p_group_id
531: and process_phase = wip_constants.ml_validation
532: and process_status in (wip_constants.running,

Line 550: from wip_job_dtls_interface wjdi2

546: and wro.organization_id = wjdi.organization_id
547: and wro.operation_seq_num = wjdi.operation_seq_num
548: and wro.inventory_item_id = wjdi.inventory_item_id_new)
549: or exists (select 1
550: from wip_job_dtls_interface wjdi2
551: where wjdi.interface_id <> wjdi2.interface_id
552: and wjdi.group_id = wjdi2.group_id
553: and wjdi.wip_entity_id = wjdi2.wip_entity_id
554: and wjdi.organization_id = wjdi2.organization_id

Line 572: from wip_job_dtls_interface wjdi

568: p_operation_seq_num in number,
569: p_inventory_item_id_new in number) IS
570: cursor c_invalid_rows is
571: select interface_id
572: from wip_job_dtls_interface wjdi
573: where wjdi.group_id = p_group_id
574: and wjdi.process_phase = wip_constants.ml_validation
575: and wjdi.process_status in (wip_constants.running,
576: wip_constants.warning)

Line 591: from wip_job_dtls_interface wjdi, wip_job_schedule_interface wjsi

587:
588: /* bug#2811687 : begin */
589: cursor c_supply_types_invalid_rows is
590: select wjdi.interface_id
591: from wip_job_dtls_interface wjdi, wip_job_schedule_interface wjsi
592: where wjdi.group_id = p_group_id
593: and wjdi.process_phase = wip_constants.ml_validation
594: and wjdi.process_status in (wip_constants.running,
595: wip_constants.warning)

Line 612: from wip_job_dtls_interface wjdi, wip_job_schedule_interface wjsi

608: and wjdi.wip_supply_type <> wip_constants.push));
609:
610: cursor c_mrp_net_flag_invalid_rows is
611: select wjdi.interface_id
612: from wip_job_dtls_interface wjdi, wip_job_schedule_interface wjsi
613: where wjdi.group_id = p_group_id
614: and wjdi.process_phase = wip_constants.ml_validation
615: and wjdi.process_status in (wip_constants.running,
616: wip_constants.warning)

Line 631: from wip_job_dtls_interface wjdi, wip_job_schedule_interface wjsi

627: and (wjdi.mrp_net_flag not in (wip_constants.yes, wip_constants.no));
628:
629: cursor c_auto_req_mat_invalid_rows is
630: select wjdi.interface_id
631: from wip_job_dtls_interface wjdi, wip_job_schedule_interface wjsi
632: where wjdi.group_id = p_group_id
633: and wjdi.process_phase = wip_constants.ml_validation
634: and wjdi.process_status in (wip_constants.running,
635: wip_constants.warning)

Line 652: from wip_job_dtls_interface wjdi

648:
649: /* bug 3112793 */
650: cursor c_direct_item_rows(p_profile_value IN number) is
651: select interface_id
652: from wip_job_dtls_interface wjdi
653: where wjdi.group_id=p_group_id
654: and wjdi.process_phase = wip_constants.ml_validation
655: and wjdi.process_status in ( wip_constants.running,
656: wip_constants.warning )

Line 758: update wip_job_dtls_interface wjdi

754: end if ;
755: end loop;
756:
757: if(l_error_exists) then
758: update wip_job_dtls_interface wjdi
759: set process_status = wip_constants.error
760: where group_id = p_group_id
761: and process_phase = wip_constants.ml_validation
762: and process_status in (wip_constants.running,

Line 798: from wip_job_dtls_interface wjdi /, wip_job_schedule_interface wjsi /

794: only if there is a parent record in wip_job_schedule_interface for the same job.
795: */
796: cursor c_supply_types_invalid_rows is
797: select wjdi.interface_id
798: from wip_job_dtls_interface wjdi /*, wip_job_schedule_interface wjsi */
799: where wjdi.group_id = p_group_id
800: and wjdi.process_phase = wip_constants.ml_validation
801: and wjdi.process_status in (wip_constants.running,
802: wip_constants.warning)

Line 842: update wip_job_dtls_interface wjdi

838: p_text => substr(fnd_message.get,1,500),
839: p_error_type => wip_jdi_utils.msg_error);
840: end if;
841:
842: update wip_job_dtls_interface wjdi
843: set process_status = wip_constants.error
844: where interface_id = l_inv_row.interface_id;
845: end loop;
846:

Line 879: FROM WIP_JOB_DTLS_INTERFACE

875: mps_date_required, attribute_category, attribute1,
876: attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,
877: attribute8,attribute9,attribute10,attribute11,attribute12,
878: attribute13,attribute14,attribute15
879: FROM WIP_JOB_DTLS_INTERFACE
880: WHERE group_id = p_group_id
881: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
882: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
883: AND wip_entity_id = p_wip_entity_id

Line 991: from wip_job_dtls_interface wjdi

987: p_operation_seq_num number,
988: p_inventory_item_id_new number) IS
989: cursor c_invalid_rows is
990: select interface_id
991: from wip_job_dtls_interface wjdi
992: where wjdi.group_id = p_group_id
993: and wjdi.process_phase = wip_constants.ml_validation
994: and wjdi.process_status in (wip_constants.running,
995: wip_constants.warning)

Line 1026: update wip_job_dtls_interface wjdi

1022: end if;
1023: end loop;
1024:
1025: if(l_error_exists) then
1026: update wip_job_dtls_interface wjdi
1027: set process_status = wip_constants.error
1028: where group_id = p_group_id
1029: and process_phase = wip_constants.ml_validation
1030: and process_status in (wip_constants.running,

Line 1051: from wip_job_dtls_interface wjdi

1047: p_substitution_type number,
1048: p_operation_seq_num number) IS
1049: cursor c_invalid_rows is
1050: select interface_id
1051: from wip_job_dtls_interface wjdi
1052: where wjdi.group_id = p_group_id
1053: and wjdi.process_phase = wip_constants.ml_validation
1054: and wjdi.process_status in (wip_constants.running,
1055: wip_constants.warning)

Line 1103: update wip_job_dtls_interface wjdi

1099: end if;
1100: end loop;
1101:
1102: if(l_error_exists) then
1103: update wip_job_dtls_interface wjdi
1104: set process_status = wip_constants.error
1105: where group_id = p_group_id
1106: and process_phase = wip_constants.ml_validation
1107: and process_status in (wip_constants.running,

Line 1246: UPDATE WIP_JOB_DTLS_INTERFACE

1242:
1243: end if;
1244:
1245: if (x_required_quantity is not null) then
1246: UPDATE WIP_JOB_DTLS_INTERFACE
1247: SET quantity_per_assembly = nvl(X_quantity_per_assembly, quantity_per_assembly),
1248: required_quantity = x_required_quantity,
1249: mps_required_quantity = nvl(x_mps_required_quantity,mps_required_quantity),
1250: component_yield_factor = nvl(x_component_yield_factor,component_yield_factor)

Line 1295: FROM WIP_JOB_DTLS_INTERFACE

1291: mps_date_required, attribute_category, attribute1,
1292: attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,
1293: attribute8,attribute9,attribute10,attribute11,attribute12,
1294: attribute13,attribute14,attribute15
1295: FROM WIP_JOB_DTLS_INTERFACE
1296: WHERE group_id = p_group_id
1297: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
1298: AND process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
1299: AND wip_entity_id = p_wip_entity_id

Line 1464: FROM WIP_JOB_DTLS_INTERFACE

1460:
1461: IF p_substitution_type = WIP_JOB_DETAILS.WIP_DELETE THEN
1462: SELECT count(*)
1463: INTO x_count
1464: FROM WIP_JOB_DTLS_INTERFACE
1465: WHERE group_id = p_group_id
1466: AND process_status = WIP_CONSTANTS.ERROR
1467: AND wip_entity_id = p_wip_entity_id
1468: AND organization_id = p_organization_id

Line 1477: FROM WIP_JOB_DTLS_INTERFACE

1473:
1474: ELSIF p_substitution_type = WIP_JOB_DETAILS.WIP_ADD THEN
1475: SELECT count(*)
1476: INTO x_count
1477: FROM WIP_JOB_DTLS_INTERFACE
1478: WHERE group_id = p_group_id
1479: AND process_status = WIP_CONSTANTS.ERROR
1480: AND wip_entity_id = p_wip_entity_id
1481: AND organization_id = p_organization_id

Line 1490: FROM WIP_JOB_DTLS_INTERFACE

1486:
1487: ELSIF p_substitution_type = WIP_JOB_DETAILS.WIP_CHANGE THEN
1488: SELECT count(*)
1489: INTO x_count
1490: FROM WIP_JOB_DTLS_INTERFACE
1491: WHERE group_id = p_group_id
1492: AND process_status = WIP_CONSTANTS.ERROR
1493: AND wip_entity_id = p_wip_entity_id
1494: AND organization_id = p_organization_id

Line 1524: FROM WIP_JOB_DTLS_INTERFACE

1520:
1521: IF p_substitution_type = WIP_JOB_DETAILS.WIP_DELETE THEN
1522: SELECT count(*)
1523: INTO x_count
1524: FROM WIP_JOB_DTLS_INTERFACE
1525: WHERE group_id = p_group_id
1526: AND process_status = WIP_CONSTANTS.ERROR
1527: AND wip_entity_id = p_wip_entity_id
1528: AND organization_id = p_organization_id

Line 1537: FROM WIP_JOB_DTLS_INTERFACE

1533:
1534: ELSIF p_substitution_type = WIP_JOB_DETAILS.WIP_ADD THEN
1535: SELECT count(*)
1536: INTO x_count
1537: FROM WIP_JOB_DTLS_INTERFACE
1538: WHERE group_id = p_group_id
1539: AND process_status = WIP_CONSTANTS.ERROR
1540: AND wip_entity_id = p_wip_entity_id
1541: AND organization_id = p_organization_id

Line 1551: FROM WIP_JOB_DTLS_INTERFACE

1547:
1548: ELSIF p_substitution_type = WIP_JOB_DETAILS.WIP_CHANGE THEN
1549: SELECT count(*)
1550: INTO x_count
1551: FROM WIP_JOB_DTLS_INTERFACE
1552: WHERE group_id = p_group_id
1553: AND process_status = WIP_CONSTANTS.ERROR
1554: AND wip_entity_id = p_wip_entity_id
1555: AND organization_id = p_organization_id