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_SYSTEM_ITEMS

Line 106: msc_system_items msi ,

102: p_to_date IN DATE ) IS
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

Line 135: msc_system_items msi,

131: p_to_date IN DATE ) IS
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

Line 165: msc_system_items msi ,

161: p_to_date IN DATE ) IS
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

Line 195: msc_system_items msi ,

191: p_to_date IN DATE ) IS
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

Line 224: msc_system_items msi ,

220: p_to_date IN DATE ) IS
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

Line 258: msc_system_items msi ,

254: SELECT dem.demand_id transaction_id
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

Line 295: msc_system_items msi ,

291: SELECT dem.demand_id transaction_id
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

Line 425: msc_system_items i

421: p_to_date DATE) IS
422: SELECT supply_id
423: FROM msc_resource_requirements r,
424: msc_supplies s,
425: msc_system_items i
426: WHERE r.plan_id = p_plan_id
427: AND r.sr_instance_id = p_inst_id
428: AND r.organization_id = p_org_id
429: AND r.department_id = p_dept_id

Line 2570: from_clause_segment :=from_clause_segment||',msc_system_items i';

2566: l_folder_object := c_f_criteria_row.fOLDER_object ;
2567: IF l_folder_object ='MSC_WRKSH_FLTR_ITEM' THEN
2568: IF l_field_name IN ('ITEM_SEGMENTS','PLANNER_CODE') THEN
2569: IF l_item_flag='N' THEN
2570: from_clause_segment :=from_clause_segment||',msc_system_items i';
2571: from_clause_dmd :=from_clause_dmd||',msc_system_items i';
2572: l_item_flag:='Y';
2573: END IF;
2574: elsif l_field_name ='CATEGORY1' THEN

Line 2571: from_clause_dmd :=from_clause_dmd||',msc_system_items i';

2567: IF l_folder_object ='MSC_WRKSH_FLTR_ITEM' THEN
2568: IF l_field_name IN ('ITEM_SEGMENTS','PLANNER_CODE') THEN
2569: IF l_item_flag='N' THEN
2570: from_clause_segment :=from_clause_segment||',msc_system_items i';
2571: from_clause_dmd :=from_clause_dmd||',msc_system_items i';
2572: l_item_flag:='Y';
2573: END IF;
2574: elsif l_field_name ='CATEGORY1' THEN
2575: l_wmic1_flag:='Y';

Line 2577: from_clause_segment :=from_clause_segment||',msc_system_items i';

2573: END IF;
2574: elsif l_field_name ='CATEGORY1' THEN
2575: l_wmic1_flag:='Y';
2576: IF l_item_flag='N' THEN
2577: from_clause_segment :=from_clause_segment||',msc_system_items i';
2578: from_clause_dmd :=from_clause_dmd||',msc_system_items i';
2579: l_item_flag:='Y';
2580: END IF;
2581: IF l_mic1_flag='N' THEN

Line 2578: from_clause_dmd :=from_clause_dmd||',msc_system_items i';

2574: elsif l_field_name ='CATEGORY1' THEN
2575: l_wmic1_flag:='Y';
2576: IF l_item_flag='N' THEN
2577: from_clause_segment :=from_clause_segment||',msc_system_items i';
2578: from_clause_dmd :=from_clause_dmd||',msc_system_items i';
2579: l_item_flag:='Y';
2580: END IF;
2581: IF l_mic1_flag='N' THEN
2582: l_mic1_flag:='Y';

Line 2592: from_clause_segment :=from_clause_segment||',msc_system_items i';

2588: end if;
2589: elsif l_field_name ='CATEGORY2' THEN
2590: l_wmic2_flag:='Y';
2591: IF l_item_flag='N' THEN
2592: from_clause_segment :=from_clause_segment||',msc_system_items i';
2593: from_clause_dmd :=from_clause_dmd||',msc_system_items i';
2594: l_item_flag:='Y';
2595: END IF;
2596: IF l_mic2_flag='N' THEN

Line 2593: from_clause_dmd :=from_clause_dmd||',msc_system_items i';

2589: elsif l_field_name ='CATEGORY2' THEN
2590: l_wmic2_flag:='Y';
2591: IF l_item_flag='N' THEN
2592: from_clause_segment :=from_clause_segment||',msc_system_items i';
2593: from_clause_dmd :=from_clause_dmd||',msc_system_items i';
2594: l_item_flag:='Y';
2595: END IF;
2596: IF l_mic2_flag='N' THEN
2597: l_mic2_flag:='Y';

