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.MSD_SALES_OPERATION_PLAN dependencies on MSC_RESOURCE_REQUIREMENTS

Line 349: msc_resource_requirements mrr,

345: msc_demands md,
346: msc_full_pegging mfp1,
347: msc_full_pegging mfp2,
348: msc_supplies ms2,
349: msc_resource_requirements mrr,
350: msc_department_resources mdr,
351: msc_plan_organizations mpo2
352: where
353: mpo1.plan_id = p_supply_plan_id

Line 373: /* msc_full_pegging2 and msc_resource_requirements */

369: /*msc_full_pegging1 and msc_full_pegging2 */
370: and mfp1.pegging_id = mfp2.end_pegging_id
371: and mfp1.plan_id = mfp2.plan_id
372: and mfp1.sr_instance_id = mfp2.sr_instance_id -- (No organization id join between mfp1 and mfp2 because single demand can span across various orgs.
373: /* msc_full_pegging2 and msc_resource_requirements */
374: and mfp2.transaction_id = mrr.supply_id
375: and mfp2.plan_id = mrr.plan_id
376: and mfp2.sr_instance_id = mrr.sr_instance_id
377: and mfp2.organization_id = mrr.organization_id

Line 383: /* msc_resource_requirements and msc_department_resources */

379: and ms2.transaction_id = mfp2.transaction_id
380: and ms2.plan_id = mfp2.plan_id
381: and ms2.sr_instance_id = mfp2.sr_instance_id
382: and ms2.organization_id = mfp2.organization_id
383: /* msc_resource_requirements and msc_department_resources */
384: and mrr.resource_id = mdr.resource_id
385: and mrr.plan_id = mdr.plan_id
386: and mrr.sr_instance_id = mdr.sr_instance_id
387: and mrr.organization_id = mdr.organization_id

Line 465: msc_resource_requirements mrr,

461: msc_system_items msi,
462: msc_supplies ms,
463: msc_full_pegging mfp1,
464: msc_full_pegging mfp2,
465: msc_resource_requirements mrr,
466: msc_department_resources mdr,
467: msc_plan_organizations mpo2
468: where
469: mpo1.plan_id = p_supply_plan_id

Line 488: /* msc_full_pegging2 - component and msc_resource_requirements */

484: /*msc_full_pegging1 - assembly and msc_full_pegging2 - component */
485: and mfp1.pegging_id = mfp2.end_pegging_id
486: and mfp1.plan_id = mfp2.plan_id
487: and mfp1.sr_instance_id = mfp2.sr_instance_id -- (No organization id join between mfp1 and mfp2 because single demand ca span across various orgs.
488: /* msc_full_pegging2 - component and msc_resource_requirements */
489: and mfp2.transaction_id = mrr.supply_id
490: and mfp2.plan_id = mrr.plan_id
491: and mfp2.sr_instance_id = mrr.sr_instance_id
492: and mfp2.organization_id = mrr.organization_id

Line 493: /* msc_resource_requirements and msc_department_resources */

489: and mfp2.transaction_id = mrr.supply_id
490: and mfp2.plan_id = mrr.plan_id
491: and mfp2.sr_instance_id = mrr.sr_instance_id
492: and mfp2.organization_id = mrr.organization_id
493: /* msc_resource_requirements and msc_department_resources */
494: and mrr.resource_id = mdr.resource_id
495: and mrr.plan_id = mdr.plan_id
496: and mrr.sr_instance_id = mdr.sr_instance_id
497: and mrr.organization_id = mdr.organization_id

Line 1109: msc_resource_requirements mrr,

1105: msd_level_values mlv1,
1106: msc_demands md,
1107: msc_full_pegging mfp1,
1108: msc_full_pegging mfp2,
1109: msc_resource_requirements mrr,
1110: msc_department_resources mdr,
1111: msd_level_values mlv2,
1112: msc_plan_organizations mpo2
1113: where

Line 1136: /* msc_full_pegging2 and msc_resource_requirements */

1132: /*msc_full_pegging1 and msc_full_pegging2 */
1133: and mfp1.pegging_id = mfp2.end_pegging_id
1134: and mfp1.plan_id = mfp2.plan_id
1135: and mfp1.sr_instance_id = mfp2.sr_instance_id -- (No organization id join between mfp1 and mfp2 because single demand ca span across various orgs.
1136: /* msc_full_pegging2 and msc_resource_requirements */
1137: and mfp2.transaction_id = mrr.supply_id
1138: and mfp2.plan_id = mrr.plan_id
1139: and mfp2.sr_instance_id = mrr.sr_instance_id
1140: and mfp2.organization_id = mrr.organization_id

Line 1141: /* msc_resource_requirements and msc_department_resources */

1137: and mfp2.transaction_id = mrr.supply_id
1138: and mfp2.plan_id = mrr.plan_id
1139: and mfp2.sr_instance_id = mrr.sr_instance_id
1140: and mfp2.organization_id = mrr.organization_id
1141: /* msc_resource_requirements and msc_department_resources */
1142: and mrr.resource_id = mdr.resource_id
1143: and mrr.plan_id = mdr.plan_id
1144: and mrr.sr_instance_id = mdr.sr_instance_id
1145: and mrr.organization_id = mdr.organization_id