ZX_TRANSACTION_LINES

Details

Schema: FUSION
Object owner: FND
Object type: VIEW

Columns

Name
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_SEQ_ID OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN SOURCE_APPLICATION_ID SOURCE_ENTITY_CODE SOURCE_EVENT_CLASS_CODE SOURCE_TRX_ID SOURCE_LINE_ID SOURCE_TRX_LEVEL_TYPE ADJUSTED_DOC_NUMBER APPLIED_FROM_TRX_NUMBER APPLIED_TO_TRX_NUMBER BILL_THIRD_PTY_ACCT_ID BILL_THIRD_PTY_ACCT_SITE_ID BILL_TO_CUST_ACCT_SITE_USE_ID CHAR1 CHAR10 CHAR2 CHAR3 CHAR4 CHAR5 CHAR6 CHAR7 CHAR8 CHAR9 DATE1 DATE10 DATE2 DATE3 DATE4 DATE5 DATE6 DATE7 DATE8 DATE9 FOB_POINT MERCHANT_PTY_DOC_NUMBER MERCHANT_PTY_NAME MERCHANT_PTY_REFERENCE MERCHANT_PTY_TAXPAYER_ID MERCHANT_PTY_TAX_PROF_ID MERCHANT_PTY_TAX_REG_NUMBER NUMERIC1 NUMERIC10 NUMERIC2 NUMERIC3 NUMERIC4 NUMERIC5 NUMERIC6 NUMERIC7 NUMERIC8 NUMERIC9 SHIP_THIRD_PTY_ACCT_ID SHIP_THIRD_PTY_ACCT_SITE_ID SHIP_TO_CUST_ACCT_SITE_USE_ID START_EXPENSE_DATE TRADING_HQ_PARTY_ID TRADING_HQ_PARTY_SITE_ID TRX_LINE_CURRENCY_CODE TRX_LINE_CURRENCY_CONV_DATE TRX_LINE_CURRENCY_CONV_RATE TRX_LINE_CURRENCY_CONV_TYPE TRX_LINE_MAU TRX_LINE_PRECISION TRX_SIC_CODE TRX_WAYBILL_NUMBER TAX_INVOICE_NUMBER TAX_INVOICE_DATE WHT_GROUP_ID REQUISITION_TYPE PURCHASING_CATEGORY_ID DROP_SHIP_FLAG CONSIGNED_FLAG DESTINATION_TYPE_CODE CONSIGN_ITM_UPON_RECPT_FLAG EXPENDITURE_TYPE PORT_OF_DISCHARGE PORT_OF_LOADING DELIVERY_TYPE DOCUMENT_TYPE SHIPMENT_TYPE FOS_TRANSACTION_ID FINAL_DISCHARGE_LOCATION_ID COUNTRY_OF_ORIGIN_CODE FINAL_TRANSACTION_NODE_FLAG DEBIT_ACCOUNT_CCID CREDIT_ACCOUNT_CCID RETAINAGE_AMT RETAINAGE_PERCENTAGE TAX_GROSS_NET_FLAG WHT_GROSS_NET_FLAG

Name

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_SEQ_ID

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

SOURCE_APPLICATION_ID

SOURCE_ENTITY_CODE

SOURCE_EVENT_CLASS_CODE

SOURCE_TRX_ID

SOURCE_LINE_ID

SOURCE_TRX_LEVEL_TYPE

ADJUSTED_DOC_NUMBER

APPLIED_FROM_TRX_NUMBER

APPLIED_TO_TRX_NUMBER

BILL_THIRD_PTY_ACCT_ID

BILL_THIRD_PTY_ACCT_SITE_ID

BILL_TO_CUST_ACCT_SITE_USE_ID

CHAR1

CHAR10

CHAR2

CHAR3

CHAR4

CHAR5

CHAR6

CHAR7

CHAR8

CHAR9

DATE1

DATE10

DATE2

DATE3

DATE4

DATE5

DATE6

DATE7

DATE8

DATE9

FOB_POINT

MERCHANT_PTY_DOC_NUMBER

MERCHANT_PTY_NAME

MERCHANT_PTY_REFERENCE

MERCHANT_PTY_TAXPAYER_ID

MERCHANT_PTY_TAX_PROF_ID

MERCHANT_PTY_TAX_REG_NUMBER

NUMERIC1

NUMERIC10

NUMERIC2

NUMERIC3

NUMERIC4

NUMERIC5

NUMERIC6

NUMERIC7

NUMERIC8

NUMERIC9

SHIP_THIRD_PTY_ACCT_ID

SHIP_THIRD_PTY_ACCT_SITE_ID

SHIP_TO_CUST_ACCT_SITE_USE_ID

START_EXPENSE_DATE

TRADING_HQ_PARTY_ID

TRADING_HQ_PARTY_SITE_ID

TRX_LINE_CURRENCY_CODE

TRX_LINE_CURRENCY_CONV_DATE

TRX_LINE_CURRENCY_CONV_RATE

TRX_LINE_CURRENCY_CONV_TYPE

TRX_LINE_MAU

TRX_LINE_PRECISION

TRX_SIC_CODE

TRX_WAYBILL_NUMBER

TAX_INVOICE_NUMBER

TAX_INVOICE_DATE

WHT_GROUP_ID

REQUISITION_TYPE

PURCHASING_CATEGORY_ID

DROP_SHIP_FLAG

CONSIGNED_FLAG

DESTINATION_TYPE_CODE

CONSIGN_ITM_UPON_RECPT_FLAG

EXPENDITURE_TYPE

PORT_OF_DISCHARGE

PORT_OF_LOADING

DELIVERY_TYPE

DOCUMENT_TYPE

SHIPMENT_TYPE

FOS_TRANSACTION_ID

FINAL_DISCHARGE_LOCATION_ID

COUNTRY_OF_ORIGIN_CODE

FINAL_TRANSACTION_NODE_FLAG

DEBIT_ACCOUNT_CCID

CREDIT_ACCOUNT_CCID

RETAINAGE_AMT

RETAINAGE_PERCENTAGE

TAX_GROSS_NET_FLAG

WHT_GROSS_NET_FLAG

Query

SQL_Statement
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_SEQ_ID, TRL.OBJECT_VERSION_NUMBER, TRL.CREATED_BY, TRL.CREATION_DATE, TRL.LAST_UPDATED_BY, TRL.LAST_UPDATE_DATE, TRL.LAST_UPDATE_LOGIN, TRL.SOURCE_APPLICATION_ID, TRL.SOURCE_ENTITY_CODE , TRL.SOURCE_EVENT_CLASS_CODE, TRL.SOURCE_TRX_ID, TRL.SOURCE_LINE_ID, TRL.SOURCE_TRX_LEVEL_TYPE, TRL.ADJUSTED_DOC_NUMBER, TRL.APPLIED_FROM_TRX_NUMBER, TRL.APPLIED_TO_TRX_NUMBER, TRL.BILL_THIRD_PTY_ACCT_ID, TRL.BILL_THIRD_PTY_ACCT_SITE_ID, TRL.BILL_TO_CUST_ACCT_SITE_USE_ID, TRL.CHAR1, TRL.CHAR10, TRL.CHAR2, TRL.CHAR3, TRL.CHAR4, TRL.CHAR5, TRL.CHAR6, TRL.CHAR7, TRL.CHAR8, TRL.CHAR9, TRL.DATE1, TRL.DATE10, TRL.DATE2, TRL.DATE3, TRL.DATE4, TRL.DATE5, TRL.DATE6, TRL.DATE7, TRL.DATE8, TRL.DATE9, TRL.FOB_POINT, TRL.MERCHANT_PTY_DOC_NUMBER, TRL.MERCHANT_PTY_NAME, TRL.MERCHANT_PTY_REFERENCE, TRL.MERCHANT_PTY_TAXPAYER_ID, TRL.MERCHANT_PTY_TAX_PROF_ID, TRL.MERCHANT_PTY_TAX_REG_NUMBER, TRL.NUMERIC1, TRL.NUMERIC10, TRL.NUMERIC2, TRL.NUMERIC3, TRL.NUMERIC4, TRL.NUMERIC5, TRL.NUMERIC6, TRL.NUMERIC7, TRL.NUMERIC8, TRL.NUMERIC9, TRL.SHIP_THIRD_PTY_ACCT_ID, TRL.SHIP_THIRD_PTY_ACCT_SITE_ID, TRL.SHIP_TO_CUST_ACCT_SITE_USE_ID, TRL.START_EXPENSE_DATE, TRL.TRADING_HQ_PARTY_ID, TRL.TRADING_HQ_PARTY_SITE_ID, TRL.TRX_LINE_CURRENCY_CODE, TRL.TRX_LINE_CURRENCY_CONV_DATE, TRL.TRX_LINE_CURRENCY_CONV_RATE, TRL.TRX_LINE_CURRENCY_CONV_TYPE, TRL.TRX_LINE_MAU, TRL.TRX_LINE_PRECISION, TRL.TRX_SIC_CODE, TRL.TRX_WAYBILL_NUMBER, TRL.TAX_INVOICE_NUMBER, TRL.TAX_INVOICE_DATE, TRL.WHT_GROUP_ID, TRL.REQUISITION_TYPE, TRL.PURCHASING_CATEGORY_ID, TRL.DROP_SHIP_FLAG, TRL.CONSIGNED_FLAG, TRL.DESTINATION_TYPE_CODE, TRL.CONSIGN_ITM_UPON_RECPT_FLAG, TRL.EXPENDITURE_TYPE, TRL.PORT_OF_DISCHARGE, TRL.PORT_OF_LOADING, TRL.DELIVERY_TYPE, TRL.DOCUMENT_TYPE, TRL.SHIPMENT_TYPE, TRL.FOS_TRANSACTION_ID, TRL.FINAL_DISCHARGE_LOCATION_ID, TRL.COUNTRY_OF_ORIGIN_CODE, TRL.FINAL_TRANSACTION_NODE_FLAG, TRL.DEBIT_ACCOUNT_CCID, TRL.CREDIT_ACCOUNT_CCID, RETAINAGE_AMT, RETAINAGE_PERCENTAGE, TAX_GROSS_NET_FLAG, WHT_GROSS_NET_FLAG FROM ZX_TRANSACTION_LINES TRL, INV_ORGANIZATION_DEFINITIONS_V ORG, ZX_PRODUCT_TYPES_V PROD WHERE TRL.PRODUCT_ORG_ID = ORG.ORGANIZATION_ID(+) AND TRL.PRODUCT_TYPE = PROD.CLASSIFICATION_CODE(+)

SQL_Statement

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_SEQ_ID,

TRL.OBJECT_VERSION_NUMBER,

TRL.CREATED_BY,

TRL.CREATION_DATE,

TRL.LAST_UPDATED_BY,

TRL.LAST_UPDATE_DATE,

TRL.LAST_UPDATE_LOGIN,

TRL.SOURCE_APPLICATION_ID,

TRL.SOURCE_ENTITY_CODE ,

TRL.SOURCE_EVENT_CLASS_CODE,

TRL.SOURCE_TRX_ID,

TRL.SOURCE_LINE_ID,

TRL.SOURCE_TRX_LEVEL_TYPE,

TRL.ADJUSTED_DOC_NUMBER,

TRL.APPLIED_FROM_TRX_NUMBER,

TRL.APPLIED_TO_TRX_NUMBER,

TRL.BILL_THIRD_PTY_ACCT_ID,

TRL.BILL_THIRD_PTY_ACCT_SITE_ID,

TRL.BILL_TO_CUST_ACCT_SITE_USE_ID,

TRL.CHAR1,

TRL.CHAR10,

TRL.CHAR2,

TRL.CHAR3,

TRL.CHAR4,

TRL.CHAR5,

TRL.CHAR6,

TRL.CHAR7,

TRL.CHAR8,

TRL.CHAR9,

TRL.DATE1,

TRL.DATE10,

TRL.DATE2,

TRL.DATE3,

TRL.DATE4,

TRL.DATE5,

TRL.DATE6,

TRL.DATE7,

TRL.DATE8,

TRL.DATE9,

TRL.FOB_POINT,

TRL.MERCHANT_PTY_DOC_NUMBER,

TRL.MERCHANT_PTY_NAME,

TRL.MERCHANT_PTY_REFERENCE,

TRL.MERCHANT_PTY_TAXPAYER_ID,

TRL.MERCHANT_PTY_TAX_PROF_ID,

TRL.MERCHANT_PTY_TAX_REG_NUMBER,

TRL.NUMERIC1,

TRL.NUMERIC10,

TRL.NUMERIC2,

TRL.NUMERIC3,

TRL.NUMERIC4,

TRL.NUMERIC5,

TRL.NUMERIC6,

TRL.NUMERIC7,

TRL.NUMERIC8,

TRL.NUMERIC9,

TRL.SHIP_THIRD_PTY_ACCT_ID,

TRL.SHIP_THIRD_PTY_ACCT_SITE_ID,

TRL.SHIP_TO_CUST_ACCT_SITE_USE_ID,

TRL.START_EXPENSE_DATE,

TRL.TRADING_HQ_PARTY_ID,

TRL.TRADING_HQ_PARTY_SITE_ID,

TRL.TRX_LINE_CURRENCY_CODE,

TRL.TRX_LINE_CURRENCY_CONV_DATE,

TRL.TRX_LINE_CURRENCY_CONV_RATE,

TRL.TRX_LINE_CURRENCY_CONV_TYPE,

TRL.TRX_LINE_MAU,

TRL.TRX_LINE_PRECISION,

TRL.TRX_SIC_CODE,

TRL.TRX_WAYBILL_NUMBER,

TRL.TAX_INVOICE_NUMBER,

TRL.TAX_INVOICE_DATE,

TRL.WHT_GROUP_ID,

TRL.REQUISITION_TYPE,

TRL.PURCHASING_CATEGORY_ID,

TRL.DROP_SHIP_FLAG,

TRL.CONSIGNED_FLAG,

TRL.DESTINATION_TYPE_CODE,

TRL.CONSIGN_ITM_UPON_RECPT_FLAG,

TRL.EXPENDITURE_TYPE,

TRL.PORT_OF_DISCHARGE,

TRL.PORT_OF_LOADING,

TRL.DELIVERY_TYPE,

TRL.DOCUMENT_TYPE,

TRL.SHIPMENT_TYPE,

TRL.FOS_TRANSACTION_ID,

TRL.FINAL_DISCHARGE_LOCATION_ID,

TRL.COUNTRY_OF_ORIGIN_CODE,

TRL.FINAL_TRANSACTION_NODE_FLAG,

TRL.DEBIT_ACCOUNT_CCID,

TRL.CREDIT_ACCOUNT_CCID,

RETAINAGE_AMT,

RETAINAGE_PERCENTAGE,

TAX_GROSS_NET_FLAG,

WHT_GROSS_NET_FLAG

FROM ZX_TRANSACTION_LINES TRL,

INV_ORGANIZATION_DEFINITIONS_V ORG,

ZX_PRODUCT_TYPES_V PROD

WHERE TRL.PRODUCT_ORG_ID = ORG.ORGANIZATION_ID(+)

AND TRL.PRODUCT_TYPE = PROD.CLASSIFICATION_CODE(+)