DBA Data[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:

SchemaAPPS
SynonymFND_LOOKUP_VALUES
APPS.CN_LOOKUPS is referenced by following:

SchemaAPPS
Package BodyCNREDF_COLUMNS_PKG - show dependent code
Package BodyCNREDF_REPOSITORIES_PKG - show dependent code
Package BodyCNREDF_TABLES_PKG - show dependent code
Package BodyCNREDF_TRIGGERS_PKG - show dependent code
Package BodyCNSYIN_COLUMNS_PKG - show dependent code
Package BodyCNSYIN_REPOSITORY_PKG - show dependent code
Package BodyCNSYSP_SYSTEM_PARAMETERS_PKG - show dependent code
Package BodyCN_ACC_PERIODS_PVT - show dependent code
PL/SQL PackageCN_ACC_PERIODS_PVT - show dependent code
ViewCN_ADJUSTMENTS_V
ViewCN_ADJ_DETAIL_LINES_V
PL/SQL PackageCN_API - show dependent code
Package BodyCN_API - show dependent code
Package BodyCN_CALC_EXT_TABLES_PVT - show dependent code
Package BodyCN_CALC_FORMULAS_PVT - show dependent code
Package BodyCN_CALC_SQL_EXPS_PVT - show dependent code
Package BodyCN_CALC_SUBMISSION_PUB - show dependent code
Package BodyCN_CALC_SUBMISSION_PVT - show dependent code
Package BodyCN_CHK_PLAN_ELEMENT_PKG - show dependent code
PL/SQL PackageCN_CHK_PLAN_ELEMENT_PKG - show dependent code
Package BodyCN_COLLECTION_GEN - show dependent code
Package BodyCN_COMP_PLANS_PKG - show dependent code
Package BodyCN_COMP_PLAN_PUB - show dependent code
Package BodyCN_COMP_PLAN_PVT - show dependent code
Package BodyCN_COMP_PLAN_XMLCOPY_PVT - show dependent code
Package BodyCN_GENERAL_UTILS - show dependent code
Package BodyCN_GET_EXPRESSION - show dependent code
Package BodyCN_GET_TX_DATA_PUB - show dependent code
Package BodyCN_IMP_TRXAPI_PVT - show dependent code
Package BodyCN_MASS_ADJUST_UTIL - show dependent code
Package BodyCN_MULTI_RATE_SCHEDULES_PVT - show dependent code
PL/SQL PackageCN_MULTI_RATE_SCHEDULES_PVT - show dependent code
ViewCN_NOTIFY_LOG_V
Package BodyCN_PAYGROUP_PVT - show dependent code
Package BodyCN_PAYMENT_WORKSHEET_PVT - show dependent code
Package BodyCN_PAYRUN_PVT - show dependent code
Package BodyCN_PERIOD_QUOTAS_GRP - show dependent code
PL/SQL PackageCN_PLAN_ELEMENT_PUB - show dependent code
Package BodyCN_PLAN_ELEMENT_PUB - show dependent code
Package BodyCN_PLAN_ELEMENT_PVT - show dependent code
Package BodyCN_PLAN_TEXTS_PVT - show dependent code
Package BodyCN_PMTPLAN_PVT - show dependent code
PL/SQL PackageCN_PMT_TRANS_PVT - show dependent code
Package BodyCN_PMT_TRANS_PVT - show dependent code
Package BodyCN_PRD_QUOTA_PUB - show dependent code
Package BodyCN_PRD_QUOTA_PVT - show dependent code
ViewCN_PROCESS_AUDITS_V
ViewCN_PROCESS_AUDIT_LINES_V
Package BodyCN_PROC_BATCHES_PKG - show dependent code
Package BodyCN_QUOTA_ASSIGN_PVT - show dependent code
Package BodyCN_QUOTA_CATEGORIES_PUB - show dependent code
ViewCN_QUOTA_LOOKUPS_V
Package BodyCN_QUOTA_PAY_ELEMENTS_PVT - show dependent code
Package BodyCN_QUOTA_RULES_GRP - show dependent code
Package BodyCN_QUOTA_RULE_PVT - show dependent code
Package BodyCN_QUOTA_RULE_UPLIFTS_GRP - show dependent code
Package BodyCN_QUOTA_RULE_UPLIFT_PVT - show dependent code
Package BodyCN_RATE_DIMENSIONS_PVT - show dependent code
Package BodyCN_REASONS_PUB - show dependent code
PL/SQL PackageCN_ROLE_PAY_GROUPS_PVT - show dependent code
Package BodyCN_ROLE_PAY_GROUPS_PVT - show dependent code
Package BodyCN_ROLE_PLANS_PUB - show dependent code
PL/SQL PackageCN_ROLE_PLANS_PUB - show dependent code
Package BodyCN_ROLE_PMT_PLANS_PVT - show dependent code
PL/SQL PackageCN_ROLE_PMT_PLANS_PVT - show dependent code
Package BodyCN_RT_QUOTA_ASGNS_PVT - show dependent code
Package BodyCN_RT_QUOTA_ASGN_PVT - show dependent code
Package BodyCN_RULEATTRIBUTE_PUB - show dependent code
Package BodyCN_RULEATTRIBUTE_PVT - show dependent code
PL/SQL PackageCN_RULESET_PUB - show dependent code
Package BodyCN_RULESET_PUB - show dependent code
Package BodyCN_RULESET_PVT - show dependent code
Package BodyCN_RULES_DISP_PUB - show dependent code
Package BodyCN_RULE_PUB - show dependent code
Package BodyCN_RULE_PVT - show dependent code
Package BodyCN_SCA_RULES_BATCH_GEN_PVT - show dependent code
Package BodyCN_SCA_RULES_ONLINE_GEN_PVT - show dependent code
PL/SQL PackageCN_SFP_GROUP_UTIL_PVT - show dependent code
Package BodyCN_SFP_GROUP_UTIL_PVT - show dependent code
PL/SQL PackageCN_SFP_SRP_UTIL_PVT - show dependent code
Package BodyCN_SFP_SRP_UTIL_PVT - show dependent code
Package BodyCN_SRP_PAYEE_ASSIGNS_PVT - show dependent code
Package BodyCN_SRP_PAYGROUP_PUB - show dependent code
ViewCN_SRP_PLAN_ASSIGNS_V
Package BodyCN_SRP_PMT_PLANS_PUB - show dependent code
Package BodyCN_SRP_PMT_PLANS_PVT - show dependent code
Package BodyCN_SRP_PRD_QUOTA_PUB - show dependent code
ViewCN_SRP_QUOTA_ASSIGNS_V
ViewCN_SRP_RATE_ASSIGNS_V
Package BodyCN_SRP_ROLLOVER_QUOTA_PVT - show dependent code
Package BodyCN_TRANSACTION_LOAD_PKG - show dependent code
ViewCN_TRX_DETAILS
Package BodyCN_TRX_FACTORS_PKG - show dependent code
Package BodyCN_TRX_FACTORS_PVT - show dependent code
ViewCN_TRX_FACTORS_V
Package BodyCN_TRX_FACTOR_PVT - show dependent code
PL/SQL PackageCN_UN_PROC_PUB - show dependent code
Package BodyCN_UPG_PMT_REASONS_PKG - show dependent code
PL/SQL PackageCN_WKSHT_GET_PUB - show dependent code
Package BodyCN_WKSHT_GET_PUB - show dependent code