APPS.MSC_REL_WF dependencies on MSC_PLAN_ORGANIZATIONS_V

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 1896: from msc_plan_organizations_v

1892: implement_alternate_bom = NULL,
1893: implement_alternate_routing = NULL
1894: WHERE organization_id IN
1895: (select planned_organization
1896: from msc_plan_organizations_v
1897: where organization_id = p_owning_org
1898: and owning_sr_instance = p_owning_instance
1899: and plan_id = p_plan_id
1900: AND planned_organization = decode(p_org_id,