[Home] [Help] [Dependency Information]
Object Name: | JTF_SEEDED_QUAL_USGS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | JTF.JTF_SEEDED_QUAL_USGS_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
QUAL_USG_ID | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
APPLICATION_SHORT_NAME | VARCHAR2 | (50) | Yes | |
SEEDED_QUAL_ID | NUMBER | Yes | ||
QUAL_TYPE_USG_ID | NUMBER | Yes | ||
ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
QUAL_COL1 | VARCHAR2 | (30) | ||
QUAL_COL1_ALIAS | VARCHAR2 | (60) | ||
QUAL_COL1_DATATYPE | VARCHAR2 | (30) | ||
QUAL_COL1_TABLE | VARCHAR2 | (30) | ||
QUAL_COL1_TABLE_ALIAS | VARCHAR2 | (30) | ||
PRIM_INT_CDE_COL | VARCHAR2 | (30) | ||
PRIM_INT_CDE_COL_ALIAS | VARCHAR2 | (60) | ||
PRIM_INT_CDE_COL_DATATYPE | VARCHAR2 | (30) | ||
INT_CDE_COL_TABLE | VARCHAR2 | (30) | ||
INT_CDE_COL_TABLE_ALIAS | VARCHAR2 | (30) | ||
SEC_INT_CDE_COL | VARCHAR2 | (30) | ||
SEC_INT_CDE_COL_ALIAS | VARCHAR2 | (60) | ||
SEC_INT_CDE_COL_DATATYPE | VARCHAR2 | (30) | ||
SEEDED_FLAG | VARCHAR2 | (1) | ||
DISPLAY_TYPE | VARCHAR2 | (40) | ||
LOV_SQL | VARCHAR2 | (1000) | ||
CONVERT_TO_ID_FLAG | VARCHAR2 | (1) | ||
ORGANIZATION_NAME | VARCHAR2 | (4000) | ||
ORG_ID | NUMBER | Organization identifier | ||
COLUMN_COUNT | NUMBER | |||
FORMATTING_FUNCTION_FLAG | VARCHAR2 | (1) | ||
FORMATTING_FUNCTION_NAME | VARCHAR2 | (120) | ||
SPECIAL_FUNCTION_FLAG | VARCHAR2 | (1) | ||
SPECIAL_FUNCTION_NAME | VARCHAR2 | (120) | ||
ENABLE_LOV_VALIDATION | VARCHAR2 | (1) | ||
DISPLAY_SQL1 | VARCHAR2 | (1000) | ||
LOV_SQL2 | VARCHAR2 | (1000) | ||
DISPLAY_SQL2 | VARCHAR2 | (1000) | ||
LOV_SQL3 | VARCHAR2 | (1000) | ||
DISPLAY_SQL3 | VARCHAR2 | (1000) | ||
SEEDED_QUAL_NAME | VARCHAR2 | (60) | Yes | |
DESCRIPTION | VARCHAR2 | (240) | ||
QUAL_TYPE_ID | NUMBER | Yes | ||
QUALIFIER_TYPE_NAME | VARCHAR2 | (40) | Yes | |
QUALIFIER_TYPE_DESCRIPTION | VARCHAR2 | (80) | Yes | |
SOURCE_ID | NUMBER | Yes | ||
LOOKUP_CODE | VARCHAR2 | (30) | Yes | |
USAGE | VARCHAR2 | (240) | Yes | |
RULE1 | VARCHAR2 | (2000) | ||
RULE2 | VARCHAR2 | (2000) | ||
DISPLAY_SEQUENCE | NUMBER | |||
DISPLAY_LENGTH | NUMBER | |||
JSP_LOV_SQL | VARCHAR2 | (2000) | ||
USE_IN_LOOKUP_FLAG | VARCHAR2 | (1) | ||
HTML_LOV_SQL1 | VARCHAR2 | (1000) | ||
HTML_LOV_SQL2 | VARCHAR2 | (1000) | ||
HTML_LOV_SQL3 | VARCHAR2 | (1000) | ||
HIERARCHY_TYPE | VARCHAR2 | (30) | ||
EQUAL_FLAG | VARCHAR2 | (1) | ||
LIKE_FLAG | VARCHAR2 | (1) | ||
BETWEEN_FLAG | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, QUAL_USG_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, APPLICATION_SHORT_NAME
, SEEDED_QUAL_ID
, QUAL_TYPE_USG_ID
, ENABLED_FLAG
, QUAL_COL1
, QUAL_COL1_ALIAS
, QUAL_COL1_DATATYPE
, QUAL_COL1_TABLE
, QUAL_COL1_TABLE_ALIAS
, PRIM_INT_CDE_COL
, PRIM_INT_CDE_COL_ALIAS
, PRIM_INT_CDE_COL_DATATYPE
, INT_CDE_COL_TABLE
, INT_CDE_COL_TABLE_ALIAS
, SEC_INT_CDE_COL
, SEC_INT_CDE_COL_ALIAS
, SEC_INT_CDE_COL_DATATYPE
, SEEDED_FLAG
, DISPLAY_TYPE
, LOV_SQL
, CONVERT_TO_ID_FLAG
, ORGANIZATION_NAME
, ORG_ID
, COLUMN_COUNT
, FORMATTING_FUNCTION_FLAG
, FORMATTING_FUNCTION_NAME
, SPECIAL_FUNCTION_FLAG
, SPECIAL_FUNCTION_NAME
, ENABLE_LOV_VALIDATION
, DISPLAY_SQL1
, LOV_SQL2
, DISPLAY_SQL2
, LOV_SQL3
, DISPLAY_SQL3
, SEEDED_QUAL_NAME
, DESCRIPTION
, QUAL_TYPE_ID
, QUALIFIER_TYPE_NAME
, QUALIFIER_TYPE_DESCRIPTION
, SOURCE_ID
, LOOKUP_CODE
, USAGE
, RULE1
, RULE2
, DISPLAY_SEQUENCE
, DISPLAY_LENGTH
, JSP_LOV_SQL
, USE_IN_LOOKUP_FLAG
, HTML_LOV_SQL1
, HTML_LOV_SQL2
, HTML_LOV_SQL3
, HIERARCHY_TYPE
, EQUAL_FLAG
, LIKE_FLAG
, BETWEEN_FLAG
FROM APPS.JTF_SEEDED_QUAL_USGS_V;
|
|
|