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

TABLE: GL.JE_BE_REPORTERS

Object Details
Object Name: JE_BE_REPORTERS
Object Type: TABLE
Owner: GL
FND Design Data: TableJE.JE_BE_REPORTERS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JE_BE_REPORTERS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSET_OF_BOOKS_ID
Columns
Name Datatype Length Mandatory Comments
REPORTER_ID NUMBER (15) Yes
NAME VARCHAR2 (80) Yes
ADDRESS VARCHAR2 (80) Yes
POSTAL_CODE VARCHAR2 (12) Yes
CITY VARCHAR2 (40) Yes
COUNTRY_CODE VARCHAR2 (3) Yes
CONTACT VARCHAR2 (80) Yes
TELEPHONE VARCHAR2 (20) Yes
VAT_NUMBER VARCHAR2 (20) Yes
ESTABLISHMENT_NUMBER VARCHAR2 (2)
PROCESSING_UNIT_NUMBER VARCHAR2 (1)
SET_OF_BOOKS_ID NUMBER (15) Yes
REGIME VARCHAR2 (1)
AP_REPORT_TO_INTRASTAT_FLAG VARCHAR2 (30)
AR_REPORT_TO_INTRASTAT_FLAG VARCHAR2 (30)
AP_DEFAULT_INTRASTAT_INFO VARCHAR2 (30)
AR_DEFAULT_INTRASTAT_INFO VARCHAR2 (30)
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

Query Text

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


SELECT REPORTER_ID
,      NAME
,      ADDRESS
,      POSTAL_CODE
,      CITY
,      COUNTRY_CODE
,      CONTACT
,      TELEPHONE
,      VAT_NUMBER
,      ESTABLISHMENT_NUMBER
,      PROCESSING_UNIT_NUMBER
,      SET_OF_BOOKS_ID
,      REGIME
,      AP_REPORT_TO_INTRASTAT_FLAG
,      AR_REPORT_TO_INTRASTAT_FLAG
,      AP_DEFAULT_INTRASTAT_INFO
,      AR_DEFAULT_INTRASTAT_INFO
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM GL.JE_BE_REPORTERS;

Dependencies

[top of page]

GL.JE_BE_REPORTERS does not reference any database object

GL.JE_BE_REPORTERS is referenced by following:

SchemaAPPS
SynonymJE_BE_REPORTERS