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

TABLE: GR.GR_COUNTRY_PROFILES

Object Details
Object Name: GR_COUNTRY_PROFILES
Object Type: TABLE
Owner: GR
FND Design Data: TableGR.GR_COUNTRY_PROFILES
Subobject Name:
Status: VALID


Contains Country Codes and Descriptions that can be linked to a customer so that documents display or print in the appropriate country's format.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GR_COUNTRY_PROFILES_PK NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnTERRITORY_CODE
Columns
Name Datatype Length Mandatory Comments
TERRITORY_CODE VARCHAR2 (2) Yes The code for the territory.
LABEL_CODE_EXPOSURE VARCHAR2 (5)
The Code that will be used in the Regulatory module to reference the label information for the Item.
LABEL_CODE_TOXIC VARCHAR2 (5)
The Code that will be used in the Regulatory module to reference the label information for the Item.
DISCLOSURE_CODE VARCHAR2 (10) Yes Disclosure Codes to assign value(s) to reporting levels (disclosure percentages) by country or recipient.
LANGUAGE VARCHAR2 (4) Yes Language code.
DOCUMENT_CODE VARCHAR2 (10) Yes The Document Code for the document.
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
Query Text

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


SELECT TERRITORY_CODE
,      LABEL_CODE_EXPOSURE
,      LABEL_CODE_TOXIC
,      DISCLOSURE_CODE
,      LANGUAGE
,      DOCUMENT_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM GR.GR_COUNTRY_PROFILES;

Dependencies

[top of page]

GR.GR_COUNTRY_PROFILES does not reference any database object

GR.GR_COUNTRY_PROFILES is referenced by following:

SchemaAPPS
SynonymGR_COUNTRY_PROFILES