VIEW: APPS.AHL_MASTER_CONFIG_DETAILS_V

Source

View Text - Preformatted

SELECT MCHV.ROW_ID, MCHV.MC_HEADER_ID, MCHV.OBJECT_VERSION_NUMBER, MCHV.NAME, MCHV.MC_ID, MCHV.VERSION_NUMBER, MCHV.REVISION, MCHV.CONFIG_STATUS_CODE, MCHV.CONFIG_STATUS_MEANING, MCHV.CONFIG_STATUS_DESC, MCHV.LAST_UPDATE_DATE, MCHV.LAST_UPDATED_BY, MCHV.CREATION_DATE, MCHV.CREATED_BY, MCHV.LAST_UPDATE_LOGIN, MCHV.SECURITY_GROUP_ID, MCHV.ATTRIBUTE_CATEGORY, MCHV.ATTRIBUTE1, MCHV.ATTRIBUTE2, MCHV.ATTRIBUTE3, MCHV.ATTRIBUTE4, MCHV.ATTRIBUTE5, MCHV.ATTRIBUTE6, MCHV.ATTRIBUTE7, MCHV.ATTRIBUTE8, MCHV.ATTRIBUTE9, MCHV.ATTRIBUTE10, MCHV.ATTRIBUTE11, MCHV.ATTRIBUTE12, MCHV.ATTRIBUTE13, MCHV.ATTRIBUTE14, MCHV.ATTRIBUTE15, MCHV.DESCRIPTION, MCRV.RELATIONSHIP_ID, MCRV.POSITION_KEY, MCRV.PARENT_RELATIONSHIP_ID, MCRV.POSITION_REF_CODE, MCRV.POSITION_REF_MEANING, MCRV.POSITION_REF_DESC, MCRV.POSITION_NECESSITY_CODE, MCRV.POSITION_NECESSITY_MEANING, MCRV.POSITION_NECESSITY_DESC, MCRV.UOM_CODE, MCRV.QUANTITY, MCRV.DISPLAY_ORDER, MCRV.ACTIVE_START_DATE, MCRV.ACTIVE_END_DATE, MCRV.ITEM_GROUP_ID, MCRV.GROUP_NAME, MCRV.GROUP_DESC, MCHV.SOURCED_FROM_ENIGMA_FLAG, MCHV.SOURCED_FROM_ENIGMA_MEANING FROM AHL_MC_HEADERS_V MCHV, AHL_MC_RELATIONSHIPS_V MCRV WHERE MCHV.MC_HEADER_ID = MCRV.MC_HEADER_ID (+)

View Text - HTML Formatted

SELECT MCHV.ROW_ID
, MCHV.MC_HEADER_ID
, MCHV.OBJECT_VERSION_NUMBER
, MCHV.NAME
, MCHV.MC_ID
, MCHV.VERSION_NUMBER
, MCHV.REVISION
, MCHV.CONFIG_STATUS_CODE
, MCHV.CONFIG_STATUS_MEANING
, MCHV.CONFIG_STATUS_DESC
, MCHV.LAST_UPDATE_DATE
, MCHV.LAST_UPDATED_BY
, MCHV.CREATION_DATE
, MCHV.CREATED_BY
, MCHV.LAST_UPDATE_LOGIN
, MCHV.SECURITY_GROUP_ID
, MCHV.ATTRIBUTE_CATEGORY
, MCHV.ATTRIBUTE1
, MCHV.ATTRIBUTE2
, MCHV.ATTRIBUTE3
, MCHV.ATTRIBUTE4
, MCHV.ATTRIBUTE5
, MCHV.ATTRIBUTE6
, MCHV.ATTRIBUTE7
, MCHV.ATTRIBUTE8
, MCHV.ATTRIBUTE9
, MCHV.ATTRIBUTE10
, MCHV.ATTRIBUTE11
, MCHV.ATTRIBUTE12
, MCHV.ATTRIBUTE13
, MCHV.ATTRIBUTE14
, MCHV.ATTRIBUTE15
, MCHV.DESCRIPTION
, MCRV.RELATIONSHIP_ID
, MCRV.POSITION_KEY
, MCRV.PARENT_RELATIONSHIP_ID
, MCRV.POSITION_REF_CODE
, MCRV.POSITION_REF_MEANING
, MCRV.POSITION_REF_DESC
, MCRV.POSITION_NECESSITY_CODE
, MCRV.POSITION_NECESSITY_MEANING
, MCRV.POSITION_NECESSITY_DESC
, MCRV.UOM_CODE
, MCRV.QUANTITY
, MCRV.DISPLAY_ORDER
, MCRV.ACTIVE_START_DATE
, MCRV.ACTIVE_END_DATE
, MCRV.ITEM_GROUP_ID
, MCRV.GROUP_NAME
, MCRV.GROUP_DESC
, MCHV.SOURCED_FROM_ENIGMA_FLAG
, MCHV.SOURCED_FROM_ENIGMA_MEANING
FROM AHL_MC_HEADERS_V MCHV
, AHL_MC_RELATIONSHIPS_V MCRV
WHERE MCHV.MC_HEADER_ID = MCRV.MC_HEADER_ID (+)