VIEW: APPS.AHL_MC_RELATIONSHIPS_V

Source

View Text - Preformatted

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, IGB.NAME GROUP_NAME, IGTL.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.ATA_CODE, FATA.MEANING ATA_MEANING, FATA.DESCRIPTION ATA_DESC, 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, FND_LOOKUP_VALUES_VL FATA, AHL_ITEM_GROUPS_B IGB, AHL_ITEM_GROUPS_TL IGTL 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 FATA.LOOKUP_CODE (+) = MCR.ATA_CODE AND FATA.LOOKUP_TYPE (+) = 'AHL_ATA_CODE' AND MCR.ITEM_GROUP_ID = IGB.ITEM_GROUP_ID (+) AND IGB.ITEM_GROUP_ID = IGTL.ITEM_GROUP_ID(+) AND IGTL.LANGUAGE(+) = USERENV('LANG')

View Text - HTML Formatted

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
, IGB.NAME GROUP_NAME
, IGTL.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.ATA_CODE
, FATA.MEANING ATA_MEANING
, FATA.DESCRIPTION ATA_DESC
, 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
, FND_LOOKUP_VALUES_VL FATA
, AHL_ITEM_GROUPS_B IGB
, AHL_ITEM_GROUPS_TL IGTL
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 FATA.LOOKUP_CODE (+) = MCR.ATA_CODE
AND FATA.LOOKUP_TYPE (+) = 'AHL_ATA_CODE'
AND MCR.ITEM_GROUP_ID = IGB.ITEM_GROUP_ID (+)
AND IGB.ITEM_GROUP_ID = IGTL.ITEM_GROUP_ID(+)
AND IGTL.LANGUAGE(+) = USERENV('LANG')