VIEW: APPS.AHL_MC_HEADERS_V

Source

View Text - Preformatted

SELECT MCB.ROWID ROW_ID, MCB.MC_HEADER_ID, MCB.OBJECT_VERSION_NUMBER, MCB.NAME, MCB.MC_ID, MCB.VERSION_NUMBER, MCB.REVISION, DECODE ( MCB.CONFIG_STATUS_CODE, 'CLOSED', MCB.CONFIG_STATUS_CODE, DECODE ( SIGN(TRUNC(NVL(MCR.ACTIVE_END_DATE, SYSDATE+1)) - TRUNC(SYSDATE)), 1, MCB.CONFIG_STATUS_CODE, 'EXPIRED' ) ) CONFIG_STATUS_CODE, FND.MEANING CONFIG_STATUS_MEANING, FND.DESCRIPTION CONFIG_STATUS_DESC, MCB.LAST_UPDATE_DATE, MCB.LAST_UPDATED_BY, MCB.CREATION_DATE, MCB.CREATED_BY, MCB.LAST_UPDATE_LOGIN, MCB.SECURITY_GROUP_ID, MCB.ATTRIBUTE_CATEGORY, MCB.ATTRIBUTE1, MCB.ATTRIBUTE2, MCB.ATTRIBUTE3, MCB.ATTRIBUTE4, MCB.ATTRIBUTE5, MCB.ATTRIBUTE6, MCB.ATTRIBUTE7, MCB.ATTRIBUTE8, MCB.ATTRIBUTE9, MCB.ATTRIBUTE10, MCB.ATTRIBUTE11, MCB.ATTRIBUTE12, MCB.ATTRIBUTE13, MCB.ATTRIBUTE14, MCB.ATTRIBUTE15, MCTL.DESCRIPTION, FND1.LOOKUP_CODE MODEL_CODE, FND1.MEANING MODEL_MEANING, MCB.SOURCED_FROM_ENIGMA_FLAG, FND2.MEANING SOURCED_FROM_ENIGMA_MEANING FROM AHL_MC_HEADERS_B MCB, AHL_MC_HEADERS_TL MCTL, AHL_MC_RELATIONSHIPS MCR, FND_LOOKUP_VALUES_VL FND, FND_LOOKUP_VALUES_VL FND1, FND_LOOKUP_VALUES_VL FND2 WHERE MCB.MC_HEADER_ID = MCTL.MC_HEADER_ID AND MCTL.LANGUAGE = USERENV('LANG') AND MCB.MC_HEADER_ID = MCR.MC_HEADER_ID AND MCR.PARENT_RELATIONSHIP_ID IS NULL AND FND.LOOKUP_CODE = DECODE ( MCB.CONFIG_STATUS_CODE, 'CLOSED', MCB.CONFIG_STATUS_CODE, DECODE ( SIGN(TRUNC(NVL(MCR.ACTIVE_END_DATE, SYSDATE+1)) - TRUNC(SYSDATE)), 1, MCB.CONFIG_STATUS_CODE, 'EXPIRED' ) ) AND FND.LOOKUP_TYPE (+) = 'AHL_CONFIG_STATUS' AND FND1.LOOKUP_CODE(+) = MCB.MODEL_CODE AND FND1.LOOKUP_TYPE(+) = 'AHL_ENIGMA_MODEL_CODE' AND FND2.LOOKUP_CODE(+) = NVL(MCB.SOURCED_FROM_ENIGMA_FLAG, 'N') AND FND2.LOOKUP_TYPE(+) = 'AHL_YES_NO_TYPE'

View Text - HTML Formatted

SELECT MCB.ROWID ROW_ID
, MCB.MC_HEADER_ID
, MCB.OBJECT_VERSION_NUMBER
, MCB.NAME
, MCB.MC_ID
, MCB.VERSION_NUMBER
, MCB.REVISION
, DECODE ( MCB.CONFIG_STATUS_CODE
, 'CLOSED'
, MCB.CONFIG_STATUS_CODE
, DECODE ( SIGN(TRUNC(NVL(MCR.ACTIVE_END_DATE
, SYSDATE+1)) - TRUNC(SYSDATE))
, 1
, MCB.CONFIG_STATUS_CODE
, 'EXPIRED' ) ) CONFIG_STATUS_CODE
, FND.MEANING CONFIG_STATUS_MEANING
, FND.DESCRIPTION CONFIG_STATUS_DESC
, MCB.LAST_UPDATE_DATE
, MCB.LAST_UPDATED_BY
, MCB.CREATION_DATE
, MCB.CREATED_BY
, MCB.LAST_UPDATE_LOGIN
, MCB.SECURITY_GROUP_ID
, MCB.ATTRIBUTE_CATEGORY
, MCB.ATTRIBUTE1
, MCB.ATTRIBUTE2
, MCB.ATTRIBUTE3
, MCB.ATTRIBUTE4
, MCB.ATTRIBUTE5
, MCB.ATTRIBUTE6
, MCB.ATTRIBUTE7
, MCB.ATTRIBUTE8
, MCB.ATTRIBUTE9
, MCB.ATTRIBUTE10
, MCB.ATTRIBUTE11
, MCB.ATTRIBUTE12
, MCB.ATTRIBUTE13
, MCB.ATTRIBUTE14
, MCB.ATTRIBUTE15
, MCTL.DESCRIPTION
, FND1.LOOKUP_CODE MODEL_CODE
, FND1.MEANING MODEL_MEANING
, MCB.SOURCED_FROM_ENIGMA_FLAG
, FND2.MEANING SOURCED_FROM_ENIGMA_MEANING
FROM AHL_MC_HEADERS_B MCB
, AHL_MC_HEADERS_TL MCTL
, AHL_MC_RELATIONSHIPS MCR
, FND_LOOKUP_VALUES_VL FND
, FND_LOOKUP_VALUES_VL FND1
, FND_LOOKUP_VALUES_VL FND2
WHERE MCB.MC_HEADER_ID = MCTL.MC_HEADER_ID
AND MCTL.LANGUAGE = USERENV('LANG')
AND MCB.MC_HEADER_ID = MCR.MC_HEADER_ID
AND MCR.PARENT_RELATIONSHIP_ID IS NULL
AND FND.LOOKUP_CODE = DECODE ( MCB.CONFIG_STATUS_CODE
, 'CLOSED'
, MCB.CONFIG_STATUS_CODE
, DECODE ( SIGN(TRUNC(NVL(MCR.ACTIVE_END_DATE
, SYSDATE+1)) - TRUNC(SYSDATE))
, 1
, MCB.CONFIG_STATUS_CODE
, 'EXPIRED' ) )
AND FND.LOOKUP_TYPE (+) = 'AHL_CONFIG_STATUS'
AND FND1.LOOKUP_CODE(+) = MCB.MODEL_CODE
AND FND1.LOOKUP_TYPE(+) = 'AHL_ENIGMA_MODEL_CODE'
AND FND2.LOOKUP_CODE(+) = NVL(MCB.SOURCED_FROM_ENIGMA_FLAG
, 'N')
AND FND2.LOOKUP_TYPE(+) = 'AHL_YES_NO_TYPE'