[Home] [Help] [Dependency Information]

VIEW: APPS.FND_TERRITORIES_VL

Object Details

Object Name:	FND_TERRITORIES_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	FND.FND_TERRITORIES_VL
Subobject Name:
Status:	VALID

View Type

MultiLingual view (a language resolved view of the data.)

FND_TERRITORIES_VL is a view that joins the translated, language
specific values from FND_TERRITORIES_TL with the non-displayed
data from FND_TERRITORIES to form territory entities. Oracle
Application Object Library uses this view to display translated
information in languages installed at your site.

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT ROW_ID
,      EU_CODE
,      TERRITORY_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      ISO_NUMERIC_CODE
,      ALTERNATE_TERRITORY_CODE
,      LAST_UPDATE_LOGIN
,      NLS_TERRITORY
,      ADDRESS_STYLE
,      ADDRESS_VALIDATION
,      BANK_INFO_STYLE
,      BANK_INFO_VALIDATION
,      OBSOLETE_FLAG
,      TERRITORY_SHORT_NAME
,      DESCRIPTION
,      ISO_TERRITORY_CODE
FROM APPS.FND_TERRITORIES_VL;

Dependencies

[top of page]

APPS

FND_TERRITORIES

FND_TERRITORIES_TL

APPS

AHL_FMP_COMMON_PVT - show dependent code

AHL_MR_EFFECTIVITY_DTLS_V

AML_LEAD_PROCESS_REPT_V

AMS_ACCT_INTEREST_V

AMS_LOOKUP_SALES_V

AP_APXVDLBL_XMLP_PKG - show dependent code

AP_APXVDMVD_PKG - show dependent code

AP_APXVDVSR_XMLP_PKG - show dependent code

AP_CHECKS_V

AP_VENDOR_DISP_V

AP_VENDOR_PUB_PKG - show dependent code

AP_VENDOR_SITES_V

AP_WEB_DB_COUNTRY_PKG - show dependent code

AP_WEB_DB_COUNTRY_PKG - show dependent code

AP_WEB_UPLOAD_PDM_PKG - show dependent code

ARFV_CUSTOMER_SITES

ARFV_LOCATIONS

ARH_ARXCUDCI_PKG - show dependent code

ARI_UTILITIES - show dependent code

ARPT_SQL_FUNC_UTIL - show dependent code

ARP_ADDR_LABEL_PKG - show dependent code

ARP_ADDS_MINUS99 - show dependent code

ARP_ARXCUDCI_PKG - show dependent code

ARP_TRX_DEFAULTS_3 - show dependent code

ARP_TRX_DEFAULTS_3 - show dependent code

AR_ACTIVE_REMIT_TO_ADDRESSES_V

AR_ADDRESSES_V

AR_ARBRRMLT_XMLP_PKG - show dependent code

AR_BILL_DRAWEE_ADDRESS_V

AR_BILL_TO_ADDRESSES_ACTIVE_V

AR_CMGT_PARTY_SEARCH - show dependent code

AR_CONS_INV_V

AR_CUSTOMER_BILLS_TRX_V

AR_CUSTOMER_CALLS_V

AR_CUSTOMER_FIND_V

AR_DEPOSIT_LIB_PVT - show dependent code

AR_INTEREST_HEADERS_V

AR_INVOICE_ADJ_V

AR_INVOICE_HEADER_V

AR_INVOICE_UTILS - show dependent code

AR_IREC_PAYMENTS - show dependent code

AR_MERGE_ADDRESSES_V

AR_PARTY_FIND_V

AR_REMIT_TO_ADDRESSES_V

AR_REMIT_TO_COUNTRY

AR_SHIP_ADDRESS_V

AR_SHIP_TO_ADDRESSES_ACTIVE_V

AR_XML_INVOICE_REMIT_TO_V

AR_XML_INVOICE_TP_V

ASO_I_ACCT_SITE_ADDR_V

ASO_I_COUNTRIES_V

ASO_I_PARTY_ADDRESSES_V

ASO_I_PARTY_SITES_V

ASO_PVT_QUOTE_HEADERS_V

ASO_PVT_QUOTE_LINES_V

ASO_PVT_SHIPMENTS_V

AST_CONTACT_CLASSIFICATION_V

AST_CONT_CLASSIFICATION_INT_V

AST_PARTY_LOCATIONS_V

AST_SALES_LEADS_EBC_V

AST_SALES_LEADS_V

