View: OKC_RULE_ATTS_BLK_V

Product:	OKC - Contracts Core
Description:
Implementation/DBA Data:	APPS.OKC_RULE_ATTS_BLK_V

View Text

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 (+)

Columns