APPS.MSC_REL_WF dependencies on MSC_APPS_INSTANCES

Line 64: FROM msc_apps_instances mai,

60: CURSOR instances_cur IS
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

Line 155: FROM msc_apps_instances mai

151:
152: CURSOR instance_cur IS
153: SELECT decode(mai.m2a_dblink, null,' ','@'||m2a_dblink),
154: mai.instance_code
155: FROM msc_apps_instances mai
156: WHERE mai.instance_id = p_instance_id;
157: BEGIN
158: deleteActivities(p_item_key);
159:

Line 758: msc_apps_instances mai

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
762: and nvl(mai.apps_ver,1) <> 1; -- not back port to 107 yet

Line 767: msc_apps_instances mai

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
771:

Line 830: FROM msc_apps_instances mai, -- xml fix

826: p_distribution_id,
827: p_uom_code,
828: p_operating_unit,
829: p_action
830: FROM msc_apps_instances mai, -- xml fix
831: msc_system_items msi,
832: msc_trading_partners mp,
833: msc_supplies s
834: WHERE msi.inventory_item_id = s.inventory_item_id

Line 937: FROM msc_apps_instances mai,

933: p_po_line_id,
934: p_po_number,
935: p_po_quantity,
936: p_plan_id
937: FROM msc_apps_instances mai,
938: msc_system_items msi,
939: msc_supplies s
940: WHERE msi.inventory_item_id = s.inventory_item_id
941: AND msi.plan_id = s.plan_id

Line 1229: msc_apps_instances mai

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
1233: and nvl(mai.apps_ver,1) <> 1; -- not back port to 107 yet

Line 1537: from msc_apps_instances

1533:
1534: Function get_job_seq_from_source(p_instance_id number) RETURN number IS
1535: CURSOR db_cur IS
1536: select decode(M2A_dblink,null,' ','@'||M2A_dblink)
1537: from msc_apps_instances
1538: where instance_id = p_instance_id;
1539:
1540: db_link varchar2(128);
1541: seq_num number;

Line 1620: from msc_apps_instances

1616:
1617: CURSOR db_cur IS
1618: select decode(M2A_dblink,null,' ','@'||M2A_dblink),
1619: apps_ver
1620: from msc_apps_instances
1621: where instance_id = p_instance_id;
1622:
1623: db_link varchar2(128);
1624: apps_version number;

Line 1690: from msc_apps_instances

1686: p_project_id number, p_instance_id number) RETURN varchar2 IS
1687: CURSOR db_cur IS
1688: select decode(M2A_dblink,null,' ','@'||M2A_dblink),apps_ver
1689:
1690: from msc_apps_instances
1691: where instance_id = p_instance_id;
1692:
1693: db_link varchar2(128);
1694:

Line 1740: from msc_apps_instances

1736:
1737: Function is_source_db_up(p_instance_id number) RETURN boolean IS
1738: CURSOR db_cur IS
1739: select decode(M2A_dblink,null,' ','@'||M2A_dblink)
1740: from msc_apps_instances
1741: where instance_id = p_instance_id;
1742:
1743: db_link varchar2(128);
1744: seq_num number;

Line 1933: from msc_apps_instances

1929: p_instance_code varchar2(10);
1930:
1931: cursor apps_ver_cur IS
1932: select apps_ver
1933: from msc_apps_instances
1934: where instance_id = p_instance_id;
1935: BEGIN
1936: if (funcmode = 'RUN') then
1937: p_load_type :=

Line 2449: FROM msc_apps_instances

2445:
2446: SELECT DECODE( M2A_DBLINK, NULL, ' ', '@'||M2A_DBLINK),
2447: DECODE( M2A_DBLINK, NULL, ' ', M2A_DBLINK)
2448: INTO lv_dblink, lv_dblink2
2449: FROM msc_apps_instances
2450: WHERE instance_id = p_instance_id;
2451:
2452: SELECT FND_GLOBAL.USER_NAME,
2453: FND_GLOBAL.RESP_NAME,