View: OKC_RULES_HV

Product:	OKC - Contracts Core
Description:	History view for OKC_RULES.
Implementation/DBA Data:	APPS.OKC_RULES_HV

View Text

SELECT RULB.ROWID ROW_ID
, RULB.ID ID
, RULB.MAJOR_VERSION
, RULB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, 'N' SFWT_FLAG
, RULB.OBJECT1_ID1 OBJECT1_ID1
, RULB.OBJECT2_ID1 OBJECT2_ID1
, RULB.OBJECT3_ID1 OBJECT3_ID1
, RULB.OBJECT1_ID2 OBJECT1_ID2
, RULB.OBJECT2_ID2 OBJECT2_ID2
, RULB.OBJECT3_ID2 OBJECT3_ID2
, RULB.JTOT_OBJECT1_CODE JTOT_OBJECT1_CODE
, RULB.JTOT_OBJECT2_CODE JTOT_OBJECT2_CODE
, RULB.JTOT_OBJECT3_CODE JTOT_OBJECT3_CODE
, RULB.DNZ_CHR_ID DNZ_CHR_ID
, RULB.RGP_ID RGP_ID
, RULB.PRIORITY PRIORITY
, RULB.STD_TEMPLATE_YN STD_TEMPLATE_YN
, RULB.COMMENTS COMMENTS
, RULB.WARN_YN WARN_YN
, RULB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, RULB.ATTRIBUTE1 ATTRIBUTE1
, RULB.ATTRIBUTE2 ATTRIBUTE2
, RULB.ATTRIBUTE3 ATTRIBUTE3
, RULB.ATTRIBUTE4 ATTRIBUTE4
, RULB.ATTRIBUTE5 ATTRIBUTE5
, RULB.ATTRIBUTE6 ATTRIBUTE6
, RULB.ATTRIBUTE7 ATTRIBUTE7
, RULB.ATTRIBUTE8 ATTRIBUTE8
, RULB.ATTRIBUTE9 ATTRIBUTE9
, RULB.ATTRIBUTE10 ATTRIBUTE10
, RULB.ATTRIBUTE11 ATTRIBUTE11
, RULB.ATTRIBUTE12 ATTRIBUTE12
, RULB.ATTRIBUTE13 ATTRIBUTE13
, RULB.ATTRIBUTE14 ATTRIBUTE14
, RULB.ATTRIBUTE15 ATTRIBUTE15
, RULB.CREATED_BY CREATED_BY
, RULB.CREATION_DATE CREATION_DATE
, RULB.LAST_UPDATED_BY LAST_UPDATED_BY
, RULB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, RULB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, NULL TEXT
, RULB.RULE_INFORMATION_CATEGORY RULE_INFORMATION_CATEGORY
, RULB.RULE_INFORMATION1 RULE_INFORMATION1
, RULB.RULE_INFORMATION2 RULE_INFORMATION2
, RULB.RULE_INFORMATION3 RULE_INFORMATION3
, RULB.RULE_INFORMATION4 RULE_INFORMATION4
, RULB.RULE_INFORMATION5 RULE_INFORMATION5
, RULB.RULE_INFORMATION6 RULE_INFORMATION6
, RULB.RULE_INFORMATION7 RULE_INFORMATION7
, RULB.RULE_INFORMATION8 RULE_INFORMATION8
, RULB.RULE_INFORMATION9 RULE_INFORMATION9
, RULB.RULE_INFORMATION10 RULE_INFORMATION10
, RULB.RULE_INFORMATION11 RULE_INFORMATION11
, RULB.RULE_INFORMATION12 RULE_INFORMATION12
, RULB.RULE_INFORMATION13 RULE_INFORMATION13
, RULB.RULE_INFORMATION14 RULE_INFORMATION14
, RULB.RULE_INFORMATION15 RULE_INFORMATION15
, RULB.TEMPLATE_YN TEMPLATE_YN
, RULB.ANS_SET_JTOT_OBJECT_CODE ANS_SET_JTOT_OBJECT_CODE
, RULB.ANS_SET_JTOT_OBJECT_ID1 ANS_SET_JTOT_OBJECT_ID1
, RULB.ANS_SET_JTOT_OBJECT_ID2 ANS_SET_JTOT_OBJECT_ID2
, RULB.DISPLAY_SEQUENCE DISPLAY_SEQUENCE
FROM OKC_RULES_BH RULB

Columns