APPS.MSC_REL_PLAN_PUB dependencies on MSC_PLANS

Line 1235: from msc_plans a

1231: TYPE CurTyp is ref cursor;
1232:
1233: CURSOR c_plan_type(p_plan_id number) IS
1234: select plan_type
1235: from msc_plans a
1236: where
1237: plan_id = p_plan_id;
1238:
1239: VERSION CONSTANT CHAR(80) :=

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

1441: CLOSE c_plan_type;
1442:
1443: --execute immediate ' SELECT mrp_workbench_query_s@arg_dblink.nextval INTO l_batch_number4 from dual'|| arg_dblink;
1444:
1445: --SELECT msc_plans.mrp_plan_type INTO l_plan_type from MSC_PLANS
1446: --WHERE PLAN_ID = arg_plan_id ;
1447:
1448: IF l_plan_type = 8 THEN
1449:

Line 2207: from msc_plans a

2203: c_row_count CurTyp;
2204:
2205: CURSOR c_plan_type(p_plan_id number) IS
2206: select plan_type
2207: from msc_plans a
2208: where
2209: plan_id = p_plan_id;
2210:
2211: l_sql_stmt VARCHAR2(20000):= NULL;

Line 2571: from msc_plans a

2567: c_row_count CurTyp;
2568:
2569: CURSOR c_plan_type(p_plan_id number) IS
2570: select plan_type
2571: from msc_plans a
2572: where
2573: plan_id = p_plan_id;
2574:
2575: l_sql_stmt VARCHAR2(20000):= NULL;

Line 3815: msc_plans mp

3811: FROM msc_supplies s,
3812: msc_plan_organizations_v orgs,
3813: msc_plan_buckets mpb,
3814: msc_system_items msi,
3815: msc_plans mp
3816: WHERE mp.plan_id = :arg_plan_id
3817: AND s.release_errors is NULL
3818: AND nvl(s.cfm_routing_flag,0) = 3
3819: AND s.implement_quantity > 0

Line 4790: FROM msc_plans mp,

4786: 2),
4787: 2),2),2)),
4788: s.organization_id,
4789: s.plan_id
4790: FROM msc_plans mp,
4791: msc_supplies s,
4792: msc_plan_organizations_v orgs,
4793: msc_plan_buckets mpb
4794: WHERE mp.plan_id = :arg_plan_id

Line 5738: from msc_plans a

5734:
5735:
5736: CURSOR c_plan_type(p_plan_id number) IS
5737: select plan_type
5738: from msc_plans a
5739: where
5740: plan_id = p_plan_id;
5741:
5742: l_sub_comp_count NUMBER;

Line 5812: msc_plans mp

5808: FROM msc_supplies s,
5809: msc_plan_organizations_v orgs,
5810: msc_plan_buckets mpb,
5811: msc_system_items msi,
5812: msc_plans mp
5813: WHERE mp.plan_id = :arg_plan_id
5814: AND s.release_errors is NULL
5815: AND s.implement_quantity > 0
5816: AND s.organization_id = orgs.planned_organization

Line 7274: from msc_plans a

7270:
7271:
7272: CURSOR c_plan_type(p_plan_id number) IS
7273: select plan_type
7274: from msc_plans a
7275: where
7276: plan_id = p_plan_id;
7277:
7278: l_count NUMBER := 0;

Line 7301: msc_plans mp,

7297: 2),2)),
7298: s.organization_id,
7299: s.plan_id
7300: FROM msc_supplies s,
7301: msc_plans mp,
7302: msc_plan_organizations_v orgs,
7303: msc_plan_buckets mpb
7304: WHERE s.release_errors is NULL
7305: AND s.implement_quantity > 0