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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.HR_LOCATIONS_ALL2_DFV

Object Details

Object Name:	HR_LOCATIONS_ALL2_DFV
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
ROW_ID	ROWID	(10)
CONTEXT_VALUE	VARCHAR2	(150)
TAX_REGISTRATION_NUMBER	VARCHAR2	(150)
TAXABLE_PERSON	VARCHAR2	(150)
INDUSTRY_CLASSIFICATION	VARCHAR2	(150)
INDUSTRY_SUB_CLASSIFICATION	VARCHAR2	(150)
BANK_CODE	VARCHAR2	(150)
BANK_BRANCH_CODE	VARCHAR2	(150)
BANK_ACCOUNT_NUMBER	VARCHAR2	(150)
TAX_FILING_PERIOD	VARCHAR2	(150)
PROPERTY_RENTAL	VARCHAR2	(150)
RATES_REFERENCE	VARCHAR2	(150)
ESTABLISHMENT_TYPE	VARCHAR2	(150)
TAX_CODE	VARCHAR2	(150)
FOUR_DIGIT_CODE	VARCHAR2	(150)
FEDERAL_TAX_BUREAU_OFFICE	VARCHAR2	(150)
INCEPTION_DATE	DATE
COA_ID	VARCHAR2	(150)
VALIDATE_FULL	VARCHAR2	(150)
TAX_RATE_DIFF_ACCTS	VARCHAR2	(150)
BRAND	VARCHAR2	(150)
INSCRIPTION	VARCHAR2	(150)
LEGAL_REPRESENTATIVE	VARCHAR2	(150)
LEGAL_REPRESENTATIVE_ID	VARCHAR2	(150)
CITY_CODE	NUMBER
ECONOMIC_ACTIVITY_CODE	NUMBER
CONCATENATED_SEGMENTS	VARCHAR2	(1056)

Query Text

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


SELECT ROW_ID
,      CONTEXT_VALUE
,      TAX_REGISTRATION_NUMBER
,      TAXABLE_PERSON
,      INDUSTRY_CLASSIFICATION
,      INDUSTRY_SUB_CLASSIFICATION
,      BANK_CODE
,      BANK_BRANCH_CODE
,      BANK_ACCOUNT_NUMBER
,      TAX_FILING_PERIOD
,      PROPERTY_RENTAL
,      RATES_REFERENCE
,      ESTABLISHMENT_TYPE
,      TAX_CODE
,      FOUR_DIGIT_CODE
,      FEDERAL_TAX_BUREAU_OFFICE
,      INCEPTION_DATE
,      COA_ID
,      VALIDATE_FULL
,      TAX_RATE_DIFF_ACCTS
,      BRAND
,      INSCRIPTION
,      LEGAL_REPRESENTATIVE
,      LEGAL_REPRESENTATIVE_ID
,      CITY_CODE
,      ECONOMIC_ACTIVITY_CODE
,      CONCATENATED_SEGMENTS
FROM APPS.HR_LOCATIONS_ALL2_DFV;

Dependencies

[top of page]

APPS.HR_LOCATIONS_ALL2_DFV references the following:

APPS: FND_NUMBER - show dependent code; HR_LOCATIONS_ALL

APPS.HR_LOCATIONS_ALL2_DFV is not referenced by any database object