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_DEMANDS

Line 134: FROM msc_demands dem,

130: p_from_date IN DATE,
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

Line 256: FROM msc_demands dem,

252: p_from_date IN DATE,
253: p_to_date IN DATE ) IS
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

Line 293: FROM msc_demands dem,

289: p_from_date IN DATE,
290: p_to_date IN DATE ) IS
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

Line 339: FROM msc_demands

335: CURSOR c_sd_49(p_plan_id NUMBER,
336: p_sr_instance_id NUMBER,
337: p_demand_id NUMBER) IS
338: SELECT demand_id
339: FROM msc_demands
340: WHERE plan_id = p_plan_id
341: AND sr_instance_id = p_sr_instance_id
342: AND group_id IN (SELECT group_id
343: FROM msc_demands

Line 343: FROM msc_demands

339: FROM msc_demands
340: WHERE plan_id = p_plan_id
341: AND sr_instance_id = p_sr_instance_id
342: AND group_id IN (SELECT group_id
343: FROM msc_demands
344: WHERE plan_id = p_plan_id
345: AND sr_instance_id = p_sr_instance_id
346: AND demand_id = p_demand_id);
347:

Line 352: msc_demands md

348: CURSOR c_demand_84 (p_plan_id NUMBER,
349: p_excp_id NUMBER) IS
350: SELECT md.demand_id
351: FROM msc_exception_details med,
352: msc_demands md
353: WHERE med.plan_id = md.plan_id
354: AND med.exception_type = 84
355: AND med.exception_detail_id = p_excp_id
356: AND med.plan_id = p_plan_id

Line 2725: from_clause_dmd :=from_clause_dmd||',msc_demands dmd';

2721: IF l_order_flag='N' THEN
2722: l_order_flag:='Y';
2723: from_clause_segment :=from_clause_segment||',msc_supplies sup';
2724: where_clause_segment := where_clause_segment||' and i.plan_id=sup.plan_id and i.sr_instance_id=sup.sr_instance_id and i.organization_id=sup.organization_id and i.inventory_item_id=sup.inventory_item_id ';
2725: from_clause_dmd :=from_clause_dmd||',msc_demands dmd';
2726: 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 ';
2727: END IF;
2728: END IF;
2729: END IF;

Line 2738: from_clause_segment :=from_clause_segment||',msc_demands dem';

2734: l_enditem_flag:='Y';
2735: END IF;
2736: IF l_demand_flag='N' THEN
2737: l_demand_flag:='Y';
2738: from_clause_segment :=from_clause_segment||',msc_demands dem';
2739: where_clause_segment := where_clause_segment||' and ei.plan_id=dem.plan_id and ei.sr_instance_id=dem.sr_instance_id and ei.organization_id=dem.organization_id and ei.inventory_item_id=dem.inventory_item_id ';
2740: END IF;
2741: END IF;
2742: END IF;

Line 2900: from_clause_dmd :=from_clause_dmd||' ,msc_demands dmd';

2896: IF l_order_flag='N' THEN
2897: l_order_flag:='Y';
2898: from_clause_segment :=from_clause_segment||',msc_supplies sup';
2899: where_clause_segment :=where_clause_segment||' and i.plan_id=sup.plan_id and i.sr_instance_id=sup.sr_instance_id and i.organization_id=sup.organization_id and i.inventory_item_id=sup.inventory_item_id ';
2900: from_clause_dmd :=from_clause_dmd||' ,msc_demands dmd';
2901: 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 ';
2902: END IF;
2903: IF l_field_name_2 ='IWU_CATEGORY1' THEN
2904: l_wwu1_flag:='Y';

Line 2948: from_clause_segment :=from_clause_segment||',msc_demands dem';

2944: END IF;
2945: IF l_folder_object_2 ='MSC_WRKSH_RSLT_DEMAND' THEN
2946: IF l_demand_flag='N' THEN
2947: l_demand_flag:='Y';
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';

Line 3199: from_clause_dmd :=from_clause_dmd||' ,msc_demands dmd';

3195: l_order_flag :='Y';
3196: from_clause_segment :=from_clause_segment||',msc_supplies sup';
3197: where_clause_segment := where_clause_segment||' and i.plan_id=sup.plan_id
3198: and i.sr_instance_id=sup.sr_instance_id and i.organization_id=sup.organization_id and i.inventory_item_id=sup.inventory_item_id ';
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';

Line 3223: from_clause_dmd :=from_clause_dmd||' ,msc_demands dmd';

3219: IF l_order_flag ='N' THEN
3220: l_order_flag :='Y';
3221: from_clause_segment :=from_clause_segment||',msc_supplies sup';
3222: where_clause_segment := where_clause_segment||' and i.plan_id=sup.plan_idand i.sr_instance_id=sup.sr_instance_id and i.organization_id=sup.organization_id and i.inventory_item_id=sup.inventory_item_id ';
3223: from_clause_dmd :=from_clause_dmd||' ,msc_demands dmd';
3224: 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 ';
3225: END IF;
3226: END IF;
3227: IF entity_segment NOT LIKE '%ENDASSEMBLY%' AND entity_segment NOT LIKE '%ORDER%' AND entity_segment LIKE '%DEMAND%' THEN

Line 3236: from_clause_segment :=from_clause_segment||',msc_demands dem';

3232: and i.sr_instance_id=sup.sr_instance_id and i.organization_id=sup.organization_id and i.inventory_item_id=sup.inventory_item_id ';
3233: END IF;
3234: IF l_demand_flag ='N' THEN
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';

Line 3260: from_clause_segment :=from_clause_segment||',msc_demands dem';

3256: where_clause_segment := where_clause_segment||' and i.plan_id=sup.plan_id and i.sr_instance_id=sup.sr_instance_id and i.organization_id=sup.organization_id and i.inventory_item_id=sup.inventory_item_id ';
3257: END IF;
3258: IF l_demand_flag ='N' THEN
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';

Line 3279: from_clause_dmd :=from_clause_dmd||' ,msc_demands dmd';

3275: IF l_order_flag ='N' THEN
3276: l_order_flag :='Y';
3277: from_clause_segment :=from_clause_segment||',msc_supplies sup';
3278: where_clause_segment := where_clause_segment||' and i.plan_id=sup.plan_id and i.sr_instance_id=sup.sr_instance_id and i.organization_id=sup.organization_id and i.inventory_item_id=sup.inventory_item_id ';
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';

Line 3315: from_clause_segment :=from_clause_segment||',msc_demands dem';

3311: where_clause_segment := where_clause_segment||' and mfpw1.plan_id=mfpe1.plan_id and mfpw1.end_pegging_id=mfpe1.end_pegging_id and mfpe1.plan_id=dem.plan_id (+) and mfpe1.demand_id=dem.demand_id (+) ';
3312: END IF;
3313: IF l_demand_flag ='N' THEN
3314: l_demand_flag :='Y';
3315: from_clause_segment :=from_clause_segment||',msc_demands dem';
3316: END IF;
3317: IF l_order_flag ='N' THEN
3318: l_order_flag :='Y';
3319: from_clause_segment :=from_clause_segment||',msc_supplies sup';