SELECT /*+ index(srcStatus nc_params(object_id, attr_id)) cardinality(srcCard 10) */
    srcDevice.object_id src_device_id,
    srcDevice.name src_device_name,
    cable.object_id cable_id,
    cable.name cable_name,
    dstDevice.object_id dst_device_id,
    dstDevice.name dst_device_name
FROM nc_objects srcRack,
    nc_objects srcDevice,
    nc_params srcStatus,
    TABLE (
        CAST(multiset(SELECT object_id FROM nc_objects
            WHERE object_class_id = 301 /* Device */
            START WITH object_id = srcDevice.object_id
            CONNECT BY PRIOR object_id = parent_id
            AND object_class_id = 301 /* Device */
            ) AS arrayofnumbers)
        ) srcCard,
    nc_connection_data srcCardToLink,
    nc_connection_data linkToCableConn,
    nc_references cable2CableConn,
    nc_objects cable,
    nc_references cable2AnotherConn,
    nc_connection_data alinkToCableConn,
nc_connection_data dstConnToALink,
    nc_objects dstDevice
WHERE srcRack.name = 'PL:001 Rack'
    AND srcrack.object_id = 9135760940713868861
    AND srcDevice.parent_id = srcRack.object_id
    AND srcStatus.object_id = srcDevice.object_id
    --Physical Status
    AND srcStatus.attr_id = 8033139507013843617
    --Defective
    AND srcStatus.list_value_id = 8033139507013843615
    AND srcCardToLink.object_id = srcCard.column_value
    --Connect With Device
    AND srcCardToLink.connection_type = 0
    AND linkToCableConn.link_id = srcCardToLink.link_id
    AND linkToCableConn.connector_id != srcCardToLink.connector_id
    AND cable2CableConn.reference = linkToCableConn.connector_id
    AND cable2CableConn.attr_id IN (
        9041371006013856577 /* Cable Connector A */,
        9041371006013856578 /* Cable Connector Z */)
    AND cable.object_id = cable2CableConn.object_id
    AND cable2AnotherConn.object_id = cable2CableConn.object_id
    AND cable2AnotherConn.attr_id = decode(cable2CableConn.attr_id,
                         9041371006013856577,
                         9041371006013856578,
                         9041371006013856577)
    AND alinkToCableConn.connector_id = cable2AnotherConn.reference
    AND dstConnToALink.link_id = alinkToCableConn.link_id
    AND dstConnToALink.connector_id <> alinkToCableConn.connector_id
    --Connect With Device
    AND dstConnToALink.connection_type = 0
    AND dstDevice.object_id = getChassisID(dstConnToALink.object_id)