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 778: msc_apps_instances mai

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

Line 787: msc_apps_instances mai

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

Line 857: FROM msc_apps_instances mai, -- xml fix

853: p_distribution_id,
854: p_uom_code,
855: p_operating_unit,
856: p_action
857: FROM msc_apps_instances mai, -- xml fix
858: msc_system_items msi,
859: msc_trading_partners mp,
860: msc_supplies s
861: WHERE msi.inventory_item_id = s.inventory_item_id

Line 918: FROM msc_apps_instances mai, -- xml fix

914: p_distribution_id,
915: p_uom_code,
916: p_operating_unit,
917: p_action
918: FROM msc_apps_instances mai, -- xml fix
919: msc_system_items msi,
920: msc_trading_partners mp,
921: msc_supplies s
922: WHERE msi.inventory_item_id = s.inventory_item_id

Line 1027: FROM msc_apps_instances mai,

1023: p_po_line_id,
1024: p_po_number,
1025: p_po_quantity,
1026: p_plan_id
1027: FROM msc_apps_instances mai,
1028: msc_system_items msi,
1029: msc_supplies s
1030: WHERE msi.inventory_item_id = s.inventory_item_id
1031: AND msi.plan_id = s.plan_id

Line 1085: FROM msc_apps_instances mai,

1081: p_po_line_id,
1082: p_po_number,
1083: p_po_quantity,
1084: p_plan_id
1085: FROM msc_apps_instances mai,
1086: msc_system_items msi,
1087: msc_supplies s
1088: WHERE msi.inventory_item_id = s.inventory_item_id
1089: AND msi.plan_id = s.plan_id

Line 1381: msc_apps_instances mai

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

Line 1772: from msc_apps_instances

1768:
1769: Function get_job_seq_from_source(p_instance_id number) RETURN number IS
1770: CURSOR db_cur IS
1771: select decode(M2A_dblink,null,' ','@'||M2A_dblink)
1772: from msc_apps_instances
1773: where instance_id = p_instance_id;
1774:
1775: db_link varchar2(128);
1776: seq_num number;

Line 1855: from msc_apps_instances

1851:
1852: CURSOR db_cur IS
1853: select decode(M2A_dblink,null,' ','@'||M2A_dblink),
1854: apps_ver
1855: from msc_apps_instances
1856: where instance_id = p_instance_id;
1857:
1858: db_link varchar2(128);
1859: apps_version number;

Line 1925: from msc_apps_instances

1921: p_project_id number, p_instance_id number) RETURN varchar2 IS
1922: CURSOR db_cur IS
1923: select decode(M2A_dblink,null,' ','@'||M2A_dblink),apps_ver
1924:
1925: from msc_apps_instances
1926: where instance_id = p_instance_id;
1927:
1928: db_link varchar2(128);
1929:

Line 1975: from msc_apps_instances

1971:
1972: Function is_source_db_up(p_instance_id number) RETURN boolean IS
1973: CURSOR db_cur IS
1974: select decode(M2A_dblink,null,' ','@'||M2A_dblink)
1975: from msc_apps_instances
1976: where instance_id = p_instance_id;
1977:
1978: db_link varchar2(128);
1979: seq_num number;

Line 2184: from msc_apps_instances

2180: p_instance_code varchar2(10);
2181:
2182: cursor apps_ver_cur IS
2183: select apps_ver
2184: from msc_apps_instances
2185: where instance_id = p_instance_id;
2186: BEGIN
2187: if (funcmode = 'RUN') then
2188: p_load_type :=

Line 2700: FROM msc_apps_instances

2696:
2697: SELECT DECODE( M2A_DBLINK, NULL, ' ', '@'||M2A_DBLINK),
2698: DECODE( M2A_DBLINK, NULL, ' ', M2A_DBLINK)
2699: INTO lv_dblink, lv_dblink2
2700: FROM msc_apps_instances
2701: WHERE instance_id = p_instance_id;
2702:
2703: SELECT FND_GLOBAL.USER_NAME,
2704: FND_GLOBAL.RESP_NAME,