INCOMPLETE INVOICES REPORT, Add customer name to Report

TICKET 6: INCOMPLETE INVOICES REPORT:

                 Add to more PARAMETERS Complete flag, Customer Name.

WHAT IS: Use this report to review all of your incomplete invoices, debit memos, credit memos, and on-account credits. Incomplete invoices do not update your open receivables balance nor do they display on your agings. 

QUERY:

From hz_parties party,

          ra_customer_trx ct

Where

and party.party_name=nvl(:P_Party_name,party.party_name)

and ct.complete_flag =:P_Complete_Flag 

Added Complete flag, Customer Name in Concurrent Program Parameters

What it is:

Use this report to review all of your incomplete invoices, debit memos, credit memos, and on-account credits. Incomplete invoices do not update your open receivables balance nor do they display on your agings. Use the Transactions window to complete your invoice or debit memo once you have updated them. For credit memos and on-account credits, use the Credit Memos window.

Customization:

Add two parameters Complete flag and Customer name. Depending on complete flag customer name parameter should be enabled or disabled.

Value sets : XXCOMPLETE_FLAG, XXCUSTOMER_SAN

Parameters:

Order by, from invoice num, to Invoice Num etc…..

TABLES:

ra_customer_trx ,hz_cust_accounts ,hz_parties ,ra_cust_trx_types,ra_cust_trx_line_gl_dist