ZX_TRANSACTIONS

Details

Schema: FUSION
Object owner: FND
Object type: VIEW

Columns

Name
ROW_ID FIRST_PTY_ORG_ID OPERATING_UNIT INTERNAL_ORGANIZATION_ID INTERNAL_ORG_LOCATION_ID APPLICATION_ID APPLICATION_NAME 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 NAME 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_SEQ_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 FIRST_PTY_REG_ID THIRD_PTY_REG_ID TRX_SOURCE HDR_GL_DATE WITHHELD_TAX_AMT RECEIPT_SOURCE_CODE DROPSHIP_TYPE_ID BATCH_NAME TRX_STATUS_FLAG DOC_SEQ_ID DOC_SEQ_NAME DOC_SEQ_VALUE

Name

ROW_ID

FIRST_PTY_ORG_ID

OPERATING_UNIT

INTERNAL_ORGANIZATION_ID

INTERNAL_ORG_LOCATION_ID

APPLICATION_ID

APPLICATION_NAME

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

NAME

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_SEQ_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

FIRST_PTY_REG_ID

THIRD_PTY_REG_ID

TRX_SOURCE

HDR_GL_DATE

WITHHELD_TAX_AMT

RECEIPT_SOURCE_CODE

DROPSHIP_TYPE_ID

BATCH_NAME

TRX_STATUS_FLAG

DOC_SEQ_ID

DOC_SEQ_NAME

DOC_SEQ_VALUE

Query

SQL_Statement
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_SEQ_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, TRX.FIRST_PTY_REG_ID, TRX.THIRD_PTY_REG_ID, TRX.TRX_SOURCE, TRX.HDR_GL_DATE, TRX.WITHHELD_TAX_AMT, TRX.RECEIPT_SOURCE_CODE, TRX.DROPSHIP_TYPE_ID, TRX.BATCH_NAME, TRX.TRX_STATUS_FLAG, TRX.DOC_SEQ_ID, TRX.DOC_SEQ_NAME, TRX.DOC_SEQ_VALUE 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

SQL_Statement

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_SEQ_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,

TRX.FIRST_PTY_REG_ID,

TRX.THIRD_PTY_REG_ID,

TRX.TRX_SOURCE,

TRX.HDR_GL_DATE,

TRX.WITHHELD_TAX_AMT,

TRX.RECEIPT_SOURCE_CODE,

TRX.DROPSHIP_TYPE_ID,

TRX.BATCH_NAME,

TRX.TRX_STATUS_FLAG,

TRX.DOC_SEQ_ID,

TRX.DOC_SEQ_NAME,

TRX.DOC_SEQ_VALUE

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