Product: | CZ - Configurator |
---|---|
Description: | |
Implementation/DBA Data: | APPS.CZ_SIGNATURE_INFO_V |
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 (+)