AST_SALES_TEAM_EMP_V

AST_SALES_TEAM_PTR_V

AS_ISSUE_UTIL_PVT - show dependent code

BIS_TERRITORIES_V

CE_BU_PAY_EXTERNAL_ACCTS_V

CSC_CUST_ACCT_SITES_V

CSC_HZ_PARTIES_CONT_PTS_REL_V

CSF_RESOURCE_ADDRESS_PVT - show dependent code

CSF_RESOURCE_ADDRESS_PVT - show dependent code

CSP_SEC_INVENTORIES_V

CSR_SCHEDULER_PVT - show dependent code

CS_BILL_TO_SHIP_TO_PARTY_V

CS_CONT_CONTACTS_RG_V

EDWBV_HR_PERM_ASSIGN_LCV

EDWBV_ORGA_BUSINESS_GRP_LCV

EDW_ORGANIZATION_M_SIZING - show dependent code

EGO_SBDH_COUNTRY_OF_ASSY_AGV

FA_INS_MST_POLS_V

FA_INS_POLICIES_V

FND_CONC_TEMPLATES - show dependent code

FND_OID_USERS - show dependent code

GHR_PA_REQUESTS_PKG - show dependent code

GMF_GLSYNCH - show dependent code

GML_MOBILE_RECEIPT - show dependent code

GR_COUNTRY_PROFILES_V

HRFV_DEPLOYMENT_FACTORS

HRI_CL_GEO_COUNTRY_V

HRI_PARAMETERS - show dependent code

HR_DELTA_SYNC_MESSAGES - show dependent code

HR_FULL_SYNC_MESSAGES - show dependent code

HR_GENERAL - show dependent code

HR_ITEM_PROPERTIES_PKG - show dependent code

HR_LOCATIONS_PKG - show dependent code

HR_NMF_SYNC - show dependent code

HR_PARAMETER_HRMNPSUM - show dependent code

HR_PAYROLLS - show dependent code

HR_PERSON_RECORD - show dependent code

HR_PERSON_RECORD - show dependent code

HR_PUMP_GET - show dependent code

HR_TERRITORIES_V

HR_TMPLT - show dependent code

HR_USER_ACCT_INTERNAL - show dependent code

HR_US_FF_UDFS - show dependent code

HR_WORKFLOWS_PKG - show dependent code

HZ_COMMON_PUB - show dependent code

HZ_DNBUI_PVT - show dependent code

HZ_DQM_AC_AS_V

HZ_DQM_AC_CS_V

HZ_DQM_PS_V

HZ_DQM_P_PS_V

HZ_DQM_P_V

HZ_FORMAT_PUB - show dependent code

HZ_MERGE_ADDRESSES_V

IBY_FD_EXTRACT_GEN_PVT - show dependent code

IBY_XML_FD_INVPAYEE_1_0_V

IBY_XML_FD_PAYEEM_1_0_V

IBY_XML_FD_PAYEE_1_0_V

IBY_XML_FNDCPT_BANKACCOUNT_V

IBY_XML_FNDCPT_CREDITCARD_V

IBY_XML_FNDCPT_DEBITCARD_V

IBY_XML_FNDCPT_PAYER_1_0_V

IBY_XML_HR_ADDR_1_0_V

IBY_XML_HZ_ADDR_1_0_V

ICX_AS_EVENT_FACILITIES_V

IEC_GETPHONECOUNTRYCODEDISPLAY

IEX_AGING_TRANSACTIONS_V

IEX_AG_TRX_V

IEX_CUST_SITE_USES_V

IEX_LS_SIT_EXP_V

IEX_LS_SIT_QUICK_V

IEX_LS_TRX_ADV_V

IEX_RECEIPTS_V

IEX_TRANSACTIONS_V

IEX_TRANS_DEL_V

IGI_AR_ADDRESSES_V

IGSBV_CITIZENSHIP_COUNTRIES

IGSFV_CITIZENSHIP_COUNTRIES

IGSFV_RESIDENCY_COUNTRIES

IGS_AD_IMP_002 - show dependent code

IGS_AD_IMP_007 - show dependent code

IGS_AD_IMP_008 - show dependent code

IGS_AD_LOCVENUE_ADDR_V

IGS_AD_RVGR_INC_EXC_V

IGS_CO_GEN_003 - show dependent code

IGS_CO_PROCESS - show dependent code

IGS_GE_GEN_002 - show dependent code

