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 905: msc_system_items msi,

901: lv_org_id,
902: lv_plan_id
903: FROM msc_supplies s,
904: msc_plan_organizations_v orgs,
905: msc_system_items msi,
906: msc_plans mp
907: WHERE mp.plan_id = arg_plan_id
908: AND s.release_errors is NULL
909: AND nvl(s.cfm_routing_flag,0) = 3

Line 1335: msc_system_items msi

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
1337: AND res.sr_instance_id = s.sr_instance_id
1338: AND s.transaction_id = res.supply_id
1339: AND res.parent_id = 2

Line 1419: msc_system_items icomp,

1415: 3,
1416: s.sr_instance_id
1417: From msc_supplies s,
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

Line 1420: msc_system_items icomp1,

1416: s.sr_instance_id
1417: From msc_supplies s,
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'

Line 1421: msc_system_items icomp2,

1417: From msc_supplies s,
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

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

1931: 2,
1932: 1,
1933: 'Y',
1934: s.transaction_id,
1935: -- bugbug Is this right for Uom. R12 looks in msc_system_items if not here.
1936: s.implement_uom_code,
1937: s.sr_instance_id,
1938: 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
1939:

Line 1938: 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

1934: s.transaction_id,
1935: -- bugbug Is this right for Uom. R12 looks in msc_system_items if not here.
1936: s.implement_uom_code,
1937: s.sr_instance_id,
1938: 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
1939:
1940: s.transaction_id, --Outbound Changes for XML
1941: s.schedule_priority,
1942: s.requested_completion_date

Line 2212: msc_system_items msi

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
2214: AND res.sr_instance_id = s.sr_instance_id
2215: AND s.transaction_id = res.supply_id
2216: AND res.parent_id = 2

Line 2299: msc_system_items icomp,

2295: 3,
2296: s.sr_instance_id
2297: From msc_supplies s,
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

Line 2300: msc_system_items icomp1,

2296: s.sr_instance_id
2297: From msc_supplies s,
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'

Line 2301: msc_system_items icomp2,

2297: From msc_supplies s,
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

Line 2703: msc_system_items msi, -- REMOVE

2699: lv_plan_id,
2700: lv_round_primary_item
2701: FROM msc_supplies s,
2702: msc_plan_organizations_v orgs,
2703: msc_system_items msi, -- REMOVE
2704: msc_plans mp
2705: WHERE mp.plan_id = arg_plan_id
2706: AND s.release_errors is NULL
2707: AND s.implement_quantity > 0

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

3219: -- bugbug Should we check sys_items for uom_code?
3220: s.implement_uom_code,
3221: s.sr_instance_id
3222: FROM msc_trading_partners tp,
3223: msc_system_items icomp, -- bugbug ey, should this be msc_item_id_lid or msi?
3224: msc_demands md,
3225: msc_parameters param,
3226: msc_supplies s
3227: WHERE

Line 3968: 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

3964: 'Y',
3965: s.transaction_id,
3966: s.sr_instance_id,
3967: s.implement_uom_code, -- bugbug MN: NOTE: this can not be null
3968: 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
3969: s.transaction_id, --Outbound Changes for XML
3970: s.schedule_priority, --dsr
3971: s.requested_completion_date -- dsr
3972: FROM msc_trading_partners tp,

Line 4108: 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

4104: 'N',
4105: s.transaction_id,
4106: s.sr_instance_id,
4107: s.implement_uom_code, -- bugbug MN: NOTE: this can not be null
4108: 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
4109: s.transaction_id, --Outbound Changes for XML
4110: s.schedule_priority, --dsr
4111: s.requested_completion_date -- dsr
4112: FROM msc_trading_partners tp,

Line 4245: 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

4241: 'Y',
4242: s.transaction_id,
4243: s.sr_instance_id,
4244: s.implement_uom_code, -- bugbug MN: NOTE: this can not be null
4245: 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
4246: s.transaction_id, --Outbound Changes for XML
4247: s.schedule_priority, --dsr
4248: s.requested_completion_date -- dsr
4249: FROM msc_trading_partners tp,

Line 4588: msc_system_items msi,

4584: s.implement_uom_code, -- bugbug MN: again, is this correct?
4585: s.disposition_id
4586: FROM msc_trading_partners tp,
4587: msc_demands md,
4588: msc_system_items msi,
4589: msc_supplies s
4590: -- bugbug Is this join correct?
4591: WHERE tp.sr_tp_id= msi.organization_id -- ey, should be s.organization_id
4592: AND tp.sr_instance_id= s.sr_instance_id -- ey, s.sr_instance_id

Line 4866: msc_system_items icompold,

4862: s.sr_instance_id
4863: FROM msc_trading_partners tp,
4864: msc_demands md,
4865: msc_supplies s,
4866: msc_system_items icompold,
4867: msc_system_items icompnew
4868: WHERE tp.sr_tp_id= s.organization_id
4869: AND tp.sr_instance_id= s.sr_instance_id
4870: AND tp.partner_type=3

Line 4867: msc_system_items icompnew

4863: FROM msc_trading_partners tp,
4864: msc_demands md,
4865: msc_supplies s,
4866: msc_system_items icompold,
4867: msc_system_items icompnew
4868: WHERE tp.sr_tp_id= s.organization_id
4869: AND tp.sr_instance_id= s.sr_instance_id
4870: AND tp.partner_type=3
4871: AND s.transaction_id= lv_transaction_id(j)