VIEW: APPS.AHL_ITEM_ASSOCIATIONS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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