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.MSC_PQ_UTILS dependencies on MSC_ITEM_CATEGORIES

Line 107: msc_item_categories mic

103: SELECT sup.transaction_id
104: --,sup.new_schedule_date new_due_date
105: FROM msc_supplies sup,
106: msc_system_items msi ,
107: msc_item_categories mic
108: WHERE mic.sr_instance_id = sup.sr_instance_id
109: AND mic.organization_id = sup.organization_id
110: AND mic.inventory_item_id = sup.inventory_item_id
111: AND

Line 136: msc_item_categories mic

132: SELECT dem.demand_id transaction_id
133: --,dem.using_assembly_demand_date new_due_date
134: FROM msc_demands dem,
135: msc_system_items msi,
136: msc_item_categories mic
137: WHERE mic.sr_instance_id = dem.sr_instance_id
138: AND mic.organization_id = dem.organization_id
139: AND mic.inventory_item_id = dem.inventory_item_id
140: AND

Line 166: msc_item_categories mic

162: SELECT mso.demand_id transaction_id
163: --,mso.requirement_date new_due_date
164: FROM msc_sales_orders mso,
165: msc_system_items msi ,
166: msc_item_categories mic
167: WHERE mso.sr_instance_id = mic.sr_instance_id
168: AND mso.inventory_item_id = mic.inventory_item_id
169: AND mso.organization_id = mic.organization_id
170: AND

Line 196: msc_item_categories mic

192: SELECT jro.transaction_id
193: --,jro.reco_date_required new_due_date
194: FROM msc_job_requirement_ops jro,
195: msc_system_items msi ,
196: msc_item_categories mic
197: WHERE mic.sr_instance_id = jro.sr_instance_id
198: AND mic.organization_id = jro.organization_id
199: AND mic.inventory_item_id = jro.component_item_id
200: --AND jro.plan_id = -1

Line 225: msc_item_categories mic,

221: SELECT sup.transaction_id
222: --,nvl(sup.new_ship_date,sup.new_schedule_date) new_due_date
223: FROM msc_supplies sup,
224: msc_system_items msi ,
225: msc_item_categories mic,
226: msc_plans mp
227: WHERE mic.sr_instance_id = sup.sr_instance_id
228: AND mic.organization_id = sup.organization_id
229: AND mic.inventory_item_id = sup.inventory_item_id

Line 259: msc_item_categories mic

255: --,nvl(dem.planned_inbound_due_date , dem.using_assembly_demand_date) new_due_date
256: FROM msc_demands dem,
257: msc_plans mp,
258: msc_system_items msi ,
259: msc_item_categories mic
260: WHERE mic.sr_instance_id = dem.sr_instance_id
261: AND mic.organization_id = dem.organization_id
262: AND mic.inventory_item_id = dem.inventory_item_id
263: AND

Line 296: msc_item_categories mic

292: --,nvl(dem.old_using_assembly_demand_date , dem.using_assembly_demand_date) new_due_date
293: FROM msc_demands dem,
294: msc_plans mp,
295: msc_system_items msi ,
296: msc_item_categories mic
297: WHERE mic.sr_instance_id = dem.sr_instance_id
298: AND mic.organization_id = dem.organization_id
299: AND mic.inventory_item_id = dem.inventory_item_id
300: AND

Line 2583: from_clause_segment :=from_clause_segment||',msc_item_categories mic1';

2579: l_item_flag:='Y';
2580: END IF;
2581: IF l_mic1_flag='N' THEN
2582: l_mic1_flag:='Y';
2583: from_clause_segment :=from_clause_segment||',msc_item_categories mic1';
2584: where_clause_segment := where_clause_segment|| ' and i.sr_instance_id=mic1.sr_instance_id and i.organization_id=mic1.organization_id and i.inventory_item_id=mic1.inventory_item_id ';
2585:
2586: from_clause_dmd :=from_clause_dmd||',msc_item_categories mic1';
2587: where_clause_dmd := where_clause_dmd|| ' and i.sr_instance_id=mic1.sr_instance_id and i.organization_id=mic1.organization_id and i.inventory_item_id=mic1.inventory_item_id ';

Line 2586: from_clause_dmd :=from_clause_dmd||',msc_item_categories mic1';

2582: l_mic1_flag:='Y';
2583: from_clause_segment :=from_clause_segment||',msc_item_categories mic1';
2584: where_clause_segment := where_clause_segment|| ' and i.sr_instance_id=mic1.sr_instance_id and i.organization_id=mic1.organization_id and i.inventory_item_id=mic1.inventory_item_id ';
2585:
2586: from_clause_dmd :=from_clause_dmd||',msc_item_categories mic1';
2587: where_clause_dmd := where_clause_dmd|| ' and i.sr_instance_id=mic1.sr_instance_id and i.organization_id=mic1.organization_id and i.inventory_item_id=mic1.inventory_item_id ';
2588: end if;
2589: elsif l_field_name ='CATEGORY2' THEN
2590: l_wmic2_flag:='Y';