Line 2606: from_clause_segment :=from_clause_segment||',msc_system_items i';

2602: END IF;
2603: elsif l_field_name ='CATEGORY3' THEN
2604: l_wmic3_flag:='Y';
2605: IF l_item_flag='N' THEN
2606: from_clause_segment :=from_clause_segment||',msc_system_items i';
2607: from_clause_dmd :=from_clause_dmd||',msc_system_items i';
2608: l_item_flag:='Y';
2609: END IF;
2610: IF l_mic3_flag='N' THEN

Line 2607: from_clause_dmd :=from_clause_dmd||',msc_system_items i';

2603: elsif l_field_name ='CATEGORY3' THEN
2604: l_wmic3_flag:='Y';
2605: IF l_item_flag='N' THEN
2606: from_clause_segment :=from_clause_segment||',msc_system_items i';
2607: from_clause_dmd :=from_clause_dmd||',msc_system_items i';
2608: l_item_flag:='Y';
2609: END IF;
2610: IF l_mic3_flag='N' THEN
2611: l_mic3_flag:='Y';

Line 2666: from_clause_segment :=from_clause_segment||',msc_system_items ei';

2662:
2663: IF l_folder_object ='MSC_WRKSH_FLTR_ENDITEM' THEN
2664: IF l_field_name ='ITEM_SEGMENTS' THEN
2665: IF l_enditem_flag='N' THEN
2666: from_clause_segment :=from_clause_segment||',msc_system_items ei';
2667: from_clause_dmd :=from_clause_dmd||',msc_system_items ei';
2668: l_enditem_flag:='Y';
2669: END IF;
2670: elsif l_field_name ='CATEGORY1' THEN

Line 2667: from_clause_dmd :=from_clause_dmd||',msc_system_items ei';

2663: IF l_folder_object ='MSC_WRKSH_FLTR_ENDITEM' THEN
2664: IF l_field_name ='ITEM_SEGMENTS' THEN
2665: IF l_enditem_flag='N' THEN
2666: from_clause_segment :=from_clause_segment||',msc_system_items ei';
2667: from_clause_dmd :=from_clause_dmd||',msc_system_items ei';
2668: l_enditem_flag:='Y';
2669: END IF;
2670: elsif l_field_name ='CATEGORY1' THEN
2671: l_wmic4_flag:='Y';

Line 2673: from_clause_segment :=from_clause_segment||',msc_system_items ei';

2669: END IF;
2670: elsif l_field_name ='CATEGORY1' THEN
2671: l_wmic4_flag:='Y';
2672: IF l_enditem_flag='N' THEN
2673: from_clause_segment :=from_clause_segment||',msc_system_items ei';
2674: from_clause_dmd :=from_clause_dmd||',msc_system_items ei';
2675: l_enditem_flag:='Y';
2676: END IF;
2677: IF l_mic4_flag='N' THEN

Line 2674: from_clause_dmd :=from_clause_dmd||',msc_system_items ei';

2670: elsif l_field_name ='CATEGORY1' THEN
2671: l_wmic4_flag:='Y';
2672: IF l_enditem_flag='N' THEN
2673: from_clause_segment :=from_clause_segment||',msc_system_items ei';
2674: from_clause_dmd :=from_clause_dmd||',msc_system_items ei';
2675: l_enditem_flag:='Y';
2676: END IF;
2677: IF l_mic4_flag='N' THEN
2678: l_mic4_flag:='Y';

Line 2687: from_clause_segment :=from_clause_segment||',msc_system_items ei';

2683: end if;
2684: elsif l_field_name ='CATEGORY2' THEN
2685: l_wmic5_flag:='Y';
2686: IF l_enditem_flag='N' THEN
2687: from_clause_segment :=from_clause_segment||',msc_system_items ei';
2688: from_clause_dmd :=from_clause_dmd||',msc_system_items ei';
2689: l_enditem_flag:='Y';
2690: END IF;
2691: IF l_mic5_flag='N' THEN

Line 2688: from_clause_dmd :=from_clause_dmd||',msc_system_items ei';

