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_SUPPLIES

Line 105: FROM msc_supplies sup,

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

Line 223: FROM msc_supplies sup,

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

Line 424: msc_supplies s,

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

Line 2647: from_clause_segment :=from_clause_segment||',msc_supplies sup';

2643: l_Ewhere_flag :='Y';
2644: END IF;
2645: IF l_order_flag='N' THEN
2646: l_order_flag:='Y';
2647: from_clause_segment :=from_clause_segment||',msc_supplies sup';
2648: 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 ';
2649: END IF;
2650: IF l_mfpw1_flag='N' and l_mfpw2_flag='N' THEN
2651: l_mfpw1_flag:='Y';

Line 2723: from_clause_segment :=from_clause_segment||',msc_supplies sup';

2719: l_item_flag:='Y';
2720: END IF;
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;

Line 2898: from_clause_segment :=from_clause_segment||',msc_supplies sup';

2894: l_item_flag:='Y';
2895: END IF;
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;

Line 2968: from_clause_segment :=from_clause_segment||',msc_supplies sup';

2964: and mfpe1.demand_id=dem.demand_id (+)';
2965: END IF;
2966: IF l_order_flag ='N' THEN
2967: l_order_flag :='Y';
2968: from_clause_segment :=from_clause_segment||',msc_supplies sup';
2969: 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
2970: and i.inventory_item_id=sup.inventory_item_id ';
2971: END IF;
2972: -- END IF;

Line 3068: from_clause_segment :=from_clause_segment||',msc_supplies sup';

3064: where_clause_segment:= where_clause_segment|| ' and wu1.category_set_id='||l_hidden_field;
3065: END IF;
3066: IF l_order_flag ='N' THEN
3067: l_order_flag :='Y';
3068: from_clause_segment :=from_clause_segment||',msc_supplies sup';
3069: 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 ';
3070: END IF;
3071: IF l_mfpw1_flag ='N' AND l_mfpw2_flag='N' THEN
3072: l_mfpw1_flag :='Y';

Line 3093: from_clause_segment :=from_clause_segment||',msc_supplies sup';

3089: where_clause_segment:= where_clause_segment|| ' and wu2.category_set_id='||l_hidden_field;
3090: END IF;
3091: IF l_order_flag ='N' THEN
3092: l_order_flag :='Y';
3093: from_clause_segment :=from_clause_segment||',msc_supplies sup';
3094: where_clause_segment := where_clause_segment||' and i.plan_id=sup.plan_id
3095: and i.sr_instance_id=sup.sr_instance_id and i.organization_id=sup.organization_id
3096: and i.inventory_item_id=sup.inventory_item_id ';
3097: END IF;

Line 3121: from_clause_segment :=from_clause_segment||',msc_supplies sup';

3117: where_clause_segment:= where_clause_segment|| ' and wu3.category_set_id='||l_hidden_field;
3118: END IF;
3119: IF l_order_flag ='N' THEN
3120: l_order_flag :='Y';
3121: from_clause_segment :=from_clause_segment||',msc_supplies sup';
3122: where_clause_segment := where_clause_segment||' and i.plan_id=sup.plan_id
3123: and i.sr_instance_id=sup.sr_instance_id and i.organization_id=sup.organization_id
3124: and i.inventory_item_id=sup.inventory_item_id ';
3125: END IF;

Line 3196: from_clause_segment :=from_clause_segment||',msc_supplies sup';

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
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 ';

Line 3221: from_clause_segment :=from_clause_segment||',msc_supplies sup';

3217: END IF;
3218: IF entity_segment NOT LIKE '%ENDASSEMBLY%' AND entity_segment LIKE '%ORDER%' AND entity_segment NOT LIKE '%DEMAND%' THEN
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;

Line 3230: from_clause_segment :=from_clause_segment||',msc_supplies sup';

3226: END IF;
3227: IF entity_segment NOT LIKE '%ENDASSEMBLY%' AND entity_segment NOT LIKE '%ORDER%' AND entity_segment LIKE '%DEMAND%' THEN
3228: IF l_order_flag ='N' THEN
3229: l_order_flag :='Y';
3230: from_clause_segment :=from_clause_segment||',msc_supplies sup';
3231: where_clause_segment := where_clause_segment||' and i.plan_id=sup.plan_id
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

Line 3255: from_clause_segment :=from_clause_segment||',msc_supplies sup';

3251: END IF;
3252: IF entity_segment LIKE '%ENDASSEMBLY%' AND entity_segment NOT LIKE '%ORDER%' AND entity_segment LIKE '%DEMAND%' THEN
3253: IF l_order_flag ='N' THEN
3254: l_order_flag :='Y';
3255: from_clause_segment :=from_clause_segment||',msc_supplies sup';
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';

Line 3277: from_clause_segment :=from_clause_segment||',msc_supplies sup';

3273: END IF;
3274: IF entity_segment LIKE '%ENDASSEMBLY%' AND entity_segment LIKE '%ORDER%' AND entity_segment NOT LIKE '%DEMAND%' THEN
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;

Line 3319: from_clause_segment :=from_clause_segment||',msc_supplies sup';

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';
3320: 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 ';
3321: END IF;
3322: END IF;
3323: END IF;