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

VIEW: APPS.MTH_SRC_ITEM_COST_V

Object Details
Object Name: MTH_SRC_ITEM_COST_V
Object Type: VIEW
Owner: APPS
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
SYSTEM_FK VARCHAR2 (4000)
Reference to source system
ITEM_FK VARCHAR2 (150)
Reference to source item
ITEM_COST NUMBER

Item cost
FROM_DATE DATE
Yes From date
COST_ELEMENT VARCHAR2 (18)
Cost element
USER_ATTR1 VARCHAR2 (150)
User-defined attribute
USER_ATTR2 VARCHAR2 (150)
User-defined attribute
USER_ATTR3 VARCHAR2 (150)
User-defined attribute
USER_ATTR4 VARCHAR2 (150)
User-defined attribute
USER_ATTR5 VARCHAR2 (150)
User-defined attribute
TO_DATE DATE

To date
INVENTORY_ITEM_ID NUMBER
Yes Inventory Item identifier
SOURCE_ORG_CODE VARCHAR2 (3)
Organization Code
LAST_UPDATE_DATE DATE
Yes Last Update Date
Query Text

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


SELECT SYSTEM_FK
,      ITEM_FK
,      ITEM_COST
,      FROM_DATE
,      COST_ELEMENT
,      USER_ATTR1
,      USER_ATTR2
,      USER_ATTR3
,      USER_ATTR4
,      USER_ATTR5
,      TO_DATE
,      INVENTORY_ITEM_ID
,      SOURCE_ORG_CODE
,      LAST_UPDATE_DATE
FROM APPS.MTH_SRC_ITEM_COST_V;

Dependencies

[top of page]

APPS.MTH_SRC_ITEM_COST_V references the following:

SchemaAPPS
SynonymCST_ITEM_COSTS
PL/SQL PackageFND_PROFILE - show dependent code
SynonymMTL_PARAMETERS
SchemaPUBLIC
SynonymDUAL

APPS.MTH_SRC_ITEM_COST_V is not referenced by any database object