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

TABLE: JE.JE_NO_REPORT_PARAMETERS

Object Details
Object Name: JE_NO_REPORT_PARAMETERS
Object Type: TABLE
Owner: JE
FND Design Data: TableJE.JE_NO_REPORT_PARAMETERS
Subobject Name:
Status: VALID


This table stores the request parameters for the Norwegian VAT Reconciliation report submitted in final mode.
To be able to reprint a report submitted in final mode, fill in the parameter values so that the comparison can be made to parameter values entered in previous report submissions. Through the REQUEST_ID the report is able to find the correct data stored in JE_NO_GL_VAT_REP table.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JE_NO_REPORT_PARAMETERS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUEST_ID
JE_NO_REPORT_PARAMETERS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSET_OF_BOOKS_ID
ColumnCONCURRENT_PROGRAM_ID
Columns
Name Datatype Length Mandatory Comments
CONCURRENT_PROGRAM_ID NUMBER (15) Yes Concurrent program Id
SET_OF_BOOKS_ID NUMBER (15) Yes Set of books id
REQUEST_ID NUMBER (15) Yes Request Id
RUN_DATE DATE

Run Date
PARAMETER_1 VARCHAR2 (50)
Parameter 1
PARAMETER_2 VARCHAR2 (50)
Parameter 2
PARAMETER_3 VARCHAR2 (50)
Parameter 3
PARAMETER_4 VARCHAR2 (50)
Parameter 4
PARAMETER_5 VARCHAR2 (50)
Parameter 5
PARAMETER_6 VARCHAR2 (50)
Parameter 6
PARAMETER_7 VARCHAR2 (50)
Parameter 7
PARAMETER_8 VARCHAR2 (50)
Parameter 8
PARAMETER_9 VARCHAR2 (50)
Parameter 9
PARAMETER_10 VARCHAR2 (50)
Parameter 10
PARAMETER_11 VARCHAR2 (50)
Parameter 11
REPORT_STATUS VARCHAR2 (1)
Report Status
CREATION_DATE DATE
Yes Standard who column
CREATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_LOGIN NUMBER

Standard who column
LAST_UPDATE_BY NUMBER (15)
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
Query Text

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


SELECT CONCURRENT_PROGRAM_ID
,      SET_OF_BOOKS_ID
,      REQUEST_ID
,      RUN_DATE
,      PARAMETER_1
,      PARAMETER_2
,      PARAMETER_3
,      PARAMETER_4
,      PARAMETER_5
,      PARAMETER_6
,      PARAMETER_7
,      PARAMETER_8
,      PARAMETER_9
,      PARAMETER_10
,      PARAMETER_11
,      REPORT_STATUS
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM JE.JE_NO_REPORT_PARAMETERS;

Dependencies

[top of page]

JE.JE_NO_REPORT_PARAMETERS does not reference any database object

JE.JE_NO_REPORT_PARAMETERS is referenced by following:

SchemaJE
ViewJE_NO_REPORT_PARAMETERS#