1. Tables and Views for Financials
  2. AR_XML_INVOICE_LINE_V

AR_XML_INVOICE_LINE_V

Details

  • Schema: FUSION

  • Object owner: AR

  • Object type: VIEW

Columns

Name

CUSTOMER_TRX_ID

CUSTOMER_TRX_LINE_ID

LINE_TYPE

LINE_NUMBER

LINE_AMOUNT

CURRENCY_CODE

UNIT_SELLING_PRICE

QUANTITY

DESCRIPTION

UOM

ITEM

ITEM_DESCRIPTION

REFERENCE_NUMBER

LINE_USER_ONE

LINE_USER_TWO

LINE_USER_THREE

LINE_USER_FOUR

LINE_USER_FIVE

LINE_USER_SIX

LINE_USER_SEVEN

LINE_USER_EIGHT

LINE_USER_NINE

LINE_USER_TEN

LINE_USER_ELEVEN

LINE_USER_TWELVE

LINE_USER_THIRTEEN

LINE_USER_FOURTEEN

LINE_USER_FIFTEEN

LINE_USER_SIXTEEN

LINE_USER_SEVENTEEN

LINE_USER_EIGHTEEN

LINE_USER_NINETEEN

LINE_USER_TWENTY

LINE_USER_TWENTY_ONE

LINE_USER_TWENTY_TWO

LINE_USER_TWENTY_THREE

LINE_USER_TWENTY_FOUR

LINE_USER_TWENTY_FIVE

LINE_USER_TWENTY_SIX

LINE_USER_TWENTY_SEVEN

LINE_USER_TWENTY_EIGHT

LINE_USER_TWENTY_NINE

LINE_USER_THIRTY

TAX_POINT_DATE

LINE_TAX_AMOUNT

ROUNDED_LINE_TAX_AMOUNT

GLOBAL_ATTRIBUTE_CATEGORY

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

GLOBAL_ATTRIBUTE_NUMBER1

GLOBAL_ATTRIBUTE_NUMBER2

GLOBAL_ATTRIBUTE_NUMBER3

GLOBAL_ATTRIBUTE_NUMBER4

GLOBAL_ATTRIBUTE_NUMBER5

GLOBAL_ATTRIBUTE_DATE1

GLOBAL_ATTRIBUTE_DATE2

GLOBAL_ATTRIBUTE_DATE3

GLOBAL_ATTRIBUTE_DATE4

GLOBAL_ATTRIBUTE_DATE5

ATTRIBUTE_DATE1

ATTRIBUTE_DATE2

ATTRIBUTE_DATE3

ATTRIBUTE_DATE4

ATTRIBUTE_DATE5

ATTRIBUTE_NUMBER1

ATTRIBUTE_NUMBER2

ATTRIBUTE_NUMBER3

ATTRIBUTE_NUMBER4

ATTRIBUTE_NUMBER5

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

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

INTERFACE_LINE_CONTEXT

TAX_CLASSIFICATION_CODE

TRX_BUSINESS_CATEGORY

PRODUCT_TYPE

USER_DEFINED_FISC_CLASS

TRANSLATED_DESCRIPTION

ITEM_NUMBER

ITEM_GLOBAL_ATTRIBUTE1

ITEM_GLOBAL_ATTRIBUTE2

ITEM_GLOBAL_ATTRIBUTE3

ITEM_GLOBAL_ATTRIBUTE4

ITEM_GLOBAL_ATTRIBUTE5

ITEM_GLOBAL_ATTRIBUTE6

ITEM_GLOBAL_ATTRIBUTE7

ITEM_GLOBAL_ATTRIBUTE8

ITEM_GLOBAL_ATTRIBUTE9

ITEM_GLOBAL_ATTRIBUTE10

ITEM_GLOBAL_ATTRIBUTE11

ITEM_GLOBAL_ATTRIBUTE12

ITEM_GLOBAL_ATTRIBUTE13

ITEM_GLOBAL_ATTRIBUTE14

ITEM_GLOBAL_ATTRIBUTE15

ITEM_GLOBAL_ATTRIBUTE16

ITEM_GLOBAL_ATTRIBUTE17

ITEM_GLOBAL_ATTRIBUTE18

ITEM_GLOBAL_ATTRIBUTE19

ITEM_GLOBAL_ATTRIBUTE20

ITEM_GLOBAL_ATTRIBUTE_CATEGORY

ITEM_GLOBAL_ATTRIBUTE_DATE1

ITEM_GLOBAL_ATTRIBUTE_DATE2

ITEM_GLOBAL_ATTRIBUTE_DATE3

