VIEW: APPS.ZX_TRANSACTIONS_V

Source

View Text - Preformatted

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

   

View Text - HTML Formatted

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