Issue in extracting as stored BOM from windchill DB using SQL query

We tried the below query again today and it returned parent's version and iteration instead of children's:

SELECT parent_dm.CADName as Parent_Cadname, 
parent_doc.idA2A2 AS ParentDocID, 
parent_doc.versionIdA2versionInfo as Parent_Version, 
parent_doc.iterationIdA2iterationInfo as Parent_iteration, 
child_doc.versionIdA2versionInfo as Child_Version,
child_doc.iterationIdA2iterationInfo as Child_iteration,
ml.idA2A2 AS LinkID, 
ml.idA3B5 AS ChildMasterID,
child_dm.CADName as Child_Cadname

FROM pdmlink.EPMDocument parent_doc
JOIN pdmlink.EPMDocumentMaster parent_dm 
  ON parent_doc.idA3masterReference = parent_dm.idA2A2

JOIN pdmlink.EPMMemberLink ml 
  ON ml.idA3A5 = parent_doc.idA2A2

JOIN pdmlink.EPMAsStoredMember asstored 
  ON asstored.idA3B5 = ml.idA3A5

JOIN pdmlink.EPMAsStoredConfig as config
ON config.idA2A2 = asstored.idA3A5

JOIN pdmlink.EPMDocumentMaster child_dm
    ON ml.idA3B5 = child_dm.idA2A2

JOIN pdmlink.EPMDocument child_doc
ON asstored.idA3B5 = child_doc.idA2A2     --This gives parent's version and iteration which is incorrect--

--JOIN pdmlink.EPMDocument child_doc1
--ON child_doc1.idA3masterReference = child_dm.idA2A2 --This gives both iterations of child 2 which is incorrect--

WHERE parent_dm.CADName = '13_oct_assy_1.asm'
  AND parent_doc.versionIdA2versionInfo = 'P1'
  AND parent_doc.iterationIdA2iterationInfo = '2'
  ORDER BY parent_dm.CADName;

--- We also tried to point the filter to children somehow using below subquery in between, but that did not work either:

AND child_doc.idA2A2 = (
    SELECT child_doc.idA2A2
    FROM pdmlink.EPMDocument
    WHERE child_doc.idA3masterReference = ml.idA3B5 
  )

Could you please check and advise how to proceed?