View: ZX_TRANSACTIONS_V

Product:	FND - Application Object Library
Description:
Implementation/DBA Data:	APPS.ZX_TRANSACTIONS_V

View Text

SELECT TRX.ROWID ROW_ID
, TRX.FIRST_PTY_ORG_ID
, OU.NAME OPERATING_UNIT
, TRX.INTERNAL_ORGANIZATION_ID
, TRX.INTERNAL_ORG_LOCATION_ID
, TRX.APPLICATION_ID
, APP.APPLICATION_NAME
, TRX.ENTITY_CODE
, TRX.EVENT_CLASS_CODE
, TRX.EVENT_TYPE_CODE
, TRX.TRX_ID
, TRX.TAX_EVENT_TYPE_CODE
, TRX.TRX_DATE
, TRX.DOCUMENT_EVENT_TYPE
, TRX.LEDGER_ID
, TRX.TRX_CURRENCY_CODE
, TRX.CURRENCY_CONVERSION_DATE
, TRX.CURRENCY_CONVERSION_RATE
, TRX.CURRENCY_CONVERSION_TYPE
, TRX.MINIMUM_ACCOUNTABLE_UNIT
, TRX.PRECISION
, TRX.LEGAL_ENTITY_PTP_ID
, TRX.LEGAL_ENTITY_ID
, XLE.NAME
, TRX.ROUNDING_SHIP_TO_PARTY_ID
, TRX.ROUNDING_SHIP_FROM_PARTY_ID
, TRX.ROUNDING_BILL_TO_PARTY_ID
, TRX.ROUNDING_BILL_FROM_PARTY_ID
, TRX.RNDG_SHIP_TO_PARTY_SITE_ID
, TRX.RNDG_SHIP_FROM_PARTY_SITE_ID
, TRX.RNDG_BILL_TO_PARTY_SITE_ID
, TRX.RNDG_BILL_FROM_PARTY_SITE_ID
, TRX.BILL_FROM_PARTY_SITE_ID
, TRX.BILL_TO_PARTY_SITE_ID
, TRX.SHIP_FROM_PARTY_SITE_ID
, TRX.SHIP_TO_PARTY_SITE_ID
, TRX.SHIP_TO_PARTY_ID
, TRX.SHIP_FROM_PARTY_ID
, TRX.BILL_TO_PARTY_ID
, TRX.BILL_FROM_PARTY_ID
, TRX.SHIP_TO_LOCATION_ID
, TRX.SHIP_FROM_LOCATION_ID
, TRX.BILL_TO_LOCATION_ID
, TRX.BILL_FROM_LOCATION_ID
, TRX.POA_LOCATION_ID
, TRX.POO_LOCATION_ID
, TRX.PAYING_LOCATION_ID
, TRX.OWN_HQ_LOCATION_ID
, TRX.TRADING_HQ_LOCATION_ID
, TRX.POC_LOCATION_ID
, TRX.POI_LOCATION_ID
, TRX.POD_LOCATION_ID
, TRX.TRX_NUMBER
, TRX.TRX_DESCRIPTION
, TRX.DOCUMENT_SUB_TYPE
, TRX.SUPPLIER_TAX_INVOICE_NUMBER
, TRX.SUPPLIER_TAX_INVOICE_DATE
, TRX.SUPPLIER_EXCHANGE_RATE
, TRX.TAX_INVOICE_DATE
, TRX.TAX_INVOICE_NUMBER
, TRX.TITLE_TRANSFER_LOCATION_ID
, TRX.TAX_MANUAL_ENTRY_FLAG
, TRX.ESTABLISHMENT_ID
, TRX.RECEIVABLES_TRX_TYPE_ID
, TRX.DEFAULT_TAXATION_COUNTRY
, TRX.QUOTE_FLAG
, TRX.CTRL_TOTAL_HDR_TX_AMT
, TRX.PORT_OF_ENTRY_CODE
, TRX.TAX_REPORTING_FLAG
, TRX.SHIP_TO_CUST_ACCT_SITE_USE_ID
, TRX.BILL_TO_CUST_ACCT_SITE_USE_ID
, TRX.PROVNL_TAX_DETERMINATION_DATE
, TRX.APPLIED_TO_TRX_NUMBER
, TRX.SHIP_THIRD_PTY_ACCT_ID
, TRX.BILL_THIRD_PTY_ACCT_ID
, TRX.SHIP_THIRD_PTY_ACCT_SITE_ID
, TRX.BILL_THIRD_PTY_ACCT_SITE_ID
, TRX.VALIDATION_CHECK_FLAG
, TRX.OBJECT_VERSION_NUMBER
, TRX.CREATED_BY
, TRX.CREATION_DATE
, TRX.LAST_UPDATED_BY
, TRX.LAST_UPDATE_DATE
, TRX.LAST_UPDATE_LOGIN
FROM ZX_TRANSACTION TRX
, HR_OPERATING_UNITS OU
, XLE_ENTITY_PROFILES XLE
, FND_APPLICATION_VL APP
WHERE TRX.INTERNAL_ORGANIZATION_ID = OU.ORGANIZATION_ID
AND TRX.APPLICATION_ID = APP.APPLICATION_ID (+)
AND TRX.LEGAL_ENTITY_ID = XLE.LEGAL_ENTITY_ID