eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: ZX.ZX_TRANSACTION_LINES#

Object Details

Object Name:	ZX_TRANSACTION_LINES#
Object Type:	VIEW
Owner:	ZX
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
APPLICATION_ID	NUMBER		Yes
ENTITY_CODE	VARCHAR2	(30)	Yes
EVENT_CLASS_CODE	VARCHAR2	(30)	Yes
TRX_LINE_ID	NUMBER	(15)	Yes
TRX_LINE_NUMBER	NUMBER		Yes
TRX_ID	NUMBER	(15)	Yes
TRX_LEVEL_TYPE	VARCHAR2	(30)	Yes
TRX_LINE_TYPE	VARCHAR2	(30)
TRX_LINE_DATE	DATE
TRX_BUSINESS_CATEGORY	VARCHAR2	(240)
LINE_INTENDED_USE	VARCHAR2	(240)
USER_DEFINED_FISC_CLASS	VARCHAR2	(30)
LINE_AMT_INCLUDES_TAX_FLAG	VARCHAR2	(1)	Yes
LINE_AMT	NUMBER
TRX_LINE_QUANTITY	NUMBER
UNIT_PRICE	NUMBER
PRODUCT_ID	NUMBER
PRODUCT_FISC_CLASSIFICATION	VARCHAR2	(240)
PRODUCT_ORG_ID	NUMBER
UOM_CODE	VARCHAR2	(30)
PRODUCT_TYPE	VARCHAR2	(240)
PRODUCT_CODE	VARCHAR2	(300)
PRODUCT_CATEGORY	VARCHAR2	(240)
MERCHANT_PARTY_ID	NUMBER
ACCOUNT_CCID	NUMBER
ACCOUNT_STRING	VARCHAR2	(2000)
REF_DOC_LINE_ID	NUMBER
REF_DOC_LINE_QUANTITY	NUMBER
REF_DOC_APPLICATION_ID	NUMBER
REF_DOC_ENTITY_CODE	VARCHAR2	(30)
REF_DOC_EVENT_CLASS_CODE	VARCHAR2	(30)
REF_DOC_TRX_ID	NUMBER
APPLIED_FROM_LINE_ID	NUMBER
APPLIED_FROM_APPLICATION_ID	NUMBER
APPLIED_FROM_ENTITY_CODE	VARCHAR2	(30)
APPLIED_FROM_EVENT_CLASS_CODE	VARCHAR2	(30)
APPLIED_FROM_TRX_ID	NUMBER
ADJUSTED_DOC_LINE_ID	NUMBER
ADJUSTED_DOC_DATE	DATE
ADJUSTED_DOC_APPLICATION_ID	NUMBER
ADJUSTED_DOC_ENTITY_CODE	VARCHAR2	(30)
ADJUSTED_DOC_EVENT_CLASS_CODE	VARCHAR2	(30)
ADJUSTED_DOC_TRX_ID	NUMBER
TRX_LINE_DESCRIPTION	VARCHAR2	(240)
PRODUCT_DESCRIPTION	VARCHAR2	(240)
TRX_LINE_GL_DATE	DATE
LINE_LEVEL_ACTION	VARCHAR2	(30)	Yes
HISTORICAL_FLAG	VARCHAR2	(1)
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
TAX_REGIME_ID	NUMBER	(15)
TAX_REGIME_CODE	VARCHAR2	(30)
TAX_ID	NUMBER	(15)
TAX	VARCHAR2	(30)
TAX_STATUS_ID	NUMBER	(15)
TAX_STATUS_CODE	VARCHAR2	(30)
TAX_RATE_ID	NUMBER	(15)
TAX_RATE_CODE	VARCHAR2	(50)
TAX_RATE	NUMBER
TAX_LINE_AMT	NUMBER
LINE_CLASS	VARCHAR2	(30)
TRX_SHIPPING_DATE	DATE
TRX_RECEIPT_DATE	DATE
EXEMPT_CERTIFICATE_NUMBER	VARCHAR2	(80)
EXEMPT_REASON	VARCHAR2	(240)
CASH_DISCOUNT	NUMBER
VOLUME_DISCOUNT	NUMBER
TRADING_DISCOUNT	NUMBER
TRANSFER_CHARGE	NUMBER
TRANSPORTATION_CHARGE	NUMBER
INSURANCE_CHARGE	NUMBER
OTHER_CHARGE	NUMBER
POA_PARTY_ID	NUMBER
POO_PARTY_ID	NUMBER
POA_PARTY_SITE_ID	NUMBER
POO_PARTY_SITE_ID	NUMBER
MERCHANT_PARTY_COUNTRY	VARCHAR2	(150)
APPLIED_TO_APPLICATION_ID	NUMBER
APPLIED_TO_ENTITY_CODE	VARCHAR2	(30)
APPLIED_TO_EVENT_CLASS_CODE	VARCHAR2	(30)
APPLIED_TO_TRX_ID	NUMBER
APPLIED_TO_TRX_LINE_ID	NUMBER
CTRL_HDR_TX_APPL_FLAG	VARCHAR2	(1)
CTRL_TOTAL_LINE_TX_AMT	NUMBER
INPUT_TAX_CLASSIFICATION_CODE	VARCHAR2	(30)
OUTPUT_TAX_CLASSIFICATION_CODE	VARCHAR2	(50)
REF_DOC_TRX_LEVEL_TYPE	VARCHAR2	(30)
APPLIED_TO_TRX_LEVEL_TYPE	VARCHAR2	(30)
APPLIED_FROM_TRX_LEVEL_TYPE	VARCHAR2	(30)
ADJUSTED_DOC_TRX_LEVEL_TYPE	VARCHAR2	(30)
EXEMPTION_CONTROL_FLAG	VARCHAR2	(1)
EXEMPT_REASON_CODE	VARCHAR2	(30)
RECEIVABLES_TRX_TYPE_ID	NUMBER
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 APPLICATION_ID
,      ENTITY_CODE
,      EVENT_CLASS_CODE
,      TRX_LINE_ID
,      TRX_LINE_NUMBER
,      TRX_ID
,      TRX_LEVEL_TYPE
,      TRX_LINE_TYPE
,      TRX_LINE_DATE
,      TRX_BUSINESS_CATEGORY
,      LINE_INTENDED_USE
,      USER_DEFINED_FISC_CLASS
,      LINE_AMT_INCLUDES_TAX_FLAG
,      LINE_AMT
,      TRX_LINE_QUANTITY
,      UNIT_PRICE
,      PRODUCT_ID
,      PRODUCT_FISC_CLASSIFICATION
,      PRODUCT_ORG_ID
,      UOM_CODE
,      PRODUCT_TYPE
,      PRODUCT_CODE
,      PRODUCT_CATEGORY
,      MERCHANT_PARTY_ID
,      ACCOUNT_CCID
,      ACCOUNT_STRING
,      REF_DOC_LINE_ID
,      REF_DOC_LINE_QUANTITY
,      REF_DOC_APPLICATION_ID
,      REF_DOC_ENTITY_CODE
,      REF_DOC_EVENT_CLASS_CODE
,      REF_DOC_TRX_ID
,      APPLIED_FROM_LINE_ID
,      APPLIED_FROM_APPLICATION_ID
,      APPLIED_FROM_ENTITY_CODE
,      APPLIED_FROM_EVENT_CLASS_CODE
,      APPLIED_FROM_TRX_ID
,      ADJUSTED_DOC_LINE_ID
,      ADJUSTED_DOC_DATE
,      ADJUSTED_DOC_APPLICATION_ID
,      ADJUSTED_DOC_ENTITY_CODE
,      ADJUSTED_DOC_EVENT_CLASS_CODE
,      ADJUSTED_DOC_TRX_ID
,      TRX_LINE_DESCRIPTION
,      PRODUCT_DESCRIPTION
,      TRX_LINE_GL_DATE
,      LINE_LEVEL_ACTION
,      HISTORICAL_FLAG
,      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
,      TAX_REGIME_ID
,      TAX_REGIME_CODE
,      TAX_ID
,      TAX
,      TAX_STATUS_ID
,      TAX_STATUS_CODE
,      TAX_RATE_ID
,      TAX_RATE_CODE
,      TAX_RATE
,      TAX_LINE_AMT
,      LINE_CLASS
,      TRX_SHIPPING_DATE
,      TRX_RECEIPT_DATE
,      EXEMPT_CERTIFICATE_NUMBER
,      EXEMPT_REASON
,      CASH_DISCOUNT
,      VOLUME_DISCOUNT
,      TRADING_DISCOUNT
,      TRANSFER_CHARGE
,      TRANSPORTATION_CHARGE
,      INSURANCE_CHARGE
,      OTHER_CHARGE
,      POA_PARTY_ID
,      POO_PARTY_ID
,      POA_PARTY_SITE_ID
,      POO_PARTY_SITE_ID
,      MERCHANT_PARTY_COUNTRY
,      APPLIED_TO_APPLICATION_ID
,      APPLIED_TO_ENTITY_CODE
,      APPLIED_TO_EVENT_CLASS_CODE
,      APPLIED_TO_TRX_ID
,      APPLIED_TO_TRX_LINE_ID
,      CTRL_HDR_TX_APPL_FLAG
,      CTRL_TOTAL_LINE_TX_AMT
,      INPUT_TAX_CLASSIFICATION_CODE
,      OUTPUT_TAX_CLASSIFICATION_CODE
,      REF_DOC_TRX_LEVEL_TYPE
,      APPLIED_TO_TRX_LEVEL_TYPE
,      APPLIED_FROM_TRX_LEVEL_TYPE
,      ADJUSTED_DOC_TRX_LEVEL_TYPE
,      EXEMPTION_CONTROL_FLAG
,      EXEMPT_REASON_CODE
,      RECEIVABLES_TRX_TYPE_ID
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM ZX.ZX_TRANSACTION_LINES#;

Dependencies

[top of page]

ZX.ZX_TRANSACTION_LINES# references the following:

ZX: ZX_TRANSACTION_LINES

ZX.ZX_TRANSACTION_LINES# is referenced by following:

APPS: ZX_TRANSACTION_LINES