IGS_OR_INST_IMP_003_PKG - show dependent code

IGS_PE_ADDR_V

IGS_PE_CITIZENSHIP_V

IGS_PE_EIT_COUNTRY_V

IGS_PE_EIT_PERM_RES_V

IGS_PE_GEN_004 - show dependent code

IGS_PE_HZ_PARTIES_V

IGS_PE_INCOME_TAX_V

IGS_PE_PASSPORT_V

IGS_PE_PERSON_ADDR_V

IGS_PE_PERS_IMP_001 - show dependent code

IGS_PE_SS_ADDR_V

IGS_PE_VISA_V

IGS_PE_VOTE_INFO_V

IGS_PE_WF_GEN - show dependent code

IGS_SV_BATCH_PROCESS_PKG - show dependent code

IGS_UC_EXP_APPLICANT_DTLS - show dependent code

IGW_ORGANIZATIONS_PVT - show dependent code

IGW_SETUP_PERSONS_PVT - show dependent code

IMC_COUNTRY_ORG_CHART_V

IMC_COUNTRY_ORG_RPT_V

IMC_COUNTRY_PER_CHART_V

IMC_COUNTRY_PER_RPT_V

INL_INTEGRATION_GRP - show dependent code

INV_UI_RCV_LOVS - show dependent code

IRCFV_CANDIDATE_EMPLYMNT_HSTRY

JG_JGZZRCAK_XMLP_PKG - show dependent code

JG_ZZ_COMMON_PKG - show dependent code

JL_JLCOARCR_XMLP_PKG - show dependent code

JMF_GTA_ARTRX_PROC - show dependent code

JMF_GTA_REPORTS_PKG - show dependent code

LNS_LOAN_PARTICIPANTS_V

MSD_SR_AREA_ALL_V

MSD_SR_COUNTRY_AREA_V

MSD_SR_REG_COUNTRY_V

MTL_COUNTRY_ASSIGNMENTS_V

MTL_CUSTOMER_ITEMS_ACTIVE_V

MTL_CUSTOMER_ITEMS_ALL_V

MTL_CUSTOMER_ITEM_XREFS_V

MTL_MOVEMENT_RPT_PKG - show dependent code

OE_OE_INLINE_ADDRESS - show dependent code

OKE_CHR_PVT - show dependent code

OKE_CLE_PVT - show dependent code

OKL_IPY_PVT - show dependent code

ORACLEAPPS - show dependent code

OZF_LOCATION_PVT - show dependent code

PAY_ADHOC_UTILS_PKG - show dependent code

PAY_AE_ARCHIVE - show dependent code

PAY_CA_EOY_RL1_ARCHIVE - show dependent code

PAY_CA_RL1_REG - show dependent code

PAY_CA_RL2_REG - show dependent code

PAY_CA_T4AEOY_ARCHIVE - show dependent code

PAY_DK_ARCHIVE - show dependent code

PAY_ENABLED_LEGISLATIONS_V

PAY_EXA_BUS - show dependent code

PAY_FI_ARCHIVE_DPSA - show dependent code

PAY_FI_ARCHIVE_PSTA - show dependent code

PAY_FI_ARCHIVE_PYSA - show dependent code

PAY_FI_ARCHIVE_UMFR - show dependent code

PAY_FUNCTIONAL_USAGES_V

PAY_GB_MOVDED_EDI - show dependent code

PAY_HK_IR56_EMPLOYEE_V

PAY_IE_PAY_ADVICE_REPORT - show dependent code

PAY_IP_STARTUP_UTIL - show dependent code

PAY_KR_SEP_TAX_WO_ADDR_V

PAY_KW_ARCHIVE - show dependent code

PAY_MONETARY_UNITS_PKG - show dependent code

PAY_MX_ANNUAL_WRI - show dependent code

PAY_NL_GENERAL - show dependent code

PAY_NL_NSI_PROCESS - show dependent code

PAY_NL_PAYSLIP_ARCHIVE - show dependent code

PAY_NO_PAYSLIP_ARCHIVE - show dependent code

PAY_ORG_PAYMENT_METHODS_V

PAY_P45_PKG - show dependent code

PAY_PAYMENT_TYPES_V

PAY_PAYMENT_TYPE_LOV

PAY_PERSONAL_PAY_METHODS_LOV

PAY_PPMV4_SS - show dependent code

PAY_SA_ARCHIVE - show dependent code

