[Home] [Help] [Dependency Information]
Object Name: | FND_FLEXBUILDER_ASSIGNMENTS |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | FND.FND_FLEXBUILDER_ASSIGNMENTS |
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_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FND_FLEXBUILDER_ASSIGNMENTS_U1 | NORMAL | UNIQUE | APPS_TS_ARCHIVE |
APPLICATION_ID
FUNCTION_CODE ID_FLEX_NUM SEQUENCE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPLICATION_ID | NUMBER | (10) | Yes | Application identifier |
FUNCTION_CODE | VARCHAR2 | (30) | Yes | Flexbuilder function code |
ID_FLEX_NUM | NUMBER | (10) | Yes | Key flexfield structure number |
SEQUENCE | NUMBER | (3) | Yes | Sequence number for the assignment |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
ASSIGNMENT_TYPE | VARCHAR2 | (1) | Yes | Type of assignment |
PROTECTED_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate whether this is a protected assignment |
DESCRIPTION | VARCHAR2 | (250) | Description | |
CONDITIONAL_PARAMETER | VARCHAR2 | (30) | Flexbuilder parameter name for conditional assignment | |
CONDITIONAL_VALUE | VARCHAR2 | (250) | Value of conditional parameter | |
ID_PARAMETER | VARCHAR2 | (30) | "Flexfield" type flexbuilder parameter | |
FLEXFIELD_SEGMENT_USAGES | VARCHAR2 | (250) | Segment usage information for the "Flexfield" type assignments | |
SEGMENT_ATTRIBUTE_TYPE | VARCHAR2 | (30) | Flexfield qualifier | |
SEGMENT_PARAMETER_PAIRINGS | VARCHAR2 | (240) | Pairings of flexfield segments and flexbuilder parameters | |
SEGMENT_PARAMETER | VARCHAR2 | (30) | Flexbuilder parameter to obtain segment value for segments identified by the flexfield qualifier | |
SEGMENT_CONSTANTS | VARCHAR2 | (2000) | Constant values for flexfield segments |
Cut, paste (and edit) the following text to query this object:
SELECT APPLICATION_ID
, FUNCTION_CODE
, ID_FLEX_NUM
, SEQUENCE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ASSIGNMENT_TYPE
, PROTECTED_FLAG
, DESCRIPTION
, CONDITIONAL_PARAMETER
, CONDITIONAL_VALUE
, ID_PARAMETER
, FLEXFIELD_SEGMENT_USAGES
, SEGMENT_ATTRIBUTE_TYPE
, SEGMENT_PARAMETER_PAIRINGS
, SEGMENT_PARAMETER
, SEGMENT_CONSTANTS
FROM APPLSYS.FND_FLEXBUILDER_ASSIGNMENTS;
APPLSYS.FND_FLEXBUILDER_ASSIGNMENTS does not reference any database object
APPLSYS.FND_FLEXBUILDER_ASSIGNMENTS is referenced by following:
|
|
|