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_FULL_PEGGING

Line 443: FROM msc_full_pegging

439:
440: CURSOR PEG_TRANS_C(p_plan_id NUMBER,
441: p_end_peg_id NUMBER) IS
442: SELECT transaction_id
443: FROM msc_full_pegging
444: WHERE plan_id = p_plan_id
445: AND end_pegging_id = p_end_peg_id;
446:
447: CURSOR get_bucket_dates(p_plan_id NUMBER,

Line 2653: from_clause_segment :=from_clause_segment||',msc_full_pegging mfpw1,msc_full_pegging mfpw2 ';

2649: END IF;
2650: IF l_mfpw1_flag='N' and l_mfpw2_flag='N' THEN
2651: l_mfpw1_flag:='Y';
2652: l_mfpw2_flag:='Y';
2653: from_clause_segment :=from_clause_segment||',msc_full_pegging mfpw1,msc_full_pegging mfpw2 ';
2654: where_clause_segment:= where_clause_segment|| ' and mfpw1.plan_id=sup.plan_id and mfpw1.transaction_id=sup.transaction_id and mfpw1.plan_id=mfpw2.plan_id and mfpw1.prev_pegging_id=mfpw2.pegging_id ';
2655: END IF;
2656: if l_mfpw2_flag='N' and l_mfpw1_flag='Y' THEN
2657: l_mfpw2_flag:='Y';

Line 2658: from_clause_segment :=from_clause_segment||',msc_full_pegging mfpw2';

2654: where_clause_segment:= where_clause_segment|| ' and mfpw1.plan_id=sup.plan_id and mfpw1.transaction_id=sup.transaction_id and mfpw1.plan_id=mfpw2.plan_id and mfpw1.prev_pegging_id=mfpw2.pegging_id ';
2655: END IF;
2656: if l_mfpw2_flag='N' and l_mfpw1_flag='Y' THEN
2657: l_mfpw2_flag:='Y';
2658: from_clause_segment :=from_clause_segment||',msc_full_pegging mfpw2';
2659: where_clause_segment:=where_clause_segment||' and mfpw1.plan_id=mfpw2.plan_id and mfpw1.prev_pegging_id=mfpw2.pegging_id ';
2660: end if;
2661: END IF;
2662:

Line 2935: from_clause_segment :=from_clause_segment||',msc_full_pegging mfpw1,msc_full_pegging mfpw2 ';

2931: end if;
2932: IF l_mfpw1_flag='N' and l_mfpw2_flag='N' THEN
2933: l_mfpw1_flag:='Y';
2934: l_mfpw2_flag:='Y';
2935: from_clause_segment :=from_clause_segment||',msc_full_pegging mfpw1,msc_full_pegging mfpw2 ';
2936: where_clause_segment := where_clause_segment|| ' and mfpw1.plan_id=sup.plan_id and mfpw1.transaction_id=sup.transaction_id and mfpw1.plan_id=mfpw2.plan_id and mfpw1.prev_pegging_id=mfpw2.pegging_id ';
2937: END IF;
2938: if l_mfpw2_flag='N' and l_mfpw1_flag='Y' THEN
2939: l_mfpw2_flag:='Y';

Line 2940: from_clause_segment :=from_clause_segment||',msc_full_pegging mfpw2';

2936: where_clause_segment := where_clause_segment|| ' and mfpw1.plan_id=sup.plan_id and mfpw1.transaction_id=sup.transaction_id and mfpw1.plan_id=mfpw2.plan_id and mfpw1.prev_pegging_id=mfpw2.pegging_id ';
2937: END IF;
2938: if l_mfpw2_flag='N' and l_mfpw1_flag='Y' THEN
2939: l_mfpw2_flag:='Y';
2940: from_clause_segment :=from_clause_segment||',msc_full_pegging mfpw2';
2941: where_clause_segment:=where_clause_segment||' and mfpw1.plan_id=mfpw2.plan_id and mfpw1.prev_pegging_id=mfpw2.pegging_id ';
2942: end if;
2943: END IF;
2944: END IF;

Line 2958: from_clause_segment :=from_clause_segment||',msc_full_pegging mfpw1,msc_full_pegging mfpe1';

2954: END IF;
2955: IF l_mfpw1_flag ='N' AND l_mfpe1_flag='N' THEN
2956: l_mfpw1_flag :='Y';
2957: l_mfpe1_flag :='Y';
2958: from_clause_segment :=from_clause_segment||',msc_full_pegging mfpw1,msc_full_pegging mfpe1';
2959: where_clause_segment := where_clause_segment|| ' and mfpe1.prev_pegging_id is null
2960: and mfpe1.plan_id=ei.plan_id and mfpe1.sr_instance_id=ei.sr_instance_id
2961: and mfpe1.organization_id=ei.organization_id and mfpe1.inventory_item_id=ei.inventory_item_id
2962: and mfpw1.plan_id=sup.plan_id and mfpw1.transaction_id=sup.transaction_id

Line 3074: from_clause_segment :=from_clause_segment||',msc_full_pegging mfpw1,msc_full_pegging mfpw2 ';

3070: END IF;
3071: IF l_mfpw1_flag ='N' AND l_mfpw2_flag='N' THEN
3072: l_mfpw1_flag :='Y';
3073: l_mfpw2_flag :='Y';
3074: from_clause_segment :=from_clause_segment||',msc_full_pegging mfpw1,msc_full_pegging mfpw2 ';
3075: where_clause_segment:= where_clause_segment|| ' and mfpw1.plan_id=sup.plan_id and mfpw1.transaction_id=sup.transaction_id and mfpw1.plan_id=mfpw2.plan_id and mfpw1.prev_pegging_id=mfpw2.pegging_id ';
3076: END IF;
3077: elsif l_field_name_3 ='WHEREUSED_CATEGORY_SET2' THEN
3078: l_owu2_flag :='Y';

Line 3101: from_clause_segment :=from_clause_segment||',msc_full_pegging mfpw1,msc_full_pegging mfpw2 ';

3097: END IF;
3098: IF l_mfpw1_flag ='N' AND l_mfpw2_flag='N' THEN
3099: l_mfpw1_flag :='Y';
3100: l_mfpw2_flag :='Y';
3101: from_clause_segment :=from_clause_segment||',msc_full_pegging mfpw1,msc_full_pegging mfpw2 ';
3102: where_clause_segment:= where_clause_segment|| ' and mfpw1.plan_id=sup.plan_id
3103: and mfpw1.transaction_id=sup.transaction_id and mfpw1.plan_id=mfpw2.plan_id
3104: and mfpw1.prev_pegging_id=mfpw2.pegging_id ';
3105: END IF;

Line 3129: from_clause_segment :=from_clause_segment||',msc_full_pegging mfpw1,msc_full_pegging mfpw2 ';

3125: END IF;
3126: IF l_mfpw1_flag ='N' AND l_mfpw2_flag='N' THEN
3127: l_mfpw1_flag :='Y';
3128: l_mfpw2_flag :='Y';
3129: from_clause_segment :=from_clause_segment||',msc_full_pegging mfpw1,msc_full_pegging mfpw2 ';
3130: where_clause_segment:= where_clause_segment|| ' and mfpw1.plan_id=sup.plan_id
3131: and mfpw1.transaction_id=sup.transaction_id and mfpw1.plan_id=mfpw2.plan_id and mfpw1.prev_pegging_id=mfpw2.pegging_id ';
3132: END IF;
3133: END IF;

Line 3138: from_clause_segment :=from_clause_segment||',msc_full_pegging mfpw2';

3134: if l_field_name_3 like 'WHEREUSED_CATEGORY_SET%' THEN
3135: entity_segment:=entity_segment||'WHERE_USED:';
3136: if l_mfpw2_flag='N' and l_mfpw1_flag='Y' THEN
3137: l_mfpw2_flag:='Y';
3138: from_clause_segment :=from_clause_segment||',msc_full_pegging mfpw2';
3139: where_clause_segment:=where_clause_segment||' and mfpw1.plan_id=mfpw2.plan_id and mfpw1.prev_pegging_id=mfpw2.pegging_id ';
3140: end if;
3141: end if;
3142: END IF;

Line 3210: from_clause_segment :=from_clause_segment||',msc_full_pegging mfpw1,msc_full_pegging mfpe1';

3206: END IF;
3207: IF l_mfpw1_flag ='N' AND l_mfpe1_flag='N' THEN
3208: l_mfpw1_flag :='Y';
3209: l_mfpe1_flag :='Y';
3210: from_clause_segment :=from_clause_segment||',msc_full_pegging mfpw1,msc_full_pegging mfpe1';
3211: where_clause_segment := where_clause_segment|| ' and mfpe1.prev_pegging_id is null and mfpe1.plan_id=ei.plan_id and mfpe1.sr_instance_id=ei.sr_instance_id and mfpe1.organization_id=ei.organization_id';
3212: where_clause_segment := where_clause_segment|| ' and mfpe1.inventory_item_id=ei.inventory_item_id and mfpw1.plan_id=sup.plan_id and mfpw1.transaction_id=sup.transaction_id and mfpw1.plan_id=mfpe1.plan_id and mfpw1.end_pegging_id=mfpe1.end_pegging_id ';
3213: from_clause_dmd :=from_clause_dmd||',msc_full_pegging mfpw1,msc_full_pegging mfpe1';
3214: where_clause_dmd := where_clause_dmd|| ' and mfpe1.prev_pegging_id is null and mfpe1.plan_id=ei.plan_id and mfpe1.sr_instance_id=ei.sr_instance_id and mfpe1.organization_id=ei.organization_id';

Line 3213: from_clause_dmd :=from_clause_dmd||',msc_full_pegging mfpw1,msc_full_pegging mfpe1';

3209: l_mfpe1_flag :='Y';
3210: from_clause_segment :=from_clause_segment||',msc_full_pegging mfpw1,msc_full_pegging mfpe1';
3211: where_clause_segment := where_clause_segment|| ' and mfpe1.prev_pegging_id is null and mfpe1.plan_id=ei.plan_id and mfpe1.sr_instance_id=ei.sr_instance_id and mfpe1.organization_id=ei.organization_id';
3212: where_clause_segment := where_clause_segment|| ' and mfpe1.inventory_item_id=ei.inventory_item_id and mfpw1.plan_id=sup.plan_id and mfpw1.transaction_id=sup.transaction_id and mfpw1.plan_id=mfpe1.plan_id and mfpw1.end_pegging_id=mfpe1.end_pegging_id ';
3213: from_clause_dmd :=from_clause_dmd||',msc_full_pegging mfpw1,msc_full_pegging mfpe1';
3214: where_clause_dmd := where_clause_dmd|| ' and mfpe1.prev_pegging_id is null and mfpe1.plan_id=ei.plan_id and mfpe1.sr_instance_id=ei.sr_instance_id and mfpe1.organization_id=ei.organization_id';
3215: where_clause_dmd := where_clause_dmd|| ' and mfpe1.inventory_item_id=ei.inventory_item_id and mfpw1.plan_id=dmd.plan_id and mfpw1.transaction_id=dmd.demand_id and mfpw1.plan_id=mfpe1.plan_id and mfpw1.end_pegging_id=mfpe1.end_pegging_id ';
3216: END IF;
3217: END IF;

Line 3245: from_clause_segment :=from_clause_segment||',msc_full_pegging mfpw1,msc_full_pegging mfpe1';

3241: END IF;
3242: IF l_mfpw1_flag ='N' AND l_mfpe1_flag='N' THEN
3243: l_mfpw1_flag :='Y';
3244: l_mfpe1_flag :='Y';
3245: from_clause_segment :=from_clause_segment||',msc_full_pegging mfpw1,msc_full_pegging mfpe1';
3246: where_clause_segment := where_clause_segment|| ' and mfpe1.prev_pegging_id is null
3247: and mfpe1.plan_id=ei.plan_id and mfpe1.sr_instance_id=ei.sr_instance_id
3248: and mfpe1.organization_id=ei.organization_id and mfpe1.inventory_item_id=ei.inventory_item_id
3249: and mfpw1.plan_id=sup.plan_id and mfpw1.transaction_id=sup.transaction_id and mfpw1.plan_id=mfpe1.plan_id and mfpw1.end_pegging_id=mfpe1.end_pegging_id ';

Line 3269: from_clause_segment :=from_clause_segment||',msc_full_pegging mfpw1,msc_full_pegging mfpe1';

3265: END IF;
3266: IF l_mfpw1_flag ='N' AND l_mfpe1_flag='N' THEN
3267: l_mfpw1_flag :='Y';
3268: l_mfpe1_flag :='Y';
3269: from_clause_segment :=from_clause_segment||',msc_full_pegging mfpw1,msc_full_pegging mfpe1';
3270: where_clause_segment := where_clause_segment|| ' and mfpe1.prev_pegging_id is null and mfpe1.plan_id=ei.plan_id and mfpe1.sr_instance_id=ei.sr_instance_id and mfpe1.organization_id=ei.organization_id';
3271: where_clause_segment := where_clause_segment|| ' and mfpe1.inventory_item_id=ei.inventory_item_id and mfpw1.plan_id=sup.plan_id and mfpw1.transaction_id=sup.transaction_id and mfpw1.plan_id=mfpe1.plan_id and mfpw1.end_pegging_id=mfpe1.end_pegging_id ';
3272: END IF;
3273: END IF;

Line 3290: from_clause_segment :=from_clause_segment||',msc_full_pegging mfpw1,msc_full_pegging mfpe1';

3286: END IF;
3287: IF l_mfpw1_flag ='N' AND l_mfpe1_flag='N' THEN
3288: l_mfpw1_flag :='Y';
3289: l_mfpe1_flag :='Y';
3290: from_clause_segment :=from_clause_segment||',msc_full_pegging mfpw1,msc_full_pegging mfpe1';
3291: where_clause_segment := where_clause_segment|| ' and mfpe1.prev_pegging_id is null and mfpe1.plan_id=ei.plan_id and mfpe1.sr_instance_id=ei.sr_instance_id and mfpe1.organization_id=ei.organization_id';
3292: where_clause_segment := where_clause_segment|| ' and mfpe1.inventory_item_id=ei.inventory_item_id and mfpw1.plan_id=sup.plan_id and mfpw1.transaction_id=sup.transaction_id and mfpw1.plan_id=mfpe1.plan_id and mfpw1.end_pegging_id=mfpe1.end_pegging_id ';
3293: from_clause_dmd :=from_clause_dmd||',msc_full_pegging mfpw1,msc_full_pegging mfpe1';
3294: where_clause_dmd := where_clause_dmd|| ' and mfpe1.prev_pegging_id is null and mfpe1.plan_id=ei.plan_id and mfpe1.sr_instance_id=ei.sr_instance_id and mfpe1.organization_id=ei.organization_id';

Line 3293: from_clause_dmd :=from_clause_dmd||',msc_full_pegging mfpw1,msc_full_pegging mfpe1';

3289: l_mfpe1_flag :='Y';
3290: from_clause_segment :=from_clause_segment||',msc_full_pegging mfpw1,msc_full_pegging mfpe1';
3291: where_clause_segment := where_clause_segment|| ' and mfpe1.prev_pegging_id is null and mfpe1.plan_id=ei.plan_id and mfpe1.sr_instance_id=ei.sr_instance_id and mfpe1.organization_id=ei.organization_id';
3292: where_clause_segment := where_clause_segment|| ' and mfpe1.inventory_item_id=ei.inventory_item_id and mfpw1.plan_id=sup.plan_id and mfpw1.transaction_id=sup.transaction_id and mfpw1.plan_id=mfpe1.plan_id and mfpw1.end_pegging_id=mfpe1.end_pegging_id ';
3293: from_clause_dmd :=from_clause_dmd||',msc_full_pegging mfpw1,msc_full_pegging mfpe1';
3294: where_clause_dmd := where_clause_dmd|| ' and mfpe1.prev_pegging_id is null and mfpe1.plan_id=ei.plan_id and mfpe1.sr_instance_id=ei.sr_instance_id and mfpe1.organization_id=ei.organization_id';
3295: where_clause_dmd := where_clause_dmd|| ' and mfpe1.inventory_item_id=ei.inventory_item_id and mfpw1.plan_id=dmd.plan_id and mfpw1.transaction_id=dmd.demand_id and mfpw1.plan_id=mfpe1.plan_id and mfpw1.end_pegging_id=mfpe1.end_pegging_id ';
3296: END IF;
3297: END IF;

Line 3306: from_clause_segment :=from_clause_segment||',msc_full_pegging mfpw1,msc_full_pegging mfpe1';

3302: END IF;
3303: IF l_mfpw1_flag ='N' AND l_mfpe1_flag='N' THEN
3304: l_mfpw1_flag :='Y';
3305: l_mfpe1_flag :='Y';
3306: from_clause_segment :=from_clause_segment||',msc_full_pegging mfpw1,msc_full_pegging mfpe1';
3307: where_clause_segment := where_clause_segment||
3308: ' and mfpe1.prev_pegging_id is null and mfpe1.plan_id=ei.plan_id and mfpe1.sr_instance_id=ei.sr_instance_id
3309: and mfpe1.organization_id=ei.organization_id';
3310: where_clause_segment := where_clause_segment||' and mfpe1.inventory_item_id=ei.inventory_item_id and mfpw1.plan_id=sup.plan_id and mfpw1.transaction_id=sup.transaction_id';