[Home] [Help] [Dependency Information]
Object Name: | HZ_STYLE_FMT_LAYOUTS_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AR.HZ_STYLE_FMT_LAYOUTS_VL |
Subobject Name: | |
Status: | VALID |
MultiLingual view (a language resolved view of the data.)
A multilingual view joining HZ_STYLE_FMT_LAYOUTS_B with
HZ_STYLE_FMT_LAYOUTS_TL for the current session language.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
STYLE_FMT_LAYOUT_ID | NUMBER | (15) | Yes | Sequence generated unique identifier for style format layout row. |
PROMPT | VARCHAR2 | (30) | Attribute prompt specific to location, for example Zip Code for US and Postcode for UK. | |
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. |
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). |
Cut, paste (and edit) the following text to query this object:
SELECT STYLE_FMT_LAYOUT_ID
, PROMPT
, STYLE_FORMAT_CODE
, VARIATION_NUMBER
, ATTRIBUTE_CODE
, ATTRIBUTE_APPLICATION_ID
, 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
FROM APPS.HZ_STYLE_FMT_LAYOUTS_VL;
|
|
|