Product: | AHL - Complex Maintenance Repair and Overhaul |
---|---|
Description: | This view gives Master Configuration header information with the respective lookups columns resolved into meanings. |
Implementation/DBA Data: | APPS.AHL_MC_HEADERS_V |
SELECT MCVL.ROWID ROW_ID
, MCVL.MC_HEADER_ID
, MCVL.OBJECT_VERSION_NUMBER
, MCVL.NAME
, MCVL.MC_ID
, MCVL.VERSION_NUMBER
, MCVL.REVISION
, DECODE ( MCVL.CONFIG_STATUS_CODE
, 'CLOSED'
, MCVL.CONFIG_STATUS_CODE
, DECODE ( SIGN(TRUNC(NVL(MCR.ACTIVE_END_DATE
, SYSDATE+1)) - TRUNC(SYSDATE))
, 1
, MCVL.CONFIG_STATUS_CODE
, 'EXPIRED' ) ) CONFIG_STATUS_CODE
, FND.MEANING CONFIG_STATUS_MEANING
, FND.DESCRIPTION CONFIG_STATUS_DESC
, MCVL.LAST_UPDATE_DATE
, MCVL.LAST_UPDATED_BY
, MCVL.CREATION_DATE
, MCVL.CREATED_BY
, MCVL.LAST_UPDATE_LOGIN
, MCVL.SECURITY_GROUP_ID
, MCVL.ATTRIBUTE_CATEGORY
, MCVL.ATTRIBUTE1
, MCVL.ATTRIBUTE2
, MCVL.ATTRIBUTE3
, MCVL.ATTRIBUTE4
, MCVL.ATTRIBUTE5
, MCVL.ATTRIBUTE6
, MCVL.ATTRIBUTE7
, MCVL.ATTRIBUTE8
, MCVL.ATTRIBUTE9
, MCVL.ATTRIBUTE10
, MCVL.ATTRIBUTE11
, MCVL.ATTRIBUTE12
, MCVL.ATTRIBUTE13
, MCVL.ATTRIBUTE14
, MCVL.ATTRIBUTE15
, MCVL.DESCRIPTION
FROM AHL_MC_HEADERS_VL MCVL
, AHL_MC_RELATIONSHIPS MCR
, FND_LOOKUP_VALUES_VL FND
WHERE MCVL.MC_HEADER_ID = MCR.MC_HEADER_ID
AND MCR.PARENT_RELATIONSHIP_ID IS NULL
AND FND.LOOKUP_CODE = DECODE ( MCVL.CONFIG_STATUS_CODE
, 'CLOSED'
, MCVL.CONFIG_STATUS_CODE
, DECODE ( SIGN(TRUNC(NVL(MCR.ACTIVE_END_DATE
, SYSDATE+1)) - TRUNC(SYSDATE))
, 1
, MCVL.CONFIG_STATUS_CODE
, 'EXPIRED' ) )
AND FND.LOOKUP_TYPE (+) = 'AHL_CONFIG_STATUS'