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_TRANSACTIONS_V

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
ROW_ID	ROWID	(10)
FIRST_PTY_ORG_ID	NUMBER
OPERATING_UNIT	VARCHAR2	(240)	Yes
INTERNAL_ORGANIZATION_ID	NUMBER		Yes
INTERNAL_ORG_LOCATION_ID	NUMBER
APPLICATION_ID	NUMBER		Yes
APPLICATION_DESCRIPTION	VARCHAR2	(240)
ENTITY_CODE	VARCHAR2	(30)	Yes
EVENT_CLASS_CODE	VARCHAR2	(30)	Yes
EVENT_TYPE_CODE	VARCHAR2	(30)	Yes
TRX_ID	NUMBER	(15)	Yes
TAX_EVENT_TYPE_CODE	VARCHAR2	(30)
TRX_DATE	DATE		Yes
DOCUMENT_EVENT_TYPE	VARCHAR2	(30)
LEDGER_ID	NUMBER	(15)
TRX_CURRENCY_CODE	VARCHAR2	(15)
CURRENCY_CONVERSION_DATE	DATE
CURRENCY_CONVERSION_RATE	NUMBER
CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)
MINIMUM_ACCOUNTABLE_UNIT	NUMBER
PRECISION	NUMBER
LEGAL_ENTITY_PTP_ID	NUMBER	(15)
LEGAL_ENTITY_ID	NUMBER		Yes
LEGAL_ENTITY_DESCRIPTION	VARCHAR2	(240)	Yes
ROUNDING_SHIP_TO_PARTY_ID	NUMBER
ROUNDING_SHIP_FROM_PARTY_ID	NUMBER
ROUNDING_BILL_TO_PARTY_ID	NUMBER
ROUNDING_BILL_FROM_PARTY_ID	NUMBER
RNDG_SHIP_TO_PARTY_SITE_ID	NUMBER
RNDG_SHIP_FROM_PARTY_SITE_ID	NUMBER
RNDG_BILL_TO_PARTY_SITE_ID	NUMBER
RNDG_BILL_FROM_PARTY_SITE_ID	NUMBER
BILL_FROM_PARTY_SITE_ID	NUMBER
BILL_TO_PARTY_SITE_ID	NUMBER
SHIP_FROM_PARTY_SITE_ID	NUMBER
SHIP_TO_PARTY_SITE_ID	NUMBER
SHIP_TO_PARTY_ID	NUMBER
SHIP_FROM_PARTY_ID	NUMBER
BILL_TO_PARTY_ID	NUMBER
BILL_FROM_PARTY_ID	NUMBER
SHIP_TO_LOCATION_ID	NUMBER
SHIP_FROM_LOCATION_ID	NUMBER
BILL_TO_LOCATION_ID	NUMBER
BILL_FROM_LOCATION_ID	NUMBER
POA_LOCATION_ID	NUMBER
POO_LOCATION_ID	NUMBER
PAYING_LOCATION_ID	NUMBER
OWN_HQ_LOCATION_ID	NUMBER
TRADING_HQ_LOCATION_ID	NUMBER
POC_LOCATION_ID	NUMBER
POI_LOCATION_ID	NUMBER
POD_LOCATION_ID	NUMBER
TRX_NUMBER	VARCHAR2	(150)	Yes
TRX_DESCRIPTION	VARCHAR2	(240)
DOCUMENT_SUB_TYPE	VARCHAR2	(240)
SUPPLIER_TAX_INVOICE_NUMBER	VARCHAR2	(150)
SUPPLIER_TAX_INVOICE_DATE	DATE
SUPPLIER_EXCHANGE_RATE	NUMBER
TAX_INVOICE_DATE	DATE
TAX_INVOICE_NUMBER	VARCHAR2	(150)
TITLE_TRANSFER_LOCATION_ID	NUMBER
TAX_MANUAL_ENTRY_FLAG	VARCHAR2	(1)
ESTABLISHMENT_ID	NUMBER
RECEIVABLES_TRX_TYPE_ID	NUMBER
DEFAULT_TAXATION_COUNTRY	VARCHAR2	(2)
QUOTE_FLAG	VARCHAR2	(1)
CTRL_TOTAL_HDR_TX_AMT	NUMBER
PORT_OF_ENTRY_CODE	VARCHAR2	(30)
TAX_REPORTING_FLAG	VARCHAR2	(1)
SHIP_TO_CUST_ACCT_SITE_USE_ID	NUMBER
BILL_TO_CUST_ACCT_SITE_USE_ID	NUMBER
PROVNL_TAX_DETERMINATION_DATE	DATE
APPLIED_TO_TRX_NUMBER	VARCHAR2	(20)
SHIP_THIRD_PTY_ACCT_ID	NUMBER
BILL_THIRD_PTY_ACCT_ID	NUMBER
SHIP_THIRD_PTY_ACCT_SITE_ID	NUMBER
BILL_THIRD_PTY_ACCT_SITE_ID	NUMBER
VALIDATION_CHECK_FLAG	VARCHAR2	(1)
OBJECT_VERSION_NUMBER	NUMBER		Yes
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)