Line 2598: from_clause_segment :=from_clause_segment||',msc_item_categories mic2';

2594: l_item_flag:='Y';
2595: END IF;
2596: IF l_mic2_flag='N' THEN
2597: l_mic2_flag:='Y';
2598: from_clause_segment :=from_clause_segment||',msc_item_categories mic2';
2599: where_clause_segment := where_clause_segment|| ' and i.sr_instance_id=mic2.sr_instance_id and i.organization_id=mic2.organization_id and i.inventory_item_id=mic2.inventory_item_id ';
2600: from_clause_dmd :=from_clause_dmd||',msc_item_categories mic2';
2601: where_clause_dmd := where_clause_dmd|| ' and i.sr_instance_id=mic2.sr_instance_id and i.organization_id=mic2.organization_id and i.inventory_item_id=mic2.inventory_item_id ';
2602: END IF;

Line 2600: from_clause_dmd :=from_clause_dmd||',msc_item_categories mic2';

2596: IF l_mic2_flag='N' THEN
2597: l_mic2_flag:='Y';
2598: from_clause_segment :=from_clause_segment||',msc_item_categories mic2';
2599: where_clause_segment := where_clause_segment|| ' and i.sr_instance_id=mic2.sr_instance_id and i.organization_id=mic2.organization_id and i.inventory_item_id=mic2.inventory_item_id ';
2600: from_clause_dmd :=from_clause_dmd||',msc_item_categories mic2';
2601: where_clause_dmd := where_clause_dmd|| ' and i.sr_instance_id=mic2.sr_instance_id and i.organization_id=mic2.organization_id and i.inventory_item_id=mic2.inventory_item_id ';
2602: END IF;
2603: elsif l_field_name ='CATEGORY3' THEN
2604: l_wmic3_flag:='Y';

Line 2612: from_clause_segment :=from_clause_segment||',msc_item_categories mic3 ';

2608: l_item_flag:='Y';
2609: END IF;
2610: IF l_mic3_flag='N' THEN
2611: l_mic3_flag:='Y';
2612: from_clause_segment :=from_clause_segment||',msc_item_categories mic3 ';
2613: where_clause_segment:= where_clause_segment|| ' and i.sr_instance_id=mic3.sr_instance_id and i.organization_id=mic3.organization_id and i.inventory_item_id=mic3.inventory_item_id ';
2614: from_clause_dmd :=from_clause_dmd||',msc_item_categories mic3';
2615: where_clause_dmd := where_clause_dmd|| ' and i.sr_instance_id=mic3.sr_instance_id and i.organization_id=mic3.organization_id and i.inventory_item_id=mic3.inventory_item_id ';
2616: END IF;

Line 2614: from_clause_dmd :=from_clause_dmd||',msc_item_categories mic3';

2610: IF l_mic3_flag='N' THEN
2611: l_mic3_flag:='Y';
2612: from_clause_segment :=from_clause_segment||',msc_item_categories mic3 ';
2613: where_clause_segment:= where_clause_segment|| ' and i.sr_instance_id=mic3.sr_instance_id and i.organization_id=mic3.organization_id and i.inventory_item_id=mic3.inventory_item_id ';
2614: from_clause_dmd :=from_clause_dmd||',msc_item_categories mic3';
2615: where_clause_dmd := where_clause_dmd|| ' and i.sr_instance_id=mic3.sr_instance_id and i.organization_id=mic3.organization_id and i.inventory_item_id=mic3.inventory_item_id ';
2616: END IF;
2617: elsif l_field_name ='WHERE_USED_CATEGORY1' THEN
2618: l_wwu1_flag:='Y';

Line 2621: from_clause_segment :=from_clause_segment||',msc_item_categories wu1';

2617: elsif l_field_name ='WHERE_USED_CATEGORY1' THEN
2618: l_wwu1_flag:='Y';
2619: IF l_wu1_flag='N' THEN
2620: l_wu1_flag:='Y';
2621: from_clause_segment :=from_clause_segment||',msc_item_categories wu1';
2622: where_clause_segment:= where_clause_segment|| ' and mfpw2.sr_instance_id=wu1.sr_instance_id and mfpw2.organization_id=wu1.organization_id and mfpw2.inventory_item_id=wu1.inventory_item_id ';
2623: end if;
2624: elsif l_field_name ='WHERE_USED_CATEGORY2' THEN
2625: l_wwu2_flag:='Y';

Line 2628: from_clause_segment :=from_clause_segment||',msc_item_categories wu2';

