Parent Child relationship SQL Query help

All,

I have a parent child relationship data distributed in 3 tables as described in the following

Components - Will have all the list of components in the system

relationships - Parent-child relationship data

parent_status - have the status of the parent(used on unused)

I am trying to query all the unique components for a given parent, following is the sample of data set

components:

drop table components;

create table components (component_id number, component_number varchar2(20));

REM INSERTING into COMPONENTS

SET DEFINE OFF;

Insert into COMPONENTS (COMPONENT_ID,COMPONENT_NUMBER) values (106002058,'2003474-009');

Insert into COMPONENTS (COMPONENT_ID,COMPONENT_NUMBER) values (112056559,'2010164-092');