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_DEPARTMENT_RESOURCES

Line 350: msc_department_resources mdr,

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
354: and msi.sr_inventory_item_id = p_assembly_pk

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 388: /* msc_department_resources and msc_plan_organizations */

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
388: /* msc_department_resources and msc_plan_organizations */
389: and decode(mdr.resource_id,-1,mdr.department_code,mdr.resource_code)= p_component_pk
390: and mdr.plan_id = p_supply_plan_id
391: and mdr.sr_instance_id = p_instance_id
392: and mdr.organization_id = mpo2.organization_id

Line 466: msc_department_resources mdr,

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
470: and msi.sr_inventory_item_id = p_assembly_pk

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 498: /* msc_department_resources and msc_plan_organizations - component */

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
498: /* msc_department_resources and msc_plan_organizations - component */
499: and decode(mdr.resource_id,-1,mdr.department_code,mdr.resource_code)= p_component_pk
500: and mdr.plan_id = mpo2.plan_id
501: and mdr.sr_instance_id = mpo2.sr_instance_id
502: and mdr.organization_id = mpo2.organization_id

Line 1110: msc_department_resources mdr,

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
1114: mpo1.plan_id = p_supply_plan_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

Line 1146: /* msc_department_resources and msd_level_values */

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
1146: /* msc_department_resources and msd_level_values */
1147: and mlv2.instance = mdr.sr_instance_id
1148: and mlv2.level_id = 1
1149: and mlv2.sr_level_pk = decode(mdr.resource_id,-1,'L'||'.'||mdr.department_code,'R'||'.'||mdr.resource_code)
1150: /* msc_department_resources and msc_plan_organizations */

Line 1150: /* msc_department_resources and msc_plan_organizations */

1146: /* msc_department_resources and msd_level_values */
1147: and mlv2.instance = mdr.sr_instance_id
1148: and mlv2.level_id = 1
1149: and mlv2.sr_level_pk = decode(mdr.resource_id,-1,'L'||'.'||mdr.department_code,'R'||'.'||mdr.resource_code)
1150: /* msc_department_resources and msc_plan_organizations */
1151: and mdr.plan_id = mpo2.plan_id
1152: and mdr.sr_instance_id = mpo2.sr_instance_id
1153: and mdr.organization_id = mpo2.organization_id
1154: and mpo2.plan_id = p_supply_plan_id