[Home] [Help]
[Dependency Information]
VIEW: APPS.MTL_ITEM_LOCATIONS_KFV
Object Details
Object Name: | MTL_ITEM_LOCATIONS_KFV |
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | INV.MTL_ITEM_LOCATIONS_KFV
|
---|
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 |
ROW_ID |
ROWID |
(10) |
|
|
INVENTORY_LOCATION_ID |
NUMBER |
|
Yes |
Inventory locator identifier |
ORGANIZATION_ID |
NUMBER |
|
Yes |
Organization identifier |
CONCATENATED_SEGMENTS |
CHAR |
(1) |
|
|
PADDED_CONCATENATED_SEGMENTS |
CHAR |
(1) |
|
The concatenation of segments enabled for this flexfield. Padded to enable correct sorting. |
DESCRIPTION |
VARCHAR2 |
(50) |
|
Locator description |
DISABLE_DATE |
DATE |
|
|
Disable date |
SUBINVENTORY_CODE |
VARCHAR2 |
(10) |
|
Subinventory name |
Y_COORDINATE |
NUMBER |
|
|
(no longer used) |
ATTRIBUTE10 |
VARCHAR2 |
(150) |
|
Descriptive flexfield segment |
ATTRIBUTE15 |
VARCHAR2 |
(150) |
|
Descriptive flexfield segment |
START_DATE_ACTIVE |
DATE |
|
|
Date segment combination becomes active |
PROGRAM_APPLICATION_ID |
NUMBER |
|
|
Standard Who column |
CREATION_DATE |
DATE |
|
|
Standard Who column |
SUMMARY_FLAG |
VARCHAR2 |
(1) |
Yes |
Flag indicating whether segment combination includes a summary segment |
ENABLED_FLAG |
VARCHAR2 |
(1) |
Yes |
Flag indicating whether segment combination is enabled |
END_DATE_ACTIVE |
DATE |
|
|
Date segment combination becomes inactive |
ATTRIBUTE_CATEGORY |
VARCHAR2 |
(30) |
|
Descriptive flexfield structure defining column |
ATTRIBUTE1 |
VARCHAR2 |
(150) |
|
Descriptive flexfield segment |
ATTRIBUTE2 |
VARCHAR2 |
(150) |
|
Descriptive flexfield segment |
ATTRIBUTE3 |
VARCHAR2 |
(150) |
|
Descriptive flexfield segment |
ATTRIBUTE4 |
VARCHAR2 |
(150) |
|
Descriptive flexfield segment |
ATTRIBUTE5 |
VARCHAR2 |
(150) |
|
Descriptive flexfield segment |
ATTRIBUTE6 |
VARCHAR2 |
(150) |
|
Descriptive flexfield segment |
ATTRIBUTE7 |
VARCHAR2 |
(150) |
|
Descriptive flexfield segment |
ATTRIBUTE8 |
VARCHAR2 |
(150) |
|
Descriptive flexfield segment |
ATTRIBUTE9 |
VARCHAR2 |
(150) |
|
Descriptive flexfield segment |
ATTRIBUTE11 |
VARCHAR2 |
(150) |
|
Descriptive flexfield segment |
ATTRIBUTE12 |
VARCHAR2 |
(150) |
|
Descriptive flexfield segment |
ATTRIBUTE13 |
VARCHAR2 |
(150) |
|
Descriptive flexfield segment |
ATTRIBUTE14 |
VARCHAR2 |
(150) |
|
Descriptive flexfield segment |
PROGRAM_ID |
NUMBER |
|
|
Standard Who column |
PROGRAM_UPDATE_DATE |
DATE |
|
|
Standard Who column |
REQUEST_ID |
NUMBER |
|
|
Standard Who column |
PHYSICAL_LOCATION_CODE |
VARCHAR2 |
(10) |
|
(no longer used) |
MAX_CUBIC_AREA |
NUMBER |
|
|
Locator maximum cubic area |
LAST_UPDATE_DATE |
DATE |
|
Yes |
Standard Who column |
LAST_UPDATED_BY |
NUMBER |
|
Yes |
Standard Who column |
CREATED_BY |
NUMBER |
|
|
Standard Who column |
LAST_UPDATE_LOGIN |
NUMBER |
|
|
Standard Who column |
DESCRIPTIVE_TEXT |
VARCHAR2 |
(240) |
|
Locator descriptive text |
INVENTORY_LOCATION_TYPE |
NUMBER |
|
|
(no longer used) |
PICKING_ORDER |
NUMBER |
|
|
Picking order |
LOCATION_MAXIMUM_UNITS |
NUMBER |
|
|
Locator maximum unit |
LOCATION_WEIGHT_UOM_CODE |
VARCHAR2 |
(3) |
|
Locator weight UOM code |
MAX_WEIGHT |
NUMBER |
|
|
Locator maximum weight |
VOLUME_UOM_CODE |
VARCHAR2 |
(3) |
|
Locator volume UOM code |
X_COORDINATE |
NUMBER |
|
|
(no longer used) |
Z_COORDINATE |
NUMBER |
|
|
(no longer used) |
INVENTORY_ACCOUNT_ID |
NUMBER |
|
|
(not currently used) |
PROJECT_ID |
NUMBER |
(15) |
|
|
TASK_ID |
NUMBER |
(15) |
|
|
PHYSICAL_LOCATION_ID |
NUMBER |
(15) |
|
Physical location identifier |
STATUS_ID |
NUMBER |
|
|
|
PICK_UOM_CODE |
VARCHAR2 |
(3) |
|
|
DIMENSION_UOM_CODE |
VARCHAR2 |
(3) |
|
|
LENGTH |
NUMBER |
|
|
|
WIDTH |
NUMBER |
|
|
|
HEIGHT |
NUMBER |
|
|
|
LOCATOR_STATUS |
NUMBER |
|
|
|
CURRENT_CUBIC_AREA |
NUMBER |
|
|
|
AVAILABLE_CUBIC_AREA |
NUMBER |
|
|
|
CURRENT_WEIGHT |
NUMBER |
|
|
|
AVAILABLE_WEIGHT |
NUMBER |
|
|
|
LOCATION_CURRENT_UNITS |
NUMBER |
|
|
|
LOCATION_AVAILABLE_UNITS |
NUMBER |
|
|
|
INVENTORY_ITEM_ID |
NUMBER |
|
|
|
SUGGESTED_CUBIC_AREA |
NUMBER |
|
|
|
SUGGESTED_WEIGHT |
NUMBER |
|
|
|
LOCATION_SUGGESTED_UNITS |
NUMBER |
|
|
|
EMPTY_FLAG |
VARCHAR2 |
(1) |
|
Set to Y if the locator has no material; N if material resides in locator |
MIXED_ITEMS_FLAG |
VARCHAR2 |
(1) |
|
Y if multiple items reside in the locator; N if locator is empty or contains a single item |
DROPPING_ORDER |
NUMBER |
|
|
Dropping order used to sequence a drop operation |
ALIAS |
VARCHAR2 |
(30) |
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, INVENTORY_LOCATION_ID
, ORGANIZATION_ID
, CONCATENATED_SEGMENTS
, PADDED_CONCATENATED_SEGMENTS
, DESCRIPTION
, DISABLE_DATE
, SUBINVENTORY_CODE
, Y_COORDINATE
, ATTRIBUTE10
, ATTRIBUTE15
, START_DATE_ACTIVE
, PROGRAM_APPLICATION_ID
, CREATION_DATE
, SUMMARY_FLAG
, ENABLED_FLAG
, END_DATE_ACTIVE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, PHYSICAL_LOCATION_CODE
, MAX_CUBIC_AREA
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATED_BY
, LAST_UPDATE_LOGIN
, DESCRIPTIVE_TEXT
, INVENTORY_LOCATION_TYPE
, PICKING_ORDER
, LOCATION_MAXIMUM_UNITS
, LOCATION_WEIGHT_UOM_CODE
, MAX_WEIGHT
, VOLUME_UOM_CODE
, X_COORDINATE
, Z_COORDINATE
, INVENTORY_ACCOUNT_ID
, PROJECT_ID
, TASK_ID
, PHYSICAL_LOCATION_ID
, STATUS_ID
, PICK_UOM_CODE
, DIMENSION_UOM_CODE
, LENGTH
, WIDTH
, HEIGHT
, LOCATOR_STATUS
, CURRENT_CUBIC_AREA
, AVAILABLE_CUBIC_AREA
, CURRENT_WEIGHT
, AVAILABLE_WEIGHT
, LOCATION_CURRENT_UNITS
, LOCATION_AVAILABLE_UNITS
, INVENTORY_ITEM_ID
, SUGGESTED_CUBIC_AREA
, SUGGESTED_WEIGHT
, LOCATION_SUGGESTED_UNITS
, EMPTY_FLAG
, MIXED_ITEMS_FLAG
, DROPPING_ORDER
, ALIAS
FROM APPS.MTL_ITEM_LOCATIONS_KFV;
Dependencies
[top of page]
APPS.MTL_ITEM_LOCATIONS_KFV references the following:
-
APPS
-
MTL_ITEM_LOCATIONS
APPS.MTL_ITEM_LOCATIONS_KFV is referenced by following:
-
APPS
-
AHL_ALL_WORKORDERS_V
-
AHL_APPR_DEPT_SHIFTS_PUB
- show dependent code
-
AHL_CMP_PVT
- show dependent code
-
AHL_CMP_UTIL_PKG
- show dependent code
-
AHL_COMPLEX_MX_RWSC_PVT
- show dependent code
-
AHL_DEPARTMENT_SHIFTS_V
-
AHL_LTP_SIMUL_PLAN_PVT
- show dependent code
-
AHL_MM_MTL_MGT_PVT
- show dependent code
-
AHL_OSP_RCV_PVT
- show dependent code
-
AHL_PRD_MRSHL_PVT
- show dependent code
-
AHL_PRD_MTLTXN_PVT
- show dependent code
-
AHL_PRD_PARTS_CHANGE_PVT
- show dependent code
-
AHL_PRD_UTIL_PKG
- show dependent code
-
AHL_PRD_VISITS_V
-
AHL_REPORT_UTILS_PVT
- show dependent code
-
AHL_SRH_WO_HISTORY_V
-
AHL_UC_INSTANCE_PVT
- show dependent code
-
AHL_UTIL_UC_PKG
- show dependent code
-
AHL_VWP_VISITS_PVT
- show dependent code
-
AHL_WORKORDERS_V
-
AHL_WORKORDER_TASKS_V
-
BOMPBXIN
- show dependent code
-
BOMPEXPL
- show dependent code
-
BOMPKMUD
- show dependent code
-
BOMPXINQ
- show dependent code
-
BOM_EXPLODER_PUB
- show dependent code
-
BOM_INVENTORY_COMPONENTS_ERV
-
BOM_INV_COMPS_INTERFACE_ERV
-
BOM_OPEN_INTERFACE_UTL
- show dependent code
-
BOM_OPERATIONAL_ROUTINGS_ERV
-
BOM_RTG_COPYORG_IMP
- show dependent code
-
BOM_RTG_EXP
- show dependent code
-
BOM_RTG_EXP_UTIL
- show dependent code
-
BOM_RTG_OI_UTIL
- show dependent code
-
BOM_RTG_VAL_TO_ID
- show dependent code
-
BOM_VAL_TO_ID
- show dependent code
-
CSL_MTL_ITEM_LOCATIONS_V
-
CSM_MTL_ITEM_LOCATIONS_V
-
CSP_AVAILABLE_PARTS_V
-
CSP_MATERIAL_TRANSACTIONS_V1
-
CSP_ONHAND_PARTS_V
-
CSP_PICK_CONFIRM_V
-
CSP_PICK_UTILS
- show dependent code
-
CSP_RECV_PARTS_V
-
CST_MTL_RCV_TXN_V
-
EAM_ACTIVITYUTILITIES_PVT
- show dependent code
-
EAM_ASSET_MOVE_PUB
- show dependent code
-
EAM_CFR_WORK_COMPLETION_V
-
EAM_EAMMIPCK_XMLP_PKG
- show dependent code
-
EAM_MATERIALISSUE_PVT
- show dependent code
-
EAM_MAT_REQ_VALIDATE_PVT
- show dependent code
-
EAM_MTL_TXN_PROCESS
- show dependent code
-
EAM_OPERATIONS_JSP
- show dependent code
-
EAM_WORKORDERREP_PVT
- show dependent code
-
EAM_WORKORDERS_JSP
- show dependent code
-
ECE_INVENTORY
- show dependent code
-
ENGECOBO
- show dependent code
-
ENG_REVISED_COMPONENTS_ERV
-
ENG_REVISED_ITEMS_ERV
-
FLM_KANBAN
- show dependent code
-
FLM_KANBAN_PLANNING_UTIL
- show dependent code
-
FLM_KANBAN_PUB
- show dependent code
-
FLM_LOGICAL_KANBAN
- show dependent code
-
FLM_UTIL
- show dependent code
-
GMDQSVRS_APPROVAL_WF_PKG
- show dependent code
-
GMD_ALL_SPEC_VRS_VL
-
GMD_DISP_PUB
- show dependent code
-
GMD_QCR02USR_XMLP_PKG
- show dependent code
-
GMD_QC_ERES_UTILS
- show dependent code
-
GMD_QMREJ
- show dependent code
-
GMD_QMSMC
- show dependent code
-
GMD_QMTES
- show dependent code
-
GMD_QM_E_MATERIAL_SOURCES_V
-
GMD_QM_UOM
- show dependent code
-
GMD_SAMPLES_GRP
- show dependent code
-
GMD_SS_LATETEST_WF_PKG
- show dependent code
-
GMD_SS_LOT_WF_PKG
- show dependent code
-
GMD_SS_TIMEPOINT_WF_PKG
- show dependent code
-
GME_API_PUB
- show dependent code
-
GME_INV_TXNS_ERES_V
-
GME_INV_TXNS_POSTED_ERES_V
-
GME_INV_TXNS_TEMP_ERES_V
-
GME_LPN_MOBILE_TXN
- show dependent code
-
GME_MATERIAL_DETAILS_V
-
GME_STEP_MATERIAL_DETAILS_V
-
GML_MOBILE_RECEIPT
- show dependent code
-
ICX_EDM_INV_ONHAND_BAL_V
-
ICX_MTL_ONHAND_LOCATOR_KFV
-
ICX_MTL_ONHAND_LOT_KFV
-
ICX_MTL_ONHAND_SERIAL_KFV
-
INVKBCGN
- show dependent code
-
INV_COPY_ORGANIZATION_REPORT
- show dependent code
-
INV_ITEM_INQ
- show dependent code
-
INV_KANBAN_PKG
- show dependent code
-
INV_KANBAN_PVT
- show dependent code
-
INV_LABEL_PVT10
- show dependent code
-
INV_LABEL_PVT11
- show dependent code
-
INV_LABEL_PVT13
- show dependent code
-
INV_LABEL_PVT8
- show dependent code
-
INV_LOC_WMS_PUB
- show dependent code
-
INV_LOC_WMS_UTILS
- show dependent code
-
INV_MWB_QUERY_MANAGER
- show dependent code
-
INV_MWB_TREE
- show dependent code
-
INV_MWB_TREE1
- show dependent code
-
INV_REPLENISH_COUNT_LOVS
- show dependent code
-
INV_STATUS_PKG
- show dependent code
-
INV_TRANSACTION_LOVS
- show dependent code
-
INV_TXN_VALIDATIONS
- show dependent code
-
INV_UI_ITEM_ATT_LOVS
- show dependent code
-
INV_UI_ITEM_SUB_LOC_LOVS
- show dependent code
-
INV_UI_RCV_LOVS
- show dependent code
-
INV_VALUE_TO_ID
- show dependent code
-
MRP_GET_LOCATION
- show dependent code
-
MTL_ADJUSTMENT_TXN_SYNC_V
-
MTL_AVAILABLE_INVENTORY_V
-
MTL_LOT_CONV_AUDITDETAILS_ERV
-
MTL_LOT_CONV_AUDIT_DETAILS_V
-
MTL_LOT_ONHAND_SUM_V
-
MTL_MATERIAL_STATUS_HIST_ERV
-
MTL_ONHAND_LPN_MWB_V
-
MTL_ONHAND_LPN_V
-
MTL_ONHAND_NEW_LPN_MWB_V
-
MTL_ONHAND_NEW_LPN_V
-
MTL_ONHAND_SERIAL_MWB_V
-
MTL_ONHAND_SERIAL_V
-
MTL_ONHAND_STATUS_HIST_ERV
-
MTL_ONHAND_SYNC_V
-
MTL_ONHAND_TOTAL_MWB_V
-
MTL_ONHAND_TOTAL_V
-
MTL_RCV_MWB_NEW_OH_V
-
MTL_RCV_MWB_ONHAND_V
-
MTL_RCV_SERIAL_MWB_OH_V
-
MTL_RCV_SERIAL_OH_V
-
MTL_SYSTEM_ITEMS_ER1_V
-
PJM_PROJECT_ONHAND_V
-
PJM_PROJECT_WIP_COMP_V
-
POS_MTL_ONHAND_LOCATOR_KFV
-
POS_MTL_ONHAND_LOT_KFV
-
POS_MTL_ONHAND_SERIAL_KFV
-
PO_POXDLPDT_XMLP_PKG
- show dependent code
-
QA_ERES_RCV_TRANS_INTERFACE_V
-
QA_FLEX_UTIL
- show dependent code
-
RCV_DEFAULT_PKG
- show dependent code
-
RCV_RECEIPT_CONFIRMATION_TXN_V
-
RCV_RECEIPT_CONFIRMATION_V
-
RCV_RMA_TRANSACTIONS
- show dependent code
-
RCV_ROI_TRANSACTION
- show dependent code
-
RCV_TRANSACTIONS_INTERFACE_SV
- show dependent code
-
RCV_TRANSACTIONS_INTERFACE_SV1
- show dependent code
-
WIP_BFLPROC_PRIV
- show dependent code
-
WIP_DISCRETE_WS_MOVE
- show dependent code
-
WIP_FLOWUTIL_PRIV
- show dependent code
-
WMA_MATERIAL
- show dependent code
-
WMA_SPECIAL_LOVS
- show dependent code
-
WMS_CONSOLIDATION_PUB
- show dependent code
-
WMS_DEVICE_CONFIRMATION_PUB
- show dependent code
-
WMS_DEVICE_INTEGRATION_PVT
- show dependent code
-
WMS_DEVICE_REQUESTS_HIST_V
-
WMS_DIRECT_SHIP_PVT
- show dependent code
-
WMS_EXCEPTIONS_V
-
WMS_LABEL_PUB
- show dependent code
-
WMS_LABEL_REQUESTS_HIST_V
-
WMS_LPN_LOVS
- show dependent code
-
WMS_OP_PLAN_DETAILS_V
-
WMS_PACKING_WORKBENCH_PVT
- show dependent code
-
WMS_PUTAWAY_UTILS
- show dependent code
-
WMS_SHIPPING_TRANSACTION_PUB
- show dependent code
-
WMS_STAGINGLANES_ASSIGNMENTS_V
-
WMS_TASKS_V
-
WMS_TASK_DISPATCH_ENGINE
- show dependent code
-
WMS_TASK_DISPATCH_GEN
- show dependent code
-
WMS_TASK_DISPATCH_LOV
- show dependent code
-
WMS_TASK_LOAD
- show dependent code
-
WMS_WAVEPLAN_TASK_EXCEPTIONS_V
-
WMS_WAVE_PLANNING_PVT
- show dependent code
-
WMS_WORKFLOW_WRAPPERS
- show dependent code
-
WMS_WP_WWB_LINES_V
-
WMS_WP_WWB_TASKS_V
-
WMS_ZONES_PVT
- show dependent code
-
WMS_ZONE_LOCATORS_V
-
WSH_MAPPING_DATA
- show dependent code
-
WSH_UTIL_VALIDATE
- show dependent code
-
WSMPUTIL
- show dependent code
-
WSM_WIP_LOT_TXN_PVT
- show dependent code
-
WSM_WLT_VALIDATE_PVT
- show dependent code