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_REL_PLAN_PUB dependencies on MSC_PLANS

Line 1474: from msc_plans a

1470: TYPE CurTyp is ref cursor;
1471:
1472: CURSOR c_plan_type(p_plan_id number) IS
1473: select plan_type
1474: from msc_plans a
1475: where
1476: plan_id = p_plan_id;
1477:
1478: CURSOR c_plan_completion_date(p_plan_id number) IS

Line 1480: from msc_plans

1476: plan_id = p_plan_id;
1477:
1478: CURSOR c_plan_completion_date(p_plan_id number) IS
1479: select plan_completion_date
1480: from msc_plans
1481: where plan_id = p_plan_id;
1482:
1483: CURSOR c_rp_rel_ord is
1484: select s.plan_id,

Line 1499: FROM msc_supplies s, msc_plans p

1495: 11,21,
1496: 12,22,
1497: 13,23,
1498: s.release_status) rp_release_status
1499: FROM msc_supplies s, msc_plans p
1500: WHERE p.plan_id = s.plan_id
1501: AND s.plan_id = arg_plan_id
1502: AND batch_id = g_batch_id;
1503:

Line 1730: --SELECT msc_plans.mrp_plan_type INTO l_plan_type from MSC_PLANS

1726: CLOSE c_plan_type;
1727:
1728: --execute immediate ' SELECT mrp_workbench_query_s@arg_dblink.nextval INTO l_batch_number4 from dual'|| arg_dblink;
1729:
1730: --SELECT msc_plans.mrp_plan_type INTO l_plan_type from MSC_PLANS
1731: --WHERE PLAN_ID = arg_plan_id ;
1732:
1733: IF l_plan_type = 8 THEN
1734:

Line 2035: from msc_plans mp

2031: select decode((mp.daily_material_constraints+ mp.daily_resource_constraints+
2032: mp.weekly_material_constraints+mp.weekly_resource_constraints+
2033: mp.period_material_constraints+mp.period_resource_constraints),12,
2034: 1,0) into v_unconstrained_plan
2035: from msc_plans mp
2036: where plan_id = arg_plan_id;
2037:
2038: if((l_timestamp_profile_val = 'Y') AND (v_unconstrained_plan = 1)) then
2039: v_time_stamp := 86399/86400;

Line 2740: from msc_plans a

2736: c_row_count CurTyp;
2737:
2738: CURSOR c_plan_type(p_plan_id number) IS
2739: select plan_type
2740: from msc_plans a
2741: where
2742: plan_id = p_plan_id;
2743:
2744: l_sql_stmt VARCHAR2(20000):= NULL;

Line 3109: from msc_plans a

3105: c_row_count CurTyp;
3106:
3107: CURSOR c_plan_type(p_plan_id number) IS
3108: select plan_type
3109: from msc_plans a
3110: where
3111: plan_id = p_plan_id;
3112:
3113: l_sql_stmt VARCHAR2(20000):= NULL;

Line 4364: msc_plans mp

4360: FROM msc_supplies s,
4361: msc_plan_organizations_v orgs,
4362: msc_plan_buckets mpb,
4363: msc_system_items msi,
4364: msc_plans mp
4365: WHERE mp.plan_id = :arg_plan_id
4366: AND s.release_errors is NULL
4367: AND nvl(s.cfm_routing_flag,0) = 3
4368: AND s.implement_quantity > 0

Line 5339: FROM msc_plans mp,

5335: 2),
5336: 2),2),2)),
5337: s.organization_id,
5338: s.plan_id
5339: FROM msc_plans mp,
5340: msc_supplies s,
5341: msc_plan_organizations_v orgs,
5342: msc_plan_buckets mpb
5343: WHERE mp.plan_id = :arg_plan_id

Line 6307: from msc_plans a

6303:
6304:
6305: CURSOR c_plan_type(p_plan_id number) IS
6306: select plan_type
6307: from msc_plans a
6308: where
6309: plan_id = p_plan_id;
6310:
6311: l_sub_comp_count NUMBER;

Line 6401: msc_plans mp

6397: FROM msc_supplies s,
6398: msc_plan_organizations_v orgs,
6399: msc_plan_buckets mpb,
6400: msc_system_items msi,
6401: msc_plans mp
6402: WHERE mp.plan_id = :arg_plan_id
6403: AND s.release_errors is NULL
6404: AND s.implement_quantity > 0
6405: AND s.organization_id = orgs.planned_organization

Line 7965: from msc_plans a

7961:
7962:
7963: CURSOR c_plan_type(p_plan_id number) IS
7964: select plan_type
7965: from msc_plans a
7966: where
7967: plan_id = p_plan_id;
7968:
7969: l_count NUMBER := 0;

Line 8011: msc_plans mp,

8007: NVL(s.implement_quantity, 0),
8008: NVL(s.qty_scrapped, 0),
8009: NVL(s.qty_completed, 0)
8010: FROM msc_supplies s,
8011: msc_plans mp,
8012: msc_plan_organizations_v orgs,
8013: msc_plan_buckets mpb
8014: WHERE s.release_errors is NULL
8015: AND s.implement_quantity > 0

Line 10395: from msc_plans a

10391: group by maintenance_object_source;
10392:
10393: CURSOR c_plan_type(p_plan_id number) IS
10394: select plan_type
10395: from msc_plans a
10396: where
10397: plan_id = p_plan_id;
10398:
10399: l_sub_comp_count NUMBER;

Line 10461: msc_plans mp,

10457: FROM msc_supplies s,
10458: msc_plan_organizations_v orgs,
10459: msc_plan_buckets mpb,
10460: msc_system_items msi,
10461: msc_plans mp,
10462: msc_item_attributes msa
10463: WHERE mp.plan_id = :p_arg_plan_id
10464: AND s.release_errors is NULL
10465: AND s.implement_quantity > 0

Line 10766: from msc_plans a

10762:
10763:
10764: CURSOR c_plan_type(p_plan_id number) IS
10765: select plan_type
10766: from msc_plans a
10767: where
10768: plan_id = p_plan_id;
10769:
10770: l_count NUMBER := 0;

Line 10807: msc_plans mp,

10803: NVL(s.implement_quantity, 0),
10804: NVL(s.qty_scrapped, 0),
10805: NVL(s.qty_completed, 0)
10806: FROM msc_supplies s,
10807: msc_plans mp,
10808: msc_plan_organizations_v orgs,
10809: msc_plan_buckets mpb
10810: WHERE s.release_errors is NULL
10811: AND s.implement_quantity > 0

Line 12095: from msc_plans a

12091:
12092:
12093: CURSOR c_plan_type(p_plan_id number) IS
12094: select plan_type
12095: from msc_plans a
12096: where
12097: plan_id = p_plan_id;
12098:
12099: l_count NUMBER := 0;

Line 12136: msc_plans mp,

12132: NVL(s.implement_quantity, 0),
12133: NVL(s.qty_scrapped, 0),
12134: NVL(s.qty_completed, 0)
12135: FROM msc_supplies s,
12136: msc_plans mp,
12137: msc_plan_organizations_v orgs,
12138: msc_plan_buckets mpb
12139: WHERE s.release_errors is NULL
12140: AND s.implement_quantity > 0