DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.AHL_MTL_ITEMS_OU_V

Object Details
Object Name: AHL_MTL_ITEMS_OU_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAHL.AHL_MTL_ITEMS_OU_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
INVENTORY_ITEM_ID NUMBER
Yes Inventory item identifier
INVENTORY_ORG_ID NUMBER
Yes Inventory organization identifier
ORGANIZATION_NAME VARCHAR2 (240) Yes Organization name
ORGANIZATION_CODE VARCHAR2 (3)
Organization code
ITEM_TYPE VARCHAR2 (30)
Indicating the type of the item.
CONCATENATED_SEGMENTS VARCHAR2 (40)
Concatenated segments
DESCRIPTION VARCHAR2 (240)
Description of the item
REVISION_QTY_CNTRL_CODE NUMBER

Revision quantity control code
LOT_CONTROL_CODE NUMBER

Lot control code
SERIAL_NBR_CNTRL_CODE NUMBER

Serial number control code
COMMS_NL_TRACKABLE_FLAG VARCHAR2 (1)
COMMS NL Trackable flag
SERVICE_ITEM_FLAG VARCHAR2 (1) Yes Service Item Flag
PRIMARY_UOM_CODE VARCHAR2 (3)
The Primary UOM Code of the inventory item.
PURCHASING_ENABLED_FLAG VARCHAR2 (1) Yes PurchasingEnabledFlag
INVENTORY_ITEM_FLAG VARCHAR2 (1) Yes InventoryItemFlag
WIP_SUPPLY_TYPE NUMBER

WIP_SUPPLY_TYPE
BUILD_IN_WIP_FLAG VARCHAR2 (1) Yes build_in_wip_flag
ENG_ITEM_FLAG VARCHAR2 (1) Yes eng_item_flag
EAM_ITEM_TYPE NUMBER

eam_item_type
INVENTORY_ITEM_STATUS_CODE VARCHAR2 (10) Yes inventory_item_status_code
STOCK_ENABLED_FLAG VARCHAR2 (1) Yes stock_enabled_flag
MTL_TRANSACTIONS_ENABLED_FLAG VARCHAR2 (1) Yes mtl_transactions_enabled_flag
OUTSIDE_OPERATION_FLAG VARCHAR2 (1) Yes outside_operation_flag
PURCHASING_ITEM_FLAG VARCHAR2 (1) Yes purchasing_item_flag
ENABLED_FLAG VARCHAR2 (1) Yes enabled_flag
START_DATE_ACTIVE DATE

start_date_active
END_DATE_ACTIVE DATE

end_date_active
EAM_ENABLED_FLAG VARCHAR2 (1)
eam_enabled_flag
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INVENTORY_ITEM_ID
,      INVENTORY_ORG_ID
,      ORGANIZATION_NAME
,      ORGANIZATION_CODE
,      ITEM_TYPE
,      CONCATENATED_SEGMENTS
,      DESCRIPTION
,      REVISION_QTY_CNTRL_CODE
,      LOT_CONTROL_CODE
,      SERIAL_NBR_CNTRL_CODE
,      COMMS_NL_TRACKABLE_FLAG
,      SERVICE_ITEM_FLAG
,      PRIMARY_UOM_CODE
,      PURCHASING_ENABLED_FLAG
,      INVENTORY_ITEM_FLAG
,      WIP_SUPPLY_TYPE
,      BUILD_IN_WIP_FLAG
,      ENG_ITEM_FLAG
,      EAM_ITEM_TYPE
,      INVENTORY_ITEM_STATUS_CODE
,      STOCK_ENABLED_FLAG
,      MTL_TRANSACTIONS_ENABLED_FLAG
,      OUTSIDE_OPERATION_FLAG
,      PURCHASING_ITEM_FLAG
,      ENABLED_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      EAM_ENABLED_FLAG
FROM APPS.AHL_MTL_ITEMS_OU_V;

Dependencies

[top of page]

APPS.AHL_MTL_ITEMS_OU_V references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_ORGANIZATION_UNITS
PL/SQL PackageHR_SECURITY - show dependent code
PL/SQL PackageMO_GLOBAL - show dependent code
SynonymMTL_PARAMETERS
SynonymMTL_SYSTEM_ITEMS_KFV
ViewORG_ORGANIZATION_DEFINITIONS
APPS.AHL_MTL_ITEMS_OU_V is referenced by following:

SchemaAPPS
Package BodyAHL_MC_ITEM_COMP_PUB - show dependent code
Package BodyAHL_MC_ITEM_COMP_PVT - show dependent code
ViewAHL_OSP_INV_ITEMS_V
Package BodyAHL_OSP_ORDERS_PVT - show dependent code
Package BodyAHL_UC_UTILIZATION_PVT - show dependent code