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

VIEW: APPS.MTH_SRC_RESOURCE_COST_V

Object Details
Object Name: MTH_SRC_RESOURCE_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
RESOURCE_FK VARCHAR2 (150)
Reference to source resource
FROM_DATE DATE
Yes From date
TO_DATE DATE

To date
COST_ELEMENT VARCHAR2 (150)
Cost element
COST NUMBER
Yes Resource cost
SYSTEM_FK VARCHAR2 (4000)
Reference to source system
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
RESOURCE_ID NUMBER
Yes Resource identifier
DEPARTMENT_ID NUMBER
Yes Department 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 RESOURCE_FK
,      FROM_DATE
,      TO_DATE
,      COST_ELEMENT
,      COST
,      SYSTEM_FK
,      USER_ATTR1
,      USER_ATTR2
,      USER_ATTR3
,      USER_ATTR4
,      USER_ATTR5
,      RESOURCE_ID
,      DEPARTMENT_ID
,      SOURCE_ORG_CODE
,      LAST_UPDATE_DATE
FROM APPS.MTH_SRC_RESOURCE_COST_V;

Dependencies

[top of page]

APPS.MTH_SRC_RESOURCE_COST_V references the following:

SchemaAPPS
SynonymBOM_DEPARTMENT_RESOURCES
SynonymCST_RESOURCE_COSTS
PL/SQL PackageFND_PROFILE - show dependent code
SynonymMTL_PARAMETERS

APPS.MTH_SRC_RESOURCE_COST_V is not referenced by any database object