2624: elsif l_field_name ='WHERE_USED_CATEGORY2' THEN
2625: l_wwu2_flag:='Y';
2626: IF l_wu2_flag='N' THEN
2627: l_wu2_flag:='Y';
2628: from_clause_segment :=from_clause_segment||',msc_item_categories wu2';
2629: where_clause_segment:= where_clause_segment|| ' and mfpw2.sr_instance_id=wu2.sr_instance_id and mfpw2.organization_id=wu2.organization_id and mfpw2.inventory_item_id=wu2.inventory_item_id ';
2630: end if;
2631: elsif l_field_name ='WHERE_USED_CATEGORY3' THEN
2632: l_wwu3_flag:='Y';

Line 2635: from_clause_segment :=from_clause_segment||',msc_item_categories wu3';

2631: elsif l_field_name ='WHERE_USED_CATEGORY3' THEN
2632: l_wwu3_flag:='Y';
2633: IF l_wu3_flag='N' THEN
2634: l_wu3_flag:='Y';
2635: from_clause_segment :=from_clause_segment||',msc_item_categories wu3';
2636: where_clause_segment:= where_clause_segment|| ' and mfpw2.sr_instance_id=wu3.sr_instance_id and mfpw2.organization_id=wu3.organization_id and mfpw2.inventory_item_id=wu3.inventory_item_id ';
2637: end if;
2638: END IF;
2639: END IF;

Line 2679: from_clause_segment :=from_clause_segment||',msc_item_categories mic4';

2675: l_enditem_flag:='Y';
2676: END IF;
2677: IF l_mic4_flag='N' THEN
2678: l_mic4_flag:='Y';
2679: from_clause_segment :=from_clause_segment||',msc_item_categories mic4';
2680: where_clause_segment := where_clause_segment|| ' and ei.sr_instance_id=mic4.sr_instance_id and ei.organization_id=mic4.organization_id and ei.inventory_item_id=mic4.inventory_item_id ';
2681: from_clause_dmd :=from_clause_dmd||',msc_item_categories mic4';
2682: where_clause_dmd := where_clause_dmd|| ' and ei.sr_instance_id=mic4.sr_instance_id and ei.organization_id=mic4.organization_id and ei.inventory_item_id=mic4.inventory_item_id ';
2683: end if;

Line 2681: from_clause_dmd :=from_clause_dmd||',msc_item_categories mic4';

2677: IF l_mic4_flag='N' THEN
2678: l_mic4_flag:='Y';
2679: from_clause_segment :=from_clause_segment||',msc_item_categories mic4';
2680: where_clause_segment := where_clause_segment|| ' and ei.sr_instance_id=mic4.sr_instance_id and ei.organization_id=mic4.organization_id and ei.inventory_item_id=mic4.inventory_item_id ';
2681: from_clause_dmd :=from_clause_dmd||',msc_item_categories mic4';
2682: where_clause_dmd := where_clause_dmd|| ' and ei.sr_instance_id=mic4.sr_instance_id and ei.organization_id=mic4.organization_id and ei.inventory_item_id=mic4.inventory_item_id ';
2683: end if;
2684: elsif l_field_name ='CATEGORY2' THEN
2685: l_wmic5_flag:='Y';

Line 2693: from_clause_segment :=from_clause_segment||',msc_item_categories mic5';

2689: l_enditem_flag:='Y';
2690: END IF;
2691: IF l_mic5_flag='N' THEN
2692: l_mic5_flag:='Y';
2693: from_clause_segment :=from_clause_segment||',msc_item_categories mic5';
2694: where_clause_segment := where_clause_segment|| ' and ei.sr_instance_id=mic5.sr_instance_id and ei.organization_id=mic5.organization_id and ei.inventory_item_id=mic5.inventory_item_id ';
2695: from_clause_dmd :=from_clause_dmd||',msc_item_categories mic5';
2696: where_clause_dmd := where_clause_dmd|| ' and ei.sr_instance_id=mic5.sr_instance_id and ei.organization_id=mic5.organization_id and ei.inventory_item_id=mic5.inventory_item_id ';
2697: end if;

Line 2695: from_clause_dmd :=from_clause_dmd||',msc_item_categories mic5';

2691: IF l_mic5_flag='N' THEN
2692: l_mic5_flag:='Y';
2693: from_clause_segment :=from_clause_segment||',msc_item_categories mic5';
2694: where_clause_segment := where_clause_segment|| ' and ei.sr_instance_id=mic5.sr_instance_id and ei.organization_id=mic5.organization_id and ei.inventory_item_id=mic5.inventory_item_id ';
2695: from_clause_dmd :=from_clause_dmd||',msc_item_categories mic5';
2696: where_clause_dmd := where_clause_dmd|| ' and ei.sr_instance_id=mic5.sr_instance_id and ei.organization_id=mic5.organization_id and ei.inventory_item_id=mic5.inventory_item_id ';
2697: end if;
2698: elsif l_field_name ='CATEGORY3' THEN
2699: l_wmic6_flag:='Y';

