eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_CMGT_DATA_POINTS_PKG dependencies on HZ_CUST_ACCOUNTS

Line 269: FROM hz_cust_accounts

265: AND claim_class = 'DEDUCTION'
266: AND settled_date >= ADD_MONTHS(sysdate,(-p_period))
267: AND cust_account_id IN (
268: select TO_NUMBER(cust_account_id) -- Fix for Bug 12670874
269: FROM hz_cust_accounts
270: WHERE party_id in
271: ( SELECT child_id
272: from hz_hierarchy_nodes
273: where parent_object_type = 'ORGANIZATION'

Line 491: FROM hz_cust_accounts

487: largest_inv_cust_trx_id desc) rank_amount
488: FROM AR_TRX_SUMMARY
489: where cust_account_id in (
490: select to_number(cust_account_id)
491: FROM hz_cust_accounts
492: WHERE party_id in
493: ( SELECT child_id
494: from hz_hierarchy_nodes
495: where parent_object_type = ''ORGANIZATION''

Line 573: FROM hz_cust_accounts

569: largest_inv_cust_trx_id desc) high_amount
570: FROM AR_TRX_SUMMARY
571: where cust_account_id in (
572: select to_number(cust_account_id)
573: FROM hz_cust_accounts
574: WHERE party_id in
575: ( SELECT child_id
576: from hz_hierarchy_nodes
577: where parent_object_type = ''ORGANIZATION''

Line 762: FROM hz_cust_accounts

758: WHERE op_bal_high_watermark IS NOT NULL
759: AND as_of_date >= ADD_MONTHS(sysdate,(-p_period))
760: AND cust_account_id IN (
761: SELECT TO_NUMBER(cust_account_id) -- Fix for Bug 12670874
762: FROM hz_cust_accounts
763: WHERE party_id in
764: ( SELECT child_id
765: FROM hz_hierarchy_nodes
766: WHERE parent_object_type = 'ORGANIZATION'

Line 886: FROM hz_cust_accounts

882: INTO l_last_payment_amount, l_last_payment_date,
883: l_last_payment_number, l_last_payment_currency
884: FROM AR_TRX_BAL_SUMMARY
885: WHERE cust_account_id in (select TO_NUMBER(cust_account_id) -- Fix for Bug 12670874
886: FROM hz_cust_accounts
887: WHERE party_id in
888: ( SELECT child_id
889: from hz_hierarchy_nodes
890: where parent_object_type = 'ORGANIZATION'

Line 919: FROM hz_cust_accounts

915: and last_payment_date = ( select max(last_payment_date) from
916: ar_trx_bal_summary
917: where cust_account_id in
918: (select TO_NUMBER(cust_account_id) -- Fix for Bug 12670874
919: FROM hz_cust_accounts
920: WHERE party_id in
921: ( SELECT child_id
922: from hz_hierarchy_nodes
923: where parent_object_type = 'ORGANIZATION'

Line 1137: FROM hz_cust_accounts

1133: FROM ar_correspondences_all
1134: WHERE correspondence_type = 'DUNNING'
1135: AND customer_id in (
1136: select TO_NUMBER(cust_account_id) -- Fix for Bug 12670874
1137: FROM hz_cust_accounts
1138: WHERE party_id in
1139: ( SELECT child_id
1140: from hz_hierarchy_nodes
1141: where parent_object_type = 'ORGANIZATION'

Line 4869: FROM hz_cust_accounts

4865: SUM(NVL(TOTAL_DEPOSITS_VALUE,0))),2) total_deposits_value,
4866: SUM(NVL(TOTAL_deposits_COUNT,0)) TOTAL_deposits_count
4867: FROM AR_TRX_SUMMARY
4868: WHERE CUST_ACCOUNT_ID in (select TO_NUMBER(cust_account_id) -- Fix for Bug 12670874
4869: FROM hz_cust_accounts
4870: WHERE party_id in
4871: ( SELECT child_id
4872: from hz_hierarchy_nodes
4873: where parent_object_type = 'ORGANIZATION'

Line 5241: FROM hz_cust_accounts

5237: SUM(nvl(op_invoices_value,0) - nvl(past_due_inv_value,0))) current_invoice_value,
5238: SUM(nvl(op_invoices_count,0) - nvl(past_due_inv_inst_count,0)) current_invoice_count
5239: FROM AR_TRX_BAL_SUMMARY
5240: WHERE cust_account_id in (select TO_NUMBER(cust_account_id) -- Fix for Bug 12670874
5241: FROM hz_cust_accounts
5242: WHERE party_id in
5243: ( SELECT child_id
5244: from hz_hierarchy_nodes
5245: where parent_object_type = 'ORGANIZATION'

Line 5495: FROM hz_cust_accounts

5491: nvl(OP_CHARGEBACK_VALUE,0) + nvl(OP_CREDIT_MEMOS_VALUE,0)
5492: - nvl(BEST_CURRENT_RECEIVABLES,0))*l_certified_dso_days)) delinquent_dso
5493: FROM ar_trx_bal_summary
5494: WHERE cust_account_id in (select TO_NUMBER(cust_account_id) -- Fix for Bug 12670874
5495: FROM hz_cust_accounts
5496: WHERE party_id in
5497: ( SELECT child_id
5498: from hz_hierarchy_nodes
5499: where parent_object_type = 'ORGANIZATION'

Line 5599: FROM hz_cust_accounts

5595: nvl(TOTAL_ADJUSTMENTS_VALUE,0)
5596: )))) delinquent_dso
5597: FROM ar_trx_summary
5598: WHERE cust_account_id in (select TO_NUMBER(cust_account_id) -- Fix for Bug 12670874
5599: FROM hz_cust_accounts
5600: WHERE party_id in
5601: ( SELECT child_id
5602: from hz_hierarchy_nodes
5603: where parent_object_type = 'ORGANIZATION'

Line 5698: FROM hz_cust_accounts_all

5694: CURSOR c_party_currencies IS
5695: SELECT distinct currency
5696: FROM ar_trx_bal_summary
5697: WHERE cust_account_id IN (SELECT cust_account_id
5698: FROM hz_cust_accounts_all
5699: WHERE party_id = p_party_id
5700: AND status = 'A');
5701:
5702: CURSOR c_checklist_currency_def IS

Line 6283: FROM hz_cust_accounts

6279: INTO l_wadpl,
6280: l_apd
6281: FROM ar_trx_summary
6282: WHERE CUST_ACCOUNT_ID in (select TO_NUMBER(cust_account_id) -- Fix for Bug 12670874
6283: FROM hz_cust_accounts
6284: WHERE party_id in
6285: ( SELECT child_id
6286: from hz_hierarchy_nodes
6287: where parent_object_type = 'ORGANIZATION'