ITEM_GLOBAL_ATTRIBUTE_DATE4

ITEM_GLOBAL_ATTRIBUTE_DATE5

ITEM_GLOBAL_ATTRIBUTE_NUMBER1

ITEM_GLOBAL_ATTRIBUTE_NUMBER2

ITEM_GLOBAL_ATTRIBUTE_NUMBER3

ITEM_GLOBAL_ATTRIBUTE_NUMBER4

ITEM_GLOBAL_ATTRIBUTE_NUMBER5

ITEM_ATTRIBUTE_CATEGORY

ITEM_ATTRIBUTE1

ITEM_ATTRIBUTE2

ITEM_ATTRIBUTE3

ITEM_ATTRIBUTE4

ITEM_ATTRIBUTE5

ITEM_ATTRIBUTE6

ITEM_ATTRIBUTE7

ITEM_ATTRIBUTE8

ITEM_ATTRIBUTE9

ITEM_ATTRIBUTE10

ITEM_ATTRIBUTE11

ITEM_ATTRIBUTE12

ITEM_ATTRIBUTE13

ITEM_ATTRIBUTE14

ITEM_ATTRIBUTE15

ITEM_ATTRIBUTE16

ITEM_ATTRIBUTE17

ITEM_ATTRIBUTE18

ITEM_ATTRIBUTE19

ITEM_ATTRIBUTE20

ITEM_ATTRIBUTE21

ITEM_ATTRIBUTE22

ITEM_ATTRIBUTE23

ITEM_ATTRIBUTE24

ITEM_ATTRIBUTE25

ITEM_ATTRIBUTE26

ITEM_ATTRIBUTE27

ITEM_ATTRIBUTE28

ITEM_ATTRIBUTE29

ITEM_ATTRIBUTE30

ITEM_ATTRIBUTE_NUMBER1

ITEM_ATTRIBUTE_NUMBER2

ITEM_ATTRIBUTE_NUMBER3

ITEM_ATTRIBUTE_NUMBER4

ITEM_ATTRIBUTE_NUMBER5

ITEM_ATTRIBUTE_NUMBER6

ITEM_ATTRIBUTE_NUMBER7

ITEM_ATTRIBUTE_NUMBER8

ITEM_ATTRIBUTE_NUMBER9

ITEM_ATTRIBUTE_NUMBER10

ITEM_ATTRIBUTE_DATE1

ITEM_ATTRIBUTE_DATE2

ITEM_ATTRIBUTE_DATE3

ITEM_ATTRIBUTE_DATE4

ITEM_ATTRIBUTE_DATE5

ITEM_ATTRIBUTE_TIMESTAMP1

ITEM_ATTRIBUTE_TIMESTAMP2

ITEM_ATTRIBUTE_TIMESTAMP3

ITEM_ATTRIBUTE_TIMESTAMP4

ITEM_ATTRIBUTE_TIMESTAMP5

TP_ITEM_NUMBER

TP_ITEM_DESC

ITEM_CATEGORY_NAME

TAX_CLASSIFICATION_MEANING

TRX_BUSINESS_CATEGORY_NAME

PRODUCT_FISC_CLASSIF_CODE

PRODUCT_FISC_CLASSIF_DESC

LINE_INTENDED_USE_CODE

LINE_INTENDED_USE_DESC

PRODUCT_CATEGORY_NAME

PRODUCT_CATEGORY_CODE

PRODUCT_CATEGORY_ID

USER_DEFINED_FISC_CLASS_NAME

USER_DEFINED_FISC_CLASS_ID

ITEM_DESCRIPTION_US

TRX_DATE

ORIGINAL_TRX_NUMBER

ORIGINAL_TRX_TYPE

ORIGINAL_TRX_CLASS

ORIGINAL_TRX_DATE

ORIGINAL_LINE_NUMBER

SHIP_TO_LOC_ADDRESS1

SHIP_TO_LOC_ADDRESS2

SHIP_TO_LOC_ADDRESS3

SHIP_TO_LOC_CITY

SHIP_TO_LOC_POSTAL_CODE

SHIP_TO_LOC_COUNTY

SHIP_TO_LOC_COUNTRY

TAX_EXEMPT_NUMBER

TAX_EXEMPT_FLAG

MEMO_GLOBAL_ATTRIBUTE_CATEGORY

MEMO_GLOBAL_ATTRIBUTE1

MEMO_GLOBAL_ATTRIBUTE2

MEMO_GLOBAL_ATTRIBUTE3

MEMO_GLOBAL_ATTRIBUTE4

MEMO_GLOBAL_ATTRIBUTE5

MEMO_GLOBAL_ATTRIBUTE6