Line 2707: from_clause_segment :=from_clause_segment||',msc_item_categories mic6';

2703: l_enditem_flag:='Y';
2704: END IF;
2705: IF l_mic6_flag='N' THEN
2706: l_mic6_flag:='Y';
2707: from_clause_segment :=from_clause_segment||',msc_item_categories mic6';
2708: where_clause_segment:= where_clause_segment|| ' and ei.sr_instance_id=mic6.sr_instance_id and ei.organization_id=mic6.organization_id and ei.inventory_item_id=mic6.inventory_item_id ';
2709: from_clause_dmd :=from_clause_dmd||',msc_item_categories mic6';
2710: where_clause_dmd := where_clause_dmd|| ' and ei.sr_instance_id=mic6.sr_instance_id and ei.organization_id=mic6.organization_id and ei.inventory_item_id=mic6.inventory_item_id ';
2711: end if;

Line 2709: from_clause_dmd :=from_clause_dmd||',msc_item_categories mic6';

2705: IF l_mic6_flag='N' THEN
2706: l_mic6_flag:='Y';
2707: from_clause_segment :=from_clause_segment||',msc_item_categories mic6';
2708: where_clause_segment:= where_clause_segment|| ' and ei.sr_instance_id=mic6.sr_instance_id and ei.organization_id=mic6.organization_id and ei.inventory_item_id=mic6.inventory_item_id ';
2709: from_clause_dmd :=from_clause_dmd||',msc_item_categories mic6';
2710: where_clause_dmd := where_clause_dmd|| ' and ei.sr_instance_id=mic6.sr_instance_id and ei.organization_id=mic6.organization_id and ei.inventory_item_id=mic6.inventory_item_id ';
2711: end if;
2712: END IF;
2713: END IF;

Line 2804: from_clause_segment :=from_clause_segment||',msc_item_categories mic1';

2800: l_item_flag:='Y';
2801: END IF;
2802: IF l_mic1_flag='N' THEN
2803: l_mic1_flag:='Y';
2804: from_clause_segment :=from_clause_segment||',msc_item_categories mic1';
2805: where_clause_segment := where_clause_segment|| ' and i.sr_instance_id=mic1.sr_instance_id and i.organization_id=mic1.organization_id and i.inventory_item_id=mic1.inventory_item_id ';
2806: from_clause_dmd :=from_clause_dmd||',msc_item_categories mic1';
2807: where_clause_dmd := where_clause_dmd|| ' and i.sr_instance_id=mic1.sr_instance_id and i.organization_id=mic1.organization_id and i.inventory_item_id=mic1.inventory_item_id ';
2808:

Line 2806: from_clause_dmd :=from_clause_dmd||',msc_item_categories mic1';

2802: IF l_mic1_flag='N' THEN
2803: l_mic1_flag:='Y';
2804: from_clause_segment :=from_clause_segment||',msc_item_categories mic1';
2805: where_clause_segment := where_clause_segment|| ' and i.sr_instance_id=mic1.sr_instance_id and i.organization_id=mic1.organization_id and i.inventory_item_id=mic1.inventory_item_id ';
2806: from_clause_dmd :=from_clause_dmd||',msc_item_categories mic1';
2807: where_clause_dmd := where_clause_dmd|| ' and i.sr_instance_id=mic1.sr_instance_id and i.organization_id=mic1.organization_id and i.inventory_item_id=mic1.inventory_item_id ';
2808:
2809: END IF;
2810: elsif l_field_name_2 ='ITEM_CATEGORY2' THEN

Line 2819: from_clause_segment :=from_clause_segment||',msc_item_categories mic2';

2815: l_item_flag:='Y';
2816: END IF;
2817: IF l_mic2_flag='N' THEN
2818: l_mic2_flag:='Y';
2819: from_clause_segment :=from_clause_segment||',msc_item_categories mic2';
2820: where_clause_segment := where_clause_segment|| ' and i.sr_instance_id=mic2.sr_instance_id and i.organization_id=mic2.organization_id and i.inventory_item_id=mic2.inventory_item_id ';
2821: from_clause_dmd :=from_clause_dmd||',msc_item_categories mic2';
2822: where_clause_dmd := where_clause_dmd|| ' and i.sr_instance_id=mic2.sr_instance_id and i.organization_id=mic2.organization_id and i.inventory_item_id=mic2.inventory_item_id ';
2823: END IF;

Line 2821: from_clause_dmd :=from_clause_dmd||',msc_item_categories mic2';

