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

VIEW: APPS.EDW_MTL_SUB_INV_FKV

Object Details
Object Name: EDW_MTL_SUB_INV_FKV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOPI.EDW_MTL_SUB_INV_FKV
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Foreign Key View for the Sub-Inventory level in the Inventory Locator Dimension. The view will return the DataWarehouse Foreign key corresponding to the OLTP subinventory. You can also use the get_stock_room_fk API to do the same.


[View Source]

Columns
Name Datatype Length Mandatory Comments
SECONDARY_INVENTORY_NAME VARCHAR2 (10) Yes Sub-Inventory Name
ORGANIZATION_ID NUMBER
Yes Inventory Organization Identifier
STOCK_ROOM_FK VARCHAR2 (45)
Stock Room Foreign Key
Query Text

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


SELECT SECONDARY_INVENTORY_NAME
,      ORGANIZATION_ID
,      STOCK_ROOM_FK
FROM APPS.EDW_MTL_SUB_INV_FKV;

Dependencies

[top of page]

APPS.EDW_MTL_SUB_INV_FKV references the following:

SchemaAPPS
SynonymEDW_LOCAL_INSTANCE
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymMTL_PARAMETERS
SynonymMTL_SECONDARY_INVENTORIES

APPS.EDW_MTL_SUB_INV_FKV is not referenced by any database object