MEMO_GLOBAL_ATTRIBUTE7

MEMO_GLOBAL_ATTRIBUTE8

MEMO_GLOBAL_ATTRIBUTE9

MEMO_GLOBAL_ATTRIBUTE10

MEMO_GLOBAL_ATTRIBUTE11

MEMO_GLOBAL_ATTRIBUTE12

MEMO_GLOBAL_ATTRIBUTE13

MEMO_GLOBAL_ATTRIBUTE14

MEMO_GLOBAL_ATTRIBUTE15

MEMO_GLOBAL_ATTRIBUTE16

MEMO_GLOBAL_ATTRIBUTE17

MEMO_GLOBAL_ATTRIBUTE18

MEMO_GLOBAL_ATTRIBUTE19

MEMO_GLOBAL_ATTRIBUTE20

MEMO_GLOBAL_ATTRIBUTE_NUMBER1

MEMO_GLOBAL_ATTRIBUTE_NUMBER2

MEMO_GLOBAL_ATTRIBUTE_NUMBER3

MEMO_GLOBAL_ATTRIBUTE_NUMBER4

MEMO_GLOBAL_ATTRIBUTE_NUMBER5

MEMO_GLOBAL_ATTRIBUTE_DATE1

MEMO_GLOBAL_ATTRIBUTE_DATE2

MEMO_GLOBAL_ATTRIBUTE_DATE3

MEMO_GLOBAL_ATTRIBUTE_DATE4

MEMO_GLOBAL_ATTRIBUTE_DATE5

TAX_EXEMPT_HANDLING

ORDER_PRICE_ELEMENT_CODE

ORDER_PRICE_ELEMENT_USAGE_CODE

ORDER_ADJUSTMENT_TYPE_CODE

ORDER_ADJUSTMENT_REASON_CODE

SHIP_TO_LOC_NAME

Query

SQL_Statement

SELECT

l.customer_trx_id CUSTOMER_TRX_ID,

l.customer_trx_line_id CUSTOMER_TRX_LINE_ID,

l.line_type LINE_TYPE,

l.line_number LINE_NUMBER,

l.extended_amount LINE_AMOUNT,

header.INVOICE_CURRENCY_CODE CURRENCY_CODE,

l.unit_selling_price UNIT_SELLING_PRICE,

nvl(l.quantity_invoiced,quantity_credited) QUANTITY,

l.description DESCRIPTION,

l.uom_code UOM,

DECODE(l.inventory_item_id, NULL, m.name, egpItem.item_number) ITEM,

DECODE(l.inventory_item_id, NULL, m.description, egpItem.description) ITEM_DESCRIPTION,

':'|| to_char(l.customer_trx_id) ||':'|| to_char(l.customer_trx_line_id) REFERENCE_NUMBER,

ar_xml_view_functions.line_function1 (l.customer_trx_id, l.customer_trx_line_id) Line_User_One,

ar_xml_view_functions.line_function2 (l.customer_trx_id, l.customer_trx_line_id) Line_User_Two,

ar_xml_view_functions.line_function3 (l.customer_trx_id, l.customer_trx_line_id) Line_User_Three,

ar_xml_view_functions.line_function4 (l.customer_trx_id, l.customer_trx_line_id) Line_User_Four,

ar_xml_view_functions.line_function5 (l.customer_trx_id, l.customer_trx_line_id) Line_User_Five,

ar_xml_view_functions.line_function6 (l.customer_trx_id, l.customer_trx_line_id) Line_User_Six,

ar_xml_view_functions.line_function7 (l.customer_trx_id, l.customer_trx_line_id) Line_User_Seven,

ar_xml_view_functions.line_function8 (l.customer_trx_id, l.customer_trx_line_id) Line_User_Eight,

ar_xml_view_functions.line_function9 (l.customer_trx_id, l.customer_trx_line_id) Line_User_Nine ,

ar_xml_view_functions.line_function10 (l.customer_trx_id, l.customer_trx_line_id) Line_User_Ten,

ar_xml_view_functions.line_function11 (l.customer_trx_id, l.customer_trx_line_id) Line_User_Eleven,

ar_xml_view_functions.line_function12 (l.customer_trx_id, l.customer_trx_line_id) Line_User_Twelve,

ar_xml_view_functions.line_function13 (l.customer_trx_id, l.customer_trx_line_id) Line_User_Thirteen,

ar_xml_view_functions.line_function14 (l.customer_trx_id, l.customer_trx_line_id) Line_User_Fourteen,

ar_xml_view_functions.line_function15 (l.customer_trx_id, l.customer_trx_line_id) Line_User_Fifteen,

