[Home] [Help] [Dependency Information]
Object Name: | FND_OBJECTS_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | FND.FND_OBJECTS_VL |
Subobject Name: | |
Status: | VALID |
MultiLingual view (a language resolved view of the data.)
FND_OBJECTS_VL
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ROW_ID | |
OBJECT_ID | NUMBER | (15) | Yes | PK Object ID |
OBJ_NAME | VARCHAR2 | (430) | Yes | UK Table or View name |
APPLICATION_ID | NUMBER | (15) | Yes | Application ID (Not in PK) |
DATABASE_OBJECT_NAME | VARCHAR2 | (30) | Yes | name of database table |
PK1_COLUMN_NAME | VARCHAR2 | (30) | Yes | Name of column 1 in object PK. Most selective columns first |
PK2_COLUMN_NAME | VARCHAR2 | (30) | Name of column 2 in object PK | |
PK3_COLUMN_NAME | VARCHAR2 | (30) | Name of column 3 in object PK | |
PK4_COLUMN_NAME | VARCHAR2 | (30) | Name of column 4 in object PK | |
PK5_COLUMN_NAME | VARCHAR2 | (30) | Name of column 5 in object PK | |
PK1_COLUMN_TYPE | VARCHAR2 | (8) | Yes | Data type of column 1: VARCHAR2, INTEGER, FLOAT, or DATE |
PK2_COLUMN_TYPE | VARCHAR2 | (8) | Data type of column 2: VARCHAR2, INTEGER, FLOAT, or DATE | |
PK3_COLUMN_TYPE | VARCHAR2 | (8) | Data type of column 3: VARCHAR2, INTEGER, FLOAT, or DATE | |
PK4_COLUMN_TYPE | VARCHAR2 | (8) | Data type of column 4: VARCHAR2, INTEGER, FLOAT, or DATE | |
PK5_COLUMN_TYPE | VARCHAR2 | (8) | Data type of column 5: VARCHAR2, INTEGER, FLOAT, or DATE | |
DISPLAY_NAME | VARCHAR2 | (240) | Yes | Object display name |
DESCRIPTION | VARCHAR2 | (2000) | Yes | Object description |
CREATED_BY | NUMBER | (15) | Yes | CREATED_BY |
CREATION_DATE | DATE | Yes | CREATION_DATE | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | LAST_UPDATED_BY |
LAST_UPDATE_DATE | DATE | Yes | LAST_UPDATE_DATE | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | LAST_UPDATE_LOGIN |
IREP_NAME | VARCHAR2 | (400) | ||
IREP_OBJECT_TYPE | VARCHAR2 | (30) | ||
IREP_PRODUCT | VARCHAR2 | (8) | ||
IREP_COMPATIBILITY | VARCHAR2 | (1) | ||
IREP_SCOPE | VARCHAR2 | (30) | ||
IREP_LIFECYCLE | VARCHAR2 | (30) | ||
IREP_SOURCE_FILE_PRODUCT | VARCHAR2 | (8) | ||
IREP_SOURCE_FILE_PATH | VARCHAR2 | (100) | ||
IREP_SOURCE_FILE_NAME | VARCHAR2 | (36) | ||
IREP_SOURCE_FILE_VERSION | VARCHAR2 | (150) | ||
IREP_DESCRIPTION | CLOB | (4000) | ||
IREP_XML_DESCRIPTION | CLOB | (4000) | ||
IREP_STANDARD | VARCHAR2 | (30) | ||
IREP_STANDARD_VERSION | VARCHAR2 | (30) | ||
IREP_STANDARD_SPEC | VARCHAR2 | (240) | ||
OPEN_INTERFACE_FLAG | VARCHAR2 | (1) | ||
LOAD_ERR | VARCHAR2 | (1) | ||
LOAD_ERR_MSGS | VARCHAR2 | (4000) | ||
IREP_DEF_CLASS | VARCHAR2 | (400) | ||
IREP_CLASS_NAME | VARCHAR2 | (400) | ||
IREP_IS_FILTER | VARCHAR2 | (1) | ||
IREP_IS_EXPRESSION | VARCHAR2 | (1) | ||
IREP_LDR_PP_FLAG | VARCHAR2 | (1) | ||
IREP_HIDE_SCHEMA | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, OBJECT_ID
, OBJ_NAME
, APPLICATION_ID
, DATABASE_OBJECT_NAME
, PK1_COLUMN_NAME
, PK2_COLUMN_NAME
, PK3_COLUMN_NAME
, PK4_COLUMN_NAME
, PK5_COLUMN_NAME
, PK1_COLUMN_TYPE
, PK2_COLUMN_TYPE
, PK3_COLUMN_TYPE
, PK4_COLUMN_TYPE
, PK5_COLUMN_TYPE
, DISPLAY_NAME
, DESCRIPTION
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, IREP_NAME
, IREP_OBJECT_TYPE
, IREP_PRODUCT
, IREP_COMPATIBILITY
, IREP_SCOPE
, IREP_LIFECYCLE
, IREP_SOURCE_FILE_PRODUCT
, IREP_SOURCE_FILE_PATH
, IREP_SOURCE_FILE_NAME
, IREP_SOURCE_FILE_VERSION
, IREP_DESCRIPTION
, IREP_XML_DESCRIPTION
, IREP_STANDARD
, IREP_STANDARD_VERSION
, IREP_STANDARD_SPEC
, OPEN_INTERFACE_FLAG
, LOAD_ERR
, LOAD_ERR_MSGS
, IREP_DEF_CLASS
, IREP_CLASS_NAME
, IREP_IS_FILTER
, IREP_IS_EXPRESSION
, IREP_LDR_PP_FLAG
, IREP_HIDE_SCHEMA
FROM APPS.FND_OBJECTS_VL;
|
|
|