[Home] [Help] [Dependency Information]
Object Name: | HZ_STYLE_FMT_LAYOUTS_B |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.HZ_STYLE_FMT_LAYOUTS_B |
Subobject Name: | |
Status: | VALID |
The HZ_STYLE_FMT_LAYOUTS_B table identifies which attributes appear in a particular style format variation, as well as the sequence and lines they are displayed in and delimiters that they are
separated by.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HZ_STYLE_FMT_LAYOUTS_B_U1 | NORMAL | UNIQUE | APPS_TS_SEED | STYLE_FMT_LAYOUT_ID |
HZ_STYLE_FMT_LAYOUTS_B_N2 | NORMAL | NONUNIQUE | APPS_TS_SEED |
ATTRIBUTE_APPLICATION_ID
ATTRIBUTE_CODE STYLE_FORMAT_CODE VARIATION_NUMBER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
STYLE_FMT_LAYOUT_ID | NUMBER | (15) | Yes | Sequence generated unique identifier for style format layout row. |
STYLE_FORMAT_CODE | VARCHAR2 | (30) | Yes | Identifies style format for variation. |
VARIATION_NUMBER | NUMBER | (4) | Yes | Sequential number within style format to identify Variation. |
ATTRIBUTE_CODE | VARCHAR2 | (30) | Yes | Identifies component or attribute being laid out. |
ATTRIBUTE_APPLICATION_ID | NUMBER | (15) | Yes | Identifies application that attribute belongs to. |
COMP_STYLE_CODE | VARCHAR2 | (30) | Unique code to represent the style. | |
LINE_NUMBER | NUMBER | (2) | Yes | Indicates line that attribute should be formatted on. |
POSITION | NUMBER | (2) | Yes | Indicates position on the line that attribute should be placed. |
MANDATORY_FLAG | VARCHAR2 | (1) | Yes | Y or N indicates whether attribute is mandatory for layout or not. |
USE_INITIAL_FLAG | VARCHAR2 | (1) | Yes | Y or N indicates whether only initial character of attribute should be used or not. |
UPPERCASE_FLAG | VARCHAR2 | (1) | Yes | Y or N indicates whether attribute should be translated to uppercase or not. |
TRANSFORM_FUNCTION | VARCHAR2 | (100) | Identifies PL/SQL function with optional parameters that must be called to transform attribute. | |
DELIMITER_BEFORE | VARCHAR2 | (20) | One or more characters to be placed before attribute if attribute is not null. | |
DELIMITER_AFTER | VARCHAR2 | (20) | One or more characters to be placed after attribute if attribute is not null. | |
BLANK_LINES_BEFORE | NUMBER | (2) | Number of blank lines to display before attribute. Only valid for first attribute on new line. | |
BLANK_LINES_AFTER | NUMBER | (2) | Number of blank lines to display after attribute. Only valid for last attribute on given line. | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
OBJECT_VERSION_NUMBER | NUMBER | (15) | Version number for locking purposes | |
START_DATE_ACTIVE | DATE | Date of record activation | ||
END_DATE_ACTIVE | DATE | Date of record deactivation |
Cut, paste (and edit) the following text to query this object:
SELECT STYLE_FMT_LAYOUT_ID
, STYLE_FORMAT_CODE
, VARIATION_NUMBER
, ATTRIBUTE_CODE
, ATTRIBUTE_APPLICATION_ID
, COMP_STYLE_CODE
, LINE_NUMBER
, POSITION
, MANDATORY_FLAG
, USE_INITIAL_FLAG
, UPPERCASE_FLAG
, TRANSFORM_FUNCTION
, DELIMITER_BEFORE
, DELIMITER_AFTER
, BLANK_LINES_BEFORE
, BLANK_LINES_AFTER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, START_DATE_ACTIVE
, END_DATE_ACTIVE
FROM AR.HZ_STYLE_FMT_LAYOUTS_B;
AR.HZ_STYLE_FMT_LAYOUTS_B does not reference any database object
AR.HZ_STYLE_FMT_LAYOUTS_B is referenced by following:
|
|
|