View: IBY_XML_FD_DOC_1_0_V

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

View Text

SELECT XMLELEMENT("DOCUMENTPAYABLE"
, XMLELEMENT("DOCUMENTNUMBER"
, XMLELEMENT("DOCUMENTINTERNALIDSEGMENT1"
, DOC.CALLING_APP_DOC_UNIQUE_REF1)
, XMLELEMENT("DOCUMENTINTERNALIDSEGMENT2"
, DOC.CALLING_APP_DOC_UNIQUE_REF2)
, XMLELEMENT("DOCUMENTINTERNALIDSEGMENT3"
, DOC.CALLING_APP_DOC_UNIQUE_REF3)
, XMLELEMENT("DOCUMENTINTERNALIDSEGMENT4"
, DOC.CALLING_APP_DOC_UNIQUE_REF4)
, XMLELEMENT("DOCUMENTINTERNALIDSEGMENT5"
, DOC.CALLING_APP_DOC_UNIQUE_REF5)
, XMLELEMENT("APPLICATIONINTERNALID"
, DOC.CALLING_APP_ID)
, XMLELEMENT("APPLICATIONDOCUMENTSUBTYPE"
, DOC.PAY_PROC_TRXN_TYPE_CODE)
, XMLELEMENT("APPLICATIONUNIQUEINTERNALID"
, DOC.CALLING_APP_DOCUMENT_UNIQUE_ID)
, XMLELEMENT("REFERENCENUMBER"
, DOC.CALLING_APP_DOC_REF_NUMBER)
, CASE WHEN DOC.BANK_ASSIGNED_REF_CODE IS NOT NULL THEN XMLELEMENT("BANKASSIGNEDREFCODE"
, DOC.BANK_ASSIGNED_REF_CODE) ELSE NULL END
, XMLELEMENT("UNIQUEREMITTANCEIDENTIFIER"
, XMLELEMENT("NUMBER"
, DOC.UNIQUE_REMITTANCE_IDENTIFIER)
, XMLELEMENT("CHECKDIGIT"
, DOC.URI_CHECK_DIGIT))
, XMLELEMENT("DOCCATEGORY"
, DOC.DOC_CATEGORY)
, XMLELEMENT("SEQUENCENAME"
, DOC.DOC_SEQUENCE_NAME)
, XMLELEMENT("SEQUENCEVALUE"
, DOC.DOC_SEQUENCE_VALUE))
, XMLELEMENT("PONUMBER"
, DOC.PO_NUMBER)
, XMLELEMENT("DOCUMENTSTATUS"
, XMLELEMENT("CODE"
, DOC.DOCUMENT_STATUS)
, XMLELEMENT("MEANING"
, DOC.DOCUMENT_STATUS_MEANING))
, IBY_FD_EXTRACT_GEN_PVT.GET_DOC_DOCERRAGG(DOC.DOCUMENT_PAYABLE_ID)
, XMLELEMENT("DOCUMENTDATE"
, DOC.DOCUMENT_DATE)
, XMLELEMENT("DOCUMENTCREATIONDATE"
, DOC.DOCUMENT_CREATION_DATE)
, CASE WHEN DOC.PAYMENT_DUE_DATE IS NOT NULL THEN XMLELEMENT("PAYMENTDUEDATE"
, DOC.PAYMENT_DUE_DATE) ELSE NULL END
, XMLELEMENT("DOCUMENTTYPE"
, XMLELEMENT("CODE"
, DOC.DOCUMENT_TYPE)
, XMLELEMENT("MEANING"
, DOC.DOCUMENT_TYPE_MEANING))
, XMLELEMENT("DOCUMENTDESCRIPTION"
, DOC.DOCUMENT_DESCRIPTION)
, XMLELEMENT("TOTALDOCUMENTAMOUNT"
, XMLELEMENT("VALUE"
, DOC.DOCUMENT_AMOUNT)
, XMLELEMENT("CURRENCY"
, XMLELEMENT("CODE"
, DOC.DOCUMENT_CURRENCY_CODE)))
, XMLELEMENT("PAYMENTAMOUNT"
, XMLELEMENT("VALUE"
, DOC.PAYMENT_AMOUNT)
, XMLELEMENT("CURRENCY"
, XMLELEMENT("CODE"
, DOC.PAYMENT_CURRENCY_CODE)))
, XMLELEMENT("PAYALONEFLAG"
, DOC.EXCLUSIVE_PAYMENT_FLAG)
, XMLELEMENT("SETTLEMENTPRIORITY"
, XMLELEMENT("CODE"
, DOC.SETTLEMENT_PRIORITY)
, XMLELEMENT("MEANING"
, DOC.SETTLEMENT_PRIORITY_MEANING))
, XMLELEMENT("AMOUNTWITHHELD"
, XMLELEMENT("VALUE"
, DOC.AMOUNT_WITHHELD)
, XMLELEMENT("CURRENCY"
, XMLELEMENT("CODE"
, DOC.PAYMENT_CURRENCY_CODE)))
, XMLELEMENT("DISCOUNTTAKEN"
, XMLELEMENT("AMOUNT"
, XMLELEMENT("VALUE"
, DOC.PAYMENT_CURR_DISCOUNT_TAKEN)
, XMLELEMENT("CURRENCY"
, XMLELEMENT("CODE"
, DOC.PAYMENT_CURRENCY_CODE)))
, XMLELEMENT("DISCOUNTDATE"
, DOC.DISCOUNT_DATE))
, XMLELEMENT("BANKCHARGES"
, XMLELEMENT("BANKCHARGEBEARER"
, XMLELEMENT("CODE"
, DOC.BANK_CHARGE_BEARER)
, XMLELEMENT("MEANING"
, DOC.BANK_CHARGE_BEARER_MEANING)))
, XMLELEMENT("DELIVERYCHANNEL"
, XMLELEMENT("CODE"
, DOC.DELIVERY_CHANNEL_CODE)
, XMLELEMENT("MEANING"
, DOC.DELIVERY_CHANNEL_MEANING)
, XMLELEMENT("FORMATVALUE"
, DOC.DELIVERY_CHANNEL_FORMAT_VALUE))
, XMLELEMENT("PAYMENTREASON"
, XMLELEMENT("CODE"
, DOC.PAYMENT_REASON_CODE)
, XMLELEMENT("MEANING"
, DOC.PAYMENT_REASON_MEANING)
, XMLELEMENT("FORMATVALUE"
, DOC.PAYMENT_REASON_FORMAT_VALUE))
, XMLELEMENT("PAYMENTREASONCOMMENTS"
, DOC.PAYMENT_REASON_COMMENTS)
, XMLELEMENT("REMITTANCEMESSAGE"
, DOC.REMITTANCE_MESSAGE1)
, XMLELEMENT("REMITTANCEMESSAGE"
, DOC.REMITTANCE_MESSAGE2)
, XMLELEMENT("REMITTANCEMESSAGE"
, DOC.REMITTANCE_MESSAGE3)
, XMLELEMENT("CHARGE"
, XMLELEMENT("AMOUNT"
, XMLELEMENT("VALUE"
, DOC.DOCUMENT_CURR_CHARGE_AMOUNT)
, XMLELEMENT("CURRENCY"
, XMLELEMENT("CODE"
, DOC.DOCUMENT_CURRENCY_CODE)))
, XMLELEMENT("RATEPERCENT"
, NULL)
, XMLELEMENT("CHARGETYPE"
, NULL))
, XMLELEMENT("INTERESTRATE"
, DOC.INTEREST_RATE)
, IBY_FD_EXTRACT_GEN_PVT.GET_DOC_DOCLINEAGG(DOC.DOCUMENT_PAYABLE_ID)
, CASE WHEN DOC.DOC_PAYABLE_ATTR_CAT IS NULL THEN NULL ELSE XMLELEMENT("DESCRIPTIVEFLEXFIELD"
, IBY_EXTRACTGEN_PVT.GET_DFFS( 'IBY_DOCS_PAYABLE_ALL'
, DOC.DOCUMENT_PAYABLE_ID
, NULL)) END )
, DOC.PAYMENT_ID
, DOC.PAYMENT_SERVICE_REQUEST_ID
, DOC.DOCUMENT_PAYABLE_ID
, DOC.DOCUMENT_STATUS
FROM IBY_EXT_FD_DOC_1_0_V DOC

Columns