[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

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

FND_APPLICATION_VL

HR_OPERATING_UNITS

XLE_ENTITY_PROFILES

ZX_TRANSACTION

APPS.ZX_TRANSACTIONS_V is not referenced by any database object