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]

TABLE: GMA.SY_ORGN_MST_B

Object Details

Object Name:	SY_ORGN_MST_B
Object Type:	TABLE
Owner:	GMA
FND Design Data:	GMA.SY_ORGN_MST_B
Subobject Name:
Status:	VALID

Organization code (business unit) master for Oracle Process Manufacturing.
Define organization codes and addresses here. This table is linked to
HR_ORGANIZATION_UNITS by ORGANIZATION_ID, where a one to one relationship exists.
It also stores Resource Warehouse as used in the APS integration.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
SY_ORGN_MST_B_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORGN_CODE
SY_ORGN_MST_B_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ORGN_CODE	VARCHAR2	(4)	Yes	Organization code.
ORGN_NAME	VARCHAR2	(40)		Organization name.
PARENT_ORGN_CODE	VARCHAR2	(4)	Yes	Orgn to which orgn_code reports. Must already exist in the table.
CO_CODE	VARCHAR2	(4)	Yes	Company code of the organization.
PLANT_IND	NUMBER	(5)	Yes	0=no the organization is not a plant; 1=yes the organization is a plant, 2=organization is a lab
ADDR_ID	NUMBER	(10)		Surrogate of the organization address.
ORGANIZATION_ID	NUMBER	(15)		Foreign reference to HR_ORGANIZATION_UNITS
TAXLOC_CODE	VARCHAR2	(10)		Tax Location Code for this organization (FK to TX_TLOC_CDS)
TEXT_CODE	NUMBER	(10)		ID which joins any rows of text in this table to the Text Table for this Module
DELETE_MARK	NUMBER	(5)	Yes	Standard: 0=Active record (default); 1=Marked for (logical) deletion.
TRANS_CNT	NUMBER	(10)	Yes	Not currently used
POC_IND	NUMBER	(5)		0=Do not generate POC transactions for organization; 1=Generate POC transactions for organization
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
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
ATTRIBUTE1	VARCHAR2	(240)		Standard WHO Column
ATTRIBUTE2	VARCHAR2	(240)		Standard WHO Column
ATTRIBUTE3	VARCHAR2	(240)		Standard WHO Column
ATTRIBUTE4	VARCHAR2	(240)		Standard WHO Column
ATTRIBUTE5	VARCHAR2	(240)		Standard WHO Column
ATTRIBUTE6	VARCHAR2	(240)		Standard WHO Column
ATTRIBUTE7	VARCHAR2	(240)		Standard WHO Column
ATTRIBUTE8	VARCHAR2	(240)		Standard WHO Column
ATTRIBUTE9	VARCHAR2	(240)		Standard WHO Column
ATTRIBUTE10	VARCHAR2	(240)		Standard WHO Column
ATTRIBUTE11	VARCHAR2	(240)		Standard WHO Column
ATTRIBUTE12	VARCHAR2	(240)		Standard WHO Column
ATTRIBUTE13	VARCHAR2	(240)		Standard WHO Column
ATTRIBUTE14	VARCHAR2	(240)		Standard WHO Column
ATTRIBUTE15	VARCHAR2	(240)		Standard WHO Column
ATTRIBUTE16	VARCHAR2	(240)		Standard WHO Column
ATTRIBUTE17	VARCHAR2	(240)		Standard WHO Column
ATTRIBUTE18	VARCHAR2	(240)		Standard WHO Column
ATTRIBUTE19	VARCHAR2	(240)		Standard WHO Column
ATTRIBUTE20	VARCHAR2	(240)		Standard WHO Column
ATTRIBUTE21	VARCHAR2	(240)		Standard WHO Column
ATTRIBUTE22	VARCHAR2	(240)		Standard WHO Column
ATTRIBUTE23	VARCHAR2	(240)		Standard WHO Column
ATTRIBUTE24	VARCHAR2	(240)		Standard WHO Column
ATTRIBUTE25	VARCHAR2	(240)		Standard WHO Column
ATTRIBUTE26	VARCHAR2	(240)		Standard WHO Column
ATTRIBUTE27	VARCHAR2	(240)		Standard WHO Column
ATTRIBUTE28	VARCHAR2	(240)		Standard WHO Column
ATTRIBUTE29	VARCHAR2	(240)		Standard WHO Column
ATTRIBUTE30	VARCHAR2	(240)		Standard WHO Column
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Standard WHO Column
MFG_CALENDAR_ID	NUMBER			The Surrogate Key for the MRP Calendar to be assigned to the Organization
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
INVENTORY_ORG_IND	VARCHAR2	(1)		Indicator for migrating Org as an inventory org. Y - Yes, N - No
MASTER_ORGANIZATION_ID	NUMBER	(15)		Master Organization Id for the migrated organization
MIGRATED_IND	NUMBER	(5)		Organization migrated indicator. 0 - Not Migrated, 1 - Migrated
ORGANIZATION_CODE	VARCHAR2	(3)		Inventory Organization Code for the migrating organization
ORGANIZATION_NAME	VARCHAR2	(240)		Organization Name for the new orgs created at discrete end
PROCESS_ENABLED_IND	VARCHAR2	(1)		Process Enabled Indicator. Y- Yes, N- No
REGULATORY_ORG_IND	VARCHAR2	(1)		Regulatory organization indicator
TEMPLATE_ORGANIZATION_ID	NUMBER	(15)		Template organization for copying the values for the new org
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 ORGN_CODE
,      ORGN_NAME
,      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
,      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
,      MFG_CALENDAR_ID
,      MIGRATE_AS_IND
,      ACTIVE_IND
,      INVENTORY_ORG_IND
,      MASTER_ORGANIZATION_ID
,      MIGRATED_IND
,      ORGANIZATION_CODE
,      ORGANIZATION_NAME
,      PROCESS_ENABLED_IND
,      REGULATORY_ORG_IND
,      TEMPLATE_ORGANIZATION_ID
,      DEFAULT_STATUS
FROM GMA.SY_ORGN_MST_B;

Dependencies

[top of page]

GMA.SY_ORGN_MST_B does not reference any database object

GMA.SY_ORGN_MST_B is referenced by following:

APPS: SY_ORGN_MST_B