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

VIEW: INV.MTL_SYSTEM_ITEMS_B_EFC#

Object Details
Object Name: MTL_SYSTEM_ITEMS_B_EFC#
Object Type: VIEW
Owner: INV
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
INVENTORY_ITEM_ID NUMBER
Yes
ORGANIZATION_ID NUMBER
Yes
LIST_PRICE_PER_UNIT NUMBER

ORDER_COST NUMBER

MARKET_PRICE NUMBER

CARRYING_COST NUMBER

SET_OF_BOOKS_ID NUMBER

Query Text

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


SELECT INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      LIST_PRICE_PER_UNIT
,      ORDER_COST
,      MARKET_PRICE
,      CARRYING_COST
,      SET_OF_BOOKS_ID
FROM INV.MTL_SYSTEM_ITEMS_B_EFC#;

Dependencies

[top of page]

INV.MTL_SYSTEM_ITEMS_B_EFC# references the following:

SchemaINV
TableMTL_SYSTEM_ITEMS_B_EFC
INV.MTL_SYSTEM_ITEMS_B_EFC# is referenced by following:

SchemaAPPS
SynonymMTL_SYSTEM_ITEMS_B_EFC