VIEW: APPS.CZ_RULES_WITH_ARGS_V

Source

View Text - Preformatted

SELECT rul.NAME as rule_name, rul.RULE_ID, rul.RULE_TYPE, rul.TEMPLATE_PRIMITIVE_FLAG, rul.TEMPLATE_TOKEN, rul.SEEDED_FLAG as seeded_rule, rul.DELETED_FLAG as deleted_rule, siginfo.actual_arg_records, siginfo.arg_signature_type, siginfo.argument_type_name, siginfo.seeded_argument, siginfo.mutable_flag, siginfo.java_data_type, siginfo.data_type, siginfo.argument_name, siginfo.argument_list_flag, siginfo.datatype_signature_id, siginfo.argument_index, siginfo.deleted_signature, rul.top_level_constraint_flag, siginfo.description, siginfo.seeded_signature, siginfo.collection_flag, siginfo.argument_count, siginfo.signature_type, siginfo.signature_name, siginfo.signature_id from cz_rules rul, cz_signature_info_v siginfo WHERE siginfo.signature_id = rul.SIGNATURE_ID

View Text - HTML Formatted

SELECT RUL.NAME AS RULE_NAME
, RUL.RULE_ID
, RUL.RULE_TYPE
, RUL.TEMPLATE_PRIMITIVE_FLAG
, RUL.TEMPLATE_TOKEN
, RUL.SEEDED_FLAG AS SEEDED_RULE
, RUL.DELETED_FLAG AS DELETED_RULE
, SIGINFO.ACTUAL_ARG_RECORDS
, SIGINFO.ARG_SIGNATURE_TYPE
, SIGINFO.ARGUMENT_TYPE_NAME
, SIGINFO.SEEDED_ARGUMENT
, SIGINFO.MUTABLE_FLAG
, SIGINFO.JAVA_DATA_TYPE
, SIGINFO.DATA_TYPE
, SIGINFO.ARGUMENT_NAME
, SIGINFO.ARGUMENT_LIST_FLAG
, SIGINFO.DATATYPE_SIGNATURE_ID
, SIGINFO.ARGUMENT_INDEX
, SIGINFO.DELETED_SIGNATURE
, RUL.TOP_LEVEL_CONSTRAINT_FLAG
, SIGINFO.DESCRIPTION
, SIGINFO.SEEDED_SIGNATURE
, SIGINFO.COLLECTION_FLAG
, SIGINFO.ARGUMENT_COUNT
, SIGINFO.SIGNATURE_TYPE
, SIGINFO.SIGNATURE_NAME
, SIGINFO.SIGNATURE_ID
FROM CZ_RULES RUL
, CZ_SIGNATURE_INFO_V SIGINFO
WHERE SIGINFO.SIGNATURE_ID = RUL.SIGNATURE_ID