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_DETAILS

Line 20: and wjdi.load_type = wip_job_details.wip_mtl_requirement

16: and wjdi.process_status in (wip_constants.running,
17: wip_constants.warning)
18: and wjdi.wip_entity_id = p_wip_entity_id
19: and wjdi.organization_id = p_organization_id
20: and wjdi.load_type = wip_job_details.wip_mtl_requirement
21: and wjdi.substitution_type = p_substitution_type
22: and wjdi.operation_seq_num = p_operation_seq_num
23: and wjdi.inventory_item_id_old is null;
24:

Line 32: if(wip_job_details.std_alone = 1) then

28: for l_inv_row in c_invalid_rows loop
29: l_error_exists := true;
30: fnd_message.set_name('WIP', 'WIP_JDI_DEL_REQ_INFO_MISSING');
31: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
32: if(wip_job_details.std_alone = 1) then
33: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
34: p_text => substr(fnd_message.get,1,500),
35: p_error_type => wip_jdi_utils.msg_error);
36: else

Line 52: and wjdi.load_type = wip_job_details.wip_mtl_requirement

48: and process_status in (wip_constants.running,
49: wip_constants.warning)
50: and wip_entity_id = p_wip_entity_id
51: and organization_id = p_organization_id
52: and wjdi.load_type = wip_job_details.wip_mtl_requirement
53: and wjdi.substitution_type = p_substitution_type
54: and wjdi.operation_seq_num = p_operation_seq_num
55: and wjdi.inventory_item_id_old is null;
56: end if;

Line 85: and wjdi.load_type = wip_job_details.wip_mtl_requirement

81: and wjdi.process_status in (wip_constants.running,
82: wip_constants.warning)
83: and wjdi.wip_entity_id = p_wip_entity_id
84: and wjdi.organization_id = p_organization_id
85: and wjdi.load_type = wip_job_details.wip_mtl_requirement
86: and wjdi.substitution_type = p_substitution_type
87: and wjdi.operation_seq_num = p_operation_seq_num
88: and wjdi.inventory_item_id_old = p_inventory_item_id_old
89: and wjdi.wip_entity_id = we.wip_entity_id

Line 112: if(wip_job_details.std_alone = 1) then

108: fnd_message.set_token('WEI', to_char(l_inv_row.wip_entity_id));
109: fnd_message.set_token('OPERATION', to_char(l_inv_row.operation_seq_num));
110: fnd_message.set_token('ITEM', l_inv_row.item_name);
111: fnd_message.set_token('ITEMID', to_char(l_inv_row.inventory_item_id_old));
112: if(wip_job_details.std_alone = 1) then
113: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
114: p_text => substr(fnd_message.get,1,500),
115: p_error_type => wip_jdi_utils.msg_error);
116: else

Line 132: and wjdi.load_type = wip_job_details.wip_mtl_requirement

