VIEW: APPS.OKC_RULE_ATTS_BLK_V

Source

View Text - Preformatted

SELECT col.DESCRIPTIVE_FLEX_CONTEXT_CODE rle_code ,col.column_seq_num col_seq ,decode(col.APPLICATION_COLUMN_NAME, 'JTOT_OBJECT1_CODE','JTOT_OBJECT1', 'JTOT_OBJECT2_CODE','JTOT_OBJECT2', 'JTOT_OBJECT3_CODE','JTOT_OBJECT3', col.APPLICATION_COLUMN_NAME) col_name ,col.REQUIRED_FLAG required_yn ,col.FORM_LEFT_PROMPT prompt ,decode(vst.FLEX_VALUE_SET_NAME, NULL,'J', 'OKC_TIMEVALUES', 'T', 'FND_STANDARD_DATE', 'D', decode(vst.VALIDATION_TYPE,'F','F', decode(vst.FORMAT_TYPE,'N', decode(substr(vst.FLEX_VALUE_SET_NAME,1,10),'OKC_AMOUNT','A', 'N'),NULL))) val_type ,vst.MAXIMUM_SIZE ,decode(vst.FLEX_VALUE_SET_NAME,'OKC_NUMBER',to_number(NULL), vst.NUMBER_PRECISION) NUMBER_PRECISION ,vst.UPPERCASE_ONLY_FLAG from FND_DESCR_FLEX_COL_USAGE_VL col , fnd_flex_value_sets vst , okc_rule_defs_v rld WHERE /* (col.APPLICATION_ID=510) and (col.DESCRIPTIVE_FLEXFIELD_NAME='OKC Rule Developer DF') and col.ENABLED_FLAG='Y' and col.FLEX_VALUE_SET_ID = vst.FLEX_VALUE_SET_ID (+) */ (col.DESCRIPTIVE_FLEX_CONTEXT_CODE = rld.RULE_CODE) and (col.APPLICATION_ID=rld.APPLICATION_ID) and (col.DESCRIPTIVE_FLEXFIELD_NAME=rld.DESCRIPTIVE_FLEXFIELD_NAME) and col.ENABLED_FLAG='Y' and col.FLEX_VALUE_SET_ID = vst.FLEX_VALUE_SET_ID (+)

View Text - HTML Formatted

SELECT COL.DESCRIPTIVE_FLEX_CONTEXT_CODE RLE_CODE
, COL.COLUMN_SEQ_NUM COL_SEQ
, DECODE(COL.APPLICATION_COLUMN_NAME
, 'JTOT_OBJECT1_CODE'
, 'JTOT_OBJECT1'
, 'JTOT_OBJECT2_CODE'
, 'JTOT_OBJECT2'
, 'JTOT_OBJECT3_CODE'
, 'JTOT_OBJECT3'
, COL.APPLICATION_COLUMN_NAME) COL_NAME
, COL.REQUIRED_FLAG REQUIRED_YN
, COL.FORM_LEFT_PROMPT PROMPT
, DECODE(VST.FLEX_VALUE_SET_NAME
, NULL
, 'J'
, 'OKC_TIMEVALUES'
, 'T'
, 'FND_STANDARD_DATE'
, 'D'
, DECODE(VST.VALIDATION_TYPE
, 'F'
, 'F'
, DECODE(VST.FORMAT_TYPE
, 'N'
, DECODE(SUBSTR(VST.FLEX_VALUE_SET_NAME
, 1
, 10)
, 'OKC_AMOUNT'
, 'A'
, 'N')
, NULL))) VAL_TYPE
, VST.MAXIMUM_SIZE
, DECODE(VST.FLEX_VALUE_SET_NAME
, 'OKC_NUMBER'
, TO_NUMBER(NULL)
, VST.NUMBER_PRECISION) NUMBER_PRECISION
, VST.UPPERCASE_ONLY_FLAG
FROM FND_DESCR_FLEX_COL_USAGE_VL COL
, FND_FLEX_VALUE_SETS VST
, OKC_RULE_DEFS_V RLD
WHERE /* (COL.APPLICATION_ID=510)
AND (COL.DESCRIPTIVE_FLEXFIELD_NAME='OKC RULE DEVELOPER DF')
AND COL.ENABLED_FLAG='Y'
AND COL.FLEX_VALUE_SET_ID = VST.FLEX_VALUE_SET_ID (+) */ (COL.DESCRIPTIVE_FLEX_CONTEXT_CODE = RLD.RULE_CODE)
AND (COL.APPLICATION_ID=RLD.APPLICATION_ID)
AND (COL.DESCRIPTIVE_FLEXFIELD_NAME=RLD.DESCRIPTIVE_FLEXFIELD_NAME)
AND COL.ENABLED_FLAG='Y'
AND COL.FLEX_VALUE_SET_ID = VST.FLEX_VALUE_SET_ID (+)