[Home] [Help] [Dependency Information]
Object Name: | JE_NO_REPORT_PARAMETERS |
---|---|
Object Type: | TABLE |
Owner: | JE |
FND Design Data: | JE.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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JE_NO_REPORT_PARAMETERS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | REQUEST_ID |
JE_NO_REPORT_PARAMETERS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
SET_OF_BOOKS_ID
CONCURRENT_PROGRAM_ID |
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 |
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;
JE.JE_NO_REPORT_PARAMETERS does not reference any database object
JE.JE_NO_REPORT_PARAMETERS is referenced by following:
|
|
|