ar_xml_view_functions.line_function16 (l.customer_trx_id, l.customer_trx_line_id) Line_User_Sixteen,

ar_xml_view_functions.line_function17 (l.customer_trx_id, l.customer_trx_line_id) Line_User_Seventeen,

ar_xml_view_functions.line_function18 (l.customer_trx_id, l.customer_trx_line_id) Line_User_Eighteen,

ar_xml_view_functions.line_function19 (l.customer_trx_id, l.customer_trx_line_id) Line_User_Nineteen,

ar_xml_view_functions.line_function20 (l.customer_trx_id, l.customer_trx_line_id) Line_User_Twenty,

ar_xml_view_functions.line_function21 (l.customer_trx_id, l.customer_trx_line_id) Line_User_Twenty_One,

ar_xml_view_functions.line_function22 (l.customer_trx_id, l.customer_trx_line_id) Line_User_Twenty_Two,

ar_xml_view_functions.line_function23 (l.customer_trx_id, l.customer_trx_line_id) Line_User_Twenty_Three,

ar_xml_view_functions.line_function24 (l.customer_trx_id, l.customer_trx_line_id) Line_User_Twenty_Four,

ar_xml_view_functions.line_function25 (l.customer_trx_id, l.customer_trx_line_id) Line_User_Twenty_Five,

ar_xml_view_functions.line_function26 (l.customer_trx_id, l.customer_trx_line_id) Line_User_Twenty_Six,

ar_xml_view_functions.line_function27 (l.customer_trx_id, l.customer_trx_line_id) Line_User_Twenty_Seven,

ar_xml_view_functions.line_function28 (l.customer_trx_id, l.customer_trx_line_id) Line_User_Twenty_Eight,

ar_xml_view_functions.line_function29 (l.customer_trx_id, l.customer_trx_line_id) Line_User_Twenty_Nine,

ar_xml_view_functions.line_function30 (l.customer_trx_id, l.customer_trx_line_id) Line_User_Thirty,

(select MIN(zxline.TAX_POINT_DATE) from ra_customer_trx_lines_all line, zx_lines_v zxline where line.tax_line_id=zxline.tax_line_id and line.customer_trx_id=l.CUSTOMER_TRX_ID and line.line_type='TAX' and line.link_to_cust_trx_line_id=l.customer_trx_line_id) TAX_POINT_DATE,

(SELECT (SUM (NVL (extended_amount ,0))) FROM ra_customer_trx_lines_all line WHERE line.customer_trx_id=l.CUSTOMER_TRX_ID and line.line_type='TAX' and line.link_to_cust_trx_line_id=l.customer_trx_line_id) LINE_TAX_AMOUNT,

(select SUM(NVL(zxline.UNROUNDED_TAX_AMT,0)) - SUM (NVL (extended_amount ,0)) from ra_customer_trx_lines_all line, zx_lines_v zxline where line.tax_line_id=zxline.tax_line_id and line.customer_trx_id=l.CUSTOMER_TRX_ID and line.line_type='TAX' and line.link_to_cust_trx_line_id=l.customer_trx_line_id) ROUNDED_LINE_TAX_AMOUNT,

l.GLOBAL_ATTRIBUTE_CATEGORY,

l.GLOBAL_ATTRIBUTE1,

l.GLOBAL_ATTRIBUTE2,

l.GLOBAL_ATTRIBUTE3,

l.GLOBAL_ATTRIBUTE4,

l.GLOBAL_ATTRIBUTE5,

l.GLOBAL_ATTRIBUTE6,

l.GLOBAL_ATTRIBUTE7,

l.GLOBAL_ATTRIBUTE8,

l.GLOBAL_ATTRIBUTE9,

l.GLOBAL_ATTRIBUTE10,

l.GLOBAL_ATTRIBUTE11,

l.GLOBAL_ATTRIBUTE12,

l.GLOBAL_ATTRIBUTE13,

l.GLOBAL_ATTRIBUTE14,

l.GLOBAL_ATTRIBUTE15,

l.GLOBAL_ATTRIBUTE16,

l.GLOBAL_ATTRIBUTE17,

l.GLOBAL_ATTRIBUTE18,

l.GLOBAL_ATTRIBUTE19,

l.GLOBAL_ATTRIBUTE20,

l.GLOBAL_ATTRIBUTE_NUMBER1,

l.GLOBAL_ATTRIBUTE_NUMBER2,

l.GLOBAL_ATTRIBUTE_NUMBER3,

l.GLOBAL_ATTRIBUTE_NUMBER4,

l.GLOBAL_ATTRIBUTE_NUMBER5,

