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_FC_CODES_DENORM_B

Object Details

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

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ZX_FC_CODES_DENORM_B_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CLASSIFICATION_TYPE_CODE LANGUAGE CLASSIFICATION_CODE ANCESTOR_ID
ZX_FC_CODES_DENORM_B_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	LANGUAGE CLASSIFICATION_TYPE_CODE CONCAT_CLASSIF_CODE EFFECTIVE_FROM ENABLED_FLAG
ZX_FC_CODES_DENORM_B_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ANCESTOR_NAME CONCAT_CLASSIF_NAME LANGUAGE
ZX_FC_CODES_DENORM_B_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CLASSIFICATION_CODE
ZX_FC_CODES_DENORM_B_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COUNTRY_CODE CLASSIFICATION_TYPE_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
CLASSIFICATION_TYPE_ID	NUMBER	(15)	Yes	Fiscal classification type identifier
CLASSIFICATION_TYPE_CODE	VARCHAR2	(30)	Yes	Fiscal classification type code
CLASSIFICATION_TYPE_NAME	VARCHAR2	(240)	Yes	Fiscal classification type name
CLASSIFICATION_TYPE_CATEG_CODE	VARCHAR2	(30)	Yes	Fiscal classification type category code
CLASSIFICATION_ID	NUMBER	(15)	Yes	Fiscal classification code identifier
CLASSIFICATION_CODE	VARCHAR2	(30)	Yes	Fiscal classification code
CLASSIFICATION_NAME	VARCHAR2	(240)	Yes	Fiscal classification name
LANGUAGE	VARCHAR2	(4)	Yes	Language code of fiscal classification name and fiscal classification type name
EFFECTIVE_FROM	DATE		Yes	Effective from date
EFFECTIVE_TO	DATE			Effective to date
ENABLED_FLAG	VARCHAR2	(1)		Y or N indicates if this classification code is enabled for use. If this classification code or one of the parent codes is end dated, then this classification code is not enabled for use.
ANCESTOR_ID	NUMBER	(15)		Fiscal classification code identifier of the immediate parent for this classification code
ANCESTOR_CODE	VARCHAR2	(30)		Fiscal classification code of the immediate parent for this classification code
ANCESTOR_NAME	VARCHAR2	(240)		Fiscal classification name of the immediate parent for this classification code
CONCAT_CLASSIF_CODE	VARCHAR2	(240)	Yes	Column for recording concatanated value obtained by prefixing the parent classification codes to this classification code
CONCAT_CLASSIF_NAME	VARCHAR2	(1996)	Yes	Column for recording concatanated value obtained by prefixing the parent classification names to the name of this classification code
CLASSIFICATION_CODE_LEVEL	VARCHAR2	(30)	Yes	Depth of the hierarchy at which this classification code is defined
COUNTRY_CODE	VARCHAR2	(2)		Country code for which this classification code is applicable
SEGMENT1	VARCHAR2	(30)	Yes	Parent fiscal classification code at level 1 for this classification code. If the level is 1 for this classificaiton code, then this column records the classification code itself.
SEGMENT2	VARCHAR2	(30)		Parent fiscal classification code at level 2 for this classification code. If the level is 2 for this classificaiton code, then this column records the classification code itself.
SEGMENT3	VARCHAR2	(30)		Parent fiscal classification code at level 3 for this classification code. If the level is 3 for this classificaiton code, then this column records the classification code itself.
SEGMENT4	VARCHAR2	(30)		Parent fiscal classification code at level 4 for this classification code. If the level is 4 for this classificaiton code, then this column records the classification code itself.
SEGMENT5	VARCHAR2	(30)		Parent fiscal classification code at level 5 for this classification code. If the level is 5 for this classificaiton code, then this column records the classification code itself.
SEGMENT6	VARCHAR2	(30)		Not currently used
SEGMENT7	VARCHAR2	(30)		Not currently used
SEGMENT8	VARCHAR2	(30)		Not currently used
SEGMENT9	VARCHAR2	(30)		Not currently used
SEGMENT10	VARCHAR2	(30)		Not currently used
SEGMENT1_NAME	VARCHAR2	(240)	Yes	Parent fiscal classification name at level 1 for this classification code. If the level is 1 for this classificaiton code, then this column records the name for this classification code itself.
SEGMENT2_NAME	VARCHAR2	(240)		Parent fiscal classification name at level 2 for this classification code. If the level is 2 for this classificaiton code, then this column records the name for this classification code itself.
SEGMENT3_NAME	VARCHAR2	(240)		Parent fiscal classification name at level 3 for this classification code. If the level is 3 for this classificaiton code, then this column records the name for this classification code itself.
SEGMENT4_NAME	VARCHAR2	(240)		Parent fiscal classification name at level 4 for this classification code. If the level is 4 for this classificaiton code, then this column records the name for this classification code itself.
SEGMENT5_NAME	VARCHAR2	(240)		Parent fiscal classification name at level 5 for this classification code. If the level is 5 for this classificaiton code, then this column records the name for this classification code itself.
SEGMENT6_NAME	VARCHAR2	(240)		Not currently used
SEGMENT7_NAME	VARCHAR2	(240)		Not currently used
SEGMENT8_NAME	VARCHAR2	(240)		Not currently used
SEGMENT9_NAME	VARCHAR2	(240)		Not currently used
SEGMENT10_NAME	VARCHAR2	(240)		Not currently used
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		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_ID	NUMBER			Program identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID	NUMBER			Application identifier of last concurrent program to update this record
PROGRAM_LOGIN_ID	NUMBER			Login user identifier of last concurrent program to update this record
RECORD_TYPE_CODE	VARCHAR2	(30)		Lookup code to indicate whether the record is migrated, seeded or defined by the user

Query Text

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


SELECT CLASSIFICATION_TYPE_ID
,      CLASSIFICATION_TYPE_CODE
,      CLASSIFICATION_TYPE_NAME
,      CLASSIFICATION_TYPE_CATEG_CODE
,      CLASSIFICATION_ID
,      CLASSIFICATION_CODE
,      CLASSIFICATION_NAME
,      LANGUAGE
,      EFFECTIVE_FROM
,      EFFECTIVE_TO
,      ENABLED_FLAG
,      ANCESTOR_ID
,      ANCESTOR_CODE
,      ANCESTOR_NAME
,      CONCAT_CLASSIF_CODE
,      CONCAT_CLASSIF_NAME
,      CLASSIFICATION_CODE_LEVEL
,      COUNTRY_CODE
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT1_NAME
,      SEGMENT2_NAME
,      SEGMENT3_NAME
,      SEGMENT4_NAME
,      SEGMENT5_NAME
,      SEGMENT6_NAME
,      SEGMENT7_NAME
,      SEGMENT8_NAME
,      SEGMENT9_NAME
,      SEGMENT10_NAME
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_LOGIN_ID
,      RECORD_TYPE_CODE
FROM ZX.ZX_FC_CODES_DENORM_B;

Dependencies

[top of page]

ZX.ZX_FC_CODES_DENORM_B does not reference any database object

ZX.ZX_FC_CODES_DENORM_B is referenced by following:

APPS: ZX_FC_CODES_DENORM_B