eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Concurrent Program: ARXVATRV

Product:	AR - Receivables
User Name:	Customers with Invoices at 0 VAT and no VAT Registration Number
Description:	Customers with Invoices at 0 VAT and no VAT Registration Number
Enabled:	No
Execution Method:	Oracle Reports
Argument Method:	Standard

Executable: ARXVATRV

User Name:	ARXVATRV
Description:	Customers with Invoices at 0 VAT and no VAT Registration Number
Execution Filename:	ARXVATRV
Subroutine Name:

Request Set Arguments

Name	Descriptive Flex	Display	Insert	Update	Default Type	Default Value	Shared Name
ATTRIBUTE2	$SRS$.ARXVATRV	Y	Y	Y		select fnd_date.date_to_displaydate(start_date) from gl_period_statuses gl, ar_system_parameters ar where trunc(sysdate, 'MONTH')-1 between start_date and end_date and gl.set_of_books_id = ar.set_of_books_id and gl.application_id = 222	gldatelow
ATTRIBUTE3	$SRS$.ARXVATRV	Y	Y	Y		select fnd_date.date_to_displaydate(end_date) from gl_period_statuses gl, ar_system_parameters ar where trunc(sysdate, 'MONTH')-1 between start_date and end_date and gl.set_of_books_id = ar.set_of_books_id and gl.application_id = 222	gldatehigh
ATTRIBUTE4	$SRS$.ARXVATRV	Y	Y	Y			trxdatelow
ATTRIBUTE5	$SRS$.ARXVATRV	Y	Y	Y			trxdatehigh
ATTRIBUTE6	$SRS$.ARXVATRV	Y	Y	Y	S	select meaning from ar_lookups where lookup_type = 'POSTING_STATUS' and lookup_code = 'POSTED'	posting