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.SY_ORGN_MST_VL

Object Details

Object Name:	SY_ORGN_MST_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GMA.SY_ORGN_MST_VL
Subobject Name:
Status:	VALID

View Type

MultiLingual view (a language resolved view of the data.)

Organization Master View to setup the data

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Databased Row Identifier
ORGN_CODE	VARCHAR2	(4)	Yes	Organization Code
PARENT_ORGN_CODE	VARCHAR2	(4)	Yes	Parent Organization code
CO_CODE	VARCHAR2	(4)	Yes	Company code
PLANT_IND	NUMBER	(5)	Yes	Plan Indicator
ADDR_ID	NUMBER	(10)		Foreign Key to Address Master
ORGANIZATION_ID	NUMBER	(15)		Organization ID
TAXLOC_CODE	VARCHAR2	(10)		Tax Location Code
TEXT_CODE	NUMBER	(10)		Text Code
DELETE_MARK	NUMBER	(5)	Yes	Delete Mark
TRANS_CNT	NUMBER	(10)	Yes	Not used
POC_IND	NUMBER	(5)		Process Operation Control Indicator
CREATION_DATE	DATE		Yes	Standard Row Identifiers
CREATED_BY	NUMBER	(15)	Yes	Standard Row Identifiers
LAST_UPDATE_DATE	DATE		Yes	Standard Row Identifiers
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Row Identifiers
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Row Identifiers
RESOURCE_WHSE_CODE	VARCHAR2	(4)		Resource warehouse code associated to Plants
SY_ORGN_MST_ORGN_CODE	VARCHAR2	(4)		Organization master organization code
SY_ORGN_MST_DOC_TYPE	VARCHAR2	(4)		Organization master Document Type
MFG_CALENDAR_ID	NUMBER			Manufacturing Calendar ID
ATTRIBUTE1	VARCHAR2	(240)		Flex Field Columns
ATTRIBUTE2	VARCHAR2	(240)		Flex Field Columns
ATTRIBUTE3	VARCHAR2	(240)		Flex Field Columns
ATTRIBUTE4	VARCHAR2	(240)		Flex Field Columns
ATTRIBUTE5	VARCHAR2	(240)		Flex Field Columns
ATTRIBUTE6	VARCHAR2	(240)		Flex Field Columns
ATTRIBUTE7	VARCHAR2	(240)		Flex Field Columns
ATTRIBUTE8	VARCHAR2	(240)		Flex Field Columns
ATTRIBUTE9	VARCHAR2	(240)		Flex Field Columns
ATTRIBUTE10	VARCHAR2	(240)		Flex Field Columns
ATTRIBUTE11	VARCHAR2	(240)		Flex Field Columns
ATTRIBUTE12	VARCHAR2	(240)		Flex Field Columns
ATTRIBUTE13	VARCHAR2	(240)		Flex Field Columns
ATTRIBUTE14	VARCHAR2	(240)		Flex Field Columns
ATTRIBUTE15	VARCHAR2	(240)		Flex Field Columns
ATTRIBUTE16	VARCHAR2	(240)		Flex Field Columns
ATTRIBUTE17	VARCHAR2	(240)		Flex Field Columns
ATTRIBUTE18	VARCHAR2	(240)		Flex Field Columns
ATTRIBUTE19	VARCHAR2	(240)		Flex Field Columns
ATTRIBUTE20	VARCHAR2	(240)		Flex Field Columns
ATTRIBUTE21	VARCHAR2	(240)		Flex Field Columns
ATTRIBUTE22	VARCHAR2	(240)		Flex Field Columns
ATTRIBUTE23	VARCHAR2	(240)		Flex Field Columns
ATTRIBUTE24	VARCHAR2	(240)		Flex Field Columns
ATTRIBUTE25	VARCHAR2	(240)		Flex Field Columns
ATTRIBUTE26	VARCHAR2	(240)		Flex Field Columns
ATTRIBUTE27	VARCHAR2	(240)		Flex Field Columns
ATTRIBUTE28	VARCHAR2	(240)		Flex Field Columns
ATTRIBUTE29	VARCHAR2	(240)		Flex Field Columns
ATTRIBUTE30	VARCHAR2	(240)		Flex Field Columns
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Flex Field Columns
ORGN_NAME	VARCHAR2	(40)	Yes	Organization Name
MIGRATE_AS_IND	NUMBER	(5)		This column holds the value for the migration preference for the organization. 0 - No Migration, 1 - Migrate As New, 2 - Migrate As Existing, 3 - Migrate As Inactive
ACTIVE_IND	NUMBER	(5)		Indicator if organization is used. 0 - Not Used, 1 - Used
ORGANIZATION_NAME	VARCHAR2	(240)		Organization Name for the new orgs created at discrete end
INVENTORY_ORG_IND	VARCHAR2	(1)		Indicator for migrating Org as an inventory org. Y - Yes, N - No
ORGANIZATION_CODE	VARCHAR2	(3)		Inventory Organization Code for the migrating organization
TEMPLATE_ORGANIZATION_ID	NUMBER	(15)		Template organization for copying the values for the new org
PROCESS_ENABLED_IND	VARCHAR2	(1)		Process Enabled Indicator. Y- Yes, N- No
REGULATORY_ORG_IND	VARCHAR2	(1)		Regulatory organization indicator
MIGRATED_IND	NUMBER	(5)		Organization migrated indicator. 0 - Not Migrated, 1 - Migrated
MASTER_ORGANIZATION_ID	NUMBER	(15)		Master Organization Id for the migrated organization
DEFAULT_STATUS	VARCHAR2	(4)		Default status is added for R12.1 migration

Query Text

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


SELECT ROW_ID
,      ORGN_CODE
,      PARENT_ORGN_CODE
,      CO_CODE
,      PLANT_IND
,      ADDR_ID
,      ORGANIZATION_ID
,      TAXLOC_CODE
,      TEXT_CODE
,      DELETE_MARK
,      TRANS_CNT
,      POC_IND
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      RESOURCE_WHSE_CODE
,      SY_ORGN_MST_ORGN_CODE
,      SY_ORGN_MST_DOC_TYPE
,      MFG_CALENDAR_ID
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      ATTRIBUTE_CATEGORY
,      ORGN_NAME
,      MIGRATE_AS_IND
,      ACTIVE_IND
,      ORGANIZATION_NAME
,      INVENTORY_ORG_IND
,      ORGANIZATION_CODE
,      TEMPLATE_ORGANIZATION_ID
,      PROCESS_ENABLED_IND
,      REGULATORY_ORG_IND
,      MIGRATED_IND
,      MASTER_ORGANIZATION_ID
,      DEFAULT_STATUS
FROM APPS.SY_ORGN_MST_VL;

Dependencies

[top of page]

APPS.SY_ORGN_MST_VL references the following:

APPS: SY_ORGN_MST_B; SY_ORGN_MST_TL

APPS.SY_ORGN_MST_VL is referenced by following:

APPS: SY_ORGN_MST