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

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
AID_REC_NREC_TAX_DIST_ID	NUMBER	(15)	Yes
AID_SUMMARY_TAX_LINE_ID	NUMBER	(15)
AID_TAX_LINE_ID	NUMBER	(15)	Yes
AID_TRX_LINE_DIST_ID	NUMBER		Yes
AID_RECOVERABLE_FLAG	VARCHAR2	(1)	Yes
AID_DEF_REC_SETTLE_OPTION_CODE	VARCHAR2	(30)
AID_TAX_ACCOUNT_CCID	NUMBER
AID_ORG_ID	NUMBER	(15)
AID_LEDGER_ID	NUMBER	(15)

Query Text

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


SELECT AID_REC_NREC_TAX_DIST_ID
,      AID_SUMMARY_TAX_LINE_ID
,      AID_TAX_LINE_ID
,      AID_TRX_LINE_DIST_ID
,      AID_RECOVERABLE_FLAG
,      AID_DEF_REC_SETTLE_OPTION_CODE
,      AID_TAX_ACCOUNT_CCID
,      AID_ORG_ID
,      AID_LEDGER_ID
FROM APPS.AP_ZX_DEF_TAX_EXTRACT_V;

Dependencies

[top of page]

APPS.AP_ZX_DEF_TAX_EXTRACT_V references the following:

APPS: ZX_AP_DEF_TAX_EXTRACT_V

APPS.AP_ZX_DEF_TAX_EXTRACT_V is not referenced by any database object