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.ZX_TRL_ESL_VAT_NO_V

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
TAX_REGISTRATION_NUMBER	VARCHAR2	(50)
LEGAL_ESTB_PTP_ID	NUMBER	(15)	Yes
ESTABLISHMENT_NAME	VARCHAR2	(240)	Yes
LEGAL_ENTITY_NAME	VARCHAR2	(240)	Yes
LEGAL_ENTITY_ID	NUMBER	(15)	Yes
ORGANIZATION_NUMBER	VARCHAR2	(30)	Yes
ADDRESS_LINE_1	VARCHAR2	(240)
ADDRESS_LINE_2	VARCHAR2	(240)
TOWN_OR_CITY	VARCHAR2	(30)
REGION_1	VARCHAR2	(120)
POSTAL_CODE	VARCHAR2	(30)
GEOGRAPHY_NAME	VARCHAR2	(360)
ESTB_ADDRESS	VARCHAR2	(1031)

Query Text

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


SELECT TAX_REGISTRATION_NUMBER
,      LEGAL_ESTB_PTP_ID
,      ESTABLISHMENT_NAME
,      LEGAL_ENTITY_NAME
,      LEGAL_ENTITY_ID
,      ORGANIZATION_NUMBER
,      ADDRESS_LINE_1
,      ADDRESS_LINE_2
,      TOWN_OR_CITY
,      REGION_1
,      POSTAL_CODE
,      GEOGRAPHY_NAME
,      ESTB_ADDRESS
FROM APPS.ZX_TRL_ESL_VAT_NO_V;

Dependencies

[top of page]

APPS.ZX_TRL_ESL_VAT_NO_V references the following:

APPS: HZ_GEOGRAPHIES; HZ_PARTIES; XLE_FIRSTPARTY_INFORMATION_V; XLE_FP_ESTABLISHMENT_V; ZX_PARTY_TAX_PROFILE; ZX_REGISTRATIONS

APPS.ZX_TRL_ESL_VAT_NO_V is not referenced by any database object