l.GLOBAL_ATTRIBUTE_DATE1,

l.GLOBAL_ATTRIBUTE_DATE2,

l.GLOBAL_ATTRIBUTE_DATE3,

l.GLOBAL_ATTRIBUTE_DATE4,

l.GLOBAL_ATTRIBUTE_DATE5,

l.ATTRIBUTE_DATE1,

l.ATTRIBUTE_DATE2,

l.ATTRIBUTE_DATE3,

l.ATTRIBUTE_DATE4,

l.ATTRIBUTE_DATE5,

l.ATTRIBUTE_NUMBER1,

l.ATTRIBUTE_NUMBER2,

l.ATTRIBUTE_NUMBER3,

l.ATTRIBUTE_NUMBER4,

l.ATTRIBUTE_NUMBER5,

l.ATTRIBUTE_CATEGORY,

l.ATTRIBUTE1,

l.ATTRIBUTE2,

l.ATTRIBUTE3,

l.ATTRIBUTE4,

l.ATTRIBUTE5,

l.ATTRIBUTE6,

l.ATTRIBUTE7,

l.ATTRIBUTE8,

l.ATTRIBUTE9,

l.ATTRIBUTE10,

l.ATTRIBUTE11,

l.ATTRIBUTE12,

l.ATTRIBUTE13,

l.ATTRIBUTE14,

l.ATTRIBUTE15,

l.INTERFACE_LINE_ATTRIBUTE1,

l.INTERFACE_LINE_ATTRIBUTE2,

l.INTERFACE_LINE_ATTRIBUTE3,

l.INTERFACE_LINE_ATTRIBUTE4,

l.INTERFACE_LINE_ATTRIBUTE5,

l.INTERFACE_LINE_ATTRIBUTE6,

l.INTERFACE_LINE_ATTRIBUTE7,

l.INTERFACE_LINE_ATTRIBUTE8,

l.INTERFACE_LINE_ATTRIBUTE9,

l.INTERFACE_LINE_ATTRIBUTE10,

l.INTERFACE_LINE_ATTRIBUTE11,

l.INTERFACE_LINE_ATTRIBUTE12,

l.INTERFACE_LINE_ATTRIBUTE13,

l.INTERFACE_LINE_ATTRIBUTE14,

l.INTERFACE_LINE_ATTRIBUTE15,

l.INTERFACE_LINE_CONTEXT,

l.TAX_CLASSIFICATION_CODE,

l.TRX_BUSINESS_CATEGORY,

l.PRODUCT_TYPE,

l.USER_DEFINED_FISC_CLASS,

l.TRANSLATED_DESCRIPTION,

egpItem.ITEM_NUMBER,

egpItem.GLOBAL_ATTRIBUTE1 ITEM_GLOBAL_ATTRIBUTE1,

egpItem.GLOBAL_ATTRIBUTE2 ITEM_GLOBAL_ATTRIBUTE2,

egpItem.GLOBAL_ATTRIBUTE3 ITEM_GLOBAL_ATTRIBUTE3,

egpItem.GLOBAL_ATTRIBUTE4 ITEM_GLOBAL_ATTRIBUTE4,

egpItem.GLOBAL_ATTRIBUTE5 ITEM_GLOBAL_ATTRIBUTE5,

egpItem.GLOBAL_ATTRIBUTE6 ITEM_GLOBAL_ATTRIBUTE6,

egpItem.GLOBAL_ATTRIBUTE7 ITEM_GLOBAL_ATTRIBUTE7,

egpItem.GLOBAL_ATTRIBUTE8 ITEM_GLOBAL_ATTRIBUTE8,

egpItem.GLOBAL_ATTRIBUTE9 ITEM_GLOBAL_ATTRIBUTE9,

egpItem.GLOBAL_ATTRIBUTE10 ITEM_GLOBAL_ATTRIBUTE10,

egpItem.GLOBAL_ATTRIBUTE11 ITEM_GLOBAL_ATTRIBUTE11,

egpItem.GLOBAL_ATTRIBUTE12 ITEM_GLOBAL_ATTRIBUTE12,

egpItem.GLOBAL_ATTRIBUTE13 ITEM_GLOBAL_ATTRIBUTE13,

egpItem.GLOBAL_ATTRIBUTE14 ITEM_GLOBAL_ATTRIBUTE14,

egpItem.GLOBAL_ATTRIBUTE15 ITEM_GLOBAL_ATTRIBUTE15,

egpItem.GLOBAL_ATTRIBUTE16 ITEM_GLOBAL_ATTRIBUTE16,

