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_EXEMPTIONS_V

Object Details

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

[View Source]

Columns

Name	Datatype	Length
EXEMPT_CERTIFICATE_NUMBER	VARCHAR2	(80)
EXEMPT_REASON_CODE	VARCHAR2	(30)
MEANING	VARCHAR2	(80)
EXEMPTION_STATUS_CODE	VARCHAR2	(30)
RATE_MODIFIER	NUMBER
TAX_REGIME_CODE	VARCHAR2	(30)
CUST_ACCOUNT_ID	NUMBER	(15)
SITE_USE_ID	NUMBER	(15)
PARTY_ID	NUMBER	(15)
PARTY_SITE_ID	NUMBER
EFFECTIVE_FROM	DATE
EFFECTIVE_TO	DATE
CONTENT_OWNER_ID	NUMBER	(15)
ORG_ID	NUMBER	(15)
LE_ID	NUMBER

Query Text

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


SELECT EXEMPT_CERTIFICATE_NUMBER
,      EXEMPT_REASON_CODE
,      MEANING
,      EXEMPTION_STATUS_CODE
,      RATE_MODIFIER
,      TAX_REGIME_CODE
,      CUST_ACCOUNT_ID
,      SITE_USE_ID
,      PARTY_ID
,      PARTY_SITE_ID
,      EFFECTIVE_FROM
,      EFFECTIVE_TO
,      CONTENT_OWNER_ID
,      ORG_ID
,      LE_ID
FROM APPS.ZX_EXEMPTIONS_V;

Dependencies

[top of page]

APPS.ZX_EXEMPTIONS_V references the following:

APPS: FND_LOOKUP_VALUES; GL_LEDGER_LE_V; HR_OPERATING_UNITS; HZ_PARTY_SITES; XLE_ENTITY_PROFILES; ZX_EXEMPTIONS; ZX_PARTY_TAX_PROFILE

APPS.ZX_EXEMPTIONS_V is referenced by following:

APPS: OE_BULK_PROCESS_HEADER - show dependent code; OE_CNCL_VALIDATE_HEADER - show dependent code; OE_CNCL_VALIDATE_LINE - show dependent code; OE_DEFAULT_PVT - show dependent code; ZX_TCM_VALIDATE_EXEMPT_PKG - show dependent code