AR Incomplete Invoices

Description
Categories: BI Publisher, Financials
Application: Receivables
Source: Incomplete Invoices Report (XML)
Short Name: RAXIIR_XML
DB package: AR_RAXIIR_XMLP_PKG
select
	        trx_number Number_A,
	        ctt.name    Type   ,
		ct.trx_date              Date_A   ,
		ctlgld.gl_date     GL_Date ,
		substrb(party.party_name,1,50) Name ,
		cust.account_number Number_B, 
	AR_RAXIIR_XMLP_PKG.c_data_not_foundformula(trx_number) C_data_not_found
from
		ra_customer_trx ct,
		hz_cust_accounts cust,
		hz_parties party,
		ra_cust_trx_types ctt,
		ra_cust_trx_line_gl_dist ctlgld
	where
		ct.bill_to_customer_id = cust.cust_account_id (+)
		and cust.party_id = party.party_id(+)
		and ct.cust_trx_type_id = ctt.cust_trx_type_id
		and ct.complete_flag = 'N'
                                    and  ctlgld. latest_rec_flag(+) = 'Y'
		and ctlgld.customer_trx_id (+) = ct.customer_trx_id 
		and nvl(ctlgld.account_class,'REC') = 'REC'
                &lp_item_number_low
		&lp_item_number_high
                &lp_customer_name_low 
                &lp_customer_name_high 
                &lp_customer_number_low 
                &lp_customer_number_high 
	order by
		decode(:p_order_by,
                       'Invoice', ct.trx_number,
                       party.party_name)
Parameter Name SQL text Validation
Customer Number High
 
LOV Oracle
Customer Number Low
 
LOV Oracle
Customer Name High
 
LOV Oracle
Customer Name Low
 
LOV Oracle
Invoice Number High
 
LOV Oracle
Invoice Number Low
 
LOV Oracle
Order By
 
LOV Oracle