[Home] [Help] [Dependency Information]
Object Name: | FEM_RFSH_FILES |
---|---|
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_RFSH_FILES_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
FILE_NAME
FILE_OWNER_APPLICATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FILE_NAME | VARCHAR2 | (150) | Yes | Identifies the file name containing the seeded data |
FILE_OWNER_APPLICATION_ID | NUMBER | Yes | Identifies the owning application of the file | |
FILE_PRODUCT_PREFIX | VARCHAR2 | (50) | Yes | Identifies the application short name of the owning application of the file |
FILE_TYPE | VARCHAR2 | (30) | Yes | Designates the file as either being an ldt file or a sql file |
SUB_PHASE | NUMBER | (5) | Yes | Designates the relative order in which the file needs to be run |
LCTFILE_NAME | VARCHAR2 | (150) | Identifies the control file name for the file | |
LCTFILE_OWNER_APPLICATION_ID | NUMBER | Identifies the owning application of the control file | ||
LCTFILE_PRODUCT_PREFIX | VARCHAR2 | (50) | Identifies the application short name of the owning application of the control file | |
CREATION_DATE | DATE | Yes | Identifies the date on which the record was originally created | |
CREATED_BY | NUMBER | Yes | Identifies the user that originally loaded the record | |
LAST_UPDATED_BY | NUMBER | Yes | Identifies the user that last modified the record | |
LAST_UPDATE_DATE | DATE | Yes | Identifies the date on which the record was last modified | |
LAST_UPDATE_LOGIN | NUMBER | Identifies the login that last modified the record |
Cut, paste (and edit) the following text to query this object:
SELECT FILE_NAME
, FILE_OWNER_APPLICATION_ID
, FILE_PRODUCT_PREFIX
, FILE_TYPE
, SUB_PHASE
, LCTFILE_NAME
, LCTFILE_OWNER_APPLICATION_ID
, LCTFILE_PRODUCT_PREFIX
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM FEM.FEM_RFSH_FILES;
FEM.FEM_RFSH_FILES does not reference any database object
FEM.FEM_RFSH_FILES is referenced by following:
|
|
|