View: AHL_ITEM_ASSOCIATIONS_V

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	Item group association view links Item groups with MTL Items.
Implementation/DBA Data:	APPS.AHL_ITEM_ASSOCIATIONS_V

View Text

SELECT AISV.ROW_ID
, AISV.ITEM_ASSOCIATION_ID
, AISV.SOURCE_ITEM_ASSOCIATION_ID
, AISV.OBJECT_VERSION_NUMBER
, AISV.LAST_UPDATE_DATE
, AISV.LAST_UPDATED_BY
, AISV.CREATION_DATE
, AISV.CREATED_BY
, AISV.LAST_UPDATE_LOGIN
, AISV.ITEM_GROUP_ID
, AISV.INVENTORY_ITEM_ID
, AISV.INVENTORY_ORG_ID
, AISV.PRIORITY
, AISV.UOM_CODE
, AISV.QUANTITY
, AISV.REVISION
, AISV.INTERCHANGE_TYPE_CODE
, AISV.INTERCHANGE_REASON
, AISV.ITEM_TYPE_CODE
, AISV.SECURITY_GROUP_ID
, AISV.ATTRIBUTE_CATEGORY
, AISV.ATTRIBUTE1
, AISV.ATTRIBUTE2
, AISV.ATTRIBUTE3
, AISV.ATTRIBUTE4
, AISV.ATTRIBUTE5
, AISV.ATTRIBUTE6
, AISV.ATTRIBUTE7
, AISV.ATTRIBUTE8
, AISV.ATTRIBUTE9
, AISV.ATTRIBUTE10
, AISV.ATTRIBUTE11
, AISV.ATTRIBUTE12
, AISV.ATTRIBUTE13
, AISV.ATTRIBUTE14
, AISV.ATTRIBUTE15
, MTL.ORGANIZATION_NAME
, MTL.ORGANIZATION_CODE
, MTL.ITEM_TYPE
, MTL.CONCATENATED_SEGMENTS
, MTL.DESCRIPTION
, MTL.REVISION_QTY_CNTRL_CODE
, MTL.LOT_CONTROL_CODE
, MTL.SERIAL_NBR_CNTRL_CODE
, MTL.COMMS_NL_TRACKABLE_FLAG
, MTL.SERVICE_ITEM_FLAG
, MTL.PRIMARY_UOM_CODE
, MTL.PURCHASING_ENABLED_FLAG
, MTL.INVENTORY_ITEM_FLAG
, MTL.WIP_SUPPLY_TYPE
, MTL.BUILD_IN_WIP_FLAG
, MTL.ENG_ITEM_FLAG
, MTL.EAM_ITEM_TYPE
, MTL.INVENTORY_ITEM_STATUS_CODE
, MTL.STOCK_ENABLED_FLAG
, MTL.MTL_TRANSACTIONS_ENABLED_FLAG
, MTL.OUTSIDE_OPERATION_FLAG
, MTL.PURCHASING_ITEM_FLAG
, MTL.ENABLED_FLAG
, MTL.START_DATE_ACTIVE
, MTL.END_DATE_ACTIVE
, MTL.EAM_ENABLED_FLAG
FROM AHL_MTL_ITEMS_NON_OU_V MTL
, AHL_ITEM_ASSOCIATIONS_VL AISV
WHERE AISV.INVENTORY_ITEM_ID= MTL.INVENTORY_ITEM_ID
AND AISV.INVENTORY_ORG_ID = MTL.INVENTORY_ORG_ID

Columns