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_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
Name
Datatype
Length
Mandatory
Comments
ROW_ID
ROWID
(10)
Row identifier
EU_CODE
VARCHAR2
(3)
TERRITORY_CODE
VARCHAR2
(2)
Yes
The code for the territory
LAST_UPDATE_DATE
DATE
Yes
Standard Who column
LAST_UPDATED_BY
NUMBER
(15)
Yes
Standard Who column
CREATION_DATE
DATE
Yes
Standard Who column
CREATED_BY
NUMBER
(15)
Yes
Standard Who column
ISO_NUMERIC_CODE
VARCHAR2
(3)
The ISO numeric entity code
ALTERNATE_TERRITORY_CODE
VARCHAR2
(30)
Alternate territory code
LAST_UPDATE_LOGIN
NUMBER
(15)
Standard Who column
NLS_TERRITORY
VARCHAR2
(30)
The territory using the language
ADDRESS_STYLE
VARCHAR2
(30)
The style of address used in a given country
ADDRESS_VALIDATION
VARCHAR2
(30)
Validation that is required for addresses in a particular country
BANK_INFO_STYLE
VARCHAR2
(30)
Style for bank numbers used in a particular country
BANK_INFO_VALIDATION
VARCHAR2
(30)
Validation that is required for banks in a particular country
OBSOLETE_FLAG
VARCHAR2
(1)
Yes
TERRITORY_SHORT_NAME
VARCHAR2
(80)
Yes
The short name that stands for the territory
DESCRIPTION
VARCHAR2
(240)
Description
ISO_TERRITORY_CODE
VARCHAR2
(3)
The ISO 3 character code for the territory
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_VL references the following:
APPS
FND_TERRITORIES
FND_TERRITORIES_TL
APPS.FND_TERRITORIES_VL is referenced by following:
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