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: ViewFND.ZX_TRANSACTIONS_V
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
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:

SchemaAPPS
ViewFND_APPLICATION_VL
ViewHR_OPERATING_UNITS
SynonymXLE_ENTITY_PROFILES
SynonymZX_TRANSACTION

APPS.ZX_TRANSACTIONS_V is not referenced by any database object