View: AHL_MTL_ITEMS_OU_V

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	This view retrieves items from all inventory organizations which are under an operating unit.
Implementation/DBA Data:	APPS.AHL_MTL_ITEMS_OU_V

View Text

SELECT KFV.INVENTORY_ITEM_ID
, KFV.ORGANIZATION_ID INVENTORY_ORG_ID
, HOU.NAME ORGANIZATION_NAME
, MP.ORGANIZATION_CODE
, KFV.ITEM_TYPE
, KFV.CONCATENATED_SEGMENTS
, KFV.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 KFV.ORGANIZATION_ID = HOU.ORGANIZATION_ID
AND HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND KFV.ORGANIZATION_ID IN ( SELECT ORGANIZATION_ID
FROM ORG_ORGANIZATION_DEFINITIONS
WHERE NVL(OPERATING_UNIT
, NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTR(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTR(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99))

Columns