Untitled

SELECT * FROM PPM_PRODUCT_COMPONENT_REF_MAP WHERE (product_component_id, op_id, bu_id, catalog_id) IN (SELECT product_component_id, op_id, bu_id, catalog_id FROM TCARE_PPM_PRODUCT_COMPONENTS WHERE (product_component_id, op_id bu_id) IN (SELECT entity_ref_id, op_id, bu_id FROM RELEASE_ENTITY_INST_MAP WHERE release_id='1.0' AND op_id='HOB' AND bu_id='DEFAULT'))