VIEW: APPS.AHL_MTL_ITEMS_OU_V

Source

View Text - Preformatted

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,mo_global.get_current_org_id()) = mo_global.get_current_org_id())

View Text - HTML Formatted

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
, MO_GLOBAL.GET_CURRENT_ORG_ID()) = MO_GLOBAL.GET_CURRENT_ORG_ID())