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_SYSTEM_ITEMS

Line 879: msc_system_items msi,

875: lv_org_id,
876: lv_plan_id
877: FROM msc_supplies s,
878: msc_plan_organizations_v orgs,
879: msc_system_items msi,
880: msc_plans mp
881: WHERE mp.plan_id = arg_plan_id
882: AND s.release_errors is NULL
883: AND nvl(s.cfm_routing_flag,0) = 3

Line 1309: msc_system_items msi

1305: msc_resource_requirements res,
1306: msc_apps_instances ins,
1307: msc_parameters param,
1308: msc_department_resources mdr,
1309: msc_system_items msi
1310: Where res.plan_id = s.plan_id
1311: AND res.sr_instance_id = s.sr_instance_id
1312: AND s.transaction_id = res.supply_id
1313: AND res.parent_id = 2

Line 1393: msc_system_items icomp,

1389: 3,
1390: s.sr_instance_id
1391: From msc_supplies s,
1392: msc_demands md,
1393: msc_system_items icomp,
1394: msc_system_items icomp1,
1395: msc_system_items icomp2,
1396: msc_apps_instances ins,
1397: msc_parameters param

Line 1394: msc_system_items icomp1,

1390: s.sr_instance_id
1391: From msc_supplies s,
1392: msc_demands md,
1393: msc_system_items icomp,
1394: msc_system_items icomp1,
1395: msc_system_items icomp2,
1396: msc_apps_instances ins,
1397: msc_parameters param
1398: Where /* not exists (select 'x'

Line 1395: msc_system_items icomp2,

1391: From msc_supplies s,
1392: msc_demands md,
1393: msc_system_items icomp,
1394: msc_system_items icomp1,
1395: msc_system_items icomp2,
1396: msc_apps_instances ins,
1397: msc_parameters param
1398: Where /* not exists (select 'x'
1399: from msc_exception_details excp

Line 1908: -- bugbug Is this right for Uom. R12 looks in msc_system_items if not here.

1904: 2,
1905: 1,
1906: 'Y',
1907: s.transaction_id,
1908: -- bugbug Is this right for Uom. R12 looks in msc_system_items if not here.
1909: s.implement_uom_code,
1910: s.sr_instance_id,
1911: item_lid.sr_inventory_item_id, -- msi.sr_inventory_item_id, -- ey, if you don't flush msc_system_items, you need to somehow pass the source_inventory_item_id to here MN: use msc_iten_id_lid
1912:

Line 1911: item_lid.sr_inventory_item_id, -- msi.sr_inventory_item_id, -- ey, if you don't flush msc_system_items, you need to somehow pass the source_inventory_item_id to here MN: use msc_iten_id_lid

1907: s.transaction_id,
1908: -- bugbug Is this right for Uom. R12 looks in msc_system_items if not here.
1909: s.implement_uom_code,
1910: s.sr_instance_id,
1911: item_lid.sr_inventory_item_id, -- msi.sr_inventory_item_id, -- ey, if you don't flush msc_system_items, you need to somehow pass the source_inventory_item_id to here MN: use msc_iten_id_lid
1912:
1913: s.transaction_id, --Outbound Changes for XML
1914: s.schedule_priority,
1915: s.requested_completion_date

Line 2185: msc_system_items msi

2181: msc_resource_requirements res,
2182: msc_apps_instances ins,
2183: msc_parameters param,
2184: msc_department_resources mdr,
2185: msc_system_items msi
2186: Where res.plan_id = s.plan_id
2187: AND res.sr_instance_id = s.sr_instance_id
2188: AND s.transaction_id = res.supply_id
2189: AND res.parent_id = 2

Line 2272: msc_system_items icomp,

2268: 3,
2269: s.sr_instance_id
2270: From msc_supplies s,
2271: msc_demands md,
2272: msc_system_items icomp,
2273: msc_system_items icomp1,
2274: msc_system_items icomp2,
2275: msc_apps_instances ins,
2276: msc_parameters param

Line 2273: msc_system_items icomp1,

2269: s.sr_instance_id
2270: From msc_supplies s,
2271: msc_demands md,
2272: msc_system_items icomp,
2273: msc_system_items icomp1,
2274: msc_system_items icomp2,
2275: msc_apps_instances ins,
2276: msc_parameters param
2277: Where /* not exists (select 'x'

Line 2274: msc_system_items icomp2,

2270: From msc_supplies s,
2271: msc_demands md,
2272: msc_system_items icomp,
2273: msc_system_items icomp1,
2274: msc_system_items icomp2,
2275: msc_apps_instances ins,
2276: msc_parameters param
2277: Where /* not exists (select 'x'
2278: from msc_exception_details excp

Line 2676: msc_system_items msi, -- REMOVE

2672: lv_plan_id,
2673: lv_round_primary_item
2674: FROM msc_supplies s,
2675: msc_plan_organizations_v orgs,
2676: msc_system_items msi, -- REMOVE
2677: msc_plans mp
2678: WHERE mp.plan_id = arg_plan_id
2679: AND s.release_errors is NULL
2680: AND s.implement_quantity > 0

Line 3196: msc_system_items icomp, -- bugbug ey, should this be msc_item_id_lid or msi?

3192: -- bugbug Should we check sys_items for uom_code?
3193: s.implement_uom_code,
3194: s.sr_instance_id
3195: FROM msc_trading_partners tp,
3196: msc_system_items icomp, -- bugbug ey, should this be msc_item_id_lid or msi?
3197: msc_demands md,
3198: msc_parameters param,
3199: msc_supplies s
3200: WHERE

Line 3940: item_lid.sr_inventory_item_id, -- msi.sr_inventory_item_id, -- ey, if you don't flush msc_system_items, you need to somehow pass the source_inventory_item_id to here MN: use msc_iten_id_lid

3936: 'Y',
3937: s.transaction_id,
3938: s.sr_instance_id,
3939: s.implement_uom_code, -- bugbug MN: NOTE: this can not be null
3940: item_lid.sr_inventory_item_id, -- msi.sr_inventory_item_id, -- ey, if you don't flush msc_system_items, you need to somehow pass the source_inventory_item_id to here MN: use msc_iten_id_lid
3941: s.transaction_id, --Outbound Changes for XML
3942: s.schedule_priority, --dsr
3943: s.requested_completion_date -- dsr
3944: FROM msc_trading_partners tp,

Line 4284: msc_system_items msi,

4280: s.disposition_id
4281: FROM msc_trading_partners tp,
4282: msc_demands md,
4283: msc_parameters param,
4284: msc_system_items msi,
4285: msc_supplies s
4286: -- bugbug Is this join correct?
4287: WHERE tp.sr_tp_id= msi.organization_id -- ey, should be s.organization_id
4288: AND tp.sr_instance_id= s.sr_instance_id -- ey, s.sr_instance_id