egpItem.GLOBAL_ATTRIBUTE17 ITEM_GLOBAL_ATTRIBUTE17,

egpItem.GLOBAL_ATTRIBUTE18 ITEM_GLOBAL_ATTRIBUTE18,

egpItem.GLOBAL_ATTRIBUTE19 ITEM_GLOBAL_ATTRIBUTE19,

egpItem.GLOBAL_ATTRIBUTE20 ITEM_GLOBAL_ATTRIBUTE20,

egpItem.GLOBAL_ATTRIBUTE_CATEGORY ITEM_GLOBAL_ATTRIBUTE_CATEGORY,

egpItem.GLOBAL_ATTRIBUTE_DATE1 ITEM_GLOBAL_ATTRIBUTE_DATE1,

egpItem.GLOBAL_ATTRIBUTE_DATE2 ITEM_GLOBAL_ATTRIBUTE_DATE2,

egpItem.GLOBAL_ATTRIBUTE_DATE3 ITEM_GLOBAL_ATTRIBUTE_DATE3,

egpItem.GLOBAL_ATTRIBUTE_DATE4 ITEM_GLOBAL_ATTRIBUTE_DATE4,

egpItem.GLOBAL_ATTRIBUTE_DATE5 ITEM_GLOBAL_ATTRIBUTE_DATE5,

egpItem.GLOBAL_ATTRIBUTE_NUMBER1 ITEM_GLOBAL_ATTRIBUTE_NUMBER1,

egpItem.GLOBAL_ATTRIBUTE_NUMBER2 ITEM_GLOBAL_ATTRIBUTE_NUMBER2,

egpItem.GLOBAL_ATTRIBUTE_NUMBER3 ITEM_GLOBAL_ATTRIBUTE_NUMBER3,

egpItem.GLOBAL_ATTRIBUTE_NUMBER4 ITEM_GLOBAL_ATTRIBUTE_NUMBER4,

egpItem.GLOBAL_ATTRIBUTE_NUMBER5 ITEM_GLOBAL_ATTRIBUTE_NUMBER5,

egpItem.ATTRIBUTE_CATEGORY ITEM_ATTRIBUTE_CATEGORY,

egpItem.ATTRIBUTE1 ITEM_ATTRIBUTE1,

egpItem.ATTRIBUTE2 ITEM_ATTRIBUTE2,

egpItem.ATTRIBUTE3 ITEM_ATTRIBUTE3,

egpItem.ATTRIBUTE4 ITEM_ATTRIBUTE4,

egpItem.ATTRIBUTE5 ITEM_ATTRIBUTE5,

egpItem.ATTRIBUTE6 ITEM_ATTRIBUTE6,

egpItem.ATTRIBUTE7 ITEM_ATTRIBUTE7,

egpItem.ATTRIBUTE8 ITEM_ATTRIBUTE8,

egpItem.ATTRIBUTE9 ITEM_ATTRIBUTE9,

egpItem.ATTRIBUTE10 ITEM_ATTRIBUTE10,

egpItem.ATTRIBUTE11 ITEM_ATTRIBUTE11,

egpItem.ATTRIBUTE12 ITEM_ATTRIBUTE12,

egpItem.ATTRIBUTE13 ITEM_ATTRIBUTE13,

egpItem.ATTRIBUTE14 ITEM_ATTRIBUTE14,

egpItem.ATTRIBUTE15 ITEM_ATTRIBUTE15,

egpItem.ATTRIBUTE16 ITEM_ATTRIBUTE16,

egpItem.ATTRIBUTE17 ITEM_ATTRIBUTE17,

egpItem.ATTRIBUTE18 ITEM_ATTRIBUTE18,

egpItem.ATTRIBUTE19 ITEM_ATTRIBUTE19,

egpItem.ATTRIBUTE20 ITEM_ATTRIBUTE20,

egpItem.ATTRIBUTE21 ITEM_ATTRIBUTE21,

egpItem.ATTRIBUTE22 ITEM_ATTRIBUTE22,

egpItem.ATTRIBUTE23 ITEM_ATTRIBUTE23,

egpItem.ATTRIBUTE24 ITEM_ATTRIBUTE24,

egpItem.ATTRIBUTE25 ITEM_ATTRIBUTE25,

egpItem.ATTRIBUTE26 ITEM_ATTRIBUTE26,

egpItem.ATTRIBUTE27 ITEM_ATTRIBUTE27,

egpItem.ATTRIBUTE28 ITEM_ATTRIBUTE28,

egpItem.ATTRIBUTE29 ITEM_ATTRIBUTE29,

egpItem.ATTRIBUTE30 ITEM_ATTRIBUTE30,

