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_USR_PROC_NEG_LINE_V

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
INTERNAL_ORGANIZATION_ID	NUMBER		Yes
APPLICATION_ID	NUMBER		Yes
ENTITY_CODE	VARCHAR2	(30)	Yes
EVENT_CLASS_CODE	VARCHAR2	(30)	Yes
TRX_ID	NUMBER		Yes
TAX_PROVIDER_ID	NUMBER	(15)	Yes
TAX_REGIME_CODE	VARCHAR2	(30)	Yes
TRX_LINE_TYPE	VARCHAR2	(30)	Yes
TRX_LINE_ID	NUMBER
PRODUCT_ID	NUMBER
PRODUCT_ORG_ID	NUMBER
EXEMPT_CERTIFICATE_NUMBER	VARCHAR2	(80)
EXEMPT_REASON_CODE	VARCHAR2	(240)
EXEMPTION_CONTROL_FLAG	VARCHAR2	(1)
SHIP_FROM_PARTY_TAX_PROFILE_ID	NUMBER
SHIP_TO_SITE_TAX_PROF_ID	NUMBER
SHIP_TO_PARTY_TAX_PROFILE_ID	NUMBER
SHIP_TO_LOCATION_ID	NUMBER
BILL_TO_CUST_ACCT_SITE_USE_ID	NUMBER
BILL_TO_SITE_TAX_PROF_ID	NUMBER
BILL_TO_PARTY_TAX_PROF_ID	NUMBER
BILL_TO_LOCATION_ID	NUMBER
LINE_LEVEL_ACTION	VARCHAR2	(30)
ADJUSTED_DOC_TRX_ID	NUMBER
LINE_AMT	NUMBER		Yes
TRADING_HQ_SITE_TAX_PROF_ID	NUMBER
TRADING_HQ_PARTY_TAX_PROF_ID	NUMBER
BILL_THIRD_PTY_ACCT_ID	NUMBER
ADJUSTED_DOC_APPLICATION_ID	NUMBER
ADJUSTED_DOC_ENTITY_CODE	VARCHAR2	(30)
ADJUSTED_DOC_EVENT_CLASS_CODE	VARCHAR2	(30)
ADJUSTED_DOC_TRX_LINE_ID	NUMBER
ADJUSTED_DOC_TRX_LEVEL_TYPE	VARCHAR2	(30)
RECEIVABLES_TRX_TYPE_ID	NUMBER
SHIP_TO_CUST_ACCT_SITE_USE_ID	NUMBER
SHIP_THIRD_PTY_ACCT_SITE_ID	NUMBER
BILL_THIRD_PTY_ACCT_SITE_ID	NUMBER

Query Text

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


SELECT INTERNAL_ORGANIZATION_ID
,      APPLICATION_ID
,      ENTITY_CODE
,      EVENT_CLASS_CODE
,      TRX_ID
,      TAX_PROVIDER_ID
,      TAX_REGIME_CODE
,      TRX_LINE_TYPE
,      TRX_LINE_ID
,      PRODUCT_ID
,      PRODUCT_ORG_ID
,      EXEMPT_CERTIFICATE_NUMBER
,      EXEMPT_REASON_CODE
,      EXEMPTION_CONTROL_FLAG
,      SHIP_FROM_PARTY_TAX_PROFILE_ID
,      SHIP_TO_SITE_TAX_PROF_ID
,      SHIP_TO_PARTY_TAX_PROFILE_ID
,      SHIP_TO_LOCATION_ID
,      BILL_TO_CUST_ACCT_SITE_USE_ID
,      BILL_TO_SITE_TAX_PROF_ID
,      BILL_TO_PARTY_TAX_PROF_ID
,      BILL_TO_LOCATION_ID
,      LINE_LEVEL_ACTION
,      ADJUSTED_DOC_TRX_ID
,      LINE_AMT
,      TRADING_HQ_SITE_TAX_PROF_ID
,      TRADING_HQ_PARTY_TAX_PROF_ID
,      BILL_THIRD_PTY_ACCT_ID
,      ADJUSTED_DOC_APPLICATION_ID
,      ADJUSTED_DOC_ENTITY_CODE
,      ADJUSTED_DOC_EVENT_CLASS_CODE
,      ADJUSTED_DOC_TRX_LINE_ID
,      ADJUSTED_DOC_TRX_LEVEL_TYPE
,      RECEIVABLES_TRX_TYPE_ID
,      SHIP_TO_CUST_ACCT_SITE_USE_ID
,      SHIP_THIRD_PTY_ACCT_SITE_ID
,      BILL_THIRD_PTY_ACCT_SITE_ID
FROM APPS.ZX_USR_PROC_NEG_LINE_V;

Dependencies

[top of page]

APPS.ZX_USR_PROC_NEG_LINE_V references the following:

APPS: ZX_PTNR_NEG_LINE_GT; ZX_TRX_PRE_PROC_OPTIONS_GT

APPS.ZX_USR_PROC_NEG_LINE_V is referenced by following:

APPS: ZX_TAXWARE_USER_PKG - show dependent code; ZX_VTX_USER_PKG - show dependent code