Product: | CUG - Citizen Interaction Center |
---|---|
Description: | This view is used by the Run time form to capture the details of a Service Request specific to CIC application. The details include Incident Address, Over ride Address Validation Flag and the SR attributes. |
Implementation/DBA Data: | APPS.CUG_INCIDNT_ATTR_VALS_V |
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'