Product: | AHL - Complex Maintenance Repair and Overhaul |
---|---|
Description: | This view gives Master Configuration node details with respective lookup columns resolved into meanings. |
Implementation/DBA Data: | APPS.AHL_MC_RELATIONSHIPS_V |
SELECT MCR.ROWID ROW_ID
, MCR.RELATIONSHIP_ID
, MCR.OBJECT_VERSION_NUMBER
, MCR.POSITION_KEY
, MCR.MC_HEADER_ID
, MCR.PARENT_RELATIONSHIP_ID
, MCR.ITEM_GROUP_ID
, IGV.NAME GROUP_NAME
, IGV.DESCRIPTION GROUP_DESC
, MCR.POSITION_REF_CODE
, FPRC.MEANING POSITION_REF_MEANING
, FPRC.DESCRIPTION POSITION_REF_DESC
, MCR.POSITION_NECESSITY_CODE
, FPNC.MEANING POSITION_NECESSITY_MEANING
, FPNC.DESCRIPTION POSITION_NECESSITY_DESC
, MCR.UOM_CODE
, MCR.QUANTITY
, MCR.DISPLAY_ORDER
, MCR.ACTIVE_START_DATE
, MCR.ACTIVE_END_DATE
, MCR.TEMP_ITEM_GROUP_ID
, MCR.LAST_UPDATE_DATE
, MCR.LAST_UPDATED_BY
, MCR.CREATION_DATE
, MCR.CREATED_BY
, MCR.LAST_UPDATE_LOGIN
, MCR.SECURITY_GROUP_ID
, MCR.ATTRIBUTE_CATEGORY
, MCR.ATTRIBUTE1
, MCR.ATTRIBUTE2
, MCR.ATTRIBUTE3
, MCR.ATTRIBUTE4
, MCR.ATTRIBUTE5
, MCR.ATTRIBUTE6
, MCR.ATTRIBUTE7
, MCR.ATTRIBUTE8
, MCR.ATTRIBUTE9
, MCR.ATTRIBUTE10
, MCR.ATTRIBUTE11
, MCR.ATTRIBUTE12
, MCR.ATTRIBUTE13
, MCR.ATTRIBUTE14
, MCR.ATTRIBUTE15
FROM AHL_MC_RELATIONSHIPS MCR
, FND_LOOKUP_VALUES_VL FPRC
, FND_LOOKUP_VALUES_VL FPNC
, AHL_ITEM_GROUPS_V IGV
WHERE FPRC.LOOKUP_CODE (+) = MCR.POSITION_REF_CODE
AND FPRC.LOOKUP_TYPE (+) = 'AHL_POSITION_REFERENCE'
AND FPNC.LOOKUP_CODE (+) = MCR.POSITION_NECESSITY_CODE
AND FPNC.LOOKUP_TYPE (+) = 'AHL_POSITION_NECESSITY'
AND MCR.ITEM_GROUP_ID = IGV.ITEM_GROUP_ID (+)