eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.IBY_XML_FD_DOC_1_0_V

Source

View Text - Preformatted


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("ExpenseReportCreditCardNumber", doc.EXPENSE_RPT_CC_NUM), XMLElement("EmployeePaymentFlag", doc.employee_payment_flag), 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("TotalDocumentChargeAmount", XMLElement("Value", doc.document_curr_charge_amount), XMLElement("Currency", XMLElement("Code", doc.document_currency_code)))), XMLElement("TotalDocumentTaxAmount", XMLElement("Value", doc.DOCUMENT_CURRENCY_TAX_AMOUNT), XMLElement("Currency", XMLElement("Code", doc.document_currency_code))), XMLElement("CreditAmountApplied", XMLElement("Value", doc.BORDERO_ABATEMENT), XMLElement("Currency", XMLElement("Code", doc.document_currency_code))), XMLElement("InterestAmountApplied", XMLElement("Value", doc.BORDERO_INT_AMT), XMLElement("Currency", XMLElement("Code", doc.document_currency_code))), XMLElement("InterestRate", doc.interest_rate), IBY_FD_EXTRACT_GEN_PVT.Get_Doc_DocLineAgg(doc.document_payable_id), IBY_FD_EXTRACT_EXT_PUB.Get_Doc_Ext_Agg(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, XMLElement("SrcDocDescriptiveFlexField", decode(calling_app_id, 200, IBY_EXTRACTGEN_PVT.Get_Dffs( 'AP_DOCUMENTS_PAYABLE', doc.document_payable_id, NULL), null)) ), doc.payment_id, doc.formatting_payment_id, doc.payment_service_request_id, doc.document_payable_id, doc.document_status FROM iby_ext_fd_doc_1_0_v doc

View Text - HTML Formatted

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("EXPENSEREPORTCREDITCARDNUMBER"
, DOC.EXPENSE_RPT_CC_NUM)
, XMLELEMENT("EMPLOYEEPAYMENTFLAG"
, DOC.EMPLOYEE_PAYMENT_FLAG)
, 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("TOTALDOCUMENTCHARGEAMOUNT"
, XMLELEMENT("VALUE"
, DOC.DOCUMENT_CURR_CHARGE_AMOUNT)
, XMLELEMENT("CURRENCY"
, XMLELEMENT("CODE"
, DOC.DOCUMENT_CURRENCY_CODE))))
, XMLELEMENT("TOTALDOCUMENTTAXAMOUNT"
, XMLELEMENT("VALUE"
, DOC.DOCUMENT_CURRENCY_TAX_AMOUNT)
, XMLELEMENT("CURRENCY"
, XMLELEMENT("CODE"
, DOC.DOCUMENT_CURRENCY_CODE)))
, XMLELEMENT("CREDITAMOUNTAPPLIED"
, XMLELEMENT("VALUE"
, DOC.BORDERO_ABATEMENT)
, XMLELEMENT("CURRENCY"
, XMLELEMENT("CODE"
, DOC.DOCUMENT_CURRENCY_CODE)))
, XMLELEMENT("INTERESTAMOUNTAPPLIED"
, XMLELEMENT("VALUE"
, DOC.BORDERO_INT_AMT)
, XMLELEMENT("CURRENCY"
, XMLELEMENT("CODE"
, DOC.DOCUMENT_CURRENCY_CODE)))
, XMLELEMENT("INTERESTRATE"
, DOC.INTEREST_RATE)
, IBY_FD_EXTRACT_GEN_PVT.GET_DOC_DOCLINEAGG(DOC.DOCUMENT_PAYABLE_ID)
, IBY_FD_EXTRACT_EXT_PUB.GET_DOC_EXT_AGG(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
, XMLELEMENT("SRCDOCDESCRIPTIVEFLEXFIELD"
, DECODE(CALLING_APP_ID
, 200
, IBY_EXTRACTGEN_PVT.GET_DFFS( 'AP_DOCUMENTS_PAYABLE'
, DOC.DOCUMENT_PAYABLE_ID
, NULL)
, NULL)) )
, DOC.PAYMENT_ID
, DOC.FORMATTING_PAYMENT_ID
, DOC.PAYMENT_SERVICE_REQUEST_ID
, DOC.DOCUMENT_PAYABLE_ID
, DOC.DOCUMENT_STATUS
FROM IBY_EXT_FD_DOC_1_0_V DOC