VIEW: APPS.CUG_INCIDNT_ATTR_VALS_V

Source

View Text - Preformatted

SELECT distinct b.sr_type_attr_map_id, b.sr_attribute_code, b.incident_type_id, b.sr_attr_mandatory_flag, b.sr_attr_displayed_flag, b.sr_attr_dup_check_flag, b.sr_attribute_list_name, b.sr_attr_default_value, b.start_date_active, b.end_date_active, c.row_id, c.incidnt_attr_val_id, c.object_version_number, b.created_by, b.creation_date, b.last_updated_by, b.last_update_login, b.last_update_date, c.incident_id, c.override_addr_valid_flag, c.attribute1, c.attribute2, c.attribute3, c.attribute4, c.attribute5, c.attribute6, c.attribute7, c.attribute8, c.attribute9, c.attribute10, c.attribute11, c.attribute12, c.attribute13, c.attribute14, c.attribute15, c.attribute_category, c.sr_attribute_value, b.sr_type_attr_seq_num, lkup.description, lkup.start_date_active sr_attr_lkup_start_date, lkup.end_date_active sr_attr_lkup_end_date from cug_sr_type_attr_maps_vl b, cug_incidnt_attr_vals_vl c, fnd_lookups lkup WHERE TRUNC(SYSDATE) BETWEEN TRUNC(NVL(b.start_date_active, SYSDATE)) AND TRUNC(NVL(b.end_date_active, SYSDATE)) and b.sr_attr_displayed_flag = 'Y' and c.sr_attribute_code(+) = b.sr_attribute_code and c.incident_id (+) = 0 and lkup.lookup_code = b.sr_attribute_code and lkup.lookup_type = 'CUG_SR_TYPE_ATTRIBUTES'

View Text - HTML Formatted

SELECT DISTINCT B.SR_TYPE_ATTR_MAP_ID
, B.SR_ATTRIBUTE_CODE
, B.INCIDENT_TYPE_ID
, B.SR_ATTR_MANDATORY_FLAG
, B.SR_ATTR_DISPLAYED_FLAG
, B.SR_ATTR_DUP_CHECK_FLAG
, B.SR_ATTRIBUTE_LIST_NAME
, B.SR_ATTR_DEFAULT_VALUE
, B.START_DATE_ACTIVE
, B.END_DATE_ACTIVE
, C.ROW_ID
, C.INCIDNT_ATTR_VAL_ID
, C.OBJECT_VERSION_NUMBER
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.LAST_UPDATE_DATE
, C.INCIDENT_ID
, C.OVERRIDE_ADDR_VALID_FLAG
, C.ATTRIBUTE1
, C.ATTRIBUTE2
, C.ATTRIBUTE3
, C.ATTRIBUTE4
, C.ATTRIBUTE5
, C.ATTRIBUTE6
, C.ATTRIBUTE7
, C.ATTRIBUTE8
, C.ATTRIBUTE9
, C.ATTRIBUTE10
, C.ATTRIBUTE11
, C.ATTRIBUTE12
, C.ATTRIBUTE13
, C.ATTRIBUTE14
, C.ATTRIBUTE15
, C.ATTRIBUTE_CATEGORY
, C.SR_ATTRIBUTE_VALUE
, B.SR_TYPE_ATTR_SEQ_NUM
, LKUP.DESCRIPTION
, LKUP.START_DATE_ACTIVE SR_ATTR_LKUP_START_DATE
, LKUP.END_DATE_ACTIVE SR_ATTR_LKUP_END_DATE
FROM CUG_SR_TYPE_ATTR_MAPS_VL B
, CUG_INCIDNT_ATTR_VALS_VL C
, FND_LOOKUPS LKUP
WHERE TRUNC(SYSDATE) BETWEEN TRUNC(NVL(B.START_DATE_ACTIVE
, SYSDATE))
AND TRUNC(NVL(B.END_DATE_ACTIVE
, SYSDATE))
AND B.SR_ATTR_DISPLAYED_FLAG = 'Y'
AND C.SR_ATTRIBUTE_CODE(+) = B.SR_ATTRIBUTE_CODE
AND C.INCIDENT_ID (+) = 0
AND LKUP.LOOKUP_CODE = B.SR_ATTRIBUTE_CODE
AND LKUP.LOOKUP_TYPE = 'CUG_SR_TYPE_ATTRIBUTES'