2684: elsif l_field_name ='CATEGORY2' THEN
2685: l_wmic5_flag:='Y';
2686: IF l_enditem_flag='N' THEN
2687: from_clause_segment :=from_clause_segment||',msc_system_items ei';
2688: from_clause_dmd :=from_clause_dmd||',msc_system_items ei';
2689: l_enditem_flag:='Y';
2690: END IF;
2691: IF l_mic5_flag='N' THEN
2692: l_mic5_flag:='Y';

Line 2701: from_clause_segment :=from_clause_segment||',msc_system_items ei';

2697: end if;
2698: elsif l_field_name ='CATEGORY3' THEN
2699: l_wmic6_flag:='Y';
2700: IF l_enditem_flag='N' THEN
2701: from_clause_segment :=from_clause_segment||',msc_system_items ei';
2702: from_clause_dmd :=from_clause_dmd||',msc_system_items ei';
2703: l_enditem_flag:='Y';
2704: END IF;
2705: IF l_mic6_flag='N' THEN

Line 2702: from_clause_dmd :=from_clause_dmd||',msc_system_items ei';

2698: elsif l_field_name ='CATEGORY3' THEN
2699: l_wmic6_flag:='Y';
2700: IF l_enditem_flag='N' THEN
2701: from_clause_segment :=from_clause_segment||',msc_system_items ei';
2702: from_clause_dmd :=from_clause_dmd||',msc_system_items ei';
2703: l_enditem_flag:='Y';
2704: END IF;
2705: IF l_mic6_flag='N' THEN
2706: l_mic6_flag:='Y';

Line 2717: from_clause_segment :=from_clause_segment||',msc_system_items i';

2713: END IF;
2714: IF l_folder_object ='MSC_WRKSH_FLTR_ORDER' THEN
2715: IF l_field_name IN ('ORGANIZATION_CODE','FIRM_PLANNED_TYPE','NEW_DUE_DATE') THEN
2716: IF l_item_flag='N' THEN
2717: from_clause_segment :=from_clause_segment||',msc_system_items i';
2718: from_clause_dmd :=from_clause_dmd||',msc_system_items i';
2719: l_item_flag:='Y';
2720: END IF;
2721: IF l_order_flag='N' THEN

Line 2718: from_clause_dmd :=from_clause_dmd||',msc_system_items i';

2714: IF l_folder_object ='MSC_WRKSH_FLTR_ORDER' THEN
2715: IF l_field_name IN ('ORGANIZATION_CODE','FIRM_PLANNED_TYPE','NEW_DUE_DATE') THEN
2716: IF l_item_flag='N' THEN
2717: from_clause_segment :=from_clause_segment||',msc_system_items i';
2718: from_clause_dmd :=from_clause_dmd||',msc_system_items i';
2719: l_item_flag:='Y';
2720: END IF;
2721: IF l_order_flag='N' THEN
2722: l_order_flag:='Y';

Line 2733: from_clause_segment :=from_clause_segment||',msc_system_items ei';

2729: END IF;
2730: IF l_folder_object ='MSC_WRKSH_FLTR_DEMAND' THEN
2731: IF l_field_name IN ( 'ORGANIZATION_CODE','NEW_DUE_DATE') THEN
2732: IF l_enditem_flag='N' THEN
2733: from_clause_segment :=from_clause_segment||',msc_system_items ei';
2734: l_enditem_flag:='Y';
2735: END IF;
2736: IF l_demand_flag='N' THEN
2737: l_demand_flag:='Y';

Line 2791: from_clause_segment :=from_clause_segment||',msc_system_items i';

2787: column_prompts_segment :=column_prompts_segment||L_meaning;
2788: --column_list_segment :=column_list_segment||l_sql_statement_2;
2789: IF l_folder_object_2 ='MSC_WRKSH_RSLT_ITEM' THEN
2790: IF l_item_flag='N' THEN
2791: from_clause_segment :=from_clause_segment||',msc_system_items i';
2792: from_clause_dmd :=from_clause_dmd||',msc_system_items i';
2793: l_item_flag:='Y';
2794: END IF;
2795: IF l_field_name_2 ='ITEM_CATEGORY1' THEN

Line 2792: from_clause_dmd :=from_clause_dmd||',msc_system_items i';

