DBA Data[Home] [Help]

VIEW: APPS.CZ_CX_EVENT_PARAMS_V

Source

View Text - Preformatted

SELECT evt.SIGNATURE_ID AS EVENT_SIGNATURE_ID, par.ARGUMENT_INDEX, par.ARGUMENT_NAME AS NAME, cnv.SUBJECT_TYPE AS DATA_TYPE, par.MUTABLE_FLAG AS MUTABLE_FLAG, par.COLLECTION_FLAG AS COLLECTION_FLAG, evt.P_MODEL_ID AS P_MODEL_ID FROM cz_cx_event_defs_v evt, cz_signature_arguments par, cz_conversion_rels_v cnv WHERE evt.SIGNATURE_ID = par.ARGUMENT_SIGNATURE_ID AND par.DATA_TYPE = cnv.OBJECT_TYPE
View Text - HTML Formatted

SELECT EVT.SIGNATURE_ID AS EVENT_SIGNATURE_ID
, PAR.ARGUMENT_INDEX
, PAR.ARGUMENT_NAME AS NAME
, CNV.SUBJECT_TYPE AS DATA_TYPE
, PAR.MUTABLE_FLAG AS MUTABLE_FLAG
, PAR.COLLECTION_FLAG AS COLLECTION_FLAG
, EVT.P_MODEL_ID AS P_MODEL_ID
FROM CZ_CX_EVENT_DEFS_V EVT
, CZ_SIGNATURE_ARGUMENTS PAR
, CZ_CONVERSION_RELS_V CNV
WHERE EVT.SIGNATURE_ID = PAR.ARGUMENT_SIGNATURE_ID
AND PAR.DATA_TYPE = CNV.OBJECT_TYPE