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_SYSTEM_ITEMS_KFV

Line 14752: mtl_system_items_kfv m_msi, -- Master Items

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
14756: AND m_msi.organization_id = c_mp.master_organization_id

Line 14782: Type V240TabType is VARRAY(10000) of MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;

14778: l_child_flag_mig V1TabType;
14779: Type V3TabType is VARRAY(10000) of VARCHAR2(3);
14780: l_master_org_mig V3TabType;
14781: l_child_org_mig V3TabType;
14782: Type V240TabType is VARRAY(10000) of MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
14783: l_item_segment_mig V240TabType;
14784: --
14785: MAX_BUFFER_SIZE NUMBER := 1000;
14786: BEGIN

Line 15140: FROM mtl_system_items_kfv mtl

15136: SELECT concatenated_segments,
15137: serial_number_control_code,
15138: lot_control_code
15139: INTO l_item, l_srl_ctl,l_lot_ctl
15140: FROM mtl_system_items_kfv mtl
15141: WHERE mtl.inventory_item_id = csi_rec.inventory_item_id
15142: AND mtl.organization_id = csi_rec.organization_id;
15143:
15144: SELECT comms_nl_trackable_flag,