[Home] [Help]
76: AND app.rowid <= p_end_rowid
77: AND ars.accounting_method = 'CASH'
78: AND NOT EXISTS (SELECT '1'
79: FROM psa_trx_types_all psa,
80: ra_customer_trx_all inv
81: WHERE inv.customer_trx_id = app.applied_customer_trx_id
82: AND inv.cust_trx_type_id = psa.psa_trx_type_id)
83: ORDER BY app.org_id;
84:
332: AND rowid <= l_end_rowid
333: GROUP BY applied_customer_trx_id,
334: org_id ) app,
335: ar_system_parameters_all ars,
336: ra_customer_trx_all trx,
337: ra_customer_trx_lines_all ctl,
338: ra_cust_trx_line_gl_dist_all ctlgd
339: WHERE ars.accounting_method = 'CASH'
340: AND app.org_id = ars.org_id
345: AND ctlgd.account_class IN ('REV','SUSPENSE','UNBILL','UNEARN','FREIGHT','TAX')
346: AND ctlgd.account_set_flag = 'N'
347: AND NOT EXISTS (SELECT '1'
348: FROM psa_trx_types_all psa,
349: ra_customer_trx_all inv
350: WHERE inv.customer_trx_id = app.applied_customer_trx_id
351: AND inv.cust_trx_type_id = psa.psa_trx_type_id);
352:
353:
855: AND app.customer_trx_id IS NOT NULL
856: AND app.cash_receipt_id IS NULL
857: AND NOT EXISTS (SELECT '1'
858: FROM psa_trx_types_all psa,
859: ra_customer_trx_all inv
860: WHERE inv.customer_trx_id = app.customer_trx_id
861: AND inv.cust_trx_type_id = psa.psa_trx_type_id)
862: ORDER BY app.org_id;
863:
1113: AND rowid <= l_end_rowid
1114: GROUP BY customer_trx_id,
1115: org_id ) app,
1116: ar_system_parameters_all ars,
1117: ra_customer_trx_all trx,
1118: ra_customer_trx_lines_all ctl,
1119: ra_cust_trx_line_gl_dist_all ctlgd
1120: WHERE ars.accounting_method = 'CASH'
1121: AND app.org_id = ars.org_id
1126: AND ctlgd.account_class IN ('REV','SUSPENSE','UNBILL','UNEARN','FREIGHT','TAX')
1127: AND ctlgd.account_set_flag = 'N'
1128: AND NOT EXISTS (SELECT '1'
1129: FROM psa_trx_types_all psa,
1130: ra_customer_trx_all inv
1131: WHERE inv.customer_trx_id = app.customer_trx_id
1132: AND inv.cust_trx_type_id = psa.psa_trx_type_id);
1133:
1134: