[Home] [Help]
View: ZX_TRANSACTION_LINES_V
View Text
SELECT TRL.ROWID ROW_ID
,
TRL.APPLICATION_ID
,
TRL.ENTITY_CODE
,
TRL.EVENT_CLASS_CODE
,
TRL.TRX_LINE_ID
,
TRL.TRX_LINE_NUMBER
,
TRL.TRX_ID
,
TRL.TRX_LEVEL_TYPE
,
TRL.TRX_LINE_TYPE
,
TRL.TRX_LINE_DATE
,
TRL.TRX_BUSINESS_CATEGORY
,
TRL.LINE_INTENDED_USE
,
TRL.USER_DEFINED_FISC_CLASS
,
TRL.LINE_AMT_INCLUDES_TAX_FLAG
,
TRL.LINE_AMT
,
TRL.TRX_LINE_QUANTITY
,
TRL.UNIT_PRICE
,
TRL.PRODUCT_ID
,
TRL.PRODUCT_FISC_CLASSIFICATION
,
TRL.PRODUCT_ORG_ID
,
ORG.ORGANIZATION_NAME PRODUCT_ORG_DESC
,
TRL.UOM_CODE
,
TRL.PRODUCT_TYPE
,
DECODE(TRL.PRODUCT_TYPE
, 'MEMOS'
, 'MEMOS'
,
PROD.CLASSIFICATION_NAME) PRODUCT_TYPE_DESC
,
TRL.PRODUCT_CODE
,
TRL.PRODUCT_CATEGORY
,
TRL.MERCHANT_PARTY_ID
,
TRL.ACCOUNT_CCID
,
TRL.ACCOUNT_STRING
,
TRL.REF_DOC_LINE_ID
,
TRL.REF_DOC_LINE_QUANTITY
,
TRL.REF_DOC_APPLICATION_ID
,
TRL.REF_DOC_ENTITY_CODE
,
TRL.REF_DOC_EVENT_CLASS_CODE
,
TRL.REF_DOC_TRX_ID
,
TRL.APPLIED_FROM_LINE_ID
,
TRL.APPLIED_FROM_APPLICATION_ID
,
TRL.APPLIED_FROM_ENTITY_CODE
,
TRL.APPLIED_FROM_EVENT_CLASS_CODE
,
TRL.APPLIED_FROM_TRX_ID
,
TRL.ADJUSTED_DOC_LINE_ID
,
TRL.ADJUSTED_DOC_DATE
,
TRL.ADJUSTED_DOC_APPLICATION_ID
,
TRL.ADJUSTED_DOC_ENTITY_CODE
,
TRL.ADJUSTED_DOC_EVENT_CLASS_CODE
,
TRL.ADJUSTED_DOC_TRX_ID
,
TRL.TRX_LINE_DESCRIPTION
,
TRL.PRODUCT_DESCRIPTION
,
TRL.TRX_LINE_GL_DATE
,
TRL.LINE_LEVEL_ACTION
,
TRL.HISTORICAL_FLAG
,
TRL.BILL_FROM_PARTY_SITE_ID
,
TRL.BILL_TO_PARTY_SITE_ID
,
TRL.SHIP_FROM_PARTY_SITE_ID
,
TRL.SHIP_TO_PARTY_SITE_ID
,
TRL.SHIP_TO_PARTY_ID
,
TRL.SHIP_FROM_PARTY_ID
,
TRL.BILL_TO_PARTY_ID
,
TRL.BILL_FROM_PARTY_ID
,
TRL.SHIP_TO_LOCATION_ID
,
TRL.SHIP_FROM_LOCATION_ID
,
TRL.BILL_TO_LOCATION_ID
,
TRL.BILL_FROM_LOCATION_ID
,
TRL.POA_LOCATION_ID
,
TRL.POO_LOCATION_ID
,
TRL.PAYING_LOCATION_ID
,
TRL.OWN_HQ_LOCATION_ID
,
TRL.TRADING_HQ_LOCATION_ID
,
TRL.POC_LOCATION_ID
,
TRL.POI_LOCATION_ID
,
TRL.POD_LOCATION_ID
,
TRL.TAX_REGIME_ID
,
TRL.TAX_REGIME_CODE
,
TRL.TAX_ID
,
TRL.TAX
,
TRL.TAX_STATUS_ID
,
TRL.TAX_STATUS_CODE
,
TRL.TAX_RATE_ID
,
TRL.TAX_RATE_CODE
,
TRL.TAX_RATE
,
TRL.TAX_LINE_AMT
,
TRL.LINE_CLASS
,
TRL.TRX_SHIPPING_DATE
,
TRL.TRX_RECEIPT_DATE
,
TRL.EXEMPT_CERTIFICATE_NUMBER
,
TRL.EXEMPT_REASON
,
TRL.CASH_DISCOUNT
,
TRL.VOLUME_DISCOUNT
,
TRL.TRADING_DISCOUNT
,
TRL.TRANSFER_CHARGE
,
TRL.TRANSPORTATION_CHARGE
,
TRL.INSURANCE_CHARGE
,
TRL.OTHER_CHARGE
,
TRL.POA_PARTY_ID
,
TRL.POO_PARTY_ID
,
TRL.POA_PARTY_SITE_ID
,
TRL.POO_PARTY_SITE_ID
,
TRL.MERCHANT_PARTY_COUNTRY
,
TRL.APPLIED_TO_APPLICATION_ID
,
TRL.APPLIED_TO_ENTITY_CODE
,
TRL.APPLIED_TO_EVENT_CLASS_CODE
,
TRL.APPLIED_TO_TRX_ID
,
TRL.APPLIED_TO_TRX_LINE_ID
,
TRL.CTRL_HDR_TX_APPL_FLAG
,
TRL.CTRL_TOTAL_LINE_TX_AMT
,
TRL.INPUT_TAX_CLASSIFICATION_CODE
,
TRL.OUTPUT_TAX_CLASSIFICATION_CODE
,
TRL.REF_DOC_TRX_LEVEL_TYPE
,
TRL.APPLIED_TO_TRX_LEVEL_TYPE
,
TRL.APPLIED_FROM_TRX_LEVEL_TYPE
,
TRL.ADJUSTED_DOC_TRX_LEVEL_TYPE
,
TRL.EXEMPTION_CONTROL_FLAG
,
TRL.EXEMPT_REASON_CODE
,
TRL.RECEIVABLES_TRX_TYPE_ID
,
TRL.OBJECT_VERSION_NUMBER
,
TRL.CREATED_BY
,
TRL.CREATION_DATE
,
TRL.LAST_UPDATED_BY
,
TRL.LAST_UPDATE_DATE
,
TRL.LAST_UPDATE_LOGIN
FROM ZX_TRANSACTION_LINES TRL
,
ORG_ORGANIZATION_DEFINITIONS ORG
,
ZX_PRODUCT_TYPES_V PROD
WHERE TRL.PRODUCT_ORG_ID = ORG.ORGANIZATION_ID(+)
AND TRL.PRODUCT_TYPE = PROD.CLASSIFICATION_CODE(+)