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 12320: from MTL_PARAMETERS

12316: -- Get the Master Organization ID
12317: Begin
12318: select master_organization_id
12319: into v_mast_org_id
12320: from MTL_PARAMETERS
12321: where organization_id = organization_id_mig(i);
12322: Exception
12323: when no_data_found then
12324: Raise Process_next;

Line 13733: from MTL_PARAMETERS

13729: -- Get the Master Organization ID
13730: Begin
13731: select master_organization_id
13732: into v_mast_org_id
13733: from MTL_PARAMETERS
13734: where organization_id = organization_id_mig(i);
13735: Exception
13736: when no_data_found then
13737: Raise Process_next;

Line 14740: mtl_parameters c_mp, -- Child Parameters

14736: c_msi.comms_nl_trackable_flag,
14737: m_mp.organization_code,
14738: c_mp.organization_code
14739: FROM mtl_system_items_b c_msi, -- Child Items
14740: mtl_parameters c_mp, -- Child Parameters
14741: mtl_system_items_kfv m_msi, -- Master Items
14742: mtl_parameters m_mp -- Master Parameters
14743: WHERE m_mp.organization_id = m_mp.master_organization_id
14744: AND m_msi.organization_id = m_mp.organization_id

Line 14742: mtl_parameters m_mp -- Master Parameters

14738: c_mp.organization_code
14739: FROM mtl_system_items_b c_msi, -- Child Items
14740: mtl_parameters c_mp, -- Child Parameters
14741: mtl_system_items_kfv m_msi, -- Master Items
14742: mtl_parameters m_mp -- Master Parameters
14743: WHERE m_mp.organization_id = m_mp.master_organization_id
14744: AND m_msi.organization_id = m_mp.organization_id
14745: AND m_msi.organization_id = c_mp.master_organization_id
14746: AND c_mp.master_organization_id = m_mp.organization_id

Line 15138: mtl_parameters mp

15134: organization_code
15135: INTO l_ib_flag,
15136: l_org_code
15137: FROM mtl_system_items_b msi ,
15138: mtl_parameters mp
15139: WHERE msi.inventory_item_id = csi_rec.inventory_item_id
15140: AND msi.organization_id = mp.master_organization_id
15141: AND mp.organization_id = csi_rec.organization_id;
15142: --

Line 15287: mtl_parameters e

15283: a.location_type_code,
15284: a.active_end_date
15285: FROM csi_item_instances a,
15286: mtl_serial_numbers d,
15287: mtl_parameters e
15288: WHERE a.serial_number is not null
15289: AND d.serial_number = a.serial_number
15290: AND d.inventory_item_id <> a.inventory_item_id
15291: AND e.organization_id = nvl(a.last_vld_organization_id, a.inv_master_organization_id)

Line 16382: MTL_PARAMETERS mp

16378: BEGIN
16379: SELECT comms_nl_trackable_flag
16380: INTO v_nl_trackable
16381: FROM MTL_SYSTEM_ITEMS msi,
16382: MTL_PARAMETERS mp
16383: where mp.organization_id = :new.organization_id
16384: and msi.inventory_item_id = :new.inventory_item_id
16385: and msi.organization_id = mp.master_organization_id;
16386: EXCEPTION