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 757: from msc_plan_organizations mp,

753: select distinct mp.sr_instance_id,
754: decode(mai.M2A_dblink,null,' ','@'||mai.M2A_dblink),
755: nvl(mai.A2M_dblink, '-1'),
756: mai.instance_code
757: from msc_plan_organizations mp,
758: msc_apps_instances mai
759: where plan_id = arg_plan_id
760: and mp.sr_instance_id = mai.instance_id
761: and mai.instance_type <> 3 -- xml fix

Line 766: from msc_plan_organizations mp,

762: and nvl(mai.apps_ver,1) <> 1; -- not back port to 107 yet
763:
764: CURSOR leg_instance_cur IS
765: select distinct mp.sr_instance_id
766: from msc_plan_organizations mp,
767: msc_apps_instances mai
768: where plan_id = arg_plan_id
769: and mp.sr_instance_id = mai.instance_id
770: and mai.instance_type = 3; -- xml fix

Line 1228: from msc_plan_organizations mp,

1224: CURSOR instance_cur IS
1225: select distinct mp.sr_instance_id,
1226: decode(mai.M2A_dblink,null,' ','@'||mai.M2A_dblink),
1227: decode(mai.A2M_dblink,null,' ','@'||mai.A2M_dblink)
1228: from msc_plan_organizations mp,
1229: msc_apps_instances mai
1230: where plan_id = arg_plan_id
1231: and mp.sr_instance_id = mai.instance_id
1232: -- and mai.instance_type <> 3 -- xml fix

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,