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: ZX.ZX_DETERMINING_FACTORS_B

Object Details

Object Name:	ZX_DETERMINING_FACTORS_B
Object Type:	TABLE
Owner:	ZX
FND Design Data:	ZX.ZX_DETERMINING_FACTORS_B
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ZX_DETERMINING_FACTORS_B_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DETERMINING_FACTOR_ID
ZX_DETERMINING_FACTORS_B_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	DETERMINING_FACTOR_CODE DETERMINING_FACTOR_CLASS_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
DETERMINING_FACTOR_CODE	VARCHAR2	(30)	Yes	Determining factor code
DETERMINING_FACTOR_CLASS_CODE	VARCHAR2	(30)	Yes	Determining factor class code
VALUE_SET	VARCHAR2	(80)		Value set associated with the Determining Factor.
TAX_PARAMETER_CODE	VARCHAR2	(30)		Tax parameter code for the determining factor
DATA_TYPE_CODE	VARCHAR2	(30)	Yes	Data type of the determining factor. Possible values are DATE, NUMERIC and ALPHANUMERIC.
TAX_FUNCTION_CODE	VARCHAR2	(30)		Not currently used
RECORD_TYPE_CODE	VARCHAR2	(30)	Yes	Lookup code to indicate whether the record is migrated, seeded or defined by the user
TAX_REGIME_DET_FLAG	VARCHAR2	(1)	Yes	Y or N to indicate whether the determining factor can be used for tax regime determination
TAX_SUMMARIZATION_FLAG	VARCHAR2	(1)	Yes	Y or N to Indicate whether the determining factor can be used for tax summarization
TAX_RULES_FLAG	VARCHAR2	(1)	Yes	Y or N to indicate whether the determining factor can be used to define tax rules
TAXABLE_BASIS_FLAG	VARCHAR2	(1)	Yes	Y or N to indicate whether the determining factor can be used in a taxable basis formula
TAX_CALCULATION_FLAG	VARCHAR2	(1)	Yes	Y or N to indicate whether the determining factor can be used in a tax calculation formula
INTERNAL_FLAG	VARCHAR2	(1)	Yes	Y or N to indicate whether the determining factor is for internal use only
RECORD_ONLY_FLAG	VARCHAR2	(1)	Yes	Y or N to indicate whether the determining factor can be recorded for reporting purpose
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
REQUEST_ID	NUMBER			Request identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID	NUMBER			Application identifier of last concurrent program to update this record
PROGRAM_ID	NUMBER			Program identifier of last concurrent program to update this record
PROGRAM_LOGIN_ID	NUMBER			Login user identifier of this record by a concurrent program
DETERMINING_FACTOR_ID	NUMBER	(15)	Yes	Unique identifier
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
OBJECT_VERSION_NUMBER	NUMBER		Yes	Object version number

Query Text

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


SELECT DETERMINING_FACTOR_CODE
,      DETERMINING_FACTOR_CLASS_CODE
,      VALUE_SET
,      TAX_PARAMETER_CODE
,      DATA_TYPE_CODE
,      TAX_FUNCTION_CODE
,      RECORD_TYPE_CODE
,      TAX_REGIME_DET_FLAG
,      TAX_SUMMARIZATION_FLAG
,      TAX_RULES_FLAG
,      TAXABLE_BASIS_FLAG
,      TAX_CALCULATION_FLAG
,      INTERNAL_FLAG
,      RECORD_ONLY_FLAG
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      DETERMINING_FACTOR_ID
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
FROM ZX.ZX_DETERMINING_FACTORS_B;

Dependencies

[top of page]

ZX.ZX_DETERMINING_FACTORS_B does not reference any database object

ZX.ZX_DETERMINING_FACTORS_B is referenced by following:

APPS: ZX_DETERMINING_FACTORS_B