View: AHL_MTL_ITEMS_NON_OU_V

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	This view retrieves items from all inventory organizations. Not necessary to be in the same Operating Unit.
Implementation/DBA Data:	APPS.AHL_MTL_ITEMS_NON_OU_V

View Text

SELECT DISTINCT KFV.INVENTORY_ITEM_ID
, MP.MASTER_ORGANIZATION_ID INVENTORY_ORG_ID
, HOU.NAME ORGANIZATION_NAME
, (SELECT DISTINCT ORGANIZATION_CODE
FROM MTL_PARAMETERS
WHERE ORGANIZATION_ID = HOU.ORGANIZATION_ID) ORGANIZATION_CODE
, KFV.ITEM_TYPE
, KFV.CONCATENATED_SEGMENTS
, ( SELECT DISTINCT DESCRIPTION
FROM MTL_SYSTEM_ITEMS_KFV
WHERE ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID
AND INVENTORY_ITEM_ID =KFV.INVENTORY_ITEM_ID) DESCRIPTION
, KFV.REVISION_QTY_CONTROL_CODE REVISION_QTY_CNTRL_CODE
, KFV.LOT_CONTROL_CODE
, KFV.SERIAL_NUMBER_CONTROL_CODE SERIAL_NBR_CNTRL_CODE
, KFV.COMMS_NL_TRACKABLE_FLAG
, KFV.SERVICE_ITEM_FLAG
, KFV.PRIMARY_UOM_CODE
, KFV.PURCHASING_ENABLED_FLAG
, KFV.INVENTORY_ITEM_FLAG
, KFV.WIP_SUPPLY_TYPE
, KFV.BUILD_IN_WIP_FLAG
, KFV.ENG_ITEM_FLAG
, KFV.EAM_ITEM_TYPE
, KFV.INVENTORY_ITEM_STATUS_CODE
, KFV.STOCK_ENABLED_FLAG
, KFV.MTL_TRANSACTIONS_ENABLED_FLAG
, KFV.OUTSIDE_OPERATION_FLAG
, KFV.PURCHASING_ITEM_FLAG
, KFV.ENABLED_FLAG
, KFV.START_DATE_ACTIVE
, KFV.END_DATE_ACTIVE
, MP.EAM_ENABLED_FLAG
FROM MTL_SYSTEM_ITEMS_KFV KFV
, HR_ORGANIZATION_UNITS HOU
, MTL_PARAMETERS MP
WHERE MP.MASTER_ORGANIZATION_ID = HOU.ORGANIZATION_ID
AND KFV.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND MP.EAM_ENABLED_FLAG = 'Y'

Columns