AR Incomplete Invoices

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)