2788: --column_list_segment :=column_list_segment||l_sql_statement_2;
2789: IF l_folder_object_2 ='MSC_WRKSH_RSLT_ITEM' THEN
2790: IF l_item_flag='N' THEN
2791: from_clause_segment :=from_clause_segment||',msc_system_items i';
2792: from_clause_dmd :=from_clause_dmd||',msc_system_items i';
2793: l_item_flag:='Y';
2794: END IF;
2795: IF l_field_name_2 ='ITEM_CATEGORY1' THEN
2796: l_wmic1_flag:='Y';

Line 2798: from_clause_segment :=from_clause_segment||',msc_system_items i';

2794: END IF;
2795: IF l_field_name_2 ='ITEM_CATEGORY1' THEN
2796: l_wmic1_flag:='Y';
2797: IF l_item_flag='N' THEN
2798: from_clause_segment :=from_clause_segment||',msc_system_items i';
2799: from_clause_dmd :=from_clause_dmd||',msc_system_items i';
2800: l_item_flag:='Y';
2801: END IF;
2802: IF l_mic1_flag='N' THEN

Line 2799: from_clause_dmd :=from_clause_dmd||',msc_system_items i';

2795: IF l_field_name_2 ='ITEM_CATEGORY1' THEN
2796: l_wmic1_flag:='Y';
2797: IF l_item_flag='N' THEN
2798: from_clause_segment :=from_clause_segment||',msc_system_items i';
2799: from_clause_dmd :=from_clause_dmd||',msc_system_items i';
2800: l_item_flag:='Y';
2801: END IF;
2802: IF l_mic1_flag='N' THEN
2803: l_mic1_flag:='Y';

Line 2813: from_clause_segment :=from_clause_segment||',msc_system_items i';

2809: END IF;
2810: elsif l_field_name_2 ='ITEM_CATEGORY2' THEN
2811: l_wmic2_flag:='Y';
2812: IF l_item_flag='N' THEN
2813: from_clause_segment :=from_clause_segment||',msc_system_items i';
2814: from_clause_dmd :=from_clause_dmd||',msc_system_items i';
2815: l_item_flag:='Y';
2816: END IF;
2817: IF l_mic2_flag='N' THEN

Line 2814: from_clause_dmd :=from_clause_dmd||',msc_system_items i';

2810: elsif l_field_name_2 ='ITEM_CATEGORY2' THEN
2811: l_wmic2_flag:='Y';
2812: IF l_item_flag='N' THEN
2813: from_clause_segment :=from_clause_segment||',msc_system_items i';
2814: from_clause_dmd :=from_clause_dmd||',msc_system_items i';
2815: l_item_flag:='Y';
2816: END IF;
2817: IF l_mic2_flag='N' THEN
2818: l_mic2_flag:='Y';

Line 2827: from_clause_segment :=from_clause_segment||',msc_system_items i';

2823: END IF;
2824: elsif l_field_name_2 ='ITEM_CATEGORY3' THEN
2825: l_wmic3_flag:='Y';
2826: IF l_item_flag='N' THEN
2827: from_clause_segment :=from_clause_segment||',msc_system_items i';
2828: from_clause_dmd :=from_clause_dmd||',msc_system_items i';
2829: l_item_flag:='Y';
2830: END IF;
2831: IF l_mic3_flag='N' THEN

Line 2828: from_clause_dmd :=from_clause_dmd||',msc_system_items i';

2824: elsif l_field_name_2 ='ITEM_CATEGORY3' THEN
2825: l_wmic3_flag:='Y';
2826: IF l_item_flag='N' THEN
2827: from_clause_segment :=from_clause_segment||',msc_system_items i';
2828: from_clause_dmd :=from_clause_dmd||',msc_system_items i';
2829: l_item_flag:='Y';
2830: END IF;
2831: IF l_mic3_flag='N' THEN
2832: l_mic3_flag:='Y';

Line 2842: from_clause_segment :=from_clause_segment||',msc_system_items ei';

2838: END IF;
2839: END IF;
2840: IF l_folder_object_2 ='MSC_WRKSH_RSLT_ENDITEM' THEN
2841: IF l_enditem_flag='N' THEN
2842: from_clause_segment :=from_clause_segment||',msc_system_items ei';
2843: from_clause_dmd :=from_clause_dmd||',msc_system_items ei';
2844: l_enditem_flag:='Y';
2845: END IF;
2846: IF l_field_name_2 ='ITEM_CATEGORY1' THEN

