[Home] [Help] [Dependency Information]

VIEW: APPS.ZX_TRANSACTION_LINES_V

Object Details

Object Name:	ZX_TRANSACTION_LINES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	FND.ZX_TRANSACTION_LINES_V
Subobject Name:
Status:	VALID

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT ROW_ID
,      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
,      PRODUCT_ORG_DESC
,      UOM_CODE
,      PRODUCT_TYPE
,      PRODUCT_TYPE_DESC
,      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 APPS.ZX_TRANSACTION_LINES_V;

Dependencies

[top of page]

APPS

FND_GLOBAL - show dependent code

HR_GENERAL - show dependent code

HR_SECURITY - show dependent code

ORG_ORGANIZATION_DEFINITIONS

ZX_PRODUCT_TYPES_V

ZX_TRANSACTION_LINES

APPS.ZX_TRANSACTION_LINES_V is not referenced by any database object