VIEW: APPS.IBY_XML_FNDCPT_DOC_LINE_V

Source

View Text - Preformatted

SELECT XMLElement("DocumentLine", XMLElement("LineID",inv_line.Line_number), XMLElement("LineNumber",inv_line.line_number), XMLForest(inv_line.PO_NUMBER AS "PONumber"), XMLElement("LineType", XMLElement("Code",inv_line.line_type), XMLElement("Meaning",null) ), XMLElement("LineDescription",inv_line.description), XMLElement("LineAmount", XMLElement("Value",inv_line.extended_amount), XMLElement("Currency", XMLElement("Code",inv_line.invoice_currency_code) ) ), XMLElement("UnitRate",inv_line.unit_price), XMLElement("Quantity",inv_line.quantity), XMLElement("UnitOfMeasure",inv_line.unit_of_measure), XMLForest(inv_line.inventory_item_id AS "ProductCode"), XMLForest(null AS "CommodityCode"), XMLElement("Discount", XMLElement("Amount", XMLElement("Value",inv_line.discount_amount), XMLElement("Currency", XMLElement("Code",inv_line.invoice_currency_code) ) ), XMLForest(null AS "DiscountType") ), XMLElement("Tax", XMLElement("Amount", XMLElement("Value",inv_line.sales_tax_amount), XMLElement("Currency", XMLElement("Code",inv_line.invoice_currency_code) ) ), XMLElement("RatePercent",inv_line.tax_rate), XMLForest('SALESTAX' AS "TaxType"), XMLForest(null AS "TaxJurisdiction") ), XMLElement("Tax", XMLElement("Amount", XMLElement("Value",inv_line.VAT_tax_amount), XMLElement("Currency", XMLElement("Code",inv_line.invoice_currency_code) ) ), XMLElement("RatePercent",inv_line.tax_rate), XMLForest('VAT' AS "TaxType"), XMLForest(null AS "TaxJurisdiction") ) ), inv_line.line_number, inv_line.doc_unique_ref, inv_line.line_number FROM ar_document_lines_v inv_line

View Text - HTML Formatted

SELECT XMLELEMENT("DOCUMENTLINE"
, XMLELEMENT("LINEID"
, INV_LINE.LINE_NUMBER)
, XMLELEMENT("LINENUMBER"
, INV_LINE.LINE_NUMBER)
, XMLFOREST(INV_LINE.PO_NUMBER AS "PONUMBER")
, XMLELEMENT("LINETYPE"
, XMLELEMENT("CODE"
, INV_LINE.LINE_TYPE)
, XMLELEMENT("MEANING"
, NULL) )
, XMLELEMENT("LINEDESCRIPTION"
, INV_LINE.DESCRIPTION)
, XMLELEMENT("LINEAMOUNT"
, XMLELEMENT("VALUE"
, INV_LINE.EXTENDED_AMOUNT)
, XMLELEMENT("CURRENCY"
, XMLELEMENT("CODE"
, INV_LINE.INVOICE_CURRENCY_CODE) ) )
, XMLELEMENT("UNITRATE"
, INV_LINE.UNIT_PRICE)
, XMLELEMENT("QUANTITY"
, INV_LINE.QUANTITY)
, XMLELEMENT("UNITOFMEASURE"
, INV_LINE.UNIT_OF_MEASURE)
, XMLFOREST(INV_LINE.INVENTORY_ITEM_ID AS "PRODUCTCODE")
, XMLFOREST(NULL AS "COMMODITYCODE")
, XMLELEMENT("DISCOUNT"
, XMLELEMENT("AMOUNT"
, XMLELEMENT("VALUE"
, INV_LINE.DISCOUNT_AMOUNT)
, XMLELEMENT("CURRENCY"
, XMLELEMENT("CODE"
, INV_LINE.INVOICE_CURRENCY_CODE) ) )
, XMLFOREST(NULL AS "DISCOUNTTYPE") )
, XMLELEMENT("TAX"
, XMLELEMENT("AMOUNT"
, XMLELEMENT("VALUE"
, INV_LINE.SALES_TAX_AMOUNT)
, XMLELEMENT("CURRENCY"
, XMLELEMENT("CODE"
, INV_LINE.INVOICE_CURRENCY_CODE) ) )
, XMLELEMENT("RATEPERCENT"
, INV_LINE.TAX_RATE)
, XMLFOREST('SALESTAX' AS "TAXTYPE")
, XMLFOREST(NULL AS "TAXJURISDICTION") )
, XMLELEMENT("TAX"
, XMLELEMENT("AMOUNT"
, XMLELEMENT("VALUE"
, INV_LINE.VAT_TAX_AMOUNT)
, XMLELEMENT("CURRENCY"
, XMLELEMENT("CODE"
, INV_LINE.INVOICE_CURRENCY_CODE) ) )
, XMLELEMENT("RATEPERCENT"
, INV_LINE.TAX_RATE)
, XMLFOREST('VAT' AS "TAXTYPE")
, XMLFOREST(NULL AS "TAXJURISDICTION") ) )
, INV_LINE.LINE_NUMBER
, INV_LINE.DOC_UNIQUE_REF
, INV_LINE.LINE_NUMBER
FROM AR_DOCUMENT_LINES_V INV_LINE