The below results get ALL children for my "PV105_SUB" report.  
I then modified to include the below "and fmr.fmcode = 'A1539'"
statement and it failed.
----------------------------------
Below shows that I1510
component's parent is A1539

  select fmr.FMCODE PARENT,
     (
      select fmr2.fmcode
      from fmresource fmr2
      where fmr2.FMENTITYOBJECTID = fmrc.FMRESCOMPONENTID
     ) CHILD
  from fmresource fmr
  inner join FMRESOURCECMP fmrc
  on fmr.FMENTITYOBJECTID = fmrc.FMRESOURCEID
----------------------------------
How can I modify the below so
it only extracts A1539's children
and displays a PARENT column with
"A1539" in the result set
(like attached 1.xls) ?
  ** Oracle sample tables.txt attached
           FMPROPASSCHAR
           FMPROPERTYASSIGN
           FMRESOURCE
           FMRESOURCECMP
           GML_CAS
           NLLABELNAME

select fmr.FMCODE COMPONENT, fmrc.FMPERCENTAGE * 100 PERC,
nlln.NLTEXT, fmr.FMCAS, fmppc.FMMINIMUM ALLERGEN
from fmresource fmr
inner join gml_cas gcas
on fmr.FMCAS = gcas.CAS
inner join nllabelname nlln
on nlln.FMENTITYOBJECTID = fmr.FMENTITYOBJECTID
inner join fmpropertyassign fmpa
on fmpa.FMENTITYOBJECTID = fmr.FMENTITYOBJECTID
inner join fmpropasschar fmppc
on fmppc.FMPROPERTYASSIGNID = fmpa.FMPROPERTYASSIGNID
inner join FMRESOURCECMP fmrc
on fmrc.FMRESCOMPONENTID=fmr.FMENTITYOBJECTID
where fmpa.FMPROPERTYID = 391
--and fmr.fmcode = 'A1539'