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.CSI_DIAGNOSTICS_PKG dependencies on MTL_PARAMETERS

Line 3706: mtl_parameters mp

3702: FROM mtl_serial_numbers msn
3703: WHERE exists (
3704: SELECT '1'
3705: FROM mtl_system_items msi,
3706: mtl_parameters mp
3707: WHERE mp.organization_id = msn.current_organization_id
3708: AND msi.organization_id = mp.master_organization_id
3709: AND msi.inventory_item_id = msn.inventory_item_id
3710: AND nvl(msi.comms_nl_trackable_flag, 'N') = 'Y');

Line 8858: FROM mtl_parameters mp,

8854: AND msi.serial_number_control_code in (2,5)
8855: AND msn.current_status = 3
8856: AND EXISTS (
8857: SELECT '1'
8858: FROM mtl_parameters mp,
8859: mtl_system_items msi_mast
8860: WHERE mp.organization_id = msi.organization_id
8861: AND msi_mast.inventory_item_id = msi.inventory_item_id
8862: AND msi_mast.organization_id = mp.master_organization_id

Line 10914: from MTL_PARAMETERS msi

10910: select cii.instance_id,cii.inv_master_organization_id,
10911: cii.last_vld_organization_id
10912: from CSI_ITEM_INSTANCES cii
10913: where not exists (select 'x'
10914: from MTL_PARAMETERS msi
10915: where organization_id = inv_master_organization_id
10916: and master_organization_id = inv_master_organization_id);
10917: --
10918: Type NumTabType is VARRAY(10000) of NUMBER;

Line 10937: from MTL_PARAMETERS

10933: FOR j in 1..instance_id_mig.count LOOP
10934: Begin
10935: select master_organization_id
10936: into inv_master_org_id_mig(j)
10937: from MTL_PARAMETERS
10938: where organization_id = last_vld_org_id_mig(j);
10939: Exception
10940: when no_data_found then
10941: inv_master_org_id_mig(j) := inv_master_org_id_mig(j);

Line 11561: MTL_PARAMETERS mp

11557: FOR i in 1 .. txn_error_id_mig.count LOOP
11558: select comms_nl_trackable_flag
11559: into l_nl
11560: from MTL_SYSTEM_ITEMS msi,
11561: MTL_PARAMETERS mp
11562: where mp.organization_id = organization_id_mig(i)
11563: and msi.inventory_item_id = inventory_item_id_mig(i)
11564: and msi.organization_id = mp.master_organization_id;
11565: --

Line 11617: MTL_PARAMETERS mp

11613: Begin
11614: select comms_nl_trackable_flag
11615: into l_nl
11616: from MTL_SYSTEM_ITEMS msi,
11617: MTL_PARAMETERS mp
11618: where mp.organization_id = l_organization_id
11619: and msi.inventory_item_id = l_item_id
11620: and msi.organization_id = mp.master_organization_id;
11621: Exception

Line 12325: from MTL_PARAMETERS

12321: -- Get the Master Organization ID
12322: Begin
12323: select master_organization_id
12324: into v_mast_org_id
12325: from MTL_PARAMETERS
12326: where organization_id = organization_id_mig(i);
12327: Exception
12328: when no_data_found then
12329: Raise Process_next;

Line 13738: from MTL_PARAMETERS

13734: -- Get the Master Organization ID
13735: Begin
13736: select master_organization_id
13737: into v_mast_org_id
13738: from MTL_PARAMETERS
13739: where organization_id = organization_id_mig(i);
13740: Exception
13741: when no_data_found then
13742: Raise Process_next;

Line 14751: mtl_parameters c_mp, -- Child Parameters

14747: c_msi.comms_nl_trackable_flag,
14748: m_mp.organization_code,
14749: c_mp.organization_code
14750: FROM mtl_system_items_b c_msi, -- Child Items
14751: mtl_parameters c_mp, -- Child Parameters
14752: mtl_system_items_kfv m_msi, -- Master Items
14753: mtl_parameters m_mp -- Master Parameters
14754: WHERE m_mp.organization_id = m_mp.master_organization_id
14755: AND m_msi.organization_id = m_mp.organization_id

Line 14753: mtl_parameters m_mp -- Master Parameters

14749: c_mp.organization_code
14750: FROM mtl_system_items_b c_msi, -- Child Items
14751: mtl_parameters c_mp, -- Child Parameters
14752: mtl_system_items_kfv m_msi, -- Master Items
14753: mtl_parameters m_mp -- Master Parameters
14754: WHERE m_mp.organization_id = m_mp.master_organization_id
14755: AND m_msi.organization_id = m_mp.organization_id
14756: AND m_msi.organization_id = c_mp.master_organization_id
14757: AND c_mp.master_organization_id = m_mp.organization_id

Line 15149: mtl_parameters mp

15145: organization_code
15146: INTO l_ib_flag,
15147: l_org_code
15148: FROM mtl_system_items_b msi ,
15149: mtl_parameters mp
15150: WHERE msi.inventory_item_id = csi_rec.inventory_item_id
15151: AND msi.organization_id = mp.master_organization_id
15152: AND mp.organization_id = csi_rec.organization_id;
15153: --

Line 15298: mtl_parameters e

15294: a.location_type_code,
15295: a.active_end_date
15296: FROM csi_item_instances a,
15297: mtl_serial_numbers d,
15298: mtl_parameters e
15299: WHERE a.serial_number is not null
15300: AND d.serial_number = a.serial_number
15301: AND d.inventory_item_id <> a.inventory_item_id
15302: AND e.organization_id = nvl(a.last_vld_organization_id, a.inv_master_organization_id)

Line 16393: MTL_PARAMETERS mp

16389: BEGIN
16390: SELECT comms_nl_trackable_flag
16391: INTO v_nl_trackable
16392: FROM MTL_SYSTEM_ITEMS msi,
16393: MTL_PARAMETERS mp
16394: where mp.organization_id = :new.organization_id
16395: and msi.inventory_item_id = :new.inventory_item_id
16396: and msi.organization_id = mp.master_organization_id;
16397: EXCEPTION