PAY_SE_ARCHIVE_CWCA - show dependent code

PAY_SE_INCOME_STATEMENT - show dependent code

PAY_SE_PAYSLIP_ARCHIVE - show dependent code

PAY_SE_POPULATE_COUNTRIES - show dependent code

PAY_SE_WORK_TIME_CERTIFICATE - show dependent code

PA_ASSIGNMENTS_PUB - show dependent code

PA_ASSIGNMENTS_PUB - show dependent code

PA_ASSIGNMENT_APPROVAL_PUB - show dependent code

PA_ASSIGNMENT_APPROVAL_PUB - show dependent code

PA_COUNTRY_V

PA_C_JOBLEVEL_RES_V

PA_HR_UPDATE_API - show dependent code

PA_LOCATIONS_V

PA_LOCATION_UTILS - show dependent code

PA_MASS_ASGMT_TRX - show dependent code

PA_MASS_ASGMT_TRX - show dependent code

PA_PROJECTS_LOV_V

PA_PROJECTS_MAINT_PUB - show dependent code

PA_PROJECTS_MAINT_PUB - show dependent code

PA_PROJECTS_PRM_V

PA_PROJECT_LISTS_USER_V

PA_PROJECT_LISTS_V

PA_PROJECT_REQUEST_PVT - show dependent code

PA_SEARCH_GLOB - show dependent code

PA_SEARCH_PUB - show dependent code

PA_SEARCH_PUB - show dependent code

PA_SEARCH_PVT - show dependent code

PERFRPHR - show dependent code

PER_ADDRESSES_PKG - show dependent code

PER_APPLICANT_PKG - show dependent code

PER_CN_ADD_LEG_HOOK - show dependent code

PER_DEPLOYMENT_FACTORS_V

PER_FI_POPULATE_COUNTRIES - show dependent code

PER_NL_QH_TAX - show dependent code

PER_PEM_BUS - show dependent code

PER_PEOPLE_V

PER_PER_BUS - show dependent code

PER_PREVIOUS_EMPLOYERS_V

PER_QH_MAINTAIN_QUERY - show dependent code

PER_QH_MAINTAIN_QUERY - show dependent code

PER_QH_SUMMARY_QUERY - show dependent code

PER_RI_CONFIG_DATAPUMP_ENTITY - show dependent code

PER_RI_CONFIG_TECH_SUMMARY - show dependent code

PER_RI_CONFIG_UTILITIES - show dependent code

PER_SG_PERWSEPI - show dependent code

PER_SG_PERWSEPI - show dependent code

PNP_UTIL_FUNC - show dependent code

PN_BUILDINGS_V

PN_COMPANY_SITES_V

PN_LEASE_CONTACT_ASSIGN_V

PN_LOCATIONS_PUB_V

PN_LOCATIONS_V

PN_PBUILDING_V

PN_PLAND_V

PN_PROPERTIES_V

POR_LOAD_LOCATION - show dependent code

POR_RCV_SHIP_DISP_LINES_V

POS_COO_LOV

POS_EXCELASN_PVT - show dependent code

POS_LINES_V

POS_VALIDATE_ASN - show dependent code

PO_EMAIL_GENERATE - show dependent code

PO_POAPPROVAL_INIT1 - show dependent code

PO_VENDOR_SITES_PAY_AP_V

PQH_COPY_ENTITY_CONTEXTS_V

PQH_TEMPLATES_V

PQH_TEM_BUS - show dependent code

PQP_ALIEN_EXPAT_TAXATION_PKG - show dependent code

QPR_SR_GEO_HIER_V

QPR_SR_GS_HIER_V

RA_CUSTOMER_TRX_PARTIAL_V

RA_CUSTOMER_TRX_V

RCV_TRANSACTIONS_INTERFACE_SV1 - show dependent code

RRS_LOCATIONS_OCV

RRS_SITES_PKG - show dependent code

RRS_SITE_INFO - show dependent code

TERTORY_VIEW

WSH_CORE - show dependent code

WSH_WSHRDBDR_XMLP_PKG - show dependent code

WSH_WSHRDLAB_XMLP_PKG - show dependent code

XDO_DGF_RPT_PKG - show dependent code

XTR_BIS_LIMIT_OVERVIEW_V

XTR_BIS_MIRROR_DDA_LIMIT_ROW_V

XTR_DISC_LIMIT_OVERVIEW_V

ZX_CORE_REP_EXTRACT_PKG - show dependent code