2817: IF l_mic2_flag='N' THEN
2818: l_mic2_flag:='Y';
2819: from_clause_segment :=from_clause_segment||',msc_item_categories mic2';
2820: where_clause_segment := where_clause_segment|| ' and i.sr_instance_id=mic2.sr_instance_id and i.organization_id=mic2.organization_id and i.inventory_item_id=mic2.inventory_item_id ';
2821: from_clause_dmd :=from_clause_dmd||',msc_item_categories mic2';
2822: where_clause_dmd := where_clause_dmd|| ' and i.sr_instance_id=mic2.sr_instance_id and i.organization_id=mic2.organization_id and i.inventory_item_id=mic2.inventory_item_id ';
2823: END IF;
2824: elsif l_field_name_2 ='ITEM_CATEGORY3' THEN
2825: l_wmic3_flag:='Y';

Line 2833: from_clause_segment :=from_clause_segment||',msc_item_categories mic3';

2829: l_item_flag:='Y';
2830: END IF;
2831: IF l_mic3_flag='N' THEN
2832: l_mic3_flag:='Y';
2833: from_clause_segment :=from_clause_segment||',msc_item_categories mic3';
2834: where_clause_segment := where_clause_segment|| ' and i.sr_instance_id=mic3.sr_instance_id and i.organization_id=mic3.organization_id and i.inventory_item_id=mic3.inventory_item_id ';
2835: from_clause_dmd :=from_clause_dmd||',msc_item_categories mic3';
2836: where_clause_dmd := where_clause_dmd|| ' and i.sr_instance_id=mic3.sr_instance_id and i.organization_id=mic3.organization_id and i.inventory_item_id=mic3.inventory_item_id ';
2837: END IF;

Line 2835: from_clause_dmd :=from_clause_dmd||',msc_item_categories mic3';

2831: IF l_mic3_flag='N' THEN
2832: l_mic3_flag:='Y';
2833: from_clause_segment :=from_clause_segment||',msc_item_categories mic3';
2834: where_clause_segment := where_clause_segment|| ' and i.sr_instance_id=mic3.sr_instance_id and i.organization_id=mic3.organization_id and i.inventory_item_id=mic3.inventory_item_id ';
2835: from_clause_dmd :=from_clause_dmd||',msc_item_categories mic3';
2836: where_clause_dmd := where_clause_dmd|| ' and i.sr_instance_id=mic3.sr_instance_id and i.organization_id=mic3.organization_id and i.inventory_item_id=mic3.inventory_item_id ';
2837: END IF;
2838: END IF;
2839: END IF;

Line 2855: from_clause_segment :=from_clause_segment||',msc_item_categories mic4';

2851: l_enditem_flag:='Y';
2852: END IF;
2853: IF l_mic4_flag='N' THEN
2854: l_mic4_flag:='Y';
2855: from_clause_segment :=from_clause_segment||',msc_item_categories mic4';
2856: where_clause_segment := where_clause_segment|| ' and ei.sr_instance_id=mic4.sr_instance_id and ei.organization_id=mic4.organization_id and ei.inventory_item_id=mic4.inventory_item_id ';
2857: from_clause_dmd :=from_clause_dmd||',msc_item_categories mic4';
2858: where_clause_dmd := where_clause_dmd|| ' and ei.sr_instance_id=mic4.sr_instance_id and ei.organization_id=mic4.organization_id and ei.inventory_item_id=mic4.inventory_item_id ';
2859: END IF;

Line 2857: from_clause_dmd :=from_clause_dmd||',msc_item_categories mic4';

2853: IF l_mic4_flag='N' THEN
2854: l_mic4_flag:='Y';
2855: from_clause_segment :=from_clause_segment||',msc_item_categories mic4';
2856: where_clause_segment := where_clause_segment|| ' and ei.sr_instance_id=mic4.sr_instance_id and ei.organization_id=mic4.organization_id and ei.inventory_item_id=mic4.inventory_item_id ';
2857: from_clause_dmd :=from_clause_dmd||',msc_item_categories mic4';
2858: where_clause_dmd := where_clause_dmd|| ' and ei.sr_instance_id=mic4.sr_instance_id and ei.organization_id=mic4.organization_id and ei.inventory_item_id=mic4.inventory_item_id ';
2859: END IF;
2860: elsif l_field_name_2 ='ITEM_CATEGORY2' THEN
2861: l_wmic5_flag:='Y';

Line 2869: from_clause_segment :=from_clause_segment||',msc_item_categories mic5';

