View: CZ_RULES_WITH_ARGS_V

Product:	CZ - Configurator
Description:
Implementation/DBA Data:	APPS.CZ_RULES_WITH_ARGS_V

View Text

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

Columns