Scribd
Upload
32 views3 pages

A&P Invoice Report vs. Oracle Standard

This document compares the queries used in the A&P invoice report to the Oracle standard invoice report. It lists 9 main queries that make up each report and describes changes made in the A&P version for most of the queries. Some of the key changes include using substr to limit the length of customer names, removing a condition from a where clause, reversing parameters in NVL functions, adding new attribute fields, changing the view and columns referenced in some queries.

Uploaded by

Venu Sreeramoju
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
32 views3 pages

A&P Invoice Report vs. Oracle Standard

This document compares the queries used in the A&P invoice report to the Oracle standard invoice report. It lists 9 main queries that make up each report and describes changes made in the A&P version for most of the queries. Some of the key changes include using substr to limit the length of customer names, removing a condition from a where clause, reversing parameters in NVL functions, adding new attribute fields, changing the view and columns referenced in some queries.

Uploaded by

Venu Sreeramoju
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd

Title Date Author Version Reviewer Name

Comparing the A&P RDF with Standard 18 th April 2012 Venu Sreeramoju 1.0

Description: This document about the Changes/Customizations made in the A&P Invoice
Report comparing with the Oracle Standard Report. List of Query in the Report(RDF) 1. Q_invoice 2. Q_ship_customer 3. Q_remit_customer 4. Q_lines 5. Q_summary_inv 6. Q_adjustment 7. Q_REPEAT_HEADER 8. Q_Commitment_Adjustment 9. Q_tax_rate List of Changes based on the Query 1. Q_invoice We need to find the changes in the Query 2. Q_ship_customer 1. Using the substr function party_name in A&P RDF Standard : party.party_name SHIP_CUST_NAME A&P : substrb(party.party_name,1,50) SHIP_CUST_NAME 3. Q_remit_customer Standard : WHERE acct_site.cust_acct_site_ID = :REMIT_TO_CONTROL_ID And acct_site.party_site_id = party_site.party_site_id A&P : WHERE -- acct_site.cust_acct_site_ID = :REMIT_TO_CONTROL_ID --and acct_site.party_site_id = party_site.party_site_id Commented acct_site.cust_acct_site_ID = :REMIT_TO_CONTROL_ID condition in the where clause

4. Q_lines In this Query there are two changes made. Changes are as follows 1. Reversed the parameters in the nvl function used in the Standard report Standard : , nvl (c.unit_selling_price, c.gross_unit_selling_price) /* Bug 2335596 */ line_unit_selling_price , nvl (c.extended_amount, c.gross_extended_amount) line_extended_amount /* Bug 2335596 */ A&P : , nvl (c.gross_unit_selling_price, c.unit_selling_price) line_unit_selling_price , nvl (c.gross_extended_amount, c.extended_amount) line_extended_amount 2. Added new fields in the A& P report as below , c.attribute_category Line_attribute_cat, c.attribute1 lattribute1, c.attribute2 lattribute2, c.attribute3 lattribute3, c.attribute4 lattribute4, c.attribute5 lattribute5, c.attribute6 lattribute6, c.attribute7 lattribute7, c.attribute8 lattribute8, to_char(c.attribute9,'999,999,990.00') lattribute9, to_char (c.attribute10,'999,999,990.00') lattribute10, to_char (c.attribute11,'999,999,990.00') lattribute11, c.attribute12 lattribute12, to_char (c.attribute13,'999,999,990.00') lattribute13, c.attribute14 lattribute14, c.attribute15 lattribute15 5. Q_summary_inv Three changes in the Q_summary_inv query as below 1. We observe the change of View in the script (i.e. zx_lines_v with ar_vat_tax_vl ) A&P : ar_vat_tax_vl v, Standard : zx_lines_v v,

2. Change in the columns as the source/view as changed A&P : v.amount_includes_tax_flag inv_tax_inclusive_flag, Standard : v.tax_amt_included_flag inv_tax_inclusive_flag, 3. Change in the columns as the source/view as changed A&P : and c.vat_tax_id = v.vat_tax_id(+) Standard : and c.tax_line_id = v.tax_line_id(+) 4. In the Group clause they have used the same columns A&P : v.amount_includes_tax_flag, Standard : v.tax_amt_included_flag, 6. Q_adjustment No Change 7. Q_REPEAT_HEADER No Change 8. Q_Commitment_Adjustment No Change 9. Q_tax_rate No Change

You might also like