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

VIEW: APPS.GMI_ITEM_ORGANIZATIONS_V1

Object Details
Object Name: GMI_ITEM_ORGANIZATIONS_V1
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGMI.GMI_ITEM_ORGANIZATIONS_V1
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


View of GMI_ITEM_ORGANIZATIONS plus organization name, code, and master org


[View Source]

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER
Yes Surrogate id uniquely identifying an organization
CREATED_BY NUMBER (15) Yes Standard who column
CREATION_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
ORGANIZATION_CODE VARCHAR2 (3)
Organization Code associated with the organization id
ORGANIZATION_NAME VARCHAR2 (240) Yes Organization Name associated with the organization id
MASTER_ORGANIZATION_ID NUMBER
Yes ID of the Master organization associated with the organization id
Query Text

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


SELECT ORGANIZATION_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORGANIZATION_CODE
,      ORGANIZATION_NAME
,      MASTER_ORGANIZATION_ID
FROM APPS.GMI_ITEM_ORGANIZATIONS_V1;

Dependencies

[top of page]

APPS.GMI_ITEM_ORGANIZATIONS_V1 references the following:

SchemaAPPS
SynonymGMI_ITEM_ORGANIZATIONS
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymMTL_PARAMETERS
ViewORG_ORGANIZATION_DEFINITIONS

APPS.GMI_ITEM_ORGANIZATIONS_V1 is not referenced by any database object