Query Text

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


SELECT ROW_ID
,      FIRST_PTY_ORG_ID
,      OPERATING_UNIT
,      INTERNAL_ORGANIZATION_ID
,      INTERNAL_ORG_LOCATION_ID
,      APPLICATION_ID
,      APPLICATION_DESCRIPTION
,      ENTITY_CODE
,      EVENT_CLASS_CODE
,      EVENT_TYPE_CODE
,      TRX_ID
,      TAX_EVENT_TYPE_CODE
,      TRX_DATE
,      DOCUMENT_EVENT_TYPE
,      LEDGER_ID
,      TRX_CURRENCY_CODE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_TYPE
,      MINIMUM_ACCOUNTABLE_UNIT
,      PRECISION
,      LEGAL_ENTITY_PTP_ID
,      LEGAL_ENTITY_ID
,      LEGAL_ENTITY_DESCRIPTION
,      ROUNDING_SHIP_TO_PARTY_ID
,      ROUNDING_SHIP_FROM_PARTY_ID
,      ROUNDING_BILL_TO_PARTY_ID
,      ROUNDING_BILL_FROM_PARTY_ID
,      RNDG_SHIP_TO_PARTY_SITE_ID
,      RNDG_SHIP_FROM_PARTY_SITE_ID
,      RNDG_BILL_TO_PARTY_SITE_ID
,      RNDG_BILL_FROM_PARTY_SITE_ID
,      BILL_FROM_PARTY_SITE_ID
,      BILL_TO_PARTY_SITE_ID
,      SHIP_FROM_PARTY_SITE_ID
,      SHIP_TO_PARTY_SITE_ID
,      SHIP_TO_PARTY_ID
,      SHIP_FROM_PARTY_ID
,      BILL_TO_PARTY_ID
,      BILL_FROM_PARTY_ID
,      SHIP_TO_LOCATION_ID
,      SHIP_FROM_LOCATION_ID
,      BILL_TO_LOCATION_ID
,      BILL_FROM_LOCATION_ID
,      POA_LOCATION_ID
,      POO_LOCATION_ID
,      PAYING_LOCATION_ID
,      OWN_HQ_LOCATION_ID
,      TRADING_HQ_LOCATION_ID
,      POC_LOCATION_ID
,      POI_LOCATION_ID
,      POD_LOCATION_ID
,      TRX_NUMBER
,      TRX_DESCRIPTION
,      DOCUMENT_SUB_TYPE
,      SUPPLIER_TAX_INVOICE_NUMBER
,      SUPPLIER_TAX_INVOICE_DATE
,      SUPPLIER_EXCHANGE_RATE
,      TAX_INVOICE_DATE
,      TAX_INVOICE_NUMBER
,      TITLE_TRANSFER_LOCATION_ID
,      TAX_MANUAL_ENTRY_FLAG
,      ESTABLISHMENT_ID
,      RECEIVABLES_TRX_TYPE_ID
,      DEFAULT_TAXATION_COUNTRY
,      QUOTE_FLAG
,      CTRL_TOTAL_HDR_TX_AMT
,      PORT_OF_ENTRY_CODE
,      TAX_REPORTING_FLAG
,      SHIP_TO_CUST_ACCT_SITE_USE_ID
,      BILL_TO_CUST_ACCT_SITE_USE_ID
,      PROVNL_TAX_DETERMINATION_DATE
,      APPLIED_TO_TRX_NUMBER
,      SHIP_THIRD_PTY_ACCT_ID
,      BILL_THIRD_PTY_ACCT_ID
,      SHIP_THIRD_PTY_ACCT_SITE_ID
,      BILL_THIRD_PTY_ACCT_SITE_ID
,      VALIDATION_CHECK_FLAG
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.ZX_TRANSACTIONS_V;

Dependencies

[top of page]

APPS.ZX_TRANSACTIONS_V references the following:

APPS: FND_APPLICATION_VL; HR_OPERATING_UNITS; XLE_ENTITY_PROFILES; ZX_TRANSACTION

APPS.ZX_TRANSACTIONS_V is not referenced by any database object