2865: l_enditem_flag:='Y';
2866: END IF;
2867: IF l_mic5_flag='N' THEN
2868: l_mic5_flag:='Y';
2869: from_clause_segment :=from_clause_segment||',msc_item_categories mic5';
2870: where_clause_segment := where_clause_segment|| ' and ei.sr_instance_id=mic5.sr_instance_id and ei.organization_id=mic5.organization_id and ei.inventory_item_id=mic5.inventory_item_id ';
2871: from_clause_dmd :=from_clause_dmd||',msc_item_categories mic5';
2872: where_clause_dmd := where_clause_dmd|| ' and ei.sr_instance_id=mic5.sr_instance_id and ei.organization_id=mic5.organization_id and ei.inventory_item_id=mic5.inventory_item_id ';
2873: END IF;

Line 2871: from_clause_dmd :=from_clause_dmd||',msc_item_categories mic5';

2867: IF l_mic5_flag='N' THEN
2868: l_mic5_flag:='Y';
2869: from_clause_segment :=from_clause_segment||',msc_item_categories mic5';
2870: where_clause_segment := where_clause_segment|| ' and ei.sr_instance_id=mic5.sr_instance_id and ei.organization_id=mic5.organization_id and ei.inventory_item_id=mic5.inventory_item_id ';
2871: from_clause_dmd :=from_clause_dmd||',msc_item_categories mic5';
2872: where_clause_dmd := where_clause_dmd|| ' and ei.sr_instance_id=mic5.sr_instance_id and ei.organization_id=mic5.organization_id and ei.inventory_item_id=mic5.inventory_item_id ';
2873: END IF;
2874: elsif l_field_name_2 ='ITEM_CATEGORY3' THEN
2875: l_wmic6_flag:='Y';

Line 2883: from_clause_segment :=from_clause_segment||',msc_item_categories mic6';

2879: l_enditem_flag:='Y';
2880: END IF;
2881: IF l_mic6_flag='N' THEN
2882: l_mic6_flag:='Y';
2883: from_clause_segment :=from_clause_segment||',msc_item_categories mic6';
2884: where_clause_segment := where_clause_segment|| ' and ei.sr_instance_id=mic6.sr_instance_id and ei.organization_id=mic6.organization_id and ei.inventory_item_id=mic6.inventory_item_id ';
2885: from_clause_dmd :=from_clause_dmd||',msc_item_categories mic6';
2886: where_clause_dmd := where_clause_dmd|| ' and ei.sr_instance_id=mic6.sr_instance_id and ei.organization_id=mic6.organization_id and ei.inventory_item_id=mic6.inventory_item_id ';
2887: END IF;

Line 2885: from_clause_dmd :=from_clause_dmd||',msc_item_categories mic6';

2881: IF l_mic6_flag='N' THEN
2882: l_mic6_flag:='Y';
2883: from_clause_segment :=from_clause_segment||',msc_item_categories mic6';
2884: where_clause_segment := where_clause_segment|| ' and ei.sr_instance_id=mic6.sr_instance_id and ei.organization_id=mic6.organization_id and ei.inventory_item_id=mic6.inventory_item_id ';
2885: from_clause_dmd :=from_clause_dmd||',msc_item_categories mic6';
2886: where_clause_dmd := where_clause_dmd|| ' and ei.sr_instance_id=mic6.sr_instance_id and ei.organization_id=mic6.organization_id and ei.inventory_item_id=mic6.inventory_item_id ';
2887: END IF;
2888: END IF;
2889: END IF;

Line 2907: from_clause_segment :=from_clause_segment||',msc_item_categories wu1';

2903: IF l_field_name_2 ='IWU_CATEGORY1' THEN
2904: l_wwu1_flag:='Y';
2905: IF l_wu1_flag='N' THEN
2906: l_wu1_flag:='Y';
2907: from_clause_segment :=from_clause_segment||',msc_item_categories wu1';
2908: where_clause_segment := where_clause_segment|| ' and mfpw2.sr_instance_id=wu1.sr_instance_id and mfpw2.organization_id=wu1.organization_id and mfpw2.inventory_item_id=wu1.inventory_item_id ';
2909: END IF;
2910: elsif l_field_name_2 ='IWU_CATEGORY2' THEN
2911: l_wwu2_flag:='Y';

Line 2914: from_clause_segment :=from_clause_segment||',msc_item_categories wu2';

2910: elsif l_field_name_2 ='IWU_CATEGORY2' THEN
2911: l_wwu2_flag:='Y';
2912: IF l_wu2_flag='N' THEN
2913: l_wu2_flag:='Y';
2914: from_clause_segment :=from_clause_segment||',msc_item_categories wu2';
2915: where_clause_segment := where_clause_segment|| ' and mfpw2.sr_instance_id=wu2.sr_instance_id
2916: and mfpw2.organization_id=wu2.organization_id and mfpw2.inventory_item_id=wu2.inventory_item_id ';
2917: END IF;
2918: elsif l_field_name_2 ='IWU_CATEGORY3' THEN

Line 2922: from_clause_segment :=from_clause_segment||',msc_item_categories wu3';

