View: ENG_CHANGE_POLICIES_V

Product:	ENG - Engineering
Description:
Implementation/DBA Data:	APPS.ENG_CHANGE_POLICIES_V

View Text

SELECT R.ATTRIBUTE_CODE
, RA.ATTRIBUTE_OBJECT_NAME
, RA.ATTRIBUTE_COLUMN_TYPE
, R.ATTRIBUTE_NUMBER_VALUE
, R.ATTRIBUTE_CHAR_VALUE
, P.POLICY_COLUMN_TYPE
, PV.POLICY_NUMBER_VALUE
, PV.POLICY_CHAR_VALUE
, P.POLICY_OBJECT_NAME
, P.POLICY_OBJECT_PK1_VALUE
, P.POLICY_OBJECT_PK2_VALUE
, P.POLICY_OBJECT_PK3_VALUE
, P.POLICY_OBJECT_PK4_VALUE
, P.POLICY_OBJECT_PK5_VALUE
, P.POLICY_CODE
FROM ENG_CHANGE_RULE_ATTRIBUTES_VL RA
, ENG_CHANGE_RULES R
, ENG_CHANGE_POLICY_VALUES PV
, ENG_CHANGE_POLICIES P
WHERE P.CHANGE_POLICY_ID = PV.CHANGE_POLICY_ID
AND PV.CHANGE_RULE_ID = R.CHANGE_RULE_ID
AND R.ATTRIBUTE_OBJECT_NAME = RA.ATTRIBUTE_OBJECT_NAME
AND R.ATTRIBUTE_CODE = RA.ATTRIBUTE_CODE

Columns