This will combine the scripts, so it's all mapped together:

SELECT 
    ced.table_name, 
    cesp.stored_procedure_name, 
    cfm.form_id, 
    lr.lookup_rule_id,
    Lookups.database_display_name AS Data_Source, 
    cf_business_processes.name AS Process_Name, 
    cf_forms.name AS Form_Name
FROM 
    cf_lookup_rules lr
JOIN 
    cf_field_column_mapping cfm 
    ON cfm.mapping_id = (
        SELECT TOP 1 mapping_id 
        FROM cf_field_column_mapping 
        WHERE lookup_rule_id = lr.lookup_rule_id 
        ORDER BY mapping_id ASC
    )
LEFT JOIN 
    cf_external_dbtables ced 
    ON lr.external_datasource_id = ced.datasource_id
LEFT JOIN 
    cf_external_stored_procedures cesp 
    ON lr.external_datasource_id = cesp.datasource_id
INNER JOIN (
    SELECT DISTINCT 
        cf_lookup_rules.lookup_rule_id, 
        cf_lookup_rules.external_datasource_id, 
        cf_field_column_mapping.form_id, 
        cf_form_process_mapping.process_id, 
        cf_external_databases.database_display_name
    FROM
        cf_lookup_rules
    LEFT OUTER JOIN 
        cf_field_column_mapping
        ON cf_lookup_rules.lookup_rule_id = cf_field_column_mapping.lookup_rule_id
    INNER JOIN 
        cf_form_process_mapping
        ON cf_field_column_mapping.form_id = cf_form_process_mapping.form_id
    INNER JOIN 
        cf_external_dbtables
        ON cf_lookup_rules.external_datasource_id = cf_external_dbtables.datasource_id
    INNER JOIN 
        cf_external_databases
        ON cf_external_dbtables.database_id = cf_external_databases.database_id
    WHERE 
        cf_lookup_rules.is_disabled != '1'
        AND cf_lookup_rules.external_datasource_id IS NOT NULL
) AS Lookups
ON lr.lookup_rule_id = Lookups.lookup_rule_id
INNER JOIN 
    cf_forms
    ON Lookups.form_id = cf_forms.form_id
INNER JOIN 
    cf_bp_processes
    ON Lookups.process_id = cf_bp_processes.process_id
INNER JOIN 
    cf_business_processes
    ON cf_bp_processes.bp_id = cf_business_processes.bp_id
WHERE 
    cf_business_processes.is_deleted != '1'
    AND cf_business_processes.is_archived != '1'
ORDER BY 
    cfm.form_id ASC;