1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

edit transaction xml report in receivable

Discussion in 'Oracle Apps Technical' started by anasosama, Jul 24, 2014.

  1. anasosama

    anasosama Active Member

    Messages:
    6
    Likes Received:
    1
    Trophy Points:
    55
    Any one please I need to edit some fields in the report attached , how can get this template and where can I find it and how can I make edits on it?
     

    Attached Files:

  2. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    I Think that's an OAF page.

    Check About this page at bottom...
     
  3. anasosama

    anasosama Active Member

    Messages:
    6
    Likes Received:
    1
    Trophy Points:
    55
    Thank for replying
    But can u explain more
    I checked about this page but I couldn't find any thing useful
     
  4. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi,

    I too don't have much knowledge on OAF..

    But when I check that form I find Below Query.

    SELECT lines.customer_trx_id customer_trx_id,
    lines.customer_trx_line_id customer_trx_line_id,
    TO_CHAR(lines.line_number) line_number,
    lines.line_type line_type,
    NVL(AR_INVOICE_SQL_FUNC_PUB.get_description( lines.customer_trx_line_id ), lines.description) description,
    TO_CHAR(NVL(lines.quantity_invoiced, lines.quantity_credited)) quantity,
    uom.unit_of_measure unit_of_measure_name,
    TO_CHAR(NVL(lines.unit_selling_price,0),fnd_currency.get_format_mask(trx.invoice_currency_code,40)) unit_price,
    TO_CHAR(lines.extended_amount,fnd_currency.get_format_mask(trx.invoice_currency_code,40)) extended_amount,
    lines.sales_order,
    lines.uom_code,
    trx.trx_number,
    AR_INVOICE_SQL_FUNC_PUB.get_taxyn ( lines.customer_trx_line_id ) tax_exists_for_this_line_flag,
    TO_CHAR(rownum) AS sequence_number,
    AR_BPA_UTILS_PKG.FN_GET_LINE_TAXRATE(lines.customer_trx_line_id) line_tax_rate,
    AR_BPA_UTILS_PKG.FN_GET_LINE_TAXCODE(lines.customer_trx_line_id) tax_code,
    AR_BPA_UTILS_PKG.FN_GET_LINE_TAXNAME(lines.customer_trx_line_id) printed_tax_name,
    lines.interface_line_attribute1,
    lines.interface_line_attribute2,
    lines.interface_line_attribute3,
    lines.interface_line_attribute4,
    lines.interface_line_attribute5,
    lines.interface_line_attribute6,
    lines.interface_line_attribute7,
    lines.interface_line_attribute8,
    lines.interface_line_attribute9,
    lines.interface_line_attribute10,
    lines.interface_line_attribute11,
    lines.interface_line_attribute12,
    lines.interface_line_attribute13,
    lines.interface_line_attribute14,
    lines.interface_line_attribute15,
    TO_CHAR(NVL(lines.unit_selling_price,0)) unformatted_unit_price,
    TO_CHAR(NVL(lines.extended_amount,0)) unformatted_extended_amount,
    lines.ATTRIBUTE1,
    lines.ATTRIBUTE2,
    lines.ATTRIBUTE3,
    lines.ATTRIBUTE4,
    lines.ATTRIBUTE5,
    lines.ATTRIBUTE6,
    lines.ATTRIBUTE7,
    lines.ATTRIBUTE8,
    lines.ATTRIBUTE9,
    lines.ATTRIBUTE10,
    lines.ATTRIBUTE11,
    lines.ATTRIBUTE12,
    lines.ATTRIBUTE13,
    lines.ATTRIBUTE14,
    lines.ATTRIBUTE15,
    lines.SET_OF_BOOKS_ID,
    lines.REASON_CODE,
    lines.QUANTITY_ORDERED,
    lines.QUANTITY_CREDITED,
    lines.UNIT_STANDARD_PRICE,
    lines.SALES_ORDER_LINE,
    lines.SALES_ORDER_DATE,
    lines.ACCOUNTING_RULE_DURATION,
    lines.ATTRIBUTE_CATEGORY,
    lines.RULE_START_DATE,
    lines.INTERFACE_LINE_CONTEXT,
    lines.SALES_ORDER_SOURCE,
    lines.REVENUE_AMOUNT,
    lines.DEFAULT_USSGL_TRANSACTION_CODE,
    lines.DEFAULT_USSGL_TRX_CODE_CONTEXT,
    lines.LAST_PERIOD_TO_CREDIT,
    lines.ITEM_CONTEXT,
    lines.TAX_EXEMPT_FLAG,
    lines.TAX_EXEMPT_NUMBER,
    lines.TAX_EXEMPT_REASON_CODE,
    lines.TAX_VENDOR_RETURN_CODE,
    lines.GLOBAL_ATTRIBUTE_CATEGORY,
    lines.GROSS_UNIT_SELLING_PRICE,
    lines.GROSS_EXTENDED_AMOUNT,
    lines.EXTENDED_ACCTD_AMOUNT,
    lines.MRC_EXTENDED_ACCTD_AMOUNT,
    lines.ORG_ID,
    lines.GLOBAL_ATTRIBUTE1,
    lines.GLOBAL_ATTRIBUTE2,
    lines.GLOBAL_ATTRIBUTE3,
    lines.GLOBAL_ATTRIBUTE4,
    lines.GLOBAL_ATTRIBUTE5,
    lines.GLOBAL_ATTRIBUTE6,
    lines.GLOBAL_ATTRIBUTE7,
    lines.GLOBAL_ATTRIBUTE8,
    lines.GLOBAL_ATTRIBUTE9,
    lines.GLOBAL_ATTRIBUTE10,
    lines.GLOBAL_ATTRIBUTE11,
    lines.GLOBAL_ATTRIBUTE12,
    lines.GLOBAL_ATTRIBUTE13,
    lines.GLOBAL_ATTRIBUTE14,
    lines.GLOBAL_ATTRIBUTE15,
    lines.GLOBAL_ATTRIBUTE16,
    lines.GLOBAL_ATTRIBUTE17,
    lines.GLOBAL_ATTRIBUTE18,
    lines.GLOBAL_ATTRIBUTE19,
    lines.GLOBAL_ATTRIBUTE20,
    Zx_Extract_Pkg.Get_Legal_Message(lines.customer_trx_id, lines.customer_trx_line_id) legal_msg_text
    FROM mtl_units_of_measure uom,
    ra_customer_trx_lines_all lines,
    ra_customer_trx trx
    WHERE lines.customer_trx_id = :1
    AND trx.customer_trx_id = lines.customer_trx_id
    AND trx.org_id = lines.org_id
    AND trx.complete_flag = 'Y'
    AND lines.uom_code = uom.uom_code(+)
    AND line_type IN ('LINE','CB')
    ;

    So you need to modify this query.

    First find that OAF page files in server and need to modify them. So For this you need OAF knowledge.