egpItem.ATTRIBUTE_NUMBER1 ITEM_ATTRIBUTE_NUMBER1,

egpItem.ATTRIBUTE_NUMBER2 ITEM_ATTRIBUTE_NUMBER2,

egpItem.ATTRIBUTE_NUMBER3 ITEM_ATTRIBUTE_NUMBER3,

egpItem.ATTRIBUTE_NUMBER4 ITEM_ATTRIBUTE_NUMBER4,

egpItem.ATTRIBUTE_NUMBER5 ITEM_ATTRIBUTE_NUMBER5,

egpItem.ATTRIBUTE_NUMBER6 ITEM_ATTRIBUTE_NUMBER6,

egpItem.ATTRIBUTE_NUMBER7 ITEM_ATTRIBUTE_NUMBER7,

egpItem.ATTRIBUTE_NUMBER8 ITEM_ATTRIBUTE_NUMBER8,

egpItem.ATTRIBUTE_NUMBER9 ITEM_ATTRIBUTE_NUMBER9,

egpItem.ATTRIBUTE_NUMBER10 ITEM_ATTRIBUTE_NUMBER10,

egpItem.ATTRIBUTE_DATE1 ITEM_ATTRIBUTE_DATE1,

egpItem.ATTRIBUTE_DATE2 ITEM_ATTRIBUTE_DATE2,

egpItem.ATTRIBUTE_DATE3 ITEM_ATTRIBUTE_DATE3,

egpItem.ATTRIBUTE_DATE4 ITEM_ATTRIBUTE_DATE4,

egpItem.ATTRIBUTE_DATE5 ITEM_ATTRIBUTE_DATE5,

egpItem.ATTRIBUTE_TIMESTAMP1 ITEM_ATTRIBUTE_TIMESTAMP1,

egpItem.ATTRIBUTE_TIMESTAMP2 ITEM_ATTRIBUTE_TIMESTAMP2,

egpItem.ATTRIBUTE_TIMESTAMP3 ITEM_ATTRIBUTE_TIMESTAMP3,

egpItem.ATTRIBUTE_TIMESTAMP4 ITEM_ATTRIBUTE_TIMESTAMP4,

egpItem.ATTRIBUTE_TIMESTAMP5 ITEM_ATTRIBUTE_TIMESTAMP5,

lext.TP_ITEM_NUMBER,

lext.TP_ITEM_DESC,

lext.ITEM_CATEGORY_NAME,

lext.TAX_CLASSIFICATION_MEANING,

lext.TRX_BUSINESS_CATEGORY_NAME,

lext.PRODUCT_FISC_CLASSIF_CODE,

lext.PRODUCT_FISC_CLASSIF_DESC,

lext.LINE_INTENDED_USE_CODE,

lext.LINE_INTENDED_USE_DESC,

lext.PRODUCT_CATEGORY_NAME,

lext.PRODUCT_CATEGORY_CODE,

lext.PRODUCT_CATEGORY_ID,

lext.USER_DEFINED_FISC_CLASS_NAME,

lext.USER_DEFINED_FISC_CLASS_ID,

lext.ITEM_DESCRIPTION_US,

header.trx_date,

lext.ORIGINAL_TRX_NUMBER,

lext.ORIGINAL_TRX_TYPE,

lext.ORIGINAL_TRX_CLASS,

lext.ORIGINAL_TRX_DATE,

lext.ORIGINAL_LINE_NUMBER,

lext.SHIP_TO_LOC_ADDRESS1,

lext.SHIP_TO_LOC_ADDRESS2,

lext.SHIP_TO_LOC_ADDRESS3,

lext.SHIP_TO_LOC_CITY,

lext.SHIP_TO_LOC_POSTAL_CODE,

lext.SHIP_TO_LOC_COUNTY,

lext.SHIP_TO_LOC_COUNTRY,

l.TAX_EXEMPT_NUMBER,

l.TAX_EXEMPT_FLAG,

m.GLOBAL_ATTRIBUTE_CATEGORY MEMO_GLOBAL_ATTRIBUTE_CATEGORY,

m.GLOBAL_ATTRIBUTE1 MEMO_GLOBAL_ATTRIBUTE1,

m.GLOBAL_ATTRIBUTE2 MEMO_GLOBAL_ATTRIBUTE2,

m.GLOBAL_ATTRIBUTE3 MEMO_GLOBAL_ATTRIBUTE3,

m.GLOBAL_ATTRIBUTE4 MEMO_GLOBAL_ATTRIBUTE4,

m.GLOBAL_ATTRIBUTE5 MEMO_GLOBAL_ATTRIBUTE5,

