[Home] [Help]
[Dependency Information]
VIEW: APPS.CN_LOOKUPS
Object Details
Object Name: | CN_LOOKUPS |
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
***** Warning: Oracle Internal Use Only *****
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
View Type
Internal
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
LOOKUP_TYPE |
VARCHAR2 |
(30) |
Yes |
|
LOOKUP_CODE |
VARCHAR2 |
(30) |
Yes |
|
MEANING |
VARCHAR2 |
(80) |
Yes |
|
DESCRIPTION |
VARCHAR2 |
(240) |
|
|
ENABLED_FLAG |
VARCHAR2 |
(1) |
Yes |
|
START_DATE_ACTIVE |
DATE |
|
|
|
END_DATE_ACTIVE |
DATE |
|
|
|
CREATED_BY |
NUMBER |
(15) |
Yes |
Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE |
DATE |
|
Yes |
Standard who column - date when this row was created. |
LAST_UPDATED_BY |
NUMBER |
(15) |
Yes |
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_DATE |
DATE |
|
Yes |
Standard Who column - date when a user last updated this row. |
LAST_UPDATE_LOGIN |
NUMBER |
(15) |
|
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT LOOKUP_TYPE
, LOOKUP_CODE
, MEANING
, DESCRIPTION
, ENABLED_FLAG
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.CN_LOOKUPS;
Dependencies
[top of page]
APPS.CN_LOOKUPS references the following:
-
APPS
-
FND_LOOKUP_VALUES
APPS.CN_LOOKUPS is referenced by following:
-
APPS
-
CNREDF_COLUMNS_PKG
- show dependent code
-
CNREDF_REPOSITORIES_PKG
- show dependent code
-
CNREDF_TABLES_PKG
- show dependent code
-
CNREDF_TRIGGERS_PKG
- show dependent code
-
CNSYIN_COLUMNS_PKG
- show dependent code
-
CNSYIN_REPOSITORY_PKG
- show dependent code
-
CNSYSP_SYSTEM_PARAMETERS_PKG
- show dependent code
-
CN_ACC_PERIODS_PVT
- show dependent code
-
CN_ACC_PERIODS_PVT
- show dependent code
-
CN_ADJUSTMENTS_V
-
CN_ADJ_DETAIL_LINES_V
-
CN_API
- show dependent code
-
CN_API
- show dependent code
-
CN_CALC_EXT_TABLES_PVT
- show dependent code
-
CN_CALC_FORMULAS_PVT
- show dependent code
-
CN_CALC_SQL_EXPS_PVT
- show dependent code
-
CN_CALC_SUBMISSION_PUB
- show dependent code
-
CN_CALC_SUBMISSION_PVT
- show dependent code
-
CN_CHK_PLAN_ELEMENT_PKG
- show dependent code
-
CN_CHK_PLAN_ELEMENT_PKG
- show dependent code
-
CN_COLLECTION_GEN
- show dependent code
-
CN_COMP_PLANS_PKG
- show dependent code
-
CN_COMP_PLAN_PUB
- show dependent code
-
CN_COMP_PLAN_PVT
- show dependent code
-
CN_COMP_PLAN_XMLCOPY_PVT
- show dependent code
-
CN_GENERAL_UTILS
- show dependent code
-
CN_GET_EXPRESSION
- show dependent code
-
CN_GET_TX_DATA_PUB
- show dependent code
-
CN_IMP_TRXAPI_PVT
- show dependent code
-
CN_MASS_ADJUST_UTIL
- show dependent code
-
CN_MULTI_RATE_SCHEDULES_PVT
- show dependent code
-
CN_MULTI_RATE_SCHEDULES_PVT
- show dependent code
-
CN_NOTIFY_LOG_V
-
CN_PAYGROUP_PVT
- show dependent code
-
CN_PAYMENT_WORKSHEET_PVT
- show dependent code
-
CN_PAYRUN_PVT
- show dependent code
-
CN_PERIOD_QUOTAS_GRP
- show dependent code
-
CN_PLAN_ELEMENT_PUB
- show dependent code
-
CN_PLAN_ELEMENT_PUB
- show dependent code
-
CN_PLAN_ELEMENT_PVT
- show dependent code
-
CN_PLAN_TEXTS_PVT
- show dependent code
-
CN_PMTPLAN_PVT
- show dependent code
-
CN_PMT_TRANS_PVT
- show dependent code
-
CN_PMT_TRANS_PVT
- show dependent code
-
CN_PRD_QUOTA_PUB
- show dependent code
-
CN_PRD_QUOTA_PVT
- show dependent code
-
CN_PROCESS_AUDITS_V
-
CN_PROCESS_AUDIT_LINES_V
-
CN_PROC_BATCHES_PKG
- show dependent code
-
CN_QUOTA_ASSIGN_PVT
- show dependent code
-
CN_QUOTA_CATEGORIES_PUB
- show dependent code
-
CN_QUOTA_LOOKUPS_V
-
CN_QUOTA_PAY_ELEMENTS_PVT
- show dependent code
-
CN_QUOTA_RULES_GRP
- show dependent code
-
CN_QUOTA_RULE_PVT
- show dependent code
-
CN_QUOTA_RULE_UPLIFTS_GRP
- show dependent code
-
CN_QUOTA_RULE_UPLIFT_PVT
- show dependent code
-
CN_RATE_DIMENSIONS_PVT
- show dependent code
-
CN_REASONS_PUB
- show dependent code
-
CN_ROLE_PAY_GROUPS_PVT
- show dependent code
-
CN_ROLE_PAY_GROUPS_PVT
- show dependent code
-
CN_ROLE_PLANS_PUB
- show dependent code
-
CN_ROLE_PLANS_PUB
- show dependent code
-
CN_ROLE_PMT_PLANS_PVT
- show dependent code
-
CN_ROLE_PMT_PLANS_PVT
- show dependent code
-
CN_RT_QUOTA_ASGNS_PVT
- show dependent code
-
CN_RT_QUOTA_ASGN_PVT
- show dependent code
-
CN_RULEATTRIBUTE_PUB
- show dependent code
-
CN_RULEATTRIBUTE_PVT
- show dependent code
-
CN_RULESET_PUB
- show dependent code
-
CN_RULESET_PUB
- show dependent code
-
CN_RULESET_PVT
- show dependent code
-
CN_RULES_DISP_PUB
- show dependent code
-
CN_RULE_PUB
- show dependent code
-
CN_RULE_PVT
- show dependent code
-
CN_SCA_RULES_BATCH_GEN_PVT
- show dependent code
-
CN_SCA_RULES_ONLINE_GEN_PVT
- show dependent code
-
CN_SFP_GROUP_UTIL_PVT
- show dependent code
-
CN_SFP_GROUP_UTIL_PVT
- show dependent code
-
CN_SFP_SRP_UTIL_PVT
- show dependent code
-
CN_SFP_SRP_UTIL_PVT
- show dependent code
-
CN_SRP_PAYEE_ASSIGNS_PVT
- show dependent code
-
CN_SRP_PAYGROUP_PUB
- show dependent code
-
CN_SRP_PLAN_ASSIGNS_V
-
CN_SRP_PMT_PLANS_PUB
- show dependent code
-
CN_SRP_PMT_PLANS_PVT
- show dependent code
-
CN_SRP_PRD_QUOTA_PUB
- show dependent code
-
CN_SRP_QUOTA_ASSIGNS_V
-
CN_SRP_RATE_ASSIGNS_V
-
CN_SRP_ROLLOVER_QUOTA_PVT
- show dependent code
-
CN_TRANSACTION_LOAD_PKG
- show dependent code
-
CN_TRX_DETAILS
-
CN_TRX_FACTORS_PKG
- show dependent code
-
CN_TRX_FACTORS_PVT
- show dependent code
-
CN_TRX_FACTORS_V
-
CN_TRX_FACTOR_PVT
- show dependent code
-
CN_UN_PROC_PUB
- show dependent code
-
CN_UPG_PMT_REASONS_PKG
- show dependent code
-
CN_WKSHT_GET_PUB
- show dependent code
-
CN_WKSHT_GET_PUB
- show dependent code