[Home] [Help]
1150: fnd_territories_tl fnd_terr,
1151: hz_cust_site_uses_all site_uses,
1152: hz_customer_profiles prf,
1153: ar_collectors ac,
1154: GL_SETS_OF_BOOKS gl,
1155: AR_SYSTEM_PARAMETERS_all sys,
1156: -- Added for the bug#8538945 by PNAVEENK
1157: HZ_CUST_ACCT_SITES_all ACCT_SITE,--Modified for Bug 9487600 23-Mar-2010 barathsr
1158: HZ_PARTY_SITES PARTY_SITE,
1288: MAX(trx_summ.creation_date) creation_date,
1289: MAX(trx_summ.created_by) created_by,
1290: MAX(trx_summ.last_update_login) last_update_login
1291: FROM ar_trx_bal_summary trx_summ,
1292: GL_SETS_OF_BOOKS gl,
1293: AR_SYSTEM_PARAMETERS_all sys,
1294: jtf_objects_b objb,
1295: hz_cust_accounts acc,
1296: hz_party_preferences party_pref
1494: summ.last_payment_amount last_payment_amount,
1495: summ.currency last_payment_currency,
1496: summ.last_payment_number last_payment_number
1497: from ar_trx_bal_summary summ,
1498: gl_sets_of_books gl,
1499: ar_system_parameters_all sys
1500: where summ.reference_1='1'
1501: and gl.SET_OF_BOOKS_ID = sys.SET_OF_BOOKS_ID
1502: and summ.org_id = sys.org_id
1768: fnd_territories_tl fnd_terr,
1769: hz_cust_site_uses_all site_uses,
1770: hz_customer_profiles prf,
1771: ar_collectors ac,
1772: GL_SETS_OF_BOOKS gl,
1773: AR_SYSTEM_PARAMETERS_all sys,
1774: -- Added for the bug#8538945 by PNAVEENK
1775: HZ_CUST_ACCT_SITES_all ACCT_SITE,--Modified for Bug 9487600 23-Mar-2010 barathsr
1776: HZ_PARTY_SITES PARTY_SITE,
1912: MAX(trx_summ.creation_date) creation_date,
1913: MAX(trx_summ.created_by) created_by,
1914: MAX(trx_summ.last_update_login) last_update_login
1915: FROM ar_trx_bal_summary trx_summ,
1916: GL_SETS_OF_BOOKS gl,
1917: AR_SYSTEM_PARAMETERS_all sys,
1918: jtf_objects_b objb,
1919: hz_cust_accounts acc,
1920: hz_party_preferences party_pref
2152: summ.last_payment_amount last_payment_amount,
2153: summ.currency last_payment_currency,
2154: summ.last_payment_number last_payment_number
2155: from ar_trx_bal_summary summ,
2156: gl_sets_of_books gl,
2157: ar_system_parameters_all sys
2158: where summ.reference_1='1'
2159: and gl.SET_OF_BOOKS_ID = sys.SET_OF_BOOKS_ID
2160: and summ.org_id = sys.org_id
2421: hz_contact_points phone,
2422: fnd_territories_tl fnd_terr,
2423: hz_customer_profiles prf,
2424: ar_collectors ac,
2425: GL_SETS_OF_BOOKS gl,
2426: AR_SYSTEM_PARAMETERS_all sys
2427: WHERE
2428: P_MODE = 'CP'
2429: AND trx_summ.reference_1 = '1'
2543: FROM ar_trx_bal_summary trx_summ,
2544: hz_cust_accounts acc,
2545: hz_party_preferences party_pref,--Added for Bug 8707923 27-Jul-2009 barathsr
2546: jtf_objects_b objb,
2547: GL_SETS_OF_BOOKS gl,
2548: AR_SYSTEM_PARAMETERS_all sys
2549: WHERE
2550: P_MODE = 'CP'
2551: AND trx_summ.reference_1 = '1'
2738: summ.last_payment_amount last_payment_amount,
2739: summ.currency last_payment_currency,
2740: summ.last_payment_number last_payment_number
2741: from ar_trx_bal_summary summ,
2742: gl_sets_of_books gl,
2743: ar_system_parameters_all sys
2744: where gl.SET_OF_BOOKS_ID = sys.SET_OF_BOOKS_ID
2745: and summ.org_id = sys.org_id
2746: and summ.last_payment_date=(select max(dln.last_payment_date)
3003: hz_contact_points phone,
3004: fnd_territories_tl fnd_terr,
3005: hz_customer_profiles prf,
3006: ar_collectors ac,
3007: GL_SETS_OF_BOOKS gl,
3008: AR_SYSTEM_PARAMETERS_all sys
3009:
3010: WHERE
3011: trx_summ.reference_1 = '1'
3135: FROM ar_trx_bal_summary trx_summ,
3136: hz_cust_accounts acc,
3137: hz_party_preferences party_pref,--Added for Bug 8707923 27-Jul-2009 barathsr
3138: jtf_objects_b objb,
3139: GL_SETS_OF_BOOKS gl,
3140: AR_SYSTEM_PARAMETERS_all sys
3141: WHERE
3142: P_MODE = 'CP'
3143: AND trx_summ.reference_1 = '1'
3363: summ.last_payment_amount last_payment_amount,
3364: summ.currency last_payment_currency,
3365: summ.last_payment_number last_payment_number
3366: from ar_trx_bal_summary summ,
3367: gl_sets_of_books gl,
3368: ar_system_parameters_all sys
3369: where gl.SET_OF_BOOKS_ID = sys.SET_OF_BOOKS_ID
3370: and summ.org_id = sys.org_id
3371: and summ.last_payment_date=(select max(dln.last_payment_date)
3616: hz_contact_points phone,
3617: fnd_territories_tl fnd_terr,
3618: hz_customer_profiles prf,
3619: ar_collectors ac,
3620: GL_SETS_OF_BOOKS gl,
3621: AR_SYSTEM_PARAMETERS_all sys
3622:
3623: WHERE
3624: P_MODE = 'CP'
3742: hz_cust_accounts acc,
3743: hz_parties party,
3744: hz_party_preferences party_pref,--Added for Bug 8707923 27-Jul-2009 barathsr
3745: jtf_objects_b objb,
3746: GL_SETS_OF_BOOKS gl,
3747: AR_SYSTEM_PARAMETERS_all sys
3748:
3749: WHERE
3750: P_MODE = 'CP'
3941: summ.currency last_payment_currency,
3942: summ.last_payment_number last_payment_number
3943: from ar_trx_bal_summary summ,
3944: hz_cust_accounts hca,
3945: gl_sets_of_books gl,
3946: ar_system_parameters_all sys
3947: where summ.cust_account_id=hca.cust_account_id
3948: and gl.SET_OF_BOOKS_ID = sys.SET_OF_BOOKS_ID
3949: and summ.org_id = sys.org_id
4194: hz_contact_points phone,
4195: fnd_territories_tl fnd_terr,
4196: hz_customer_profiles prf,
4197: ar_collectors ac,
4198: GL_SETS_OF_BOOKS gl,
4199: AR_SYSTEM_PARAMETERS_all sys
4200: WHERE trx_summ.reference_1 = '1'
4201: AND trx_summ.cust_account_id = acc.cust_account_id
4202: AND acc.party_id = party.party_id
4324: hz_cust_accounts acc,
4325: hz_parties party,
4326: hz_party_preferences party_pref,--Added for Bug 8707923 27-Jul-2009 barathsr
4327: jtf_objects_b objb,
4328: GL_SETS_OF_BOOKS gl,
4329: AR_SYSTEM_PARAMETERS_all sys
4330:
4331: WHERE
4332: P_MODE = 'CP'
4563: summ.currency last_payment_currency,
4564: summ.last_payment_number last_payment_number
4565: from ar_trx_bal_summary summ,
4566: hz_cust_accounts hca,
4567: gl_sets_of_books gl,
4568: ar_system_parameters_all sys
4569: where summ.cust_account_id=hca.cust_account_id
4570: and gl.SET_OF_BOOKS_ID = sys.SET_OF_BOOKS_ID
4571: and summ.org_id = sys.org_id
9624: hz_parties party,
9625: jtf_objects_b objb,
9626: fnd_territories_tl fnd_terr,
9627: hz_cust_site_uses_all site_uses,
9628: GL_SETS_OF_BOOKS gl,
9629: AR_SYSTEM_PARAMETERS_all sys,
9630: -- Added for the bug#8538945 by PNAVEENK
9631: HZ_CUST_ACCT_SITES_all ACCT_SITE,--Modified for Bug 9487600 23-Mar-2010 barathsr
9632: HZ_PARTY_SITES PARTY_SITE,
9891: FROM iex_promise_details pd,
9892: iex_delinquencies_all del,
9893: iex_pop_uwq_summ_gt temp,
9894: ar_system_parameters_all sys ,
9895: gl_sets_of_books gl
9896: WHERE pd.cust_account_id = del.cust_account_id
9897: AND pd.delinquency_id = del.delinquency_id
9898: AND pd.status IN('COLLECTABLE', 'PENDING')
9899: AND pd.state = 'BROKEN_PROMISE'
10971: hz_cust_accounts acc,
10972: hz_parties party,
10973: jtf_objects_b objb,
10974: fnd_territories_tl fnd_terr,
10975: GL_SETS_OF_BOOKS gl,
10976: AR_SYSTEM_PARAMETERS_all sys
10977: WHERE
10978: trx_summ.reference_1 = '1'
10979: AND trx_summ.cust_account_id = acc.cust_account_id
11218: FROM iex_promise_details pd,
11219: iex_delinquencies_all del,
11220: iex_pop_uwq_summ_gt temp,
11221: ar_system_parameters_all sys ,
11222: gl_sets_of_books gl
11223: WHERE pd.cust_account_id = del.cust_account_id
11224: AND pd.delinquency_id = del.delinquency_id
11225: AND pd.status IN('COLLECTABLE', 'PENDING')
11226: AND pd.state = 'BROKEN_PROMISE'
12288: hz_cust_accounts acc,
12289: hz_parties party,
12290: jtf_objects_b objb,
12291: fnd_territories_tl fnd_terr,
12292: GL_SETS_OF_BOOKS gl,
12293: AR_SYSTEM_PARAMETERS_all sys
12294: WHERE trx_summ.reference_1 = '1'
12295: AND trx_summ.cust_account_id = acc.cust_account_id
12296: AND acc.party_id = party.party_id
12528: FROM iex_promise_details pd,
12529: iex_delinquencies_all del,
12530: iex_pop_uwq_summ_gt temp,
12531: ar_system_parameters_all sys ,
12532: gl_sets_of_books gl
12533: WHERE pd.cust_account_id = del.cust_account_id
12534: AND pd.delinquency_id = del.delinquency_id
12535: AND pd.status IN('COLLECTABLE','PENDING')
12536: AND pd.state = 'BROKEN_PROMISE'