VIEW: APPS.CSC_CONDITION_LINE_DETAILS_V

Source

View Text - Preformatted

SELECT ocl.aae_id AAE_ID, decode( ocl.cnl_type, 'GEX','Expression', 'FEX','Function', 'CEX','Counter' ) CONDITION_TYPE, ocl.cnl_type CNL_TYPE, ocl.description DESCRIPTION, ocl.pdf_id PDF_ID, ocl.cnh_id CNH_ID, ocl.sortseq SORTSEQ, ocl.left_parenthesis LEFT_PARENTHESIS, decode(cnl_type,'GEX',oaa.name, 'CEX',csc_core_utils_pvt.get_counter_name(nvl(ocl.left_ctr_master_id, ocl.left_counter_id)), 'FEX',decode(opd.package_name,NULL,opd.procedure_name, opd.package_name||'.'||opd.procedure_name) ) LEFT_VALUE, decode(cnl_type,'FEX',NULL,ocl.relational_operator) relational_operator, decode(cnl_type,'GEX',ocl.right_operand, 'CEX',csc_Core_utils_pvt.get_counter_name(nvl(to_number(ocl.right_operand), nvl(ocl.right_ctr_master_id,ocl.right_counter_id))) ) RIGHT_OPERAND, ocl.right_parenthesis RIGHT_PARENTHESIS, ocl.logical_operator LOGICAL_OPERATOR FROM okc_action_attributes_v oaa, okc_condition_lines_v ocl, okc_process_defs_v opd WHERE oaa.id(+) = ocl.aae_id AND ocl.pdf_id = opd.id(+)

View Text - HTML Formatted

SELECT OCL.AAE_ID AAE_ID
, DECODE( OCL.CNL_TYPE
, 'GEX'
, 'EXPRESSION'
, 'FEX'
, 'FUNCTION'
, 'CEX'
, 'COUNTER' ) CONDITION_TYPE
, OCL.CNL_TYPE CNL_TYPE
, OCL.DESCRIPTION DESCRIPTION
, OCL.PDF_ID PDF_ID
, OCL.CNH_ID CNH_ID
, OCL.SORTSEQ SORTSEQ
, OCL.LEFT_PARENTHESIS LEFT_PARENTHESIS
, DECODE(CNL_TYPE
, 'GEX'
, OAA.NAME
, 'CEX'
, CSC_CORE_UTILS_PVT.GET_COUNTER_NAME(NVL(OCL.LEFT_CTR_MASTER_ID
, OCL.LEFT_COUNTER_ID))
, 'FEX'
, DECODE(OPD.PACKAGE_NAME
, NULL
, OPD.PROCEDURE_NAME
, OPD.PACKAGE_NAME||'.'||OPD.PROCEDURE_NAME) ) LEFT_VALUE
, DECODE(CNL_TYPE
, 'FEX'
, NULL
, OCL.RELATIONAL_OPERATOR) RELATIONAL_OPERATOR
, DECODE(CNL_TYPE
, 'GEX'
, OCL.RIGHT_OPERAND
, 'CEX'
, CSC_CORE_UTILS_PVT.GET_COUNTER_NAME(NVL(TO_NUMBER(OCL.RIGHT_OPERAND)
, NVL(OCL.RIGHT_CTR_MASTER_ID
, OCL.RIGHT_COUNTER_ID))) ) RIGHT_OPERAND
, OCL.RIGHT_PARENTHESIS RIGHT_PARENTHESIS
, OCL.LOGICAL_OPERATOR LOGICAL_OPERATOR
FROM OKC_ACTION_ATTRIBUTES_V OAA
, OKC_CONDITION_LINES_V OCL
, OKC_PROCESS_DEFS_V OPD
WHERE OAA.ID(+) = OCL.AAE_ID
AND OCL.PDF_ID = OPD.ID(+)