Line 2843: from_clause_dmd :=from_clause_dmd||',msc_system_items ei';

2839: END IF;
2840: IF l_folder_object_2 ='MSC_WRKSH_RSLT_ENDITEM' THEN
2841: IF l_enditem_flag='N' THEN
2842: from_clause_segment :=from_clause_segment||',msc_system_items ei';
2843: from_clause_dmd :=from_clause_dmd||',msc_system_items ei';
2844: l_enditem_flag:='Y';
2845: END IF;
2846: IF l_field_name_2 ='ITEM_CATEGORY1' THEN
2847: l_wmic4_flag:='Y';

Line 2849: from_clause_segment :=from_clause_segment||',msc_system_items ei';

2845: END IF;
2846: IF l_field_name_2 ='ITEM_CATEGORY1' THEN
2847: l_wmic4_flag:='Y';
2848: IF l_enditem_flag='N' THEN
2849: from_clause_segment :=from_clause_segment||',msc_system_items ei';
2850: from_clause_dmd :=from_clause_dmd||',msc_system_items ei';
2851: l_enditem_flag:='Y';
2852: END IF;
2853: IF l_mic4_flag='N' THEN

Line 2850: from_clause_dmd :=from_clause_dmd||',msc_system_items ei';

2846: IF l_field_name_2 ='ITEM_CATEGORY1' THEN
2847: l_wmic4_flag:='Y';
2848: IF l_enditem_flag='N' THEN
2849: from_clause_segment :=from_clause_segment||',msc_system_items ei';
2850: from_clause_dmd :=from_clause_dmd||',msc_system_items ei';
2851: l_enditem_flag:='Y';
2852: END IF;
2853: IF l_mic4_flag='N' THEN
2854: l_mic4_flag:='Y';

Line 2863: from_clause_segment :=from_clause_segment||',msc_system_items ei';

2859: END IF;
2860: elsif l_field_name_2 ='ITEM_CATEGORY2' THEN
2861: l_wmic5_flag:='Y';
2862: IF l_enditem_flag='N' THEN
2863: from_clause_segment :=from_clause_segment||',msc_system_items ei';
2864: from_clause_dmd :=from_clause_dmd||',msc_system_items ei';
2865: l_enditem_flag:='Y';
2866: END IF;
2867: IF l_mic5_flag='N' THEN

Line 2864: from_clause_dmd :=from_clause_dmd||',msc_system_items ei';

2860: elsif l_field_name_2 ='ITEM_CATEGORY2' THEN
2861: l_wmic5_flag:='Y';
2862: IF l_enditem_flag='N' THEN
2863: from_clause_segment :=from_clause_segment||',msc_system_items ei';
2864: from_clause_dmd :=from_clause_dmd||',msc_system_items ei';
2865: l_enditem_flag:='Y';
2866: END IF;
2867: IF l_mic5_flag='N' THEN
2868: l_mic5_flag:='Y';

Line 2877: from_clause_segment :=from_clause_segment||',msc_system_items ei';

2873: END IF;
2874: elsif l_field_name_2 ='ITEM_CATEGORY3' THEN
2875: l_wmic6_flag:='Y';
2876: IF l_enditem_flag='N' THEN
2877: from_clause_segment :=from_clause_segment||',msc_system_items ei';
2878: from_clause_dmd :=from_clause_dmd||',msc_system_items ei';
2879: l_enditem_flag:='Y';
2880: END IF;
2881: IF l_mic6_flag='N' THEN

Line 2878: from_clause_dmd :=from_clause_dmd||',msc_system_items ei';

2874: elsif l_field_name_2 ='ITEM_CATEGORY3' THEN
2875: l_wmic6_flag:='Y';
2876: IF l_enditem_flag='N' THEN
2877: from_clause_segment :=from_clause_segment||',msc_system_items ei';
2878: from_clause_dmd :=from_clause_dmd||',msc_system_items ei';
2879: l_enditem_flag:='Y';
2880: END IF;
2881: IF l_mic6_flag='N' THEN
2882: l_mic6_flag:='Y';

Line 2892: from_clause_segment :=from_clause_segment||',msc_system_items i';

