View: OKS_PMA_V

Product:	OKS - Service Contracts
Description:	This view displays all the activities (rules) selected in contracts. This view is only to be used for the forms UI development.
Implementation/DBA Data:	APPS.OKS_PMA_V

View Text

SELECT RUL.ROWID ROW_ID
, RUL.ID PMA_RULE_ID
, RUL.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, RUL.RULE_INFORMATION1 SELECT_FLAG
, RUL.RULE_INFORMATION2 CONFIRMATION_REQUIRED
, RUL.RULE_INFORMATION3 SCHEDULE_EXISTS
, RUL.OBJECT1_ID1 ACTIVITY_ID1
, RUL.OBJECT1_ID2 ACTIVITY_ID2
, RUL.OBJECT2_ID1 PMP_RULE_ID
, RUL.OBJECT2_ID2 PMP_RULE_ID2
, RGP.CLE_ID CLE_ID
, RGP.DNZ_CHR_ID DNZ_CHR_ID
, RUL.CREATED_BY CREATED_BY
, RUL.CREATION_DATE CREATION_DATE
, RUL.LAST_UPDATED_BY LAST_UPDATED_BY
, RUL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, RUL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKC_RULE_GROUPS_B RGP
, OKC_RULES_B RUL
WHERE RGP.RGD_CODE = 'SVC_K'
AND RUL.RGP_ID = RGP.ID
AND RUL.RULE_INFORMATION_CATEGORY = 'PMA'

Columns