View: AHL_MASTER_CONFIG_DETAILS_V

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	This view gives all details about the Mater Configuration Header and Nodes, and also some information about the item groups associated with the nodes.
Implementation/DBA Data:	APPS.AHL_MASTER_CONFIG_DETAILS_V

View Text

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
FROM AHL_MC_HEADERS_V MCHV
, AHL_MC_RELATIONSHIPS_V MCRV
WHERE MCHV.MC_HEADER_ID = MCRV.MC_HEADER_ID (+)

Columns