Query to get child table and foreign key status

 query to get child key and foreign key status

col owner form a10

col FK_column form a15

col table_name form a30

select b.owner, b.table_name child_table,b.status,

       c.column_name FK_column, b.constraint_name

  from dba_constraints a, dba_constraints b, dba_cons_columns c

where a.owner=b.r_owner

   and b.owner=c.owner

   and b.table_name=c.table_name

   and b.constraint_name=c.constraint_name

   and a.constraint_name=b.r_constraint_name

   and b.constraint_type='R'

   and a.owner='&OWNER'

   and a.table_name='&TABLE_NAME'

   and a.CONSTRAINT_TYPE='P';

parent table of child table

SELECT owner,

       table_name

FROM   dba_constraints

WHERE  constraint_name IN (SELECT r_constraint_name

                           FROM   dba_constraints WHERE

                            table_name = 'PUROLATOR_ACCOUNTS' AND  constraint_type = 'R');