[Home] [Help] [Dependency Information]
Object Name: | AHL_MR_ITEMS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AHL.AHL_MR_ITEMS_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MR_HEADER_ID | NUMBER | Primary Key for AHL_MR_HEADERS_B. unique identifier of a MR. | ||
MR_EFFECTIVITY_ID | NUMBER | Primary key of table AHL_MR_EFFFECTIVITIES | ||
INVENTORY_ITEM_ID | NUMBER | Yes | Inventory Item ID. FK to MTL_SYSTEM_ITEMS. | |
ITEM_NUMBER | VARCHAR2 | (40) | Concatenated segments for the Inventory Item |
Cut, paste (and edit) the following text to query this object:
SELECT MR_HEADER_ID
, MR_EFFECTIVITY_ID
, INVENTORY_ITEM_ID
, ITEM_NUMBER
FROM APPS.AHL_MR_ITEMS_V;
|
|
|