VIEW: APPS.CS_GROUP_LEVELS_MAINTAIN_V

Source

View Text - Preformatted

SELECT CGL.ROWID , CGL.SERVICE_GROUP_ID , CSG.NAME , CGL.SUPPORT_LEVEL_ID , CSL.NAME , CGL.LAST_UPDATE_DATE , CGL.LAST_UPDATED_BY , CGL.CREATION_DATE , CGL.CREATED_BY , CGL.LAST_UPDATE_LOGIN , CGL.INVENTORY_ITEM_FLAG , CGL.CUSTOMER_FLAG , CGL.SR_TYPE_FLAG , CGL.SR_SEVERITY_FLAG , CGL.SYSTEM_TYPE_FLAG , CGL.SYSTEM_FLAG , CGL.CP_TYPE_FLAG , CGL.SERVICE_INVENTORY_ITEM_FLAG , CGL.PROBLEM_CODE_FLAG , CGL.INSTALL_CITY_FLAG , CGL.INSTALL_COUNTY_FLAG , CGL.INSTALL_STATE_FLAG , CGL.INSTALL_POSTAL_CODE_FLAG , CGL.INSTALL_COUNTRY_FLAG , CGL.INSTALL_PROVINCE_FLAG , CGL.ADDRESS_FLAG , CGL.SITE_USE_FLAG , CGL.DESC_FLEX_FLAG , CGL.CONTEXT , CGL.ATTRIBUTE1 , CGL.ATTRIBUTE2 , CGL.ATTRIBUTE3 , CGL.ATTRIBUTE4 , CGL.ATTRIBUTE5 , CGL.ATTRIBUTE6 , CGL.ATTRIBUTE7 , CGL.ATTRIBUTE8 , CGL.ATTRIBUTE9 , CGL.ATTRIBUTE10 , CGL.ATTRIBUTE11 , CGL.ATTRIBUTE12 , CGL.ATTRIBUTE13 , CGL.ATTRIBUTE14 , CGL.ATTRIBUTE15 FROM CS_SERVICE_GROUPS CSG , CS_SUPPORT_LEVELS CSL , CS_GROUP_LEVELS CGL WHERE CGL.SERVICE_GROUP_ID = CSG.SERVICE_GROUP_ID AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(CSG.START_DATE_ACTIVE,SYSDATE)) AND TRUNC(NVL(CSG.END_DATE_ACTIVE,SYSDATE)) AND CGL.SUPPORT_LEVEL_ID = CSL.SUPPORT_LEVEL_ID AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(CSL.START_DATE_ACTIVE,SYSDATE)) AND TRUNC(NVL(CSL.END_DATE_ACTIVE,SYSDATE))

View Text - HTML Formatted

SELECT CGL.ROWID
, CGL.SERVICE_GROUP_ID
, CSG.NAME
, CGL.SUPPORT_LEVEL_ID
, CSL.NAME
, CGL.LAST_UPDATE_DATE
, CGL.LAST_UPDATED_BY
, CGL.CREATION_DATE
, CGL.CREATED_BY
, CGL.LAST_UPDATE_LOGIN
, CGL.INVENTORY_ITEM_FLAG
, CGL.CUSTOMER_FLAG
, CGL.SR_TYPE_FLAG
, CGL.SR_SEVERITY_FLAG
, CGL.SYSTEM_TYPE_FLAG
, CGL.SYSTEM_FLAG
, CGL.CP_TYPE_FLAG
, CGL.SERVICE_INVENTORY_ITEM_FLAG
, CGL.PROBLEM_CODE_FLAG
, CGL.INSTALL_CITY_FLAG
, CGL.INSTALL_COUNTY_FLAG
, CGL.INSTALL_STATE_FLAG
, CGL.INSTALL_POSTAL_CODE_FLAG
, CGL.INSTALL_COUNTRY_FLAG
, CGL.INSTALL_PROVINCE_FLAG
, CGL.ADDRESS_FLAG
, CGL.SITE_USE_FLAG
, CGL.DESC_FLEX_FLAG
, CGL.CONTEXT
, CGL.ATTRIBUTE1
, CGL.ATTRIBUTE2
, CGL.ATTRIBUTE3
, CGL.ATTRIBUTE4
, CGL.ATTRIBUTE5
, CGL.ATTRIBUTE6
, CGL.ATTRIBUTE7
, CGL.ATTRIBUTE8
, CGL.ATTRIBUTE9
, CGL.ATTRIBUTE10
, CGL.ATTRIBUTE11
, CGL.ATTRIBUTE12
, CGL.ATTRIBUTE13
, CGL.ATTRIBUTE14
, CGL.ATTRIBUTE15
FROM CS_SERVICE_GROUPS CSG
, CS_SUPPORT_LEVELS CSL
, CS_GROUP_LEVELS CGL
WHERE CGL.SERVICE_GROUP_ID = CSG.SERVICE_GROUP_ID
AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(CSG.START_DATE_ACTIVE
, SYSDATE))
AND TRUNC(NVL(CSG.END_DATE_ACTIVE
, SYSDATE))
AND CGL.SUPPORT_LEVEL_ID = CSL.SUPPORT_LEVEL_ID
AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(CSL.START_DATE_ACTIVE
, SYSDATE))
AND TRUNC(NVL(CSL.END_DATE_ACTIVE
, SYSDATE))