View: ARBPA_CUSTOMER_TRX_LINE

Product:	FND - Application Object Library
Description:
Implementation/DBA Data:	APPS.ARBPA_CUSTOMER_TRX_LINE

View Text

SELECT CUSTOMER_TRX_ID
, CUSTOMER_TRX_LINE_ID
, LINE_NUMBER
, LINE_TYPE
, DESCRIPTION
, QUANTITY
, UNIT_OF_MEASURE_NAME
, UNIT_PRICE
, EXTENDED_AMOUNT
, SALES_ORDER
, UOM_CODE
, TRX_NUMBER
, TAX_EXISTS_FOR_THIS_LINE_FLAG
, LINE_TAX_RATE
, TAX_CODE
, PRINTED_TAX_NAME
, INTERFACE_LINE_ATTRIBUTE1
, INTERFACE_LINE_ATTRIBUTE2
, INTERFACE_LINE_ATTRIBUTE3
, INTERFACE_LINE_ATTRIBUTE4
, INTERFACE_LINE_ATTRIBUTE5
, INTERFACE_LINE_ATTRIBUTE6
, INTERFACE_LINE_ATTRIBUTE7
, INTERFACE_LINE_ATTRIBUTE8
, INTERFACE_LINE_ATTRIBUTE9
, INTERFACE_LINE_ATTRIBUTE10
, INTERFACE_LINE_ATTRIBUTE11
, INTERFACE_LINE_ATTRIBUTE12
, INTERFACE_LINE_ATTRIBUTE13
, INTERFACE_LINE_ATTRIBUTE14
, INTERFACE_LINE_ATTRIBUTE15
, UNFORMATTED_UNIT_PRICE
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SET_OF_BOOKS_ID
, REASON_CODE
, QUANTITY_ORDERED
, QUANTITY_CREDITED
, UNIT_STANDARD_PRICE
, SALES_ORDER_LINE
, SALES_ORDER_DATE
, ACCOUNTING_RULE_DURATION
, ATTRIBUTE_CATEGORY
, RULE_START_DATE
, INTERFACE_LINE_CONTEXT
, SALES_ORDER_SOURCE
, REVENUE_AMOUNT
, DEFAULT_USSGL_TRANSACTION_CODE
, DEFAULT_USSGL_TRX_CODE_CONTEXT
, LAST_PERIOD_TO_CREDIT
, ITEM_CONTEXT
, TAX_EXEMPT_FLAG
, TAX_EXEMPT_NUMBER
, TAX_EXEMPT_REASON_CODE
, TAX_VENDOR_RETURN_CODE
, GLOBAL_ATTRIBUTE_CATEGORY
, GROSS_UNIT_SELLING_PRICE
, GROSS_EXTENDED_AMOUNT
, EXTENDED_ACCTD_AMOUNT
, MRC_EXTENDED_ACCTD_AMOUNT
, ORG_ID
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, TRANSACTION_LINE_NUMBER
, TRANSACTION_CURRENCY_CODE
, TRANSACTION_LINE_DESC
, TRANSACTION_DATE
, TRANSACTION_QUANTITY
, UNIT_SELLING_PRICE
, UNIT_SELLING_PRICE || TRANSACTION_CURRENCY_CODE CODE_UNIT_SELLING_PRICE
, LINES_EXTENDED_AMOUNT || TRANSACTION_CURRENCY_CODE CODE_LINES_EXTENDED_AMOUNT
, TAX_AMOUNT || TRANSACTION_CURRENCY_CODE CODE_TAX_AMOUNT
, (LINES_EXTENDED_AMOUNT + TAX_AMOUNT) || TRANSACTION_CURRENCY_CODE CODE_LINE_GROSS_AMOUNT
, LINES_EXTENDED_AMOUNT
, BILL_TO_CUSTOMER_ID
, INVENTORY_ITEM_ID
, COUNTRY_OF_ORIGIN
, CUSTOMS_DECLARATION_NUMBER
, TAX_AMOUNT
, TAX_RATE
, VAT_TAX_AMOUNT
, VAT_TAX_RATE
, EXCISE_TAX_AMOUNT
, EXCISE_TAX_RATE
, EXEMPT_TAX_AMOUNT
, EXEMPT_TAX_RATE
, TAX_TYPE_CODE
, ITEM_NAME
, ITEM_DESCRIPTION
, ITEM_UOM_CODE
, ITEM_UOM_NAME
, TAX_CLASSIF_CODE
, (LINES_EXTENDED_AMOUNT + TAX_AMOUNT) LINE_GROSS_AMOUNT
, NULL NULL_VALUE
FROM (SELECT LINES.CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, LINES.CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID
, TO_CHAR (LINES.LINE_NUMBER) LINE_NUMBER
, LINES.LINE_TYPE LINE_TYPE
, NVL(AR_INVOICE_SQL_FUNC_PUB.GET_DESCRIPTION(LINES.CUSTOMER_TRX_LINE_ID)
, LINES.DESCRIPTION) DESCRIPTION
, TO_CHAR (NVL (LINES.QUANTITY_INVOICED
, LINES.QUANTITY_CREDITED)) QUANTITY
, UOM.UNIT_OF_MEASURE UNIT_OF_MEASURE_NAME
, TO_CHAR(NVL (LINES.UNIT_SELLING_PRICE
, 0)
, FND_CURRENCY.GET_FORMAT_MASK(TRX.INVOICE_CURRENCY_CODE
, 40)) UNIT_PRICE
, TO_CHAR(LINES.EXTENDED_AMOUNT
, FND_CURRENCY.GET_FORMAT_MASK (TRX.INVOICE_CURRENCY_CODE
, 40)) EXTENDED_AMOUNT
, LINES.SALES_ORDER
, LINES.UOM_CODE
, TRX.TRX_NUMBER
, AR_INVOICE_SQL_FUNC_PUB.GET_TAXYN(LINES.CUSTOMER_TRX_LINE_ID) TAX_EXISTS_FOR_THIS_LINE_FLAG
, AR_BPA_UTILS_PKG.FN_GET_LINE_TAXRATE(LINES.CUSTOMER_TRX_LINE_ID)LINE_TAX_RATE
, AR_BPA_UTILS_PKG.FN_GET_LINE_TAXCODE(LINES.CUSTOMER_TRX_LINE_ID)TAX_CODE
, AR_BPA_UTILS_PKG.FN_GET_LINE_TAXNAME(LINES.CUSTOMER_TRX_LINE_ID)PRINTED_TAX_NAME
, LINES.INTERFACE_LINE_ATTRIBUTE1
, LINES.INTERFACE_LINE_ATTRIBUTE2
, LINES.INTERFACE_LINE_ATTRIBUTE3
, LINES.INTERFACE_LINE_ATTRIBUTE4
, LINES.INTERFACE_LINE_ATTRIBUTE5
, LINES.INTERFACE_LINE_ATTRIBUTE6
, LINES.INTERFACE_LINE_ATTRIBUTE7
, LINES.INTERFACE_LINE_ATTRIBUTE8
, LINES.INTERFACE_LINE_ATTRIBUTE9
, LINES.INTERFACE_LINE_ATTRIBUTE10
, LINES.INTERFACE_LINE_ATTRIBUTE11
, LINES.INTERFACE_LINE_ATTRIBUTE12
, LINES.INTERFACE_LINE_ATTRIBUTE13
, LINES.INTERFACE_LINE_ATTRIBUTE14
, LINES.INTERFACE_LINE_ATTRIBUTE15
, TO_CHAR(NVL (LINES.UNIT_SELLING_PRICE
, 0)) UNFORMATTED_UNIT_PRICE
, LINES.ATTRIBUTE1
, LINES.ATTRIBUTE2
, LINES.ATTRIBUTE3
, LINES.ATTRIBUTE4
, LINES.ATTRIBUTE5
, LINES.ATTRIBUTE6
, LINES.ATTRIBUTE7
, LINES.ATTRIBUTE8
, LINES.ATTRIBUTE9
, LINES.ATTRIBUTE10
, LINES.ATTRIBUTE11
, LINES.ATTRIBUTE12
, LINES.ATTRIBUTE13
, LINES.ATTRIBUTE14
, LINES.ATTRIBUTE15
, LINES.SET_OF_BOOKS_ID
, LINES.REASON_CODE
, LINES.QUANTITY_ORDERED
, LINES.QUANTITY_CREDITED
, LINES.UNIT_STANDARD_PRICE
, LINES.SALES_ORDER_LINE
, LINES.SALES_ORDER_DATE
, LINES.ACCOUNTING_RULE_DURATION
, LINES.ATTRIBUTE_CATEGORY
, LINES.RULE_START_DATE
, LINES.INTERFACE_LINE_CONTEXT
, LINES.SALES_ORDER_SOURCE
, LINES.REVENUE_AMOUNT
, LINES.DEFAULT_USSGL_TRANSACTION_CODE
, LINES.DEFAULT_USSGL_TRX_CODE_CONTEXT
, LINES.LAST_PERIOD_TO_CREDIT
, LINES.ITEM_CONTEXT
, LINES.TAX_EXEMPT_FLAG
, LINES.TAX_EXEMPT_NUMBER
, LINES.TAX_EXEMPT_REASON_CODE
, LINES.TAX_VENDOR_RETURN_CODE
, LINES.GLOBAL_ATTRIBUTE_CATEGORY
, LINES.GROSS_UNIT_SELLING_PRICE
, LINES.GROSS_EXTENDED_AMOUNT
, LINES.EXTENDED_ACCTD_AMOUNT
, LINES.MRC_EXTENDED_ACCTD_AMOUNT
, LINES.ORG_ID
, LINES.GLOBAL_ATTRIBUTE1
, LINES.GLOBAL_ATTRIBUTE2
, LINES.GLOBAL_ATTRIBUTE3
, LINES.GLOBAL_ATTRIBUTE4
, LINES.GLOBAL_ATTRIBUTE5
, LINES.GLOBAL_ATTRIBUTE6
, LINES.GLOBAL_ATTRIBUTE7
, LINES.GLOBAL_ATTRIBUTE8
, LINES.GLOBAL_ATTRIBUTE9
, LINES.GLOBAL_ATTRIBUTE10
, LINES.GLOBAL_ATTRIBUTE11
, LINES.GLOBAL_ATTRIBUTE12
, LINES.GLOBAL_ATTRIBUTE13
, LINES.GLOBAL_ATTRIBUTE14
, LINES.GLOBAL_ATTRIBUTE15
, LINES.GLOBAL_ATTRIBUTE16
, LINES.GLOBAL_ATTRIBUTE17
, LINES.GLOBAL_ATTRIBUTE18
, LINES.GLOBAL_ATTRIBUTE19
, LINES.GLOBAL_ATTRIBUTE20
, LINES.LINE_NUMBER TRANSACTION_LINE_NUMBER
, TRX.INVOICE_CURRENCY_CODE TRANSACTION_CURRENCY_CODE
, NVL(AR_INVOICE_SQL_FUNC_PUB.GET_DESCRIPTION(LINES.CUSTOMER_TRX_LINE_ID)
, LINES.DESCRIPTION) TRANSACTION_LINE_DESC
, TRX.TRX_DATE TRANSACTION_DATE
, TO_CHAR(NVL (LINES.QUANTITY_INVOICED
, LINES.QUANTITY_CREDITED)) TRANSACTION_QUANTITY
, TO_CHAR(NVL (LINES.UNIT_SELLING_PRICE
, 0)
, FND_CURRENCY.GET_FORMAT_MASK(TRX.INVOICE_CURRENCY_CODE
, 40)) UNIT_SELLING_PRICE
, LINES.EXTENDED_AMOUNT LINES_EXTENDED_AMOUNT
, TRX.BILL_TO_CUSTOMER_ID BILL_TO_CUSTOMER_ID
, LINES.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, LINES.GLOBAL_ATTRIBUTE1 COUNTRY_OF_ORIGIN
, LINES.GLOBAL_ATTRIBUTE2 CUSTOMS_DECLARATION_NUMBER
, SUM (RCTL_TAX.EXTENDED_AMOUNT) TAX_AMOUNT
, SUM (RCTL_TAX.TAX_RATE) TAX_RATE
, SUM(DECODE(ZX_TAX.TAX_TYPE_CODE
, 'VAT'
, NVL(RCTL_TAX.EXTENDED_AMOUNT
, 0)
, 0)) VAT_TAX_AMOUNT
, SUM(DECODE(ZX_TAX.TAX_TYPE_CODE
, 'VAT'
, NVL(RCTL_TAX.TAX_RATE
, 0)
, 0)) VAT_TAX_RATE
, SUM(DECODE(ZX_TAX.TAX_TYPE_CODE
, 'EXCISE'
, NVL(RCTL_TAX.EXTENDED_AMOUNT
, 0)
, 0)) EXCISE_TAX_AMOUNT
, SUM(DECODE(ZX_TAX.TAX_TYPE_CODE
, 'EXCISE'
, NVL(RCTL_TAX.TAX_RATE
, 0)
, 0)) EXCISE_TAX_RATE
, SUM(DECODE(ZX_TAX.TAX_TYPE_CODE
, 'EXEMPT VAT'
, NVL(RCTL_TAX.EXTENDED_AMOUNT
, 0)
, 0)) EXEMPT_TAX_AMOUNT
, SUM(DECODE(ZX_TAX.TAX_TYPE_CODE
, 'EXEMPT VAT'
, NVL(RCTL_TAX.TAX_RATE
, 0)
, 0)) EXEMPT_TAX_RATE
, ZX_TAX.TAX_TYPE_CODE TAX_TYPE_CODE
, MSI.CONCATENATED_SEGMENTS ITEM_NAME
, NVL (MSI.DESCRIPTION
, LINES.DESCRIPTION) ITEM_DESCRIPTION
, NVL (MSI.PRIMARY_UOM_CODE
, LINES.UOM_CODE) ITEM_UOM_CODE
, NVL (MSI.PRIMARY_UNIT_OF_MEASURE
, UOM.UNIT_OF_MEASURE) ITEM_UOM_NAME
, LINES.TAX_CLASSIFICATION_CODE TAX_CLASSIF_CODE
FROM MTL_UNITS_OF_MEASURE UOM
, RA_CUSTOMER_TRX_LINES LINES
, RA_CUSTOMER_TRX TRX
, MTL_SYSTEM_ITEMS_KFV MSI
, RA_CUSTOMER_TRX_LINES RCTL_TAX
, MTL_PARAMETERS MTP
, --ADDED THIS TABLE FOR THE JOIN TO MEET THE SR 7611049.992 --RA_CUSTOMER_TRX_LINES RCTL_EXCISE
, --RA_CUSTOMER_TRX_LINES RCTL_EXEMPT
, ZX_LINES ZX_TAX --ZX_LINES ZX_EXCISE
, --ZX_LINES ZX_EXEMPT
WHERE TRX.CUSTOMER_TRX_ID = LINES.CUSTOMER_TRX_ID
AND TRX.COMPLETE_FLAG = 'Y'
AND LINES.UOM_CODE = UOM.UOM_CODE(+)
AND LINES.LINE_TYPE = 'LINE'
AND MSI.INVENTORY_ITEM_ID (+) = LINES.INVENTORY_ITEM_ID --AND LINES.ORG_ID = MSI.ORGANIZATION_ID(+)
AND MSI.ORGANIZATION_ID = MTP.ORGANIZATION_ID (+)
AND NVL(MTP.ORGANIZATION_ID
, -1) = NVL(MTP.MASTER_ORGANIZATION_ID
, -1)
AND LINES.CUSTOMER_TRX_ID = RCTL_TAX.CUSTOMER_TRX_ID(+)
AND LINES.CUSTOMER_TRX_LINE_ID = RCTL_TAX.LINK_TO_CUST_TRX_LINE_ID(+)
AND RCTL_TAX.LINE_TYPE(+) = 'TAX' AND RCTL_TAX.TAX_LINE_ID = ZX_TAX.TAX_LINE_ID (+) --AND ZX_TAX.TAX_TYPE_CODE = 'VAT' --AND LINES.CUSTOMER_TRX_ID = RCTL_EXCISE.CUSTOMER_TRX_ID(+) --AND LINES.CUSTOMER_TRX_LINE_ID = RCTL_EXCISE.LINK_TO_CUST_TRX_LINE_ID(+) --AND RCTL_EXCISE.LINE_TYPE(+) = 'TAX' --AND RCTL_EXCISE.TAX_LINE_ID = ZX_EXCISE.TAX_LINE_ID --AND ZX_EXCISE.TAX_TYPE_CODE = 'EXCISE' --AND LINES.CUSTOMER_TRX_ID = RCTL_EXEMPT.CUSTOMER_TRX_ID(+) --AND LINES.CUSTOMER_TRX_LINE_ID = RCTL_EXEMPT.LINK_TO_CUST_TRX_LINE_ID(+) --AND RCTL_EXEMPT.LINE_TYPE(+) = 'TAX' --AND RCTL_EXEMPT.TAX_LINE_ID = ZX_EXEMPT.TAX_LINE_ID --AND ZX_EXEMPT.TAX_TYPE_CODE = 'EXEMPT VAT' GROUP BY LINES.CUSTOMER_TRX_ID
, LINES.CUSTOMER_TRX_LINE_ID
, TO_CHAR (LINES.LINE_NUMBER)
, LINES.LINE_TYPE
, NVL(AR_INVOICE_SQL_FUNC_PUB.GET_DESCRIPTION(LINES.CUSTOMER_TRX_LINE_ID)
, LINES.DESCRIPTION)
, TO_CHAR (NVL (LINES.QUANTITY_INVOICED
, LINES.QUANTITY_CREDITED))
, UOM.UNIT_OF_MEASURE
, TO_CHAR(NVL (LINES.UNIT_SELLING_PRICE
, 0)
, FND_CURRENCY.GET_FORMAT_MASK(TRX.INVOICE_CURRENCY_CODE
, 40))
, TO_CHAR(LINES.EXTENDED_AMOUNT
, FND_CURRENCY.GET_FORMAT_MASK (TRX.INVOICE_CURRENCY_CODE
, 40))
, LINES.SALES_ORDER
, LINES.UOM_CODE
, TRX.TRX_NUMBER
, AR_INVOICE_SQL_FUNC_PUB.GET_TAXYN(LINES.CUSTOMER_TRX_LINE_ID)
, AR_BPA_UTILS_PKG.FN_GET_LINE_TAXRATE(LINES.CUSTOMER_TRX_LINE_ID)
, AR_BPA_UTILS_PKG.FN_GET_LINE_TAXCODE(LINES.CUSTOMER_TRX_LINE_ID)
, AR_BPA_UTILS_PKG.FN_GET_LINE_TAXNAME(LINES.CUSTOMER_TRX_LINE_ID)
, LINES.INTERFACE_LINE_ATTRIBUTE1
, LINES.INTERFACE_LINE_ATTRIBUTE2
, LINES.INTERFACE_LINE_ATTRIBUTE3
, LINES.INTERFACE_LINE_ATTRIBUTE4
, LINES.INTERFACE_LINE_ATTRIBUTE5
, LINES.INTERFACE_LINE_ATTRIBUTE6
, LINES.INTERFACE_LINE_ATTRIBUTE7
, LINES.INTERFACE_LINE_ATTRIBUTE8
, LINES.INTERFACE_LINE_ATTRIBUTE9
, LINES.INTERFACE_LINE_ATTRIBUTE10
, LINES.INTERFACE_LINE_ATTRIBUTE11
, LINES.INTERFACE_LINE_ATTRIBUTE12
, LINES.INTERFACE_LINE_ATTRIBUTE13
, LINES.INTERFACE_LINE_ATTRIBUTE14
, LINES.INTERFACE_LINE_ATTRIBUTE15
, TO_CHAR (NVL (LINES.UNIT_SELLING_PRICE
, 0))
, LINES.ATTRIBUTE1
, LINES.ATTRIBUTE2
, LINES.ATTRIBUTE3
, LINES.ATTRIBUTE4
, LINES.ATTRIBUTE5
, LINES.ATTRIBUTE6
, LINES.ATTRIBUTE7
, LINES.ATTRIBUTE8
, LINES.ATTRIBUTE9
, LINES.ATTRIBUTE10
, LINES.ATTRIBUTE11
, LINES.ATTRIBUTE12
, LINES.ATTRIBUTE13
, LINES.ATTRIBUTE14
, LINES.ATTRIBUTE15
, LINES.SET_OF_BOOKS_ID
, LINES.REASON_CODE
, LINES.QUANTITY_ORDERED
, LINES.QUANTITY_CREDITED
, LINES.UNIT_STANDARD_PRICE
, LINES.SALES_ORDER_LINE
, LINES.SALES_ORDER_DATE
, LINES.ACCOUNTING_RULE_DURATION
, LINES.ATTRIBUTE_CATEGORY
, LINES.RULE_START_DATE
, LINES.INTERFACE_LINE_CONTEXT
, LINES.SALES_ORDER_SOURCE
, LINES.REVENUE_AMOUNT
, LINES.DEFAULT_USSGL_TRANSACTION_CODE
, LINES.DEFAULT_USSGL_TRX_CODE_CONTEXT
, LINES.LAST_PERIOD_TO_CREDIT
, LINES.ITEM_CONTEXT
, LINES.TAX_EXEMPT_FLAG
, LINES.TAX_EXEMPT_NUMBER
, LINES.TAX_EXEMPT_REASON_CODE
, LINES.TAX_VENDOR_RETURN_CODE
, LINES.GLOBAL_ATTRIBUTE_CATEGORY
, LINES.GROSS_UNIT_SELLING_PRICE
, LINES.GROSS_EXTENDED_AMOUNT
, LINES.EXTENDED_ACCTD_AMOUNT
, LINES.MRC_EXTENDED_ACCTD_AMOUNT
, LINES.ORG_ID
, LINES.GLOBAL_ATTRIBUTE1
, LINES.GLOBAL_ATTRIBUTE2
, LINES.GLOBAL_ATTRIBUTE3
, LINES.GLOBAL_ATTRIBUTE4
, LINES.GLOBAL_ATTRIBUTE5
, LINES.GLOBAL_ATTRIBUTE6
, LINES.GLOBAL_ATTRIBUTE7
, LINES.GLOBAL_ATTRIBUTE8
, LINES.GLOBAL_ATTRIBUTE9
, LINES.GLOBAL_ATTRIBUTE10
, LINES.GLOBAL_ATTRIBUTE11
, LINES.GLOBAL_ATTRIBUTE12
, LINES.GLOBAL_ATTRIBUTE13
, LINES.GLOBAL_ATTRIBUTE14
, LINES.GLOBAL_ATTRIBUTE15
, LINES.GLOBAL_ATTRIBUTE16
, LINES.GLOBAL_ATTRIBUTE17
, LINES.GLOBAL_ATTRIBUTE18
, LINES.GLOBAL_ATTRIBUTE19
, LINES.GLOBAL_ATTRIBUTE20
, LINES.LINE_NUMBER
, TRX.INVOICE_CURRENCY_CODE
, NVL(AR_INVOICE_SQL_FUNC_PUB.GET_DESCRIPTION(LINES.CUSTOMER_TRX_LINE_ID)
, LINES.DESCRIPTION)
, TRX.TRX_DATE
, TO_CHAR (NVL (LINES.QUANTITY_INVOICED
, LINES.QUANTITY_CREDITED))
, TO_CHAR(NVL (LINES.UNIT_SELLING_PRICE
, 0)
, FND_CURRENCY.GET_FORMAT_MASK (TRX.INVOICE_CURRENCY_CODE
, 40))
, -- TO_CHAR(LINES.EXTENDED_AMOUNT
, FND_CURRENCY.GET_FORMAT_MASK(TRX.INVOICE_CURRENCY_CODE
, 40))
, LINES.EXTENDED_AMOUNT
, TRX.BILL_TO_CUSTOMER_ID
, LINES.INVENTORY_ITEM_ID
, LINES.ATTRIBUTE12
, LINES.ATTRIBUTE13
, ZX_TAX.TAX_TYPE_CODE
, MSI.CONCATENATED_SEGMENTS
, NVL (MSI.DESCRIPTION
, LINES.DESCRIPTION)
, NVL (MSI.PRIMARY_UOM_CODE
, LINES.UOM_CODE)
, NVL (MSI.PRIMARY_UNIT_OF_MEASURE
, UOM.UNIT_OF_MEASURE)
, LINES.TAX_CLASSIFICATION_CODE)