View: IBY_XML_FNDCPT_DOC_LINE_V

Product:	IBY - Payments
Description:
Implementation/DBA Data:	APPS.IBY_XML_FNDCPT_DOC_LINE_V

View Text

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.LINE_GROSS_AMOUNT)
, XMLELEMENT("CURRENCY"
, XMLELEMENT("CODE"
, INV_HEADER.DOCUMENT_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_HEADER.DOCUMENT_CURRENCY_CODE) ) )
, XMLFOREST(NULL AS "DISCOUNTTYPE") )
, XMLELEMENT("TAX"
, XMLELEMENT("AMOUNT"
, XMLELEMENT("VALUE"
, INV_LINE.SALES_TAX_AMOUNT)
, XMLELEMENT("CURRENCY"
, XMLELEMENT("CODE"
, INV_HEADER.DOCUMENT_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_HEADER.DOCUMENT_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
FROM AR_DOCS_RECEIVABLES_V INV_HEADER
, AR_DOCUMENT_LINES_V INV_LINE
WHERE (INV_LINE.DOC_UNIQUE_REF = INV_HEADER.DOC_UNIQUE_REF)

Columns