AR Incomplete Transactions

Description

Categories
Enginatics
Repository
GitHub
Detail incomplete transaction report

When India Localization is installed, the following GST columns are also included: GST Registration No, GST PAN No, CGST Amount, SGST Amount, IGST Amount, CESS Amount, Custom Amount, Unclassified Tax Amount, Taxable Value, HSN SAC Code, HSN Length Warning, CGST Rate, SGST Rate, IGST Rate, CESS Rate, CGST Recoverable, CGST Non-Recoverable, SGST Recoverable, SGST Non-Recoverable, IGST Recoverable, IGST Non-Recoverable, Reverse Charge Flag, Place of Supply, Ship From State.

SQL 93 lines

Parameters 11

ParameterTypeList of values SQL
Operating UnitLOV
haouv.name=:operating_unit
Transaction ClassLOV
rctta.type=xxen_util.lookup_code(:transaction_class,'INV/CM/ADJ',222)
Transaction TypeLOV
rctta.name=:trx_type
CategoryLOV
rcta.interface_header_context=:category
Created ByLOV
rcta.created_by=xxen_util.user_id(:created_by)
PeriodLOV
rcta.trx_date>=(select
gps.start_date
from
gl_period_statuses gps
where
gps.period_name=:period_name and
gps.set_of_books_id=(select hou.set_of_books_id from hr_operating_units hou where hou.organization_id=fnd_global.org_id) and
gps.application_id=222) and
rcta.trx_date<(select
gps.end_date+1
from
gl_period_statuses gps
where
gps.period_name=:period_name and
gps.set_of_books_id=(select hou.set_of_books_id from hr_operating_units hou where hou.organization_id=fnd_global.org_id) and
gps.application_id=222)
Inv. Date FromDate
rcta.trx_date>=:trx_date_from
Inv. Date ToDate
rcta.trx_date<:trx_date_to+1
Customer NameLOV
upper(hp.party_name) like upper(:customer_name)
Account NumberLOV
hca.account_number=:account_number
Transaction NumberChar
rcta.trx_number=:trx_number