SELECT APXT_Redlining__Latest_Revision_Text__c, APXT_Redlining__Text_Rich__c, Id, APXT_Redlining__Order__c
FROM APXT_Redlining__Managed_Clause__c
WHERE [Object].ID = '{pv0}'
AND APXT_Redlining__Clause_Type__c = 'Definitions'
ORDER BY APXT_Redlining__Order__c ASC
CODE
When you install Contracts for Salesforce on any given object it automatically creates a parent lookup field, but changes the name of it based on which object is being used. On the above example, the managed clause used corresponds to a generic object that is also used.