SELECT
   all_cons_columns.owner AS schema_name,
   all_cons_columns.table_name,
   all_cons_columns.column_name,
   ALL_CONS_COLUMNS.POSITION,
   ALL_CONS_COLUMNS.CONSTRAINT_NAME,
   all_constraints.status
FROM all_constraints, all_cons_columns
WHERE
   all_constraints.constraint_type = 'P'
   AND all_constraints.constraint_name = all_cons_columns.constraint_name
   AND all_constraints.owner = all_cons_columns.owner
ORDER BY
   all_cons_columns.owner,
   ALL_CONS_COLUMNS.TABLE_NAME,
   all_cons_columns.position;