APPS.MSC_REL_WF dependencies on MSC_PLAN_ORGANIZATIONS

Line 21: msc_plan_organizations_v orgs

17:
18: CURSOR po_res IS
19: SELECT s.transaction_id, s.sr_instance_id
20: FROM msc_supplies s,
21: msc_plan_organizations_v orgs
22: where s.release_errors is NULL
23: AND s.po_line_id is not null
24: AND s.plan_id = orgs.plan_id
25: and s.load_type = PURCHASE_ORDER_RESCHEDULE

Line 42: msc_plan_organizations_v orgs

38:
39: CURSOR req_res IS
40: SELECT s.transaction_id, s.sr_instance_id
41: FROM msc_supplies s,
42: msc_plan_organizations_v orgs
43: where s.release_errors is NULL
44: AND s.plan_id = orgs.plan_id
45: and s.load_type = PURCHASE_REQ_RESCHEDULE
46: and s.order_type = PURCHASE_REQ

Line 65: msc_plan_organizations_v orgs

61: SELECT distinct mai.instance_id,
62: decode(mai.m2a_dblink, null,' ','@'||m2a_dblink),
63: mai.instance_code
64: FROM msc_apps_instances mai,
65: msc_plan_organizations_v orgs
66: where orgs.organization_id = arg_owning_org_id
67: AND orgs.owning_sr_instance = arg_owning_instance
68: AND orgs.plan_id = arg_plan_id
69: AND orgs.planned_organization = decode(arg_org_id,

Line 777: from msc_plan_organizations mp,

773: select distinct mp.sr_instance_id,
774: decode(mai.M2A_dblink,null,' ','@'||mai.M2A_dblink),
775: nvl(mai.A2M_dblink, '-1'),
776: mai.instance_code
777: from msc_plan_organizations mp,
778: msc_apps_instances mai
779: where plan_id = arg_plan_id
780: and mp.sr_instance_id = mai.instance_id
781: and mai.instance_type <> 3 -- xml fix

Line 786: from msc_plan_organizations mp,

782: and nvl(mai.apps_ver,1) <> 1; -- not back port to 107 yet
783:
784: CURSOR leg_instance_cur IS
785: select distinct mp.sr_instance_id
786: from msc_plan_organizations mp,
787: msc_apps_instances mai
788: where plan_id = arg_plan_id
789: and mp.sr_instance_id = mai.instance_id
790: and mai.instance_type = 3; -- xml fix

Line 1380: from msc_plan_organizations mp,

1376: CURSOR instance_cur IS
1377: select distinct mp.sr_instance_id,
1378: decode(mai.M2A_dblink,null,' ','@'||mai.M2A_dblink),
1379: decode(mai.A2M_dblink,null,' ','@'||mai.A2M_dblink)
1380: from msc_plan_organizations mp,
1381: msc_apps_instances mai
1382: where plan_id = arg_plan_id
1383: and mp.sr_instance_id = mai.instance_id
1384: -- and mai.instance_type <> 3 -- xml fix

Line 2147: from msc_plan_organizations_v

2143: implement_alternate_bom = NULL,
2144: implement_alternate_routing = NULL
2145: WHERE organization_id IN
2146: (select planned_organization
2147: from msc_plan_organizations_v
2148: where organization_id = p_owning_org
2149: and owning_sr_instance = p_owning_instance
2150: and plan_id = p_plan_id
2151: AND planned_organization = decode(p_org_id,