2918: elsif l_field_name_2 ='IWU_CATEGORY3' THEN
2919: l_wwu3_flag:='Y';
2920: IF l_wu3_flag='N' THEN
2921: l_wu3_flag:='Y';
2922: from_clause_segment :=from_clause_segment||',msc_item_categories wu3';
2923: where_clause_segment := where_clause_segment|| ' and mfpw2.sr_instance_id=wu3.sr_instance_id
2924: and mfpw2.organization_id=wu3.organization_id and mfpw2.inventory_item_id=wu3.inventory_item_id ';
2925: END IF;
2926: END IF;

Line 3009: from_clause_segment :=from_clause_segment||',msc_item_categories mic1';

3005: l_item_flag :='Y';
3006: END IF;
3007: IF l_mic1_flag ='N' THEN
3008: l_mic1_flag :='Y';
3009: from_clause_segment :=from_clause_segment||',msc_item_categories mic1';
3010: where_clause_segment:= where_clause_segment|| ' and i.sr_instance_id=mic1.sr_instance_id and i.organization_id=mic1.organization_id and i.inventory_item_id=mic1.inventory_item_id and mic1.category_set_id='||l_hidden_field;
3011: from_clause_dmd :=from_clause_dmd||',msc_item_categories mic1';
3012: where_clause_dmd:= where_clause_dmd|| ' and i.sr_instance_id=mic1.sr_instance_id and i.organization_id=mic1.organization_id and i.inventory_item_id=mic1.inventory_item_id and mic1.category_set_id='||l_hidden_field;
3013: ELSIF l_mic1_flag ='Y' THEN

Line 3011: from_clause_dmd :=from_clause_dmd||',msc_item_categories mic1';

3007: IF l_mic1_flag ='N' THEN
3008: l_mic1_flag :='Y';
3009: from_clause_segment :=from_clause_segment||',msc_item_categories mic1';
3010: where_clause_segment:= where_clause_segment|| ' and i.sr_instance_id=mic1.sr_instance_id and i.organization_id=mic1.organization_id and i.inventory_item_id=mic1.inventory_item_id and mic1.category_set_id='||l_hidden_field;
3011: from_clause_dmd :=from_clause_dmd||',msc_item_categories mic1';
3012: where_clause_dmd:= where_clause_dmd|| ' and i.sr_instance_id=mic1.sr_instance_id and i.organization_id=mic1.organization_id and i.inventory_item_id=mic1.inventory_item_id and mic1.category_set_id='||l_hidden_field;
3013: ELSIF l_mic1_flag ='Y' THEN
3014: where_clause_segment:= where_clause_segment|| ' and mic1.category_set_id='||l_hidden_field;
3015: where_clause_dmd:= where_clause_dmd|| ' and mic1.category_set_id='||l_hidden_field;

Line 3027: from_clause_segment :=from_clause_segment||',msc_item_categories mic2';

3023: l_item_flag :='Y';
3024: END IF;
3025: IF l_mic2_flag ='N' THEN
3026: l_mic2_flag :='Y';
3027: from_clause_segment :=from_clause_segment||',msc_item_categories mic2';
3028: where_clause_segment:= where_clause_segment|| ' and i.sr_instance_id=mic2.sr_instance_id and i.organization_id=mic1.organization_id and i.inventory_item_id=mic2.inventory_item_id and mic2.category_set_id='||l_hidden_field;
3029: from_clause_dmd :=from_clause_dmd||',msc_item_categories mic2';
3030: where_clause_dmd:= where_clause_dmd|| ' and i.sr_instance_id=mic2.sr_instance_id and i.organization_id=mic2.organization_id and i.inventory_item_id=mic2.inventory_item_id and mic1.category_set_id='||l_hidden_field;
3031: ELSIF l_mic2_flag ='Y' THEN

Line 3029: from_clause_dmd :=from_clause_dmd||',msc_item_categories mic2';

3025: IF l_mic2_flag ='N' THEN
3026: l_mic2_flag :='Y';
3027: from_clause_segment :=from_clause_segment||',msc_item_categories mic2';
3028: where_clause_segment:= where_clause_segment|| ' and i.sr_instance_id=mic2.sr_instance_id and i.organization_id=mic1.organization_id and i.inventory_item_id=mic2.inventory_item_id and mic2.category_set_id='||l_hidden_field;
3029: from_clause_dmd :=from_clause_dmd||',msc_item_categories mic2';
3030: where_clause_dmd:= where_clause_dmd|| ' and i.sr_instance_id=mic2.sr_instance_id and i.organization_id=mic2.organization_id and i.inventory_item_id=mic2.inventory_item_id and mic1.category_set_id='||l_hidden_field;
3031: ELSIF l_mic2_flag ='Y' THEN
3032: where_clause_segment:= where_clause_segment|| ' and mic2.category_set_id='||l_hidden_field;
3033: where_clause_dmd:= where_clause_dmd|| ' and mic2.category_set_id='||l_hidden_field;

