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_X_REPLENISH dependencies on MSC_SYSTEM_ITEMS

Line 495: , msc_system_items msi

491: p_site_id IN NUMBER
492: ) IS
493: SELECT DISTINCT mp.user_name
494: FROM msc_planners mp
495: , msc_system_items msi
496: WHERE msi.plan_id = p_plan_id
497: AND msi.organization_id = p_site_id
498: AND msi.inventory_item_id = p_inventory_item_id
499: AND msi.sr_instance_id = p_sr_instance_id

Line 510: FROM msc_system_items msi

506: (
507: p_inventory_item_id IN NUMBER
508: ) IS
509: SELECT msi.item_name
510: FROM msc_system_items msi
511: WHERE msi.plan_id = p_plan_id
512: AND msi.organization_id = p_organization_id
513: AND msi.inventory_item_id = p_inventory_item_id
514: AND msi.sr_instance_id = p_sr_instance_id

Line 1392: FROM msc_system_items si

1388: , p_sr_instance_id IN NUMBER
1389: ) IS
1390: SELECT si.uom_code
1391: , si.rounding_control_type
1392: FROM msc_system_items si
1393: WHERE si.inventory_item_id = l_inventory_item_id
1394: AND si.organization_id = l_organization_id
1395: AND si.plan_id = l_plan_id
1396: AND si.sr_instance_id = l_sr_instance_id

Line 2298: from msc_system_items si,

2294:
2295: begin
2296: select mp.employee_id
2297: into l_employee_id
2298: from msc_system_items si,
2299: msc_planners mp
2300: where si.organization_id = l_organization_id
2301: and si.inventory_item_id = l_inventory_item_id
2302: and si.plan_id = l_plan_id

Line 2390: msc_system_items si,

2386: NULL, --DECODE(sd.project_number, NULL, 'N', 'Y'), -- project_accounting_context
2387: si.sr_instance_id, -- sr_instance_id
2388: 1 -- vmi_flag
2389: FROM msc_sup_dem_entries sd,
2390: msc_system_items si,
2391: msc_trading_partners tp,
2392: msc_tp_id_lid tplid,
2393: msc_trading_partner_sites tps,
2394: msc_trading_partner_sites tps2

Line 3284: from msc_system_items si,

3280: BEGIN
3281:
3282: select mp.employee_id
3283: into l_employee_id
3284: from msc_system_items si,
3285: msc_planners mp
3286: WHERE si.organization_id = l_aps_customer_site_id
3287: AND si.inventory_item_id = p_item_id
3288: AND si.plan_id = VMI_PLAN_ID

Line 3380: FROM msc_system_items si,

3376: to_char(NULL), -- end_item_unit_number
3377: to_char(NULL), -- project_accounting_context
3378: si.sr_instance_id, -- sr_instance_id
3379: 1 -- vmi_flag
3380: FROM msc_system_items si,
3381: msc_trading_partners tp,
3382: msc_tp_id_lid tplid,
3383: msc_trading_partner_sites tps,
3384: msc_trading_partner_sites tps2

Line 3447: FROM msc_system_items si,

3443: to_char(NULL), -- end_item_unit_number
3444: to_char(NULL), -- project_accounting_context
3445: si.sr_instance_id, -- sr_instance_id
3446: 2 -- vmi_flag
3447: FROM msc_system_items si,
3448: msc_trading_partners tp,
3449: msc_trading_partner_sites tps
3450: WHERE si.organization_id = l_aps_customer_site_id
3451: AND si.inventory_item_id = p_item_id