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.
[Home] [Help]
[Dependency Information]
VIEW: APPS.FND_COMMON_LOOKUPS
Object Details
Object Name: FND_COMMON_LOOKUPS
Object Type: VIEW
Owner: APPS
FND Design Data: FND.FND_COMMON_LOOKUPS
Subobject Name:
Status: VALID
View Type A public view which may be useful for custom reporting or other data
requirements.
FND_COMMON_LOOKUPS is a view of selected columns from the
tables FND_LOOKUP_TYPES and FND_LOOKUP_VALUES, which store
information about QuickCodes. This view contains information on all
of the QuickCodes that were defined in the FND_COMMON_LOOKUPS
table in Release 11, and is provided for backward compatibility.
.
[View Source]
Columns
Name
Datatype
Length
Mandatory
Comments
APPLICATION_ID
NUMBER
(15)
Yes
Application identifier
LOOKUP_TYPE
VARCHAR2
(30)
Yes
QuickCode lookup type
LOOKUP_CODE
VARCHAR2
(30)
Yes
QuickCode code
MEANING
VARCHAR2
(80)
Yes
QuickCode meaning
DESCRIPTION
VARCHAR2
(240)
Description
ENABLED_FLAG
VARCHAR2
(1)
Yes
Enabled flag
START_DATE_ACTIVE
DATE
The date when the QuickCode becomes active
END_DATE_ACTIVE
DATE
The date when the QuickCode becomes inactive
CREATED_BY
NUMBER
(15)
Yes
Standard Who column
CREATION_DATE
DATE
Yes
Standard Who column
LAST_UPDATE_DATE
DATE
Yes
Standard Who column
LAST_UPDATED_BY
NUMBER
(15)
Yes
Standard Who column
LAST_UPDATE_LOGIN
NUMBER
(15)
Standard Who column
ATTRIBUTE_CATEGORY
VARCHAR2
(30)
Attribute category
ATTRIBUTE1
VARCHAR2
(150)
Attribute
ATTRIBUTE2
VARCHAR2
(150)
Attribute
ATTRIBUTE3
VARCHAR2
(150)
Attribute
ATTRIBUTE4
VARCHAR2
(150)
Attribute
ATTRIBUTE5
VARCHAR2
(150)
Attribute
ATTRIBUTE6
VARCHAR2
(150)
Attribute
ATTRIBUTE7
VARCHAR2
(150)
Attribute
ATTRIBUTE8
VARCHAR2
(150)
Attribute
ATTRIBUTE9
VARCHAR2
(150)
Attribute
ATTRIBUTE10
VARCHAR2
(150)
Attribute
ATTRIBUTE11
VARCHAR2
(150)
Attribute
ATTRIBUTE12
VARCHAR2
(150)
Attribute
ATTRIBUTE13
VARCHAR2
(150)
Attribute
ATTRIBUTE14
VARCHAR2
(150)
Attribute
ATTRIBUTE15
VARCHAR2
(150)
Attribute
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT APPLICATION_ID
, LOOKUP_TYPE
, LOOKUP_CODE
, MEANING
, DESCRIPTION
, ENABLED_FLAG
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM APPS.FND_COMMON_LOOKUPS;
Dependencies
[top of page]
APPS.FND_COMMON_LOOKUPS references the following:
APPS
FND_GLOBAL
- show dependent code
FND_LOOKUP_TYPES
FND_LOOKUP_VALUES
APPS.FND_COMMON_LOOKUPS is referenced by following:
APPS
AR_SITE_USES_V
ASO_VALIDATE_PVT
- show dependent code
AS_FOUNDATION_PVT
- show dependent code
BIS_CREATE_REQUESTSET
- show dependent code
BOM_BILL_OF_MATERIALS_ERV
BOM_BILL_OF_MATERIALS_V
BOM_EXPL_INQUIRY_VIEW
BOM_INVENTORY_COMPONENTS_ERV
BOM_INVENTORY_COMPONENTS_V
BOM_INV_COMPS_INTERFACE_ERV
BOM_INV_COMPS_INTERFACE_V
BOM_VALIDATE_BOM_COMPONENT
- show dependent code
CE_801_EFT_RECONCILED_V
CE_801_EFT_TRANSACTIONS_V
CE_801_RECONCILED_V
CE_801_TRANSACTIONS_V
EAM_WORKORDERREP_PVT
- show dependent code
ENG_ENGRCNDR_XMLP_PKG
- show dependent code
ENG_REVISED_COMPONENTS_ERV
ENG_REVISED_COMPONENTS_V
ENG_REVISED_ITEMS_INTERFACE_V
ENG_REVISED_ITEMS_SCHEDULE_V
GHR_COMPLAINTS2_PKG
- show dependent code
GHR_COMPLAINTS2_PKG
- show dependent code
GHR_LACS_REMARKS
- show dependent code
GHR_PD_CLASSIFICATIONS_V2
GHR_PER_SUM
- show dependent code
HR_API
- show dependent code
HR_API
- show dependent code
HR_DELTA_SYNC_MESSAGES
- show dependent code
HR_FLEXFIELD_INFO
- show dependent code
HR_FLEXFIELD_INFO
- show dependent code
HR_FR_SEED_PKG
- show dependent code
HR_FULL_SYNC_MESSAGES
- show dependent code
HR_GENERAL
- show dependent code
HR_PL_UTILITY
- show dependent code
HR_PSF_BUS
- show dependent code
HR_RO_PERSON_VALIDATE
- show dependent code
HR_SCHEDULER_V
HR_SCL_FLEX
- show dependent code
HR_SUIT_MATCH_UTILITY_WEB
- show dependent code
HR_USER_ACCT_INTERNAL
- show dependent code
HZ_ACCOUNT_VALIDATE_V2PUB
- show dependent code
INVBV_SHIP_METHODS
INVFV_INTERORG_LEAD_TIMES
INVFV_ITEMS
INVFV_ORGANIZATION_ITEMS
INVFV_SHIP_METHODS
INVIDIT1
- show dependent code
INVIDTMP_PKG
- show dependent code
INVPVDR5
- show dependent code
INV_LABEL_PVT7
- show dependent code
INV_LABEL_PVT8
- show dependent code
INV_MEANING_SEL
- show dependent code
JAI_ETCS_PKG
- show dependent code
MRPBV_DEMAND_CLASSES
MRPFV_DEMAND_CLASSES
MRP_ATP_PROPERTIES_V
MRP_SCATP_SUPPLY_SOURCES_V
MRP_VALIDATE
- show dependent code
MSC_ATP_PROC
- show dependent code
MSD_ITEM_MASTER_V
MSD_SR_DC_ALL_V
MTL_PARAMETERS_VIEW
MTL_SYSTEM_ITEMS_FKEYS_V
OE_DEMAND_CLASSES_V
OE_FND_COMMON_LOOKUPS_V
OE_OE_AVAILABILITY
- show dependent code
OE_OE_PRICING_AVAILABILITY
- show dependent code
OKS_BILLING_PROFILES_PVT
- show dependent code
OTAFRUDT
- show dependent code
OTA_OTAFRBCR_XMLP_PKG
- show dependent code
OTA_TRAINING_PLAN_COSTS_V
PABV_ORGANIZATIONS
PAY_AC_EMP_DEDN_ACTION_INFO_V
PAY_ARCHIVE_MISSING_ASG_PKG
- show dependent code
PAY_ARCH_MISSING_ASG_PKG
- show dependent code
PAY_CA_WF_PKG
- show dependent code
PAY_ELEMENT_EXTRACT_PKG
- show dependent code
PAY_EOSURVEY_PKG
- show dependent code
PAY_EOSY_AC_PKG
- show dependent code
PAY_EXA_FLEX
- show dependent code
PAY_EXA_SHD
- show dependent code
PAY_FR_UPDATE_PCS_CODE
- show dependent code
PAY_GTNLOD_PKG
- show dependent code
PAY_INS_CUSTOM_TEMPLATE
- show dependent code
PAY_IN_PF_REPORTS
- show dependent code
PAY_LIVEARCHIVE_PKG
- show dependent code
PAY_MX_TRR_PKG
- show dependent code
PAY_PAYUSRRS_XMLP_PKG
- show dependent code
PAY_US_1099R_MAG_REPORTING
- show dependent code
PAY_US_ACTION_ARCH
- show dependent code
PAY_US_EMPLOYEE_ACTION_INFO_V
PAY_US_EMP_TIME_IN_STATE_V
PAY_US_ER_REARCH
- show dependent code
PAY_US_FLS_REPORTING_PKG
- show dependent code
PAY_US_ONLINE_W4_XML_PKG
- show dependent code
PAY_US_OTHER_W2C_V
PAY_US_OTHER_W2_V
PAY_US_PAYSLIP_SIMULATION_MAIN
- show dependent code
PAY_US_TAX_INTERNAL
- show dependent code
PAY_US_USERRA
- show dependent code
PAY_US_W2_BOX14_V
PAY_US_W2_BOX_BAL
- show dependent code
PAY_US_WEB_W4
- show dependent code
PAY_US_YEPP_MISS_ASSIGN_PKG
- show dependent code
PAY_WF_PKG
- show dependent code
PAY_YEPP_MISS_ASSIGN_PKG
- show dependent code
PAY_ZA_SOE
- show dependent code
PER_FR_BIAF_REPORT
- show dependent code
PER_FR_D2_PKG
- show dependent code
PER_MX_GRES_LEGAL_EMPLOYER_V
PER_PEOPLE3_PKG
- show dependent code
PER_PERRPPSM_XMLP_PKG
- show dependent code
PER_POS_BUS
- show dependent code
PJM_PROJECT_PARAM_PUB
- show dependent code
PJM_SEIBAN_PUB
- show dependent code
PNP_UTIL_FUNC
- show dependent code
PQP_GB_PSI_ADDDRESS
- show dependent code
PY_ZA_TAX_CERTIFICATES
- show dependent code
QABV_COLLECTION_ELEMENTS
QABV_COLLECTION_PLANS
QAFV_COLLECTION_ELEMENTS
QAFV_COLLECTION_PLANS
QA_CHARS_V
QA_ERES_PLANS_V
QA_PLANS_V
QA_PLANS_VAL_V
QA_PLAN_CHARS_V
QA_QLTCHARR_XMLP_PKG
- show dependent code
QA_QLTPLANR_XMLP_PKG
- show dependent code
QA_QLTPLCHR_XMLP_PKG
- show dependent code
QA_SKIPLOT_PROCESS_PLANS_V
QA_SS_CORE
- show dependent code
QA_SS_OM
- show dependent code
QA_SS_OM
- show dependent code
RLM_RLMDMCOM_XMLP_PKG
- show dependent code
SO_DEMAND_CLASSES_ACTIVE_V
WMS_ASSIGNMENT_PVT
- show dependent code
WMS_RULES_WORKBENCH_PVT
- show dependent code
WSM_CO_PRODUCT_COMPONENTS_V