FND_APPL_TAXONOMY
Taxonomy table stores the various modules or artifacts that make up the Taxonomy hierarchy.
Details
-
Schema: TAXONOMY
-
Object owner: FND
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
FND_APPL_TAXONOMY_PK |
MODULE_ID, ENTERPRISE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ENTERPRISE_ID | NUMBER | 18 | Yes | ENTERPRISE_ID | |
| MODULE_ID | VARCHAR2 | 32 | Yes | Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data. | |
| PRODUCT_LINE | NUMBER | 15 | Yes | PRODUCT_LINE | |
| MODULE_NAME | VARCHAR2 | 4000 | Yes | MODULE_NAME | |
| MODULE_TYPE | VARCHAR2 | 30 | Yes | MODULE_TYPE | |
| MODULE_KEY | VARCHAR2 | 100 | MODULE_KEY | ||
| PRODUCT_CODE | VARCHAR2 | 30 | PRODUCT_CODE | ||
| ALTERNATIVE_ID | NUMBER | ALTERNATIVE_ID | |||
| USAGE_TYPE | VARCHAR2 | 30 | Yes | USAGE_TYPE | |
| IS_SEED_DATA_ALLOWED | VARCHAR2 | 1 | IS_SEED_DATA_ALLOWED | ||
| PILLAR_NAME | VARCHAR2 | 30 | PILLAR_NAME | ||
| WEBAPP_SHORT_NAME | VARCHAR2 | 320 | Bug 10161907 - add new column in fnd_appl_taxonomy to store page-webapp mappings | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| START_DATE | TIMESTAMP | START_DATE | |||
| END_DATE | TIMESTAMP | END_DATE | |||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Seed data file from which the row originates. | ||
| IS_VALID | VARCHAR2 | 1 | Column used during ADR extract | ||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| fnd_diag_tag | fnd_appl_taxonomy | ENTERPRISE_ID, MODULE_ID |
| fnd_grants_bk | fnd_appl_taxonomy | MODULE_ID, ENTERPRISE_ID |
| hwm_tcsmrs_b | fnd_appl_taxonomy | MODULE_ID, ENTERPRISE_ID |
| hwm_rp_tm_patterns | fnd_appl_taxonomy | MODULE_ID, ENTERPRISE_ID |
| hwm_tm_status_def_b | fnd_appl_taxonomy | MODULE_ID, ENTERPRISE_ID |
| hwm_processes_b | fnd_appl_taxonomy | MODULE_ID, ENTERPRISE_ID |
| hwm_te_alt_name_vals_tl | fnd_appl_taxonomy | ENTERPRISE_ID, MODULE_ID |
| hwm_tm_statuses | fnd_appl_taxonomy | MODULE_ID, ENTERPRISE_ID |
| hwm_tz_display_names | fnd_appl_taxonomy | ENTERPRISE_ID, MODULE_ID |
| hwm_batch_processes | fnd_appl_taxonomy | MODULE_ID, ENTERPRISE_ID |
| hwm_tcd_mapping_sets_b | fnd_appl_taxonomy | MODULE_ID, ENTERPRISE_ID |
| hwm_data_sources_b | fnd_appl_taxonomy | ENTERPRISE_ID, MODULE_ID |
| hwm_tcats_b | fnd_appl_taxonomy | MODULE_ID, ENTERPRISE_ID |
| fnd_objects | fnd_appl_taxonomy | MODULE_ID, ENTERPRISE_ID |
| hts_labor_demand_defs | fnd_appl_taxonomy | ENTERPRISE_ID, MODULE_ID |
| hwm_te_alt_names | fnd_appl_taxonomy | ENTERPRISE_ID, MODULE_ID |
| hrc_txn_conditions_lovusage | fnd_appl_taxonomy | MODULE_ID, ENTERPRISE_ID |
| hwm_process_components | fnd_appl_taxonomy | MODULE_ID, ENTERPRISE_ID |
| hwm_layer | fnd_appl_taxonomy | ENTERPRISE_ID, MODULE_ID |
| hwm_tm_atrb_fld_set_cmps | fnd_appl_taxonomy | ENTERPRISE_ID, MODULE_ID |
| hrc_arm_notifications_b | fnd_appl_taxonomy | MODULE_ID, ENTERPRISE_ID |
| hwm_grp_type | fnd_appl_taxonomy | ENTERPRISE_ID, MODULE_ID |
| hrc_txn_conditions_lovmetadata | fnd_appl_taxonomy | MODULE_ID, ENTERPRISE_ID |
| hwm_data_source_usages | fnd_appl_taxonomy | ENTERPRISE_ID, MODULE_ID |
| hwm_process_modes | fnd_appl_taxonomy | MODULE_ID, ENTERPRISE_ID |
| hwm_rp_tm_periods_b | fnd_appl_taxonomy | MODULE_ID, ENTERPRISE_ID |
| hwm_te_alt_name_vals_b | fnd_appl_taxonomy | ENTERPRISE_ID, MODULE_ID |
| hrc_txn_conditions_context | fnd_appl_taxonomy | MODULE_ID, ENTERPRISE_ID |
| hwm_tm_bal_status_usages | fnd_appl_taxonomy | MODULE_ID, ENTERPRISE_ID |
| hwm_tcsmr_sets | fnd_appl_taxonomy | MODULE_ID, ENTERPRISE_ID |
| hwm_tm_status_conditions | fnd_appl_taxonomy | MODULE_ID, ENTERPRISE_ID |
| fnd_menus | fnd_appl_taxonomy | MODULE_ID, ENTERPRISE_ID |
| fnd_grants | fnd_appl_taxonomy | MODULE_ID, ENTERPRISE_ID |
| fnd_objects_bk | fnd_appl_taxonomy | MODULE_ID, ENTERPRISE_ID |
| hrc_arm_composites_b | fnd_appl_taxonomy | MODULE_ID, ENTERPRISE_ID |
| hwm_tcat_usages | fnd_appl_taxonomy | MODULE_ID, ENTERPRISE_ID |
| hwm_data_source_attributes | fnd_appl_taxonomy | MODULE_ID, ENTERPRISE_ID |
| hwm_tm_atrb_fld_sets | fnd_appl_taxonomy | MODULE_ID, ENTERPRISE_ID |
| hwm_criteria_binds | fnd_appl_taxonomy | ENTERPRISE_ID, MODULE_ID |
| hwm_tm_atrb_flds_b | fnd_appl_taxonomy | ENTERPRISE_ID, MODULE_ID |
| fnd_menus_bk | fnd_appl_taxonomy | MODULE_ID, ENTERPRISE_ID |
| hwm_tcd_mappings_b | fnd_appl_taxonomy | MODULE_ID, ENTERPRISE_ID |
| hrc_arm_process_b | fnd_appl_taxonomy | MODULE_ID, ENTERPRISE_ID |
| fnd_form_functions | fnd_appl_taxonomy | ENTERPRISE_ID, MODULE_ID |
| hwm_data_source_criterias | fnd_appl_taxonomy | ENTERPRISE_ID, MODULE_ID |
| hwm_tm_atrb_fld_mstr_ref_b | fnd_appl_taxonomy | ENTERPRISE_ID, MODULE_ID |
| fnd_diag_test | fnd_appl_taxonomy | ENTERPRISE_ID, MODULE_ID |
| hwm_dt_src_usg_bnd_vals | fnd_appl_taxonomy | ENTERPRISE_ID, MODULE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FND_APPL_TAXONOMY_N1 | Non Unique | FUSION_TS_TX_DATA | MODULE_TYPE, PRODUCT_LINE |
| FND_APPL_TAXONOMY_N2 | Non Unique | FUSION_TS_TX_DATA | MODULE_NAME, PRODUCT_LINE |
| FND_APPL_TAXONOMY_N3 | Non Unique | FUSION_TS_TX_DATA | MODULE_KEY, PRODUCT_LINE |
| FND_APPL_TAXONOMY_N4 | Non Unique | FUSION_TS_TX_DATA | ALTERNATIVE_ID, PRODUCT_LINE |
| FND_APPL_TAXONOMY_N5 | Non Unique | FUSION_TS_TX_DATA | PRODUCT_LINE |
| FND_APPL_TAXONOMY_N6 | Non Unique | FUSION_TS_TX_DATA | UPPER("MODULE_NAME") |
| FND_APPL_TAXONOMY_N7 | Non Unique | Default | ALTERNATIVE_ID, MODULE_TYPE, ENTERPRISE_ID |
| FND_APPL_TAXONOMY_U1 | Unique | FUSION_TS_TX_DATA | DECODE("MODULE_TYPE",'PRODUCT_LINE',TO_CHAR("PRODUCT_LINE")||'#'||TO_CHAR("ALTERNATIVE_ID")||'#'||TO_CHAR("ENTERPRISE_ID"),NULL), ENTERPRISE_ID, MODULE_ID, ORA_SEED_SET1 |
| FND_APPL_TAXONOMY_U11 | Unique | FUSION_TS_TX_DATA | DECODE("MODULE_TYPE",'PRODUCT_LINE',TO_CHAR("PRODUCT_LINE")||'#'||TO_CHAR("ALTERNATIVE_ID")||'#'||TO_CHAR("ENTERPRISE_ID"),NULL), ENTERPRISE_ID, MODULE_ID, ORA_SEED_SET2 |
| FND_APPL_TAXONOMY_U2 | Unique | FUSION_TS_TX_DATA | DECODE("MODULE_TYPE",'FAMILY',TO_CHAR("PRODUCT_LINE")||'#'||TO_CHAR("ALTERNATIVE_ID")||'#'||TO_CHAR("ENTERPRISE_ID"),NULL), ENTERPRISE_ID, MODULE_ID, ORA_SEED_SET1 |
| FND_APPL_TAXONOMY_U21 | Unique | FUSION_TS_TX_DATA | DECODE("MODULE_TYPE",'FAMILY',TO_CHAR("PRODUCT_LINE")||'#'||TO_CHAR("ALTERNATIVE_ID")||'#'||TO_CHAR("ENTERPRISE_ID"),NULL), ENTERPRISE_ID, MODULE_ID, ORA_SEED_SET2 |
| FND_APPL_TAXONOMY_U3 | Unique | FUSION_TS_TX_DATA | DECODE("MODULE_TYPE",'APPLICATION',TO_CHAR("PRODUCT_LINE")||'#'||TO_CHAR("ALTERNATIVE_ID")||'#'||TO_CHAR("ENTERPRISE_ID"),NULL), ENTERPRISE_ID, MODULE_ID, ORA_SEED_SET1 |
| FND_APPL_TAXONOMY_U31 | Unique | FUSION_TS_TX_DATA | DECODE("MODULE_TYPE",'APPLICATION',TO_CHAR("PRODUCT_LINE")||'#'||TO_CHAR("ALTERNATIVE_ID")||'#'||TO_CHAR("ENTERPRISE_ID"),NULL), ENTERPRISE_ID, MODULE_ID, ORA_SEED_SET2 |
| FND_APPL_TAXONOMY_U4 | Unique | FUSION_TS_TX_DATA | DECODE("MODULE_TYPE",'PRODUCT_LINE',TO_CHAR("PRODUCT_LINE")||'#'||"MODULE_KEY"||'#'||TO_CHAR("ENTERPRISE_ID"),NULL), ENTERPRISE_ID, MODULE_ID, ORA_SEED_SET1 |
| FND_APPL_TAXONOMY_U41 | Unique | FUSION_TS_TX_DATA | DECODE("MODULE_TYPE",'PRODUCT_LINE',TO_CHAR("PRODUCT_LINE")||'#'||"MODULE_KEY"||'#'||TO_CHAR("ENTERPRISE_ID"),NULL), ENTERPRISE_ID, MODULE_ID, ORA_SEED_SET2 |
| FND_APPL_TAXONOMY_U5 | Unique | FUSION_TS_TX_DATA | DECODE("MODULE_TYPE",'FAMILY',TO_CHAR("PRODUCT_LINE")||'#'||"MODULE_KEY"||'#'||TO_CHAR("ENTERPRISE_ID"),NULL), ENTERPRISE_ID, MODULE_ID, ORA_SEED_SET1 |
| FND_APPL_TAXONOMY_U51 | Unique | FUSION_TS_TX_DATA | DECODE("MODULE_TYPE",'FAMILY',TO_CHAR("PRODUCT_LINE")||'#'||"MODULE_KEY"||'#'||TO_CHAR("ENTERPRISE_ID"),NULL), ENTERPRISE_ID, MODULE_ID, ORA_SEED_SET2 |
| FND_APPL_TAXONOMY_U6 | Unique | FUSION_TS_TX_DATA | DECODE("MODULE_TYPE",'APPLICATION',TO_CHAR("PRODUCT_LINE")||'#'||"MODULE_KEY"||'#'||TO_CHAR("ENTERPRISE_ID"),NULL), MODULE_ID, ENTERPRISE_ID, ORA_SEED_SET1 |
| FND_APPL_TAXONOMY_U61 | Unique | FUSION_TS_TX_DATA | DECODE("MODULE_TYPE",'APPLICATION',TO_CHAR("PRODUCT_LINE")||'#'||"MODULE_KEY"||'#'||TO_CHAR("ENTERPRISE_ID"),NULL), MODULE_ID, ENTERPRISE_ID, ORA_SEED_SET2 |
| FND_APPL_TAXONOMY_U7 | Unique | FUSION_TS_TX_DATA | MODULE_ID, ENTERPRISE_ID, ORA_SEED_SET1 |
| FND_APPL_TAXONOMY_U71 | Unique | FUSION_TS_TX_DATA | MODULE_ID, ENTERPRISE_ID, ORA_SEED_SET2 |
| FND_APPL_TAXONOMY_U8 | Non Unique | FUSION_TS_TX_DATA | DECODE("MODULE_TYPE",'APPLICATION',TO_CHAR("PRODUCT_LINE")||'#'||"MODULE_NAME"||'#'||TO_CHAR("ENTERPRISE_ID"),NULL), MODULE_ID, ENTERPRISE_ID |