2888: END IF;
2889: END IF;
2890: IF l_folder_object_2 ='MSC_WRKSH_RSLT_ORDER' THEN
2891: IF l_item_flag='N' THEN
2892: from_clause_segment :=from_clause_segment||',msc_system_items i';
2893: from_clause_dmd :=from_clause_dmd||',msc_system_items i';
2894: l_item_flag:='Y';
2895: END IF;
2896: IF l_order_flag='N' THEN

Line 2893: from_clause_dmd :=from_clause_dmd||',msc_system_items i';

2889: END IF;
2890: IF l_folder_object_2 ='MSC_WRKSH_RSLT_ORDER' THEN
2891: IF l_item_flag='N' THEN
2892: from_clause_segment :=from_clause_segment||',msc_system_items i';
2893: from_clause_dmd :=from_clause_dmd||',msc_system_items i';
2894: l_item_flag:='Y';
2895: END IF;
2896: IF l_order_flag='N' THEN
2897: l_order_flag:='Y';

Line 2952: from_clause_segment :=from_clause_segment||',msc_system_items ei';

2948: from_clause_segment :=from_clause_segment||',msc_demands dem';
2949: END IF;
2950: --IF l_field_name_2 IN ('ITEM_SEGMENTS','ORGANIZATION_CODE') THEN
2951: IF l_enditem_flag='N' THEN
2952: from_clause_segment :=from_clause_segment||',msc_system_items ei';
2953: l_enditem_flag:='Y';
2954: END IF;
2955: IF l_mfpw1_flag ='N' AND l_mfpe1_flag='N' THEN
2956: l_mfpw1_flag :='Y';

Line 3003: from_clause_segment :=from_clause_segment||',msc_system_items i';

2999: IF l_folder_object_3 ='MSC_WRKSH_FLTR_OTHER' THEN
3000: if l_field_name_3 ='ITEM_CATEGORY_SET1' THEN
3001: l_omic1_flag :='Y';
3002: IF l_item_flag ='N' THEN
3003: from_clause_segment :=from_clause_segment||',msc_system_items i';
3004: from_clause_dmd :=from_clause_dmd||',msc_system_items i';
3005: l_item_flag :='Y';
3006: END IF;
3007: IF l_mic1_flag ='N' THEN

Line 3004: from_clause_dmd :=from_clause_dmd||',msc_system_items i';

3000: if l_field_name_3 ='ITEM_CATEGORY_SET1' THEN
3001: l_omic1_flag :='Y';
3002: IF l_item_flag ='N' THEN
3003: from_clause_segment :=from_clause_segment||',msc_system_items i';
3004: from_clause_dmd :=from_clause_dmd||',msc_system_items i';
3005: l_item_flag :='Y';
3006: END IF;
3007: IF l_mic1_flag ='N' THEN
3008: l_mic1_flag :='Y';

Line 3021: from_clause_segment :=from_clause_segment||',msc_system_items i';

3017: -- debug_plan_event('l_mic1_flag'||' and mic1.category_set_id='||l_hidden_field);
3018: elsif l_field_name_3 ='ITEM_CATEGORY_SET2' THEN
3019: l_omic2_flag :='Y';
3020: IF l_item_flag ='N' THEN
3021: from_clause_segment :=from_clause_segment||',msc_system_items i';
3022: from_clause_dmd :=from_clause_dmd||',msc_system_items i';
3023: l_item_flag :='Y';
3024: END IF;
3025: IF l_mic2_flag ='N' THEN

Line 3022: from_clause_dmd :=from_clause_dmd||',msc_system_items i';

3018: elsif l_field_name_3 ='ITEM_CATEGORY_SET2' THEN
3019: l_omic2_flag :='Y';
3020: IF l_item_flag ='N' THEN
3021: from_clause_segment :=from_clause_segment||',msc_system_items i';
3022: from_clause_dmd :=from_clause_dmd||',msc_system_items i';
3023: l_item_flag :='Y';
3024: END IF;
3025: IF l_mic2_flag ='N' THEN
3026: l_mic2_flag :='Y';

Line 3038: from_clause_segment :=from_clause_segment||',msc_system_items i';

3034: END IF;
3035: elsif l_field_name_3 ='ITEM_CATEGORY_SET3' THEN
3036: l_omic3_flag :='Y';
3037: IF l_item_flag ='N' THEN
3038: from_clause_segment :=from_clause_segment||',msc_system_items i';
3039: from_clause_dmd :=from_clause_dmd||',msc_system_items i';
3040: l_item_flag :='Y';
3041: END IF;
3042: IF l_mic3_flag ='N' THEN

