[Home] [Help] [Dependency Information]
Object Name: | FEM_PL_REQUESTS |
---|---|
Object Type: | TABLE |
Owner: | FEM |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FEM_PL_REQUESTS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | REQUEST_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REQUEST_ID | NUMBER | Yes | Identifies the concurrent request instance that spawned the concurrent program. | |
EXEC_STATUS_CODE | VARCHAR2 | (30) | Yes | Execution Status Code. Indicates the status of the process lock . |
CREATED_BY | NUMBER | (15) | Yes | Identifies user who created row References FND_USER.USER_ID. |
CREATION_DATE | DATE | Yes | Date the row was created | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Identifies user who last modified the row. |
LAST_UPDATE_DATE | DATE | Yes | Date row was last modified. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Login ID of user who last modified the row. | |
PROGRAM_ID | NUMBER | Identifies the concurrent_program. | ||
PROGRAM_LOGIN_ID | NUMBER | Identifies the user that spawned the concurrent program. | ||
PROGRAM_APPLICATION_ID | NUMBER | Identifies the Oracle Application that spawned the concurrent program. | ||
RULE_SET_OBJ_DEF_ID | NUMBER | (9) | The rule set definition that was passed as a parameter to the process that resulted in this lock. References FEM_OBJECT_DEFINITION_B.OBJECT_DEFINITION_ID. | |
RULE_SET_NAME | VARCHAR2 | (150) | The name of the rule set. | |
EFFECTIVE_DATE | DATE | Effective date used to select object definitions used during processing. | ||
CAL_PERIOD_ID | NUMBER | Time period of data written by the object. References FEM_CAL_PERIODS_VL.CAL_PERIOD_ID. | ||
LEDGER_ID | NUMBER | Set of Books. This is a parameter passed to the calling program which identifies the set of books in the General Ledger that was processed. | ||
DATASET_IO_OBJ_DEF_ID | NUMBER | (9) | Dataset input output definition that was passed as a parameter to the process that resulted in this lock. References FEM_OBJECT_DEFINITION_B.OBJECT_DEFINITION_ID. | |
OUTPUT_DATASET_CODE | NUMBER | Data Set written to by the object. References FEM_DATASETS_VL.DATASET_CODE. | ||
SOURCE_SYSTEM_CODE | NUMBER | Source system code. References FEM_SOURCE_SYSTEMS_VL.SOURCE_SYSTEM_CODE. | ||
EXEC_MODE_CODE | VARCHAR2 | (30) | Execution Mode code. Indicates the execution mode of the processing engine. | |
DIMENSION_ID | NUMBER | (9) | Dimension ID. This is a parameter passed to the calling program which identifies the dimension that was processed. | |
TABLE_NAME | VARCHAR2 | (30) | Table Name. This is a parameter passed to the calling program which identifies the table that was processed. | |
HIERARCHY_NAME | VARCHAR2 | (150) | Hierarchy Name. This is a parameter passed to the calling program which identifies the hierarchy that was loaded. |
Cut, paste (and edit) the following text to query this object:
SELECT REQUEST_ID
, EXEC_STATUS_CODE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, PROGRAM_ID
, PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID
, RULE_SET_OBJ_DEF_ID
, RULE_SET_NAME
, EFFECTIVE_DATE
, CAL_PERIOD_ID
, LEDGER_ID
, DATASET_IO_OBJ_DEF_ID
, OUTPUT_DATASET_CODE
, SOURCE_SYSTEM_CODE
, EXEC_MODE_CODE
, DIMENSION_ID
, TABLE_NAME
, HIERARCHY_NAME
FROM FEM.FEM_PL_REQUESTS;
FEM.FEM_PL_REQUESTS does not reference any database object
FEM.FEM_PL_REQUESTS is referenced by following:
|
|
|