VIEW: APPS.WMS_RULE_CONSISTENCIES_V

Source

View Text - Preformatted

SELECT wrc.rowid, wrc.consistency_id, wrc.rule_id, wovl.object_id, wovl.name, wrc.parameter_id, WMS_Parameter_PVT.GetFlexName( wpvl.NAME ,wpvl.DB_OBJECT_REF_TYPE_CODE ,wpvl.PARAMETER_TYPE_CODE ,wpvl.FLEXFIELD_USAGE_CODE ,wpvl.FLEXFIELD_APPLICATION_ID ,wpvl.FLEXFIELD_NAME ,wpvl.COLUMN_NAME ), wrc.last_updated_by, wrc.last_update_date, wrc.created_by, wrc.creation_date, wrc.last_update_login, wrc.attribute_category, wrc.attribute1, wrc.attribute2, wrc.attribute3, wrc.attribute4, wrc.attribute5, wrc.attribute6, wrc.attribute7, wrc.attribute8, wrc.attribute9, wrc.attribute10, wrc.attribute11, wrc.attribute12, wrc.attribute13, wrc.attribute14, wrc.attribute15 FROM wms_rule_consistencies wrc, wms_parameters_vl wpvl, wms_objects_vl wovl WHERE wpvl.parameter_id = wrc.parameter_id AND wovl.object_id = wpvl.object_id

View Text - HTML Formatted

SELECT WRC.ROWID
, WRC.CONSISTENCY_ID
, WRC.RULE_ID
, WOVL.OBJECT_ID
, WOVL.NAME
, WRC.PARAMETER_ID
, WMS_PARAMETER_PVT.GETFLEXNAME( WPVL.NAME
, WPVL.DB_OBJECT_REF_TYPE_CODE
, WPVL.PARAMETER_TYPE_CODE
, WPVL.FLEXFIELD_USAGE_CODE
, WPVL.FLEXFIELD_APPLICATION_ID
, WPVL.FLEXFIELD_NAME
, WPVL.COLUMN_NAME )
, WRC.LAST_UPDATED_BY
, WRC.LAST_UPDATE_DATE
, WRC.CREATED_BY
, WRC.CREATION_DATE
, WRC.LAST_UPDATE_LOGIN
, WRC.ATTRIBUTE_CATEGORY
, WRC.ATTRIBUTE1
, WRC.ATTRIBUTE2
, WRC.ATTRIBUTE3
, WRC.ATTRIBUTE4
, WRC.ATTRIBUTE5
, WRC.ATTRIBUTE6
, WRC.ATTRIBUTE7
, WRC.ATTRIBUTE8
, WRC.ATTRIBUTE9
, WRC.ATTRIBUTE10
, WRC.ATTRIBUTE11
, WRC.ATTRIBUTE12
, WRC.ATTRIBUTE13
, WRC.ATTRIBUTE14
, WRC.ATTRIBUTE15
FROM WMS_RULE_CONSISTENCIES WRC
, WMS_PARAMETERS_VL WPVL
, WMS_OBJECTS_VL WOVL
WHERE WPVL.PARAMETER_ID = WRC.PARAMETER_ID
AND WOVL.OBJECT_ID = WPVL.OBJECT_ID