eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.MTH_SRC_ORGANIZATIONS_V

Object Details

Object Name:	MTH_SRC_ORGANIZATIONS_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
ORGANIZATION_NAME	VARCHAR2	(240)	Yes	Organization name
PROCESS_ENABLED_FLAG	VARCHAR2	(1)	Yes	Flag for process manufacturing enabled organization
CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency code
EBS_ORGANIZATION_ID	NUMBER	(15)	Yes	Oracle E-business suite organization identifier
PRIMARY_COST_METHOD	NUMBER		Yes	Primary costing method used for the organization
ORGANIZATION_CODE	VARCHAR2	(3)		Organization code
SYSTEM_FK	VARCHAR2	(4000)		Reference to system
EAM_ORGANIZATION_CODE	VARCHAR2	(3)		Maintenance organization code
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
USER_MEASURE1	NUMBER			User-defined measure
USER_MEASURE2	NUMBER			User-defined measure
USER_MEASURE3	NUMBER			User-defined measure
USER_MEASURE4	NUMBER			User-defined measure
USER_MEASURE5	NUMBER			User-defined measure

Query Text

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


SELECT ORGANIZATION_NAME
,      PROCESS_ENABLED_FLAG
,      CURRENCY_CODE
,      EBS_ORGANIZATION_ID
,      PRIMARY_COST_METHOD
,      ORGANIZATION_CODE
,      SYSTEM_FK
,      EAM_ORGANIZATION_CODE
,      USER_ATTR1
,      USER_ATTR2
,      USER_ATTR3
,      USER_ATTR4
,      USER_ATTR5
,      USER_MEASURE1
,      USER_MEASURE2
,      USER_MEASURE3
,      USER_MEASURE4
,      USER_MEASURE5
FROM APPS.MTH_SRC_ORGANIZATIONS_V;

Dependencies

[top of page]

APPS.MTH_SRC_ORGANIZATIONS_V references the following:

APPS: FND_PROFILE - show dependent code; GL_SETS_OF_BOOKS; HR_ALL_ORGANIZATION_UNITS_TL; HR_ORGANIZATION_INFORMATION; MTL_PARAMETERS

APPS.MTH_SRC_ORGANIZATIONS_V is not referenced by any database object