eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: JTF.JTF_QUAL_USGS_ALL

Object Details

Object Name:	JTF_QUAL_USGS_ALL
Object Type:	TABLE
Owner:	JTF
FND Design Data:	JTF.JTF_QUAL_USGS_ALL
Subobject Name:
Status:	VALID

This table stores the association between a qualifer and the transaction type of a source via JTF_QUAL_TYPE_USGS (stores association between SOURCES/QUALIFER TYPES tables).

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JTF_QUAL_USGS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	QUAL_USG_ID ORG_ID
JTF_QUAL_USGS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	QUAL_TYPE_USG_ID ENABLED_FLAG USE_IN_LOOKUP_FLAG SEEDED_QUAL_ID
JTF_QUAL_USGS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	QUAL_TYPE_USG_ID ENABLED_FLAG ORG_ID
JTF_QUAL_USGS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	QUAL_TYPE_USG_ID ORG_ID DISPLAY_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
QUAL_USG_ID	NUMBER		Yes	Qualifier Usages Unique Identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		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		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
APPLICATION_SHORT_NAME	VARCHAR2	(50)	Yes	Application short name of module that uses qualifier.
SEEDED_QUAL_ID	NUMBER		Yes	Foreign Key to JTF_SEEDED_QUAL_ALL_B.
QUAL_TYPE_USG_ID	NUMBER		Yes	Foreign key to JTF_QUAL_TYPE_USGS table.
ENABLED_FLAG	VARCHAR2	(1)	Yes	Flag to indicate whether the territory qualifier is enabled.
QUAL_COL1	VARCHAR2	(30)		Name of column that qualifier is sourced from.
QUAL_COL1_ALIAS	VARCHAR2	(60)		Alias name of column that qualifier is sourced from.
QUAL_COL1_DATATYPE	VARCHAR2	(30)		Datatype of column that qualifier is sourced from.
QUAL_COL1_TABLE	VARCHAR2	(30)		Name of table that qualifier is sourced from.
QUAL_COL1_TABLE_ALIAS	VARCHAR2	(30)		Alias name of table that qualifier is sourced from.
PRIM_INT_CDE_COL	VARCHAR2	(30)		Name of column that primary interest code qualifier is sourced from.
PRIM_INT_CDE_COL_ALIAS	VARCHAR2	(60)		Alias name of column that primary interest code qualifier is sourced from.
PRIM_INT_CDE_COL_DATATYPE	VARCHAR2	(30)		Datatype of column that primary interest code qualifier is sourced from.
SEC_INT_CDE_COL	VARCHAR2	(30)		Name of column that secondary interest code qualifier is sourced from.
SEC_INT_CDE_COL_ALIAS	VARCHAR2	(60)		Alias name of column that secondary interest code qualifier is sourced from.
SEC_INT_CDE_COL_DATATYPE	VARCHAR2	(30)		Datatype of column that secondary interest code qualifier is sourced from.
INT_CDE_COL_TABLE	VARCHAR2	(30)		Name of table that interest code qualifier is sourced from.
INT_CDE_COL_TABLE_ALIAS	VARCHAR2	(30)		Alias name of table that interest code qualifier is sourced from.
SEEDED_FLAG	VARCHAR2	(1)		Flag to indicate if qualifier is seeded.
CONVERT_TO_ID_FLAG	VARCHAR2	(1)		Flag to indicate if the value of this qualifier should be converted to an id.
DISPLAY_TYPE	VARCHAR2	(40)		This is the format that qualifier will be displayed in, e.g., function, interest type, char, number, range.
LOV_SQL	VARCHAR2	(1000)		This is the SQL statement that will be used to populate the LOV, from which the user can select values for the qualifier.
ORG_ID	NUMBER			Organization identifier
COLUMN_COUNT	NUMBER			The number of columns used to store a qualifier's value(s).
FORMATTING_FUNCTION_FLAG	VARCHAR2	(1)		This flag indicates whether special formatting is enabled for a qualifier. This is useful for special cases like currency and postal code qualifiers.
FORMATTING_FUNCTION_NAME	VARCHAR2	(120)		Name of the formatting function, package.function format.
SPECIAL_FUNCTION_FLAG	VARCHAR2	(1)		This flag indicates whether a special function call is enabled or disabled for qualifiers. This is to take care of 1-to-Many relations like Interest Type for Sales and Keywords.
SPECIAL_FUNCTION_NAME	VARCHAR2	(120)		Name of the special function that is being called, package.function format.
ENABLE_LOV_VALIDATION	VARCHAR2	(1)		This is used for turning LOV Validation on/off for a qualifier.
DISPLAY_SQL1	VARCHAR2	(1000)		Stores the SQL to retrieve the descriptive value for the territory value. For example, it will return the party name, interest type, meaning for the party id, interest type id, and lookup code values respectively.
LOV_SQL2	VARCHAR2	(1000)		This is the SQL statement that will be used to populate the LOV, from which the user can select values for the qualifier.
DISPLAY_SQL2	VARCHAR2	(1000)		Stores the SQL to retrieve the descriptive value for the territory value. For example, it will return the party name, interest type, meaning for the party id, interest type id, and lookup code values respectively.
LOV_SQL3	VARCHAR2	(1000)		This is the SQL statement that will be used to populate the LOV, from which the user can select values for the qualifier.
DISPLAY_SQL3	VARCHAR2	(1000)		Stores the SQL to retrieve the descriptive value for the territory value. For example, it will return the party name, interest type, meaning for the party id, interest type id, and lookup code values respectively.
SECURITY_GROUP_ID	NUMBER			Used as part of Hosting Coding Standards.
ORIG_SYSTEM_REFERENCE	VARCHAR2	(60)		Identifier of the foreign system or table.
ORIG_SYSTEM_REFERENCE_ID	NUMBER			Unique identifier for this row in foreign system or table.
UPGRADE_STATUS_FLAG	VARCHAR2	(1)		Set when this table is upgraded to support quicker upgrade re-run.
RULE1	VARCHAR2	(2000)		This is the SQL used for Territory Rule.
RULE2	VARCHAR2	(2000)		This is the SQL used for Territory Rule.
DISPLAY_SEQUENCE	NUMBER			The sequence of the display in the JSP page.
DISPLAY_LENGTH	NUMBER			The sequence of the display in the JSP page.
JSP_LOV_SQL	VARCHAR2	(2000)		This is the SQL used for JSP LOV.
USE_IN_LOOKUP_FLAG	VARCHAR2	(1)		Flag to indicate if the value of this qualifier should be used in Territory Lookup.
ALIAS_RULE1	VARCHAR2	(200)		Populated for qualifier usages which have a corresponding MV
ALIAS_RULE2	VARCHAR2	(200)		Not Used
ALIAS_OP_LIKE	VARCHAR2	(60)		Populated for qualifier usages which have a corresponding MV
ALIAS_OP_BETWEEN	VARCHAR2	(60)		Populated for qualifier usages which have a corresponding MV
ALIAS_LINE_ITEM	VARCHAR2	(240)		Not Used
OP_EQL	VARCHAR2	(2000)		Populated for sales usage . Used by bulk TAE .
OP_NOT_EQL	VARCHAR2	(2000)		Populated for sales usage . Used by bulk TAE .
OP_LSS_THN	VARCHAR2	(2000)		Populated for sales usage . Used by bulk TAE .
OP_LSS_THN_EQL	VARCHAR2	(2000)		Populated for sales usage . Used by bulk TAE .
OP_GRTR_THN	VARCHAR2	(2000)		Populated for sales usage . Used by bulk TAE .
OP_GRTR_THN_EQL	VARCHAR2	(2000)		Populated for sales usage . Used by bulk TAE .
OP_LIKE	VARCHAR2	(2000)		Populated for sales usage . Used by bulk TAE .
OP_NOT_LIKE	VARCHAR2	(2000)		Populated for sales usage . Used by bulk TAE .
OP_BETWEEN	VARCHAR2	(2000)		Populated for sales usage . Used by bulk TAE .
OP_NOT_BETWEEN	VARCHAR2	(2000)		Populated for sales usage . Used by bulk TAE .
OP_COMMON_WHERE	VARCHAR2	(2000)		Populated for sales usage . Used by bulk TAE .
QUAL_RELATION_FACTOR	NUMBER			Populated for sales usage . A unique prime number .
OBJECT_VERSION_NUMBER	NUMBER			standard column
COMPARISON_OPERATOR	VARCHAR2	(30)		comparison operator
LOW_VALUE_CHAR	VARCHAR2	(30)		low value char
HIGH_VALUE_CHAR	VARCHAR2	(30)		high value char
LOW_VALUE_CHAR_ID	VARCHAR2	(30)		low value char id
LOW_VALUE_NUMBER	VARCHAR2	(30)		low value number
HIGH_VALUE_NUMBER	VARCHAR2	(30)		high value number
INTEREST_TYPE_ID	VARCHAR2	(30)		interest type id
PRIMARY_INTEREST_CODE_ID	VARCHAR2	(30)		primary interest code id
SECONDARY_INTEREST_CODE_ID	VARCHAR2	(30)		secondary interest code id
VALUE1_ID	VARCHAR2	(30)		value 1 ID
VALUE2_ID	VARCHAR2	(30)		value 2 ID
VALUE3_ID	VARCHAR2	(30)		value 3 ID
VALUE4_ID	VARCHAR2	(30)		value 4 ID
FIRST_CHAR	VARCHAR2	(30)		first character of the value
CURRENCY_CODE	VARCHAR2	(30)		currency code
REAL_TIME_SELECT	VARCHAR2	(2000)		real time select clause
REAL_TIME_WHERE	VARCHAR2	(2000)		real time where clause
REAL_TIME_FROM	VARCHAR2	(2000)		real time from clause
UPDATE_ATTR_VAL_STMT	VARCHAR2	(2000)		update attribute value statement
INSERT_ATTR_VAL_STMT	VARCHAR2	(2000)		insert attribute value statement
HTML_LOV_SQL1	VARCHAR2	(1000)		HTML LOV SQL 1
HTML_LOV_SQL2	VARCHAR2	(1000)		HTML LOV SQL 2
HTML_LOV_SQL3	VARCHAR2	(1000)		HTML LOV SQL 3
HIERARCHY_TYPE	VARCHAR2	(30)		hierarchy type
EQUAL_FLAG	VARCHAR2	(1)		equal flag
LIKE_FLAG	VARCHAR2	(1)		like flag
BETWEEN_FLAG	VARCHAR2	(1)		between flag

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT 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
,      SEC_INT_CDE_COL
,      SEC_INT_CDE_COL_ALIAS
,      SEC_INT_CDE_COL_DATATYPE
,      INT_CDE_COL_TABLE
,      INT_CDE_COL_TABLE_ALIAS
,      SEEDED_FLAG
,      CONVERT_TO_ID_FLAG
,      DISPLAY_TYPE
,      LOV_SQL
,      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
,      SECURITY_GROUP_ID
,      ORIG_SYSTEM_REFERENCE
,      ORIG_SYSTEM_REFERENCE_ID
,      UPGRADE_STATUS_FLAG
,      RULE1
,      RULE2
,      DISPLAY_SEQUENCE
,      DISPLAY_LENGTH
,      JSP_LOV_SQL
,      USE_IN_LOOKUP_FLAG
,      ALIAS_RULE1
,      ALIAS_RULE2
,      ALIAS_OP_LIKE
,      ALIAS_OP_BETWEEN
,      ALIAS_LINE_ITEM
,      OP_EQL
,      OP_NOT_EQL
,      OP_LSS_THN
,      OP_LSS_THN_EQL
,      OP_GRTR_THN
,      OP_GRTR_THN_EQL
,      OP_LIKE
,      OP_NOT_LIKE
,      OP_BETWEEN
,      OP_NOT_BETWEEN
,      OP_COMMON_WHERE
,      QUAL_RELATION_FACTOR
,      OBJECT_VERSION_NUMBER
,      COMPARISON_OPERATOR
,      LOW_VALUE_CHAR
,      HIGH_VALUE_CHAR
,      LOW_VALUE_CHAR_ID
,      LOW_VALUE_NUMBER
,      HIGH_VALUE_NUMBER
,      INTEREST_TYPE_ID
,      PRIMARY_INTEREST_CODE_ID
,      SECONDARY_INTEREST_CODE_ID
,      VALUE1_ID
,      VALUE2_ID
,      VALUE3_ID
,      VALUE4_ID
,      FIRST_CHAR
,      CURRENCY_CODE
,      REAL_TIME_SELECT
,      REAL_TIME_WHERE
,      REAL_TIME_FROM
,      UPDATE_ATTR_VAL_STMT
,      INSERT_ATTR_VAL_STMT
,      HTML_LOV_SQL1
,      HTML_LOV_SQL2
,      HTML_LOV_SQL3
,      HIERARCHY_TYPE
,      EQUAL_FLAG
,      LIKE_FLAG
,      BETWEEN_FLAG
FROM JTF.JTF_QUAL_USGS_ALL;

Dependencies

[top of page]

JTF.JTF_QUAL_USGS_ALL does not reference any database object

JTF.JTF_QUAL_USGS_ALL is referenced by following:

APPS: JTF_QUAL_USGS; JTF_QUAL_USGS_ALL