[Home] [Help] [Dependency Information]
Object Name: | GR_OTHER_NAMES_ORGN_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | GR.GR_OTHER_NAMES_ORGN_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
MultiLingual view (a language resolved view of the data.)
This view selects unique item/organization combinations from the GR_OTHER_NAMES_TL table and denormalizes the foreign key to the SY_ORGN_MST table for the organization description.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM_CODE | VARCHAR2 | (32) | Yes | |
ORGN_CODE | VARCHAR2 | (4) | Yes | |
ORGN_NAME | VARCHAR2 | (40) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT ITEM_CODE
, ORGN_CODE
, ORGN_NAME
FROM APPS.GR_OTHER_NAMES_ORGN_V;
APPS.GR_OTHER_NAMES_ORGN_V is not referenced by any database object
|
|
|