View: OKC_RULE_DEFS_V

Product:	OKC - Contracts Core
Description:	This view displays the rule definitions.
Implementation/DBA Data:	APPS.OKC_RULE_DEFS_V

View Text

SELECT B.ROWID
, B.APPLICATION_ID
, FA.APPLICATION_NAME
, B.RULE_CODE
, B.DESCRIPTIVE_FLEXFIELD_NAME
, TL.MEANING
, TL.DESCRIPTION
, TL.SFWT_FLAG
, B.OBJECT_VERSION_NUMBER
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN /*
FROM OKC.OKC_RULE_DEFS_B B
, OKC.OKC_RULE_DEFS_TL TL
, FND_APPLICATION_VL FA */
FROM OKC_RULE_DEFS_B B
, OKC_RULE_DEFS_TL TL
, FND_APPLICATION_VL FA
WHERE B.RULE_CODE = TL.RULE_CODE
AND TL.LANGUAGE = USERENV('LANG')
AND FA.APPLICATION_ID = B.APPLICATION_ID

Columns