APPS.CSI_DIAGNOSTICS_PKG dependencies on MTL_SYSTEM_ITEMS_KFV

Line 14741: mtl_system_items_kfv m_msi, -- Master Items

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

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

14767: l_child_flag_mig V1TabType;
14768: Type V3TabType is VARRAY(10000) of VARCHAR2(3);
14769: l_master_org_mig V3TabType;
14770: l_child_org_mig V3TabType;
14771: Type V240TabType is VARRAY(10000) of MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
14772: l_item_segment_mig V240TabType;
14773: --
14774: MAX_BUFFER_SIZE NUMBER := 1000;
14775: BEGIN

Line 15129: FROM mtl_system_items_kfv mtl

15125: SELECT concatenated_segments,
15126: serial_number_control_code,
15127: lot_control_code
15128: INTO l_item, l_srl_ctl,l_lot_ctl
15129: FROM mtl_system_items_kfv mtl
15130: WHERE mtl.inventory_item_id = csi_rec.inventory_item_id
15131: AND mtl.organization_id = csi_rec.organization_id;
15132:
15133: SELECT comms_nl_trackable_flag,