m.GLOBAL_ATTRIBUTE6 MEMO_GLOBAL_ATTRIBUTE6,

m.GLOBAL_ATTRIBUTE7 MEMO_GLOBAL_ATTRIBUTE7,

m.GLOBAL_ATTRIBUTE8 MEMO_GLOBAL_ATTRIBUTE8,

m.GLOBAL_ATTRIBUTE9 MEMO_GLOBAL_ATTRIBUTE9,

m.GLOBAL_ATTRIBUTE10 MEMO_GLOBAL_ATTRIBUTE10,

m.GLOBAL_ATTRIBUTE11 MEMO_GLOBAL_ATTRIBUTE11,

m.GLOBAL_ATTRIBUTE12 MEMO_GLOBAL_ATTRIBUTE12,

m.GLOBAL_ATTRIBUTE13 MEMO_GLOBAL_ATTRIBUTE13,

m.GLOBAL_ATTRIBUTE14 MEMO_GLOBAL_ATTRIBUTE14,

m.GLOBAL_ATTRIBUTE15 MEMO_GLOBAL_ATTRIBUTE15,

m.GLOBAL_ATTRIBUTE16 MEMO_GLOBAL_ATTRIBUTE16,

m.GLOBAL_ATTRIBUTE17 MEMO_GLOBAL_ATTRIBUTE17,

m.GLOBAL_ATTRIBUTE18 MEMO_GLOBAL_ATTRIBUTE18,

m.GLOBAL_ATTRIBUTE19 MEMO_GLOBAL_ATTRIBUTE19,

m.GLOBAL_ATTRIBUTE20 MEMO_GLOBAL_ATTRIBUTE20,

m.GLOBAL_ATTRIBUTE_NUMBER1 MEMO_GLOBAL_ATTRIBUTE_NUMBER1,

m.GLOBAL_ATTRIBUTE_NUMBER2 MEMO_GLOBAL_ATTRIBUTE_NUMBER2,

m.GLOBAL_ATTRIBUTE_NUMBER3 MEMO_GLOBAL_ATTRIBUTE_NUMBER3,

m.GLOBAL_ATTRIBUTE_NUMBER4 MEMO_GLOBAL_ATTRIBUTE_NUMBER4,

m.GLOBAL_ATTRIBUTE_NUMBER5 MEMO_GLOBAL_ATTRIBUTE_NUMBER5,

m.GLOBAL_ATTRIBUTE_DATE1 MEMO_GLOBAL_ATTRIBUTE_DATE1,

m.GLOBAL_ATTRIBUTE_DATE2 MEMO_GLOBAL_ATTRIBUTE_DATE2,

m.GLOBAL_ATTRIBUTE_DATE3 MEMO_GLOBAL_ATTRIBUTE_DATE3,

m.GLOBAL_ATTRIBUTE_DATE4 MEMO_GLOBAL_ATTRIBUTE_DATE4,

m.GLOBAL_ATTRIBUTE_DATE5 MEMO_GLOBAL_ATTRIBUTE_DATE5,

lext.TAX_EXEMPT_HANDLING,

lext.ORDER_PRICE_ELEMENT_CODE,

lext.ORDER_PRICE_ELEMENT_USAGE_CODE,

lext.ORDER_ADJUSTMENT_TYPE_CODE,

lext.ORDER_ADJUSTMENT_REASON_CODE,

lext.SHIP_TO_LOC_NAME

from

ra_customer_trx_all header,

ra_customer_trx_lines_all l,

EGP_SYSTEM_ITEMS egpItem,

AR_SYSTEM_PARAMETERS_ALL SP,

ar_memo_lines_all_vl m,

ar_doc_transfer_line_ext lext

WHERE

header.CUSTOMER_TRX_ID = l.CUSTOMER_TRX_ID

AND egpItem.inventory_item_id(+) = l.inventory_item_id

AND DECODE(l.inventory_item_id, null, -99, NVL(egpItem.ORGANIZATION_ID, Nvl(l.warehouse_id, sp.ITEM_VALIDATION_ORG_ID))) = DECODE(l.inventory_item_id, null, -99, Nvl(l.warehouse_id, sp.ITEM_VALIDATION_ORG_ID))

AND SP.ORG_ID = l.ORG_ID

and l.MEMO_LINE_SEQ_ID = m.memo_line_seq_id(+)

AND l.link_to_cust_trx_line_id is null

and l.line_type = 'LINE'

AND lext.customer_trx_id (+) = l.customer_trx_id

AND lext.customer_trx_line_id (+) = l.customer_trx_line_id

order by l.line_number