VIEW: APPS.CZ_SIGNATURE_INFO_V

Source

View Text - Preformatted

SELECT sig.signature_id, sig.name as signature_name, sig.signature_type, sig.ARGUMENT_COUNT, sig.COLLECTION_FLAG, sig.SEEDED_FLAG as seeded_signature, sig.DESCRIPTION, sig.deleted_flag as deleted_signature, arg.ARGUMENT_INDEX, arg.DATATYPE_SIGNATURE_ID, arg.ARGUMENT_LIST_FLAG, arg.ARGUMENT_NAME, arg.DATA_TYPE, arg.JAVA_DATA_TYPE, arg.MUTABLE_FLAG, arg.SEEDED_FLAG as seeded_argument, argtyp.name as argument_type_name, argtyp.signature_type as arg_signature_type, (select count (*) from cz_signature_arguments countargs where countargs.argument_signature_id = sig.signature_id) as actual_arg_records from cz_signatures sig, cz_signature_arguments arg, cz_signatures argtyp WHERE sig.SIGNATURE_ID = arg.ARGUMENT_SIGNATURE_ID(+) and arg.datatype_signature_id = argtyp.signature_id (+)

View Text - HTML Formatted

SELECT SIG.SIGNATURE_ID
, SIG.NAME AS SIGNATURE_NAME
, SIG.SIGNATURE_TYPE
, SIG.ARGUMENT_COUNT
, SIG.COLLECTION_FLAG
, SIG.SEEDED_FLAG AS SEEDED_SIGNATURE
, SIG.DESCRIPTION
, SIG.DELETED_FLAG AS DELETED_SIGNATURE
, ARG.ARGUMENT_INDEX
, ARG.DATATYPE_SIGNATURE_ID
, ARG.ARGUMENT_LIST_FLAG
, ARG.ARGUMENT_NAME
, ARG.DATA_TYPE
, ARG.JAVA_DATA_TYPE
, ARG.MUTABLE_FLAG
, ARG.SEEDED_FLAG AS SEEDED_ARGUMENT
, ARGTYP.NAME AS ARGUMENT_TYPE_NAME
, ARGTYP.SIGNATURE_TYPE AS ARG_SIGNATURE_TYPE
, (SELECT COUNT (*)
FROM CZ_SIGNATURE_ARGUMENTS COUNTARGS
WHERE COUNTARGS.ARGUMENT_SIGNATURE_ID = SIG.SIGNATURE_ID) AS ACTUAL_ARG_RECORDS
FROM CZ_SIGNATURES SIG
, CZ_SIGNATURE_ARGUMENTS ARG
, CZ_SIGNATURES ARGTYP
WHERE SIG.SIGNATURE_ID = ARG.ARGUMENT_SIGNATURE_ID(+)
AND ARG.DATATYPE_SIGNATURE_ID = ARGTYP.SIGNATURE_ID (+)