How to validate a AR is correct?
- Author: Richard.liu
SELECT c.trx_number, c.complete_flag, c.customer_trx_id,
a.customer_trx_line_id,
(SELECT payment_schedule_id
FROM ar.ar_payment_schedules_all d
WHERE a.customer_trx_id = d.customer_trx_id) payment_schedule_id,
(SELECT receivable_application_id
FROM ar.ar_receivable_applications_all e
WHERE a.customer_trx_id =
e.customer_trx_id)
receivable_application_id
FROM ar.ra_customer_trx_lines_all a,
ar.ra_customer_trx_lines_all b,
ar.ra_customer_trx_all c
WHERE c.set_of_books_id = '& sob'
AND a.customer_trx_id = c.customer_trx_id
AND a.set_of_books_id = '& sob'
AND a.set_of_books_id = b.set_of_books_id
AND a.customer_trx_line_id = b.link_to_cust_trx_line_id
AND a.revenue_amount <> b.taxable_amount
AND EXISTS (
SELECT 'T'
FROM ar.ra_cust_trx_types_all rctt
WHERE rctt.post_to_gl = 'Y'
AND rctt.set_of_books_id = c.set_of_books_id
AND rctt.cust_trx_type_id = c.cust_trx_type_id
AND rctt.end_date IS NULL)
AND EXISTS (
SELECT 'T'
FROM ar.ra_cust_trx_line_gl_dist_all rctlg
WHERE rctlg.set_of_books_id = c.set_of_books_id
AND rctlg.customer_trx_id = c.customer_trx_id
AND rctlg.gl_date> = SYSDATE - 31)
Related Posts of How to validate a AR is correct?
-
The third part (20) Advanced Configuration of the single-source multi-directional replication environment (1)
This section we will copy the built environment a little bit more complex, so this is no longer copied between two databases, and coupled with the coming of a new database, synchronization of data between the three databases. I. Requirement Settings ...
-
Oracle to build table
Oracle to build table
-
SQL on the null data in the scheduling problem
We know, null as "unknown data." However, in order of time, Oracle will think that it is "infinite" to sort out on the "maximum" position. If you do not want this, you need to use the nvl function. Here are some small te ...
-
How to obtain the trace file name
Sql_trace/10046 such as when we use to carry out the process of tracking case, the trace file to generate. Trace file name from the following components: <sid> _ora_ <pid>. trc Users to track the following script file name: For Unix: For ...
-
Oracle Sysdba certification authority management
<br /> Outlined one at ORACLE has a special level of competence - sysdba authority, sysdba privileges ORACLE systems have the highest authority, has opened the database, turn off the database, restore database, such as advanced permissions, the ...
-
Detailed: database name. Instance name. ORACLE_SID. Database name
Detailed: database name, instance name, ORACLE_SID, database name, global database names, service names and hand the script to create oracle database Database name, instance name, database name, global database names, service names, This is easy for some
-
Oracle10g Network Configuration
1.Oracle Net Listener configuration listener configuration file is $ ORACLE_HOME / network / admin / listener.ora: The following format: (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = <IP/dbserver_name>) (PORT = 1521))) 2. Client <br /&g ...
-
LISTENER and EZCONNECT
listener =========================== Listener should be noted that there are two methods Register: Dynamic and Static Registration Registration Registration <br /> dynamic, that is, when the listener configuration, Do not need to configure stat ...
-
ProC will select the data on the two-dimensional array
Examples are as follows: (Over)
-
use sqlldr 1 Introduction
The customer is always asked for two days to a number of temporary table to import text data, sql * loader is also not very familiar with the FREE today to sum up. General to set up two files: Control files and data files, if the data can also be les ...
Leave a Reply