eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_REL_PS_PLAN_PUB dependencies on MSC_APPS_INSTANCES

Line 177: FROM msc_apps_instances apps,

173: apps.instance_type,
174: DECODE(apps.m2a_dblink,NULL,' ', '@' || m2a_dblink),
175: DECODE(apps.a2m_dblink,NULL,NULL_DBLINK,a2m_dblink),
176: LENGTH( apps.instance_code)+2
177: FROM msc_apps_instances apps,
178: ( SELECT distinct
179: sr_instance_id
180: FROM msc_plan_organizations_v plan_org
181: WHERE plan_org.plan_id = arg_plan_id

Line 1157: msc_apps_instances ins,

1153: 3,
1154: s.sr_instance_id
1155: From msc_supplies s,
1156: msc_operation_networks nwk,
1157: msc_apps_instances ins,
1158: msc_parameters param
1159: Where nwk.plan_id = -1
1160: AND nwk.sr_instance_id = s.sr_instance_id
1161: AND nwk.routing_sequence_id = s.routing_sequence_id

Line 1215: msc_apps_instances ins,

1211: s.sr_instance_id,
1212: max(res.CUMMULATIVE_QUANTITY)
1213: From msc_supplies s,
1214: msc_resource_requirements res,
1215: msc_apps_instances ins,
1216: msc_parameters param
1217: Where res.plan_id = s.plan_id
1218: AND res.sr_instance_id = s.sr_instance_id
1219: AND s.transaction_id = res.supply_id

Line 1332: msc_apps_instances ins,

1328:
1329: decode(nvl(res.schedule_flag,1),-23453,1,1,1,res.schedule_flag)
1330: From msc_supplies s,
1331: msc_resource_requirements res,
1332: msc_apps_instances ins,
1333: msc_parameters param,
1334: msc_department_resources mdr,
1335: msc_system_items msi
1336: Where res.plan_id = s.plan_id

Line 1422: msc_apps_instances ins,

1418: msc_demands md,
1419: msc_system_items icomp,
1420: msc_system_items icomp1,
1421: msc_system_items icomp2,
1422: msc_apps_instances ins,
1423: msc_parameters param
1424: Where /* not exists (select 'x'
1425: from msc_exception_details excp
1426: where excp.plan_id = s.plan_id

Line 1511: msc_apps_instances ins,

1507: res.resource_seq_num,
1508: res.parent_seq_num
1509: From msc_supplies s,
1510: msc_resource_requirements res,
1511: msc_apps_instances ins,
1512: msc_parameters param
1513: Where res.plan_id = s.plan_id
1514: AND res.sr_instance_id = s.sr_instance_id
1515: AND s.transaction_id = res.supply_id

Line 1604: msc_apps_instances ins,

1600: msc_trading_partners tp,
1601: msc_resource_requirements resreq,
1602: msc_resource_instance_reqs res_instreq,
1603: msc_supplies s,
1604: msc_apps_instances ins,
1605: msc_parameters param
1606: WHERE
1607: tp.sr_tp_id=s.organization_id
1608: AND tp.sr_instance_id= s.sr_instance_id

Line 1711: msc_apps_instances ins,

1707: msc_trading_partners tp,
1708: msc_resource_requirements resreq,
1709: msc_resource_instance_reqs res_instreq,
1710: msc_supplies s,
1711: msc_apps_instances ins,
1712: msc_parameters param
1713: WHERE
1714: tp.sr_tp_id=s.organization_id
1715: AND tp.sr_instance_id= s.sr_instance_id

Line 2025: msc_apps_instances ins,

2021: 3,
2022: s.sr_instance_id
2023: From msc_supplies s,
2024: msc_job_operation_networks nwk,
2025: msc_apps_instances ins,
2026: msc_parameters param
2027: Where nwk.plan_id = -1
2028: AND nwk.sr_instance_id = s.sr_instance_id
2029: AND nwk.transaction_id = s.transaction_id

Line 2086: msc_apps_instances ins,

2082: s.sr_instance_id,
2083: max(res.CUMMULATIVE_QUANTITY)
2084: From msc_supplies s,
2085: msc_resource_requirements res,
2086: msc_apps_instances ins,
2087: msc_parameters param
2088: Where res.plan_id = s.plan_id
2089: AND res.sr_instance_id = s.sr_instance_id
2090: AND s.transaction_id = res.supply_id

Line 2209: msc_apps_instances ins,

2205: ),
2206: decode(nvl(res.schedule_flag,1),-23453,1,1,1,res.schedule_flag)
2207: From msc_supplies s,
2208: msc_resource_requirements res,
2209: msc_apps_instances ins,
2210: msc_parameters param,
2211: msc_department_resources mdr,
2212: msc_system_items msi
2213: Where res.plan_id = s.plan_id

Line 2302: msc_apps_instances ins,

2298: msc_demands md,
2299: msc_system_items icomp,
2300: msc_system_items icomp1,
2301: msc_system_items icomp2,
2302: msc_apps_instances ins,
2303: msc_parameters param
2304: Where /* not exists (select 'x'
2305: from msc_exception_details excp
2306: where excp.plan_id = s.plan_id

Line 2394: msc_apps_instances ins,

2390: res.resource_seq_num,
2391: res.parent_seq_num
2392: From msc_supplies s,
2393: msc_resource_requirements res,
2394: msc_apps_instances ins,
2395: msc_parameters param
2396: Where res.plan_id = s.plan_id
2397: AND res.sr_instance_id = s.sr_instance_id
2398: AND s.transaction_id = res.supply_id

Line 2489: msc_apps_instances ins,

2485: FROM msc_trading_partners tp,
2486: msc_resource_requirements resreq,
2487: msc_resource_instance_reqs res_instreq,
2488: msc_supplies s,
2489: msc_apps_instances ins,
2490: msc_parameters param
2491: WHERE
2492: tp.sr_tp_id=s.organization_id
2493: AND tp.sr_instance_id= s.sr_instance_id

Line 2596: msc_apps_instances ins,

2592: msc_trading_partners tp,
2593: msc_resource_requirements resreq,
2594: msc_resource_instance_reqs res_instreq,
2595: msc_supplies s,
2596: msc_apps_instances ins,
2597: msc_parameters param
2598: WHERE
2599: tp.sr_tp_id=s.organization_id
2600: AND tp.sr_instance_id= s.sr_instance_id