Line 3044: from_clause_segment :=from_clause_segment||',msc_item_categories mic3';

3040: l_item_flag :='Y';
3041: END IF;
3042: IF l_mic3_flag ='N' THEN
3043: l_mic3_flag :='Y';
3044: from_clause_segment :=from_clause_segment||',msc_item_categories mic3';
3045: where_clause_segment:= where_clause_segment|| ' and i.sr_instance_id=mic3.sr_instance_id and i.organization_id=mic3.organization_id and i.inventory_item_id=mic3.inventory_item_id and mic3.category_set_id='||l_hidden_field;
3046: from_clause_dmd :=from_clause_dmd||',msc_item_categories mic3';
3047: where_clause_dmd:= where_clause_dmd|| ' and i.sr_instance_id=mic3.sr_instance_id and i.organization_id=mic3.organization_id and i.inventory_item_id=mic3.inventory_item_id and mic1.category_set_id='||l_hidden_field;
3048: ELSIF l_mic3_flag ='Y' THEN

Line 3046: from_clause_dmd :=from_clause_dmd||',msc_item_categories mic3';

3042: IF l_mic3_flag ='N' THEN
3043: l_mic3_flag :='Y';
3044: from_clause_segment :=from_clause_segment||',msc_item_categories mic3';
3045: where_clause_segment:= where_clause_segment|| ' and i.sr_instance_id=mic3.sr_instance_id and i.organization_id=mic3.organization_id and i.inventory_item_id=mic3.inventory_item_id and mic3.category_set_id='||l_hidden_field;
3046: from_clause_dmd :=from_clause_dmd||',msc_item_categories mic3';
3047: where_clause_dmd:= where_clause_dmd|| ' and i.sr_instance_id=mic3.sr_instance_id and i.organization_id=mic3.organization_id and i.inventory_item_id=mic3.inventory_item_id and mic1.category_set_id='||l_hidden_field;
3048: ELSIF l_mic3_flag ='Y' THEN
3049: where_clause_segment:= where_clause_segment|| ' and mic3.category_set_id='||l_hidden_field;
3050: where_clause_dmd:= where_clause_dmd|| ' and mic3.category_set_id='||l_hidden_field;

Line 3060: from_clause_segment :=from_clause_segment||',msc_item_categories wu1';

3056: l_item_flag :='Y';
3057: END IF;
3058: IF l_wu1_flag ='N' THEN
3059: l_wu1_flag :='Y';
3060: from_clause_segment :=from_clause_segment||',msc_item_categories wu1';
3061: where_clause_segment:= where_clause_segment|| ' and mfpw2.sr_instance_id=wu1.sr_instance_id and mfpw2.organization_id=wu1.organization_id and mfpw2.inventory_item_id=wu1.inventory_item_id
3062: and wu1.category_set_id='||l_hidden_field;
3063: elsIF l_wu1_flag ='Y' THEN
3064: where_clause_segment:= where_clause_segment|| ' and wu1.category_set_id='||l_hidden_field;

Line 3085: from_clause_segment :=from_clause_segment||',msc_item_categories wu2';

3081: l_item_flag :='Y';
3082: END IF;
3083: IF l_wu2_flag ='N' THEN
3084: l_wu2_flag :='Y';
3085: from_clause_segment :=from_clause_segment||',msc_item_categories wu2';
3086: where_clause_segment:= where_clause_segment|| ' and mfpw2.sr_instance_id=wu2.sr_instance_id
3087: and mfpw2.organization_id=wu2.organization_id and mfpw2.inventory_item_id=wu2.inventory_item_id and wu2.category_set_id='||l_hidden_field;
3088: elsIF l_wu2_flag ='Y' THEN
3089: where_clause_segment:= where_clause_segment|| ' and wu2.category_set_id='||l_hidden_field;

Line 3114: from_clause_segment :=from_clause_segment||',msc_item_categories wu3';

3110: l_item_flag :='Y';
3111: END IF;
3112: IF l_wu3_flag ='N' THEN
3113: l_wu3_flag :='Y';
3114: from_clause_segment :=from_clause_segment||',msc_item_categories wu3';
3115: where_clause_segment:= where_clause_segment|| ' and mfpw2.sr_instance_id=wu3.sr_instance_id and mfpw2.organization_id=wu3.organization_id and mfpw2.inventory_item_id=wu3.inventory_item_id and wu3.category_set_id='||l_hidden_field;
3116: elsIF l_wu3_flag ='Y' THEN
3117: where_clause_segment:= where_clause_segment|| ' and wu3.category_set_id='||l_hidden_field;
3118: END IF;