[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;
APPS
FND_ACCESS_CONTROL_UTIL
- show dependent code
FND_GLOBAL
- show dependent code
JTF_QUAL_TYPES
JTF_QUAL_TYPE_USGS
JTF_QUAL_USGS
JTF_SEEDED_QUAL
JTF_SOURCES_ALL
APPS
CSF_RESOURCE_PUB
- show dependent code
JTF_TERRITORY_RESOURCE_PVT
- show dependent code
JTF_TERR_DEFINITION_PARAM_PVT
- show dependent code
JTF_TERR_INHERITED_QUAL_V
JTF_TERR_JSP_LOV_RECS_PUB
- show dependent code
JTF_TERR_TYPE_QUAL_V
JTY_WEBADI_OTH_TERR_DWNL_PKG
- show dependent code
|
|
|
|