[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

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_GLOBAL - show dependent code

FND_LOOKUP_TYPES

FND_LOOKUP_VALUES

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