Line 3039: from_clause_dmd :=from_clause_dmd||',msc_system_items i';

3035: elsif l_field_name_3 ='ITEM_CATEGORY_SET3' THEN
3036: l_omic3_flag :='Y';
3037: IF l_item_flag ='N' THEN
3038: from_clause_segment :=from_clause_segment||',msc_system_items i';
3039: from_clause_dmd :=from_clause_dmd||',msc_system_items i';
3040: l_item_flag :='Y';
3041: END IF;
3042: IF l_mic3_flag ='N' THEN
3043: l_mic3_flag :='Y';

Line 3055: from_clause_segment :=from_clause_segment||',msc_system_items i';

3051: END IF;
3052: elsif l_field_name_3 ='WHEREUSED_CATEGORY_SET1' THEN
3053: l_owu1_flag :='Y';
3054: IF l_item_flag ='N' THEN
3055: from_clause_segment :=from_clause_segment||',msc_system_items i';
3056: l_item_flag :='Y';
3057: END IF;
3058: IF l_wu1_flag ='N' THEN
3059: l_wu1_flag :='Y';

Line 3080: from_clause_segment :=from_clause_segment||',msc_system_items i';

3076: END IF;
3077: elsif l_field_name_3 ='WHEREUSED_CATEGORY_SET2' THEN
3078: l_owu2_flag :='Y';
3079: IF l_item_flag ='N' THEN
3080: from_clause_segment :=from_clause_segment||',msc_system_items i';
3081: l_item_flag :='Y';
3082: END IF;
3083: IF l_wu2_flag ='N' THEN
3084: l_wu2_flag :='Y';

Line 3109: from_clause_segment :=from_clause_segment||',msc_system_items i';

3105: END IF;
3106: elsif l_field_name_3 ='WHEREUSED_CATEGORY_SET3' THEN
3107: l_owu3_flag :='Y';
3108: IF l_item_flag ='N' THEN
3109: from_clause_segment :=from_clause_segment||',msc_system_items i';
3110: l_item_flag :='Y';
3111: END IF;
3112: IF l_wu3_flag ='N' THEN
3113: l_wu3_flag :='Y';

Line 3189: from_clause_segment :=from_clause_segment||',msc_system_items i';

3185:
3186: /***Common joins for Result or Filter tab selection of entity*/
3187: IF entity_segment LIKE '%ITEM%' THEN
3188: IF l_item_flag ='N' THEN
3189: from_clause_segment :=from_clause_segment||',msc_system_items i';
3190: from_clause_dmd :=from_clause_dmd||',msc_system_items i';
3191: l_item_flag :='Y';
3192: END IF;
3193: IF entity_segment LIKE '%ENDASSEMBLY%' AND entity_segment NOT LIKE '%ORDER%' AND entity_segment NOT LIKE '%DEMAND%' THEN

Line 3190: from_clause_dmd :=from_clause_dmd||',msc_system_items i';

3186: /***Common joins for Result or Filter tab selection of entity*/
3187: IF entity_segment LIKE '%ITEM%' THEN
3188: IF l_item_flag ='N' THEN
3189: from_clause_segment :=from_clause_segment||',msc_system_items i';
3190: from_clause_dmd :=from_clause_dmd||',msc_system_items i';
3191: l_item_flag :='Y';
3192: END IF;
3193: IF entity_segment LIKE '%ENDASSEMBLY%' AND entity_segment NOT LIKE '%ORDER%' AND entity_segment NOT LIKE '%DEMAND%' THEN
3194: IF l_order_flag ='N' THEN

Line 3203: from_clause_segment :=from_clause_segment||',msc_system_items ei';

3199: from_clause_dmd :=from_clause_dmd||' ,msc_demands dmd';
3200: where_clause_dmd := where_clause_dmd|| ' and i.plan_id=dmd.plan_id and i.sr_instance_id=dmd.sr_instance_id and i.organization_id=dmd.organization_id and i.inventory_item_id=dmd.inventory_item_id ';
3201: END IF;
3202: IF l_enditem_flag ='N' THEN
3203: from_clause_segment :=from_clause_segment||',msc_system_items ei';
3204: from_clause_dmd :=from_clause_dmd||',msc_system_items ei';
3205: l_enditem_flag :='Y';
3206: END IF;
3207: IF l_mfpw1_flag ='N' AND l_mfpe1_flag='N' THEN

