MAPPING BETWEEN PRODUCTS (PARENT to child)

select vlocity_cmt__AllowIndependentLifeCycle__c,vlocity_cmt__ChildLineNumber__c,vlocity_cmt__ChildProductId__c,vlocity_cmt__ChildProductId__r.Name,vlocity_cmt__ChildProductId__r.ProductCode,vlocity_cmt__CollapseHierarchy__c,vlocity_cmt__IsOverride__c,vlocity_cmt__IsRootProductChildItem__c,vlocity_cmt__IsVirtualItem__c, vlocity_cmt__MaxQuantity__c, vlocity_cmt__MaximumChildItemQuantity__c, vlocity_cmt__MinQuantity__c, vlocity_cmt__MinimumChildItemQuantity__c, vlocity_cmt__ParentProductId__c, vlocity_cmt__Quantity__c, vlocity_cmt__RelationshipType__c 
from vlocity_cmt__ProductChildItem__c where vlocity_cmt__ParentProductId__r.productcode = 'SL_OF_CLIMASMART_CLIMATIZZATORE' and vlocity_cmt__IsRootProductChildItem__c = false