FND Design Data [Home] [Help]

Concurrent Program: ARXVATRN

Product: AR - Receivables
User Name: Tax Reconciliation Report
Description: Output Tax Reconciliation Report
Enabled: No
Execution Method: Oracle Reports
Argument Method: Standard

Executable: ARXVATRN

User Name: ARXVATRN
Description: Output VAT Reconciliation Report
Execution Filename: ARXVATRN
Subroutine Name:
Request Set Arguments
Name Descriptive Flex Display Insert Update Default Type Default Value Shared Name
ATTRIBUTE2 $SRS$.ARXVATRN Y Y YSselect 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 = 222gldatelow
ATTRIBUTE3 $SRS$.ARXVATRN Y Y YSselect 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 = 222gldatehigh
ATTRIBUTE5 $SRS$.ARXVATRN Y Y Ytrxdatelow
ATTRIBUTE6 $SRS$.ARXVATRN Y Y Ytrxdatehigh
ATTRIBUTE7 $SRS$.ARXVATRN Y Y YSselect meaning from ar_lookups where lookup_type = 'POSTING_STATUS' and lookup_code = 'POSTED'posting