Line 3204: from_clause_dmd :=from_clause_dmd||',msc_system_items ei';

3200: where_clause_dmd := where_clause_dmd|| ' and i.plan_id=dmd.plan_id and i.sr_instance_id=dmd.sr_instance_id and i.organization_id=dmd.organization_id and i.inventory_item_id=dmd.inventory_item_id ';
3201: END IF;
3202: IF l_enditem_flag ='N' THEN
3203: from_clause_segment :=from_clause_segment||',msc_system_items ei';
3204: from_clause_dmd :=from_clause_dmd||',msc_system_items ei';
3205: l_enditem_flag :='Y';
3206: END IF;
3207: IF l_mfpw1_flag ='N' AND l_mfpe1_flag='N' THEN
3208: l_mfpw1_flag :='Y';

Line 3239: from_clause_segment :=from_clause_segment||',msc_system_items ei';

3235: l_demand_flag :='Y';
3236: from_clause_segment :=from_clause_segment||',msc_demands dem';
3237: END IF;
3238: IF l_enditem_flag ='N' THEN
3239: from_clause_segment :=from_clause_segment||',msc_system_items ei';
3240: l_enditem_flag :='Y';
3241: END IF;
3242: IF l_mfpw1_flag ='N' AND l_mfpe1_flag='N' THEN
3243: l_mfpw1_flag :='Y';

Line 3263: from_clause_segment :=from_clause_segment||',msc_system_items ei';

3259: l_demand_flag :='Y';
3260: from_clause_segment :=from_clause_segment||',msc_demands dem';
3261: END IF;
3262: IF l_enditem_flag ='N' THEN
3263: from_clause_segment :=from_clause_segment||',msc_system_items ei';
3264: l_enditem_flag :='Y';
3265: END IF;
3266: IF l_mfpw1_flag ='N' AND l_mfpe1_flag='N' THEN
3267: l_mfpw1_flag :='Y';

Line 3283: from_clause_segment :=from_clause_segment||',msc_system_items ei';

3279: from_clause_dmd :=from_clause_dmd||' ,msc_demands dmd';
3280: where_clause_dmd := where_clause_dmd|| ' and i.plan_id=dmd.plan_id and i.sr_instance_id=dmd.sr_instance_id and i.organization_id=dmd.organization_id and i.inventory_item_id=dmd.inventory_item_id ';
3281: END IF;
3282: IF l_enditem_flag ='N' THEN
3283: from_clause_segment :=from_clause_segment||',msc_system_items ei';
3284: from_clause_dmd :=from_clause_dmd||' ,msc_system_items ei';
3285: l_enditem_flag :='Y';
3286: END IF;
3287: IF l_mfpw1_flag ='N' AND l_mfpe1_flag='N' THEN

Line 3284: from_clause_dmd :=from_clause_dmd||' ,msc_system_items ei';

3280: where_clause_dmd := where_clause_dmd|| ' and i.plan_id=dmd.plan_id and i.sr_instance_id=dmd.sr_instance_id and i.organization_id=dmd.organization_id and i.inventory_item_id=dmd.inventory_item_id ';
3281: END IF;
3282: IF l_enditem_flag ='N' THEN
3283: from_clause_segment :=from_clause_segment||',msc_system_items ei';
3284: from_clause_dmd :=from_clause_dmd||' ,msc_system_items ei';
3285: l_enditem_flag :='Y';
3286: END IF;
3287: IF l_mfpw1_flag ='N' AND l_mfpe1_flag='N' THEN
3288: l_mfpw1_flag :='Y';

Line 3300: from_clause_segment :=from_clause_segment||',msc_system_items ei';

3296: END IF;
3297: END IF;
3298: IF entity_segment LIKE '%ENDASSEMBLY%' AND entity_segment LIKE '%ORDER%' AND entity_segment LIKE '%DEMAND%' THEN
3299: IF l_enditem_flag ='N' THEN
3300: from_clause_segment :=from_clause_segment||',msc_system_items ei';
3301: l_enditem_flag :='Y';
3302: END IF;
3303: IF l_mfpw1_flag ='N' AND l_mfpe1_flag='N' THEN
3304: l_mfpw1_flag :='Y';