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 = p_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 236: update wip_job_dtls_interface wjdi

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

Line 274: update wip_job_dtls_interface wjdi

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

Line 311: update wip_job_dtls_interface wjdi

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

Line 357: FROM WIP_JOB_DTLS_INTERFACE

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

Line 418: from wip_job_dtls_interface wjdi

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

Line 450: update wip_job_dtls_interface wjdi

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

Line 478: from wip_job_dtls_interface wjdi

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

Line 498: from wip_job_dtls_interface wjdi2

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

Line 526: update wip_job_dtls_interface wjdi

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

Line 548: from wip_job_dtls_interface wjdi2

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

Line 570: from wip_job_dtls_interface wjdi

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

Line 589: from wip_job_dtls_interface wjdi, wip_job_schedule_interface wjsi

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

Line 610: from wip_job_dtls_interface wjdi, wip_job_schedule_interface wjsi

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

Line 629: from wip_job_dtls_interface wjdi, wip_job_schedule_interface wjsi

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

Line 650: from wip_job_dtls_interface wjdi

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

Line 756: update wip_job_dtls_interface wjdi

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

Line 796: from wip_job_dtls_interface wjdi /, wip_job_schedule_interface wjsi /

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

Line 840: update wip_job_dtls_interface wjdi

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

Line 855: FROM WIP_JOB_DTLS_INTERFACE

851: p_substitution_type in number) is
852:
853: CURSOR addsubinv_check IS
854: SELECT interface_id,inventory_item_id_new inventory_item_id,supply_subinventory,supply_locator_id,wip_supply_type
855: FROM WIP_JOB_DTLS_INTERFACE
856: WHERE group_id=p_group_id
857: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
858: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
859: AND wip_entity_id = p_wip_entity_id

Line 899: FROM WIP_JOB_DTLS_INTERFACE wjdi,WIP_REQUIREMENT_OPERATIONS wro

895: NULL,
896: wro.supply_locator_id,
897: wjdi.supply_locator_id)) supply_locator_id
898: ,NVL(WJDI.wip_supply_Type,wro.wip_supply_type) wip_supply_type
899: FROM WIP_JOB_DTLS_INTERFACE wjdi,WIP_REQUIREMENT_OPERATIONS wro
900: WHERE group_id=p_group_id
901: AND wjdi.process_phase = WIP_CONSTANTS.ML_VALIDATION
902: AND wjdi.process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
903: AND wjdi.wip_entity_id = p_wip_entity_id

Line 1053: update wip_job_dtls_interface wjdi

1049: fnd_message.set_token('SUBINV', error_tbl(indx).supply_subinventory);
1050: wip_interface_err_Utils.add_error(p_interface_id => error_tbl(indx).interface_id,
1051: p_text => substr(fnd_message.get,1,500),
1052: p_error_type => wip_jdi_utils.msg_error);
1053: update wip_job_dtls_interface wjdi
1054: set process_status = wip_constants.error
1055: where interface_id = error_tbl(indx).interface_id;
1056:
1057: end loop;

Line 1096: FROM WIP_JOB_DTLS_INTERFACE

1092: mps_date_required, attribute_category, attribute1,
1093: attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,
1094: attribute8,attribute9,attribute10,attribute11,attribute12,
1095: attribute13,attribute14,attribute15
1096: FROM WIP_JOB_DTLS_INTERFACE
1097: WHERE group_id = p_group_id
1098: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
1099: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
1100: AND wip_entity_id = p_wip_entity_id

Line 1213: from wip_job_dtls_interface wjdi

1209: p_operation_seq_num number,
1210: p_inventory_item_id_new number) IS
1211: cursor c_invalid_rows is
1212: select interface_id
1213: from wip_job_dtls_interface wjdi
1214: where wjdi.group_id = p_group_id
1215: and wjdi.process_phase = wip_constants.ml_validation
1216: and wjdi.process_status in (wip_constants.running,
1217: wip_constants.warning)

Line 1248: update wip_job_dtls_interface wjdi

1244: end if;
1245: end loop;
1246:
1247: if(l_error_exists) then
1248: update wip_job_dtls_interface wjdi
1249: set process_status = wip_constants.error
1250: where group_id = p_group_id
1251: and process_phase = wip_constants.ml_validation
1252: and process_status in (wip_constants.running,

Line 1273: from wip_job_dtls_interface wjdi

1269: p_substitution_type number,
1270: p_operation_seq_num number) IS
1271: cursor c_invalid_rows is
1272: select interface_id
1273: from wip_job_dtls_interface wjdi
1274: where wjdi.group_id = p_group_id
1275: and wjdi.process_phase = wip_constants.ml_validation
1276: and wjdi.process_status in (wip_constants.running,
1277: wip_constants.warning)

Line 1325: update wip_job_dtls_interface wjdi

1321: end if;
1322: end loop;
1323:
1324: if(l_error_exists) then
1325: update wip_job_dtls_interface wjdi
1326: set process_status = wip_constants.error
1327: where group_id = p_group_id
1328: and process_phase = wip_constants.ml_validation
1329: and process_status in (wip_constants.running,

Line 1469: UPDATE WIP_JOB_DTLS_INTERFACE

1465:
1466: end if;
1467:
1468: if (x_required_quantity is not null) then
1469: UPDATE WIP_JOB_DTLS_INTERFACE
1470: SET quantity_per_assembly = nvl(X_quantity_per_assembly, quantity_per_assembly),
1471: required_quantity = x_required_quantity,
1472: mps_required_quantity = nvl(x_mps_required_quantity,mps_required_quantity),
1473: component_yield_factor = nvl(x_component_yield_factor,component_yield_factor)

Line 1518: FROM WIP_JOB_DTLS_INTERFACE

1514: mps_date_required, attribute_category, attribute1,
1515: attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,
1516: attribute8,attribute9,attribute10,attribute11,attribute12,
1517: attribute13,attribute14,attribute15
1518: FROM WIP_JOB_DTLS_INTERFACE
1519: WHERE group_id = p_group_id
1520: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
1521: AND process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
1522: AND wip_entity_id = p_wip_entity_id

Line 1699: FROM WIP_JOB_DTLS_INTERFACE

1695:
1696: IF p_substitution_type = WIP_JOB_DETAILS.WIP_DELETE THEN
1697: SELECT count(*)
1698: INTO x_count
1699: FROM WIP_JOB_DTLS_INTERFACE
1700: WHERE group_id = p_group_id
1701: AND process_status = WIP_CONSTANTS.ERROR
1702: AND wip_entity_id = p_wip_entity_id
1703: AND organization_id = p_organization_id

Line 1712: FROM WIP_JOB_DTLS_INTERFACE

1708:
1709: ELSIF p_substitution_type = WIP_JOB_DETAILS.WIP_ADD THEN
1710: SELECT count(*)
1711: INTO x_count
1712: FROM WIP_JOB_DTLS_INTERFACE
1713: WHERE group_id = p_group_id
1714: AND process_status = WIP_CONSTANTS.ERROR
1715: AND wip_entity_id = p_wip_entity_id
1716: AND organization_id = p_organization_id

Line 1725: FROM WIP_JOB_DTLS_INTERFACE

1721:
1722: ELSIF p_substitution_type = WIP_JOB_DETAILS.WIP_CHANGE THEN
1723: SELECT count(*)
1724: INTO x_count
1725: FROM WIP_JOB_DTLS_INTERFACE
1726: WHERE group_id = p_group_id
1727: AND process_status = WIP_CONSTANTS.ERROR
1728: AND wip_entity_id = p_wip_entity_id
1729: AND organization_id = p_organization_id

Line 1759: FROM WIP_JOB_DTLS_INTERFACE

1755:
1756: IF p_substitution_type = WIP_JOB_DETAILS.WIP_DELETE THEN
1757: SELECT count(*)
1758: INTO x_count
1759: FROM WIP_JOB_DTLS_INTERFACE
1760: WHERE group_id = p_group_id
1761: AND process_status = WIP_CONSTANTS.ERROR
1762: AND wip_entity_id = p_wip_entity_id
1763: AND organization_id = p_organization_id

Line 1772: FROM WIP_JOB_DTLS_INTERFACE

1768:
1769: ELSIF p_substitution_type = WIP_JOB_DETAILS.WIP_ADD THEN
1770: SELECT count(*)
1771: INTO x_count
1772: FROM WIP_JOB_DTLS_INTERFACE
1773: WHERE group_id = p_group_id
1774: AND process_status = WIP_CONSTANTS.ERROR
1775: AND wip_entity_id = p_wip_entity_id
1776: AND organization_id = p_organization_id

Line 1786: FROM WIP_JOB_DTLS_INTERFACE

1782:
1783: ELSIF p_substitution_type = WIP_JOB_DETAILS.WIP_CHANGE THEN
1784: SELECT count(*)
1785: INTO x_count
1786: FROM WIP_JOB_DTLS_INTERFACE
1787: WHERE group_id = p_group_id
1788: AND process_status = WIP_CONSTANTS.ERROR
1789: AND wip_entity_id = p_wip_entity_id
1790: AND organization_id = p_organization_id