128: and process_status in (wip_constants.running,
129: wip_constants.warning)
130: and wip_entity_id = p_wip_entity_id
131: and organization_id = p_organization_id
132: and wjdi.load_type = wip_job_details.wip_mtl_requirement
133: and wjdi.substitution_type = p_substitution_type
134: and wjdi.operation_seq_num = p_operation_seq_num
135: and wjdi.inventory_item_id_old = p_inventory_item_id_old
136: and not exists (select 1

Line 165: and wjdi.load_type = wip_job_details.wip_mtl_requirement

161: and wjdi.process_status in (wip_constants.running,
162: wip_constants.warning)
163: and wjdi.wip_entity_id = p_wip_entity_id
164: and wjdi.organization_id = p_organization_id
165: and wjdi.load_type = wip_job_details.wip_mtl_requirement
166: and wjdi.substitution_type = p_substitution_type
167: and wjdi.operation_seq_num = p_operation_seq_num
168: and wjdi.inventory_item_id_old = p_inventory_item_id_old
169: and exists (select 1

Line 186: and wjdi.load_type = wip_job_details.wip_mtl_requirement

182: and wjdi.process_status in (wip_constants.running,
183: wip_constants.warning)
184: and wjdi.wip_entity_id = p_wip_entity_id
185: and wjdi.organization_id = p_organization_id
186: and wjdi.load_type = wip_job_details.wip_mtl_requirement
187: and wjdi.substitution_type = p_substitution_type
188: and wjdi.operation_seq_num = p_operation_seq_num
189: and wjdi.inventory_item_id_old = p_inventory_item_id_old
190: and exists (select 1

Line 206: and wjdi.load_type = wip_job_details.wip_mtl_requirement

202: and wjdi.process_status in (wip_constants.running,
203: wip_constants.warning)
204: and wjdi.wip_entity_id = p_wip_entity_id
205: and wjdi.organization_id = p_organization_id
206: and wjdi.load_type = wip_job_details.wip_mtl_requirement
207: and wjdi.substitution_type = p_substitution_type
208: and wjdi.operation_seq_num = p_operation_seq_num
209: and wjdi.inventory_item_id_old = p_inventory_item_id_old
210: and exists (select 1

Line 226: if(wip_job_details.std_alone = 1) then

222: for l_inv_row in c_invalid_wro_rows loop
223: l_error_exists := true;
224: fnd_message.set_name('WIP', 'WIP_JDI_QTY_ISSUED');
225: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
226: if(wip_job_details.std_alone = 1) then
227: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
228: p_text => substr(fnd_message.get,1,500),
229: p_error_type => wip_jdi_utils.msg_error);
230: else

Line 246: and wjdi.load_type = wip_job_details.wip_mtl_requirement

242: and process_status in (wip_constants.running,
243: wip_constants.warning)
244: and wip_entity_id = p_wip_entity_id
245: and organization_id = p_organization_id
246: and wjdi.load_type = wip_job_details.wip_mtl_requirement
247: and wjdi.substitution_type = p_substitution_type
248: and wjdi.operation_seq_num = p_operation_seq_num
249: and wjdi.inventory_item_id_old = p_inventory_item_id_old
250: and exists (select 1

Line 264: if(wip_job_details.std_alone = 1) then

260: for l_inv_row in c_invalid_mmtt_rows loop
261: l_error_exists := true;
262: fnd_message.set_name('WIP', 'WIP_JDI_REQ_JOB_PENDING');
263: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
264: if(wip_job_details.std_alone = 1) then
265: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
266: p_text => substr(fnd_message.get,1,500),
267: p_error_type => wip_jdi_utils.msg_error);
268: else

Line 284: and wjdi.load_type = wip_job_details.wip_mtl_requirement

280: and process_status in (wip_constants.running,
281: wip_constants.warning)
282: and wip_entity_id = p_wip_entity_id
283: and organization_id = p_organization_id
284: and wjdi.load_type = wip_job_details.wip_mtl_requirement
285: and wjdi.substitution_type = p_substitution_type
286: and wjdi.operation_seq_num = p_operation_seq_num
287: and wjdi.inventory_item_id_old = p_inventory_item_id_old
288: and exists (select 1

Line 301: if(wip_job_details.std_alone = 1) then

297: for l_inv_row in c_invalid_mmt_rows loop
298: l_error_exists := true;
299: fnd_message.set_name('WIP', 'WIP_JDI_REQ_JOB_PENDING');
300: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
301: if(wip_job_details.std_alone = 1) then
302: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
303: p_text => substr(fnd_message.get,1,500),
304: p_error_type => wip_jdi_utils.msg_error);
305: else

Line 321: and wjdi.load_type = wip_job_details.wip_mtl_requirement

317: and process_status in (wip_constants.running,
318: wip_constants.warning)
319: and wip_entity_id = p_wip_entity_id
320: and organization_id = p_organization_id
321: and wjdi.load_type = wip_job_details.wip_mtl_requirement
322: and wjdi.substitution_type = p_substitution_type
323: and wjdi.operation_seq_num = p_operation_seq_num
324: and wjdi.inventory_item_id_old = p_inventory_item_id_old
325: and exists (select 1

Line 365: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT

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
364: AND organization_id = p_organization_id
365: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
366: AND substitution_type = p_substitution_type;
367:
368: BEGIN
369: FOR cur_row IN req_info(p_group_id,

Line 427: and wjdi.load_type = wip_job_details.wip_mtl_requirement

423: and wjdi.process_status in (wip_constants.running,
424: wip_constants.warning)
425: and wjdi.wip_entity_id = p_wip_entity_id
426: and wjdi.organization_id = p_organization_id
427: and wjdi.load_type = wip_job_details.wip_mtl_requirement
428: and wjdi.substitution_type = p_substitution_type
429: and wjdi.operation_seq_num = p_operation_seq_num
430: and ( wjdi.inventory_item_id_new is null
431: or wjdi.quantity_per_assembly is null);

Line 440: if(wip_job_details.std_alone = 1) then

436: for l_inv_row in c_invalid_rows loop
437: l_error_exists := true;
438: fnd_message.set_name('WIP', 'WIP_JDI_ADD_REQ_INFO_MISSING');
439: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
440: if(wip_job_details.std_alone = 1) then
441: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
442: p_text => substr(fnd_message.get,1,500),
443: p_error_type => wip_jdi_utils.msg_error);
444: else

Line 460: and wjdi.load_type = wip_job_details.wip_mtl_requirement

456: and process_status in (wip_constants.running,
457: wip_constants.warning)
458: and wip_entity_id = p_wip_entity_id
459: and organization_id = p_organization_id
460: and wjdi.load_type = wip_job_details.wip_mtl_requirement
461: and wjdi.substitution_type = p_substitution_type
462: and wjdi.operation_seq_num = p_operation_seq_num
463: and ( wjdi.inventory_item_id_new is null
464: or wjdi.quantity_per_assembly is null);

Line 487: and wjdi.load_type = wip_job_details.wip_mtl_requirement

483: and wjdi.process_status in (wip_constants.running,
484: wip_constants.warning)
485: and wjdi.wip_entity_id = p_wip_entity_id
486: and wjdi.organization_id = p_organization_id
487: and wjdi.load_type = wip_job_details.wip_mtl_requirement
488: and wjdi.substitution_type = p_substitution_type
489: and wjdi.operation_seq_num = p_operation_seq_num
490: and wjdi.inventory_item_id_new = p_inventory_item_id_new
491: /* bug#2814045 */

Line 516: if(wip_job_details.std_alone = 1) then

512: for l_inv_row in c_invalid_rows loop
513: l_error_exists := true;
514: fnd_message.set_name('WIP', 'WIP_JDI_REQ_EXIST');
515: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
516: if(wip_job_details.std_alone = 1) then
517: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
518: p_text => substr(fnd_message.get,1,500),
519: p_error_type => wip_jdi_utils.msg_error);
520: else

Line 536: and wjdi.load_type = wip_job_details.wip_mtl_requirement

532: and process_status in (wip_constants.running,
533: wip_constants.warning)
534: and wip_entity_id = p_wip_entity_id
535: and organization_id = p_organization_id
536: and wjdi.load_type = wip_job_details.wip_mtl_requirement
537: and wjdi.substitution_type = p_substitution_type
538: and wjdi.operation_seq_num = p_operation_seq_num
539: and wjdi.inventory_item_id_new = p_inventory_item_id_new
540: /* Fix for Bug 5632150 */

Line 579: and wjdi.load_type = wip_job_details.wip_mtl_requirement

575: and wjdi.process_status in (wip_constants.running,
576: wip_constants.warning)
577: and wjdi.wip_entity_id = p_wip_entity_id
578: and wjdi.organization_id = p_organization_id
579: and wjdi.load_type = wip_job_details.wip_mtl_requirement
580: and wjdi.substitution_type = p_substitution_type
581: and wjdi.operation_seq_num = p_operation_seq_num
582: and wjdi.inventory_item_id_new = p_inventory_item_id_new
583: and not exists (select 1

Line 598: and wjdi.load_type = wip_job_details.wip_mtl_requirement

594: and wjdi.process_status in (wip_constants.running,
595: wip_constants.warning)
596: and wjdi.wip_entity_id = p_wip_entity_id
597: and wjdi.organization_id = p_organization_id
598: and wjdi.load_type = wip_job_details.wip_mtl_requirement
599: and wjdi.substitution_type = p_substitution_type
600: and wjdi.operation_seq_num = p_operation_seq_num
601: and wjdi.inventory_item_id_new = p_inventory_item_id_new
602: and wjdi.parent_header_id = wjsi.header_id

Line 619: and wjdi.load_type = wip_job_details.wip_mtl_requirement

615: and wjdi.process_status in (wip_constants.running,
616: wip_constants.warning)
617: and wjdi.wip_entity_id = p_wip_entity_id
618: and wjdi.organization_id = p_organization_id
619: and wjdi.load_type = wip_job_details.wip_mtl_requirement
620: and wjdi.substitution_type = p_substitution_type
621: and wjdi.operation_seq_num = p_operation_seq_num
622: and wjdi.inventory_item_id_new = p_inventory_item_id_new
623: and wjdi.parent_header_id = wjsi.header_id

Line 638: and wjdi.load_type = wip_job_details.wip_mtl_requirement

634: and wjdi.process_status in (wip_constants.running,
635: wip_constants.warning)
636: and wjdi.wip_entity_id = p_wip_entity_id
637: and wjdi.organization_id = p_organization_id
638: and wjdi.load_type = wip_job_details.wip_mtl_requirement
639: and wjdi.substitution_type = p_substitution_type
640: and wjdi.operation_seq_num = p_operation_seq_num
641: and wjdi.inventory_item_id_new = p_inventory_item_id_new
642: and wjdi.parent_header_id = wjsi.header_id

Line 659: and wjdi.load_type = wip_job_details.wip_mtl_requirement

655: and wjdi.process_status in ( wip_constants.running,
656: wip_constants.warning )
657: and wjdi.wip_entity_id = p_wip_entity_id
658: and wjdi.organization_id = p_organization_id
659: and wjdi.load_type = wip_job_details.wip_mtl_requirement
660: and wjdi.substitution_type = p_substitution_type
661: and wjdi.operation_seq_num = p_operation_seq_num
662: and wjdi.inventory_item_id_new = p_inventory_item_id_new
663: and NOT exists ( select 1 from mtl_system_items msi

Line 681: if(wip_job_details.std_alone = 1) then

677: for l_inv_row in c_invalid_rows loop
678: l_error_exists := true;
679: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_MTL_REQ');
680: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
681: if(wip_job_details.std_alone = 1) then
682: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
683: p_text => substr(fnd_message.get,1,500),
684: p_error_type => wip_jdi_utils.msg_error);
685: else

Line 697: if(wip_job_details.std_alone = 1) then

693: for l_inv_row in c_supply_types_invalid_rows loop
694: l_error_exists := true;
695: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_SUPPLY_TYPE');
696: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
697: if(wip_job_details.std_alone = 1) then
698: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
699: p_text => substr(fnd_message.get,1,500),
700: p_error_type => wip_jdi_utils.msg_error);
701: else

Line 712: if(wip_job_details.std_alone = 1) then

708: for l_inv_row in c_mrp_net_flag_invalid_rows loop
709: l_error_exists := true;
710: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_MRP_NET_FLAG');
711: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
712: if(wip_job_details.std_alone = 1) then
713: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
714: p_text => substr(fnd_message.get,1,500),
715: p_error_type => wip_jdi_utils.msg_error);
716: else

Line 727: if(wip_job_details.std_alone = 1) then

723: for l_inv_row in c_auto_req_mat_invalid_rows loop
724: l_error_exists := true;
725: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_AUTO_REQ_MAT');
726: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
727: if(wip_job_details.std_alone = 1) then
728: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
729: p_text => substr(fnd_message.get,1,500),
730: p_error_type => wip_jdi_utils.msg_error);
731: else

Line 744: if(wip_job_details.std_alone =1 ) then

740: for l_inv_row in c_direct_item_rows ( l_profile_value ) loop
741: l_error_exists := true ;
742: fnd_message.set_name('WIP','WIP_JDI_DIRECT_ITEM');
743: fnd_message.set_token('INTERFACE',to_char(l_inv_row.interface_id));
744: if(wip_job_details.std_alone =1 ) then
745: wip_interface_err_utils.add_error (
746: p_interface_id => l_inv_row.interface_id,
747: p_text => substr(fnd_message.get,1,500),
748: p_error_type => wip_jdi_utils.msg_error);

Line 766: and wjdi.load_type = wip_job_details.wip_mtl_requirement

762: and process_status in (wip_constants.running,
763: wip_constants.warning)
764: and wip_entity_id = p_wip_entity_id
765: and organization_id = p_organization_id
766: and wjdi.load_type = wip_job_details.wip_mtl_requirement
767: and wjdi.substitution_type = p_substitution_type
768: and wjdi.operation_seq_num = p_operation_seq_num
769: and wjdi.inventory_item_id_new = p_inventory_item_id_new;
770: /* bug#2811687

Line 805: and wjdi.load_type = wip_job_details.wip_mtl_requirement

801: and wjdi.process_status in (wip_constants.running,
802: wip_constants.warning)
803: and wjdi.wip_entity_id = p_wip_entity_id
804: and wjdi.organization_id = p_organization_id
805: and wjdi.load_type = wip_job_details.wip_mtl_requirement
806: and wjdi.substitution_type = p_substitution_type
807: and wjdi.operation_seq_num = p_operation_seq_num
808: and (wjdi.inventory_item_id_new = p_inventory_item_id_new
809: or p_inventory_item_id_new is null)

Line 815: WIP_JOB_DETAILS.STD_ALONE = 1)*/

811: or p_inventory_item_id_old is null)
812: and (p_inventory_item_id_old is not null or
813: p_inventory_item_id_new is not null)
814: /*and (wjdi.parent_header_id = p_parent_header_id or
815: WIP_JOB_DETAILS.STD_ALONE = 1)*/
816: /*and wjdi.organization_id = wjsi.organization_id
817: and wjdi.wip_entity_id = wjsi.wip_entity_id*/
818: and wjdi.wip_supply_type = wip_constants.op_pull
819: and not exists

Line 832: if(wip_job_details.std_alone = 1) then

828: for l_inv_row in c_supply_types_invalid_rows loop
829: l_error_exists := true;
830: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_SUP_TYPE_NO_OP');
831: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
832: if(wip_job_details.std_alone = 1) then
833: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
834: p_text => substr(fnd_message.get,1,500),
835: p_error_type => wip_jdi_utils.msg_error);
836: else

Line 885: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT

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
884: AND organization_id = p_organization_id
885: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
886: AND substitution_type = p_substitution_type;
887:
888: BEGIN
889: FOR cur_row IN req_info(p_group_id,

Line 998: and wjdi.load_type = wip_job_details.wip_mtl_requirement

994: and wjdi.process_status in (wip_constants.running,
995: wip_constants.warning)
996: and wjdi.wip_entity_id = p_wip_entity_id
997: and wjdi.organization_id = p_organization_id
998: and wjdi.load_type = wip_job_details.wip_mtl_requirement
999: and wjdi.substitution_type = p_substitution_type
1000: and wjdi.operation_seq_num = p_operation_seq_num
1001: and wjdi.inventory_item_id_new = p_inventory_item_id_new
1002: and wjdi.wip_supply_type is null;

Line 1014: if(wip_job_details.std_alone = 1) then

1010: for l_inv_row in c_invalid_rows loop
1011: l_error_exists := true;
1012: fnd_message.set_name('WIP', 'WIP_JDI_NULL_SUPPLY_TYPE');
1013: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
1014: if(wip_job_details.std_alone = 1) then
1015: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
1016: p_text => substr(fnd_message.get,1,500),
1017: p_error_type => wip_jdi_utils.msg_error);
1018: else

Line 1034: and wjdi.load_type = wip_job_details.wip_mtl_requirement

1030: and process_status in (wip_constants.running,
1031: wip_constants.warning)
1032: and wip_entity_id = p_wip_entity_id
1033: and organization_id = p_organization_id
1034: and wjdi.load_type = wip_job_details.wip_mtl_requirement
1035: and wjdi.substitution_type = p_substitution_type
1036: and wjdi.operation_seq_num = p_operation_seq_num
1037: and wjdi.inventory_item_id_new = p_inventory_item_id_new
1038: and wjdi.wip_supply_type is null;

Line 1058: and wjdi.load_type = wip_job_details.wip_mtl_requirement

1054: and wjdi.process_status in (wip_constants.running,
1055: wip_constants.warning)
1056: and wjdi.wip_entity_id = p_wip_entity_id
1057: and wjdi.organization_id = p_organization_id
1058: and wjdi.load_type = wip_job_details.wip_mtl_requirement
1059: and wjdi.substitution_type = p_substitution_type
1060: and wjdi.operation_seq_num = p_operation_seq_num
1061: and ( wjdi.inventory_item_id_old is null
1062: or (wjdi.inventory_item_id_old <> nvl(wjdi.inventory_item_id_new, wjdi.inventory_item_id_old)

Line 1091: if(wip_job_details.std_alone = 1) then

1087: for l_inv_row in c_invalid_rows loop
1088: l_error_exists := true;
1089: fnd_message.set_name('WIP', 'WIP_JDI_CHNG_REQ_INFO_MISSING');
1090: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
1091: if(wip_job_details.std_alone = 1) then
1092: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
1093: p_text => substr(fnd_message.get,1,500),
1094: p_error_type => wip_jdi_utils.msg_error);
1095: else

Line 1111: and wjdi.load_type = wip_job_details.wip_mtl_requirement

1107: and process_status in (wip_constants.running,
1108: wip_constants.warning)
1109: and wip_entity_id = p_wip_entity_id
1110: and organization_id = p_organization_id
1111: and wjdi.load_type = wip_job_details.wip_mtl_requirement
1112: and wjdi.substitution_type = p_substitution_type
1113: and wjdi.operation_seq_num = p_operation_seq_num
1114: and ( wjdi.inventory_item_id_old is null
1115: or ( wjdi.inventory_item_id_old <> nvl(wjdi.inventory_item_id_new, wjdi.inventory_item_id_old)

Line 1255: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT

1251: /*Component Yield Enhancement(Bug 4369064)*/
1252: WHERE group_id = p_group_id
1253: AND wip_entity_id = p_wip_entity_id
1254: AND organization_id = p_organization_id
1255: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
1256: AND substitution_type = p_substitution_type
1257: AND operation_seq_num = p_operation_seq_num
1258: AND inventory_item_id_old = p_inventory_item_id_old;
1259: end if;

Line 1301: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT

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
1300: AND organization_id = p_organization_id
1301: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
1302: AND substitution_type = p_substitution_type;
1303:
1304: BEGIN
1305:

Line 1461: IF p_substitution_type = WIP_JOB_DETAILS.WIP_DELETE THEN

1457: x_count number := 0;
1458:
1459: BEGIN
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

Line 1469: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT

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
1469: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
1470: AND substitution_type= p_substitution_type
1471: AND operation_seq_num= p_operation_seq_num
1472: AND inventory_item_id_old = p_inventory_item_id_old;
1473:

Line 1474: ELSIF p_substitution_type = WIP_JOB_DETAILS.WIP_ADD THEN

1470: AND substitution_type= p_substitution_type
1471: AND operation_seq_num= p_operation_seq_num
1472: AND inventory_item_id_old = p_inventory_item_id_old;
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

Line 1482: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT

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
1482: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
1483: AND substitution_type= p_substitution_type
1484: AND operation_seq_num= p_operation_seq_num
1485: AND inventory_item_id_new = p_inventory_item_id_new;
1486:

Line 1487: ELSIF p_substitution_type = WIP_JOB_DETAILS.WIP_CHANGE THEN

1483: AND substitution_type= p_substitution_type
1484: AND operation_seq_num= p_operation_seq_num
1485: AND inventory_item_id_new = p_inventory_item_id_new;
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

Line 1495: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT

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
1495: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
1496: AND substitution_type= p_substitution_type
1497: AND operation_seq_num= p_operation_seq_num
1498: AND inventory_item_id_old = p_inventory_item_id_old
1499: AND inventory_item_id_new = p_inventory_item_id_new;

Line 1521: IF p_substitution_type = WIP_JOB_DETAILS.WIP_DELETE THEN

1517: x_count number := 0;
1518:
1519: BEGIN
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

Line 1529: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT

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
1529: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
1530: AND substitution_type= p_substitution_type
1531: AND operation_seq_num= p_operation_seq_num
1532: AND inventory_item_id_old IS NULL;
1533:

Line 1534: ELSIF p_substitution_type = WIP_JOB_DETAILS.WIP_ADD THEN

1530: AND substitution_type= p_substitution_type
1531: AND operation_seq_num= p_operation_seq_num
1532: AND inventory_item_id_old IS NULL;
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

Line 1542: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT

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
1542: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
1543: AND substitution_type= p_substitution_type
1544: AND operation_seq_num= p_operation_seq_num
1545: AND (inventory_item_id_new IS NULL
1546: OR quantity_per_assembly IS NULL);

Line 1548: ELSIF p_substitution_type = WIP_JOB_DETAILS.WIP_CHANGE THEN

1544: AND operation_seq_num= p_operation_seq_num
1545: AND (inventory_item_id_new IS NULL
1546: OR quantity_per_assembly IS NULL);
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

Line 1556: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT

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
1556: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
1557: AND substitution_type= p_substitution_type
1558: AND operation_seq_num= p_operation_seq_num
1559: AND (inventory_item_id_old IS NULL
1560: OR quantity_per_assembly IS NULL);