[Home] [Help] [Dependency Information]
Object Name: | GL_MOVEMERGE_REQUESTS |
---|---|
Object Type: | TABLE |
Owner: | GL |
FND Design Data: | SQLGL.GL_MOVEMERGE_REQUESTS |
Subobject Name: | |
Status: | VALID |
GL_MOVEMERGE_REQUESTS stores Mass Maintenance request definitions. Each row stores the request name, the request type, and the request status. The status is set to 'NR' initially. It is updated appropriately by the Mass Maintenance program to indicate the current status of the request.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GL_MOVEMERGE_REQUESTS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | MOVEMERGE_REQUEST_ID |
GL_MOVEMERGE_REQUESTS_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
NAME
CHART_OF_ACCOUNTS_ID LEDGER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MOVEMERGE_REQUEST_ID | NUMBER | (15) | Yes | Mass maintenance request defining column |
NAME | VARCHAR2 | (25) | Yes | Mass maintenance request name |
LEDGER_ID | NUMBER | (15) | Ledger defining column | |
STATUS_CODE | VARCHAR2 | (2) | Yes | Mass maintenance request status code |
REQUEST_TYPE_CODE | VARCHAR2 | (1) | Yes | Mass maintenance request type code (Mass Creation or Move/Merge) |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard Who column |
DESCRIPTION | VARCHAR2 | (240) | Mass maintenance request description | |
CONCURRENT_REQUEST_ID | NUMBER | (15) | Concurrent request defining column | |
LAST_MOVEMERGE_PERIOD | VARCHAR2 | (15) | Last period processed by this move/merge request | |
CONTEXT | VARCHAR2 | (150) | Descriptive flexfield context | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CHART_OF_ACCOUNTS_ID | NUMBER | (15) | Yes | Key flexfield structure defining column |
ORIGINAL_MOVEMERGE_REQUEST_ID | NUMBER | (15) | Original mass maintenance request defining column |
Cut, paste (and edit) the following text to query this object:
SELECT MOVEMERGE_REQUEST_ID
, NAME
, LEDGER_ID
, STATUS_CODE
, REQUEST_TYPE_CODE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, DESCRIPTION
, CONCURRENT_REQUEST_ID
, LAST_MOVEMERGE_PERIOD
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CHART_OF_ACCOUNTS_ID
, ORIGINAL_MOVEMERGE_REQUEST_ID
FROM GL.GL_MOVEMERGE_REQUESTS;
GL.GL_MOVEMERGE_REQUESTS does not reference any database object
GL.GL_MOVEMERGE_REQUESTS is referenced by following:
|
|
|