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.

[Home] [Help]

APPS.ARP_AUTOAPPLY_API dependencies on HZ_CUST_ACCOUNTS

Line 697: l_from_clause := l_from_clause || ' , HZ_CUST_ACCOUNTS cust ';

693: l_where_clause := l_where_clause || ' AND bat.batch_id = crh.batch_id
694: AND crh.cash_receipt_id = ref.cash_receipt_id ';
695: END IF;
696: IF l_use_cust = 'Y' THEN
697: l_from_clause := l_from_clause || ' , HZ_CUST_ACCOUNTS cust ';
698: l_where_clause := l_where_clause || ' AND cust.cust_account_id = NVL(ref.customer_id, cr.pay_from_customer)';
699: END IF;
700: IF l_use_party = 'Y' THEN
701: IF l_use_cust = 'Y' THEN

Line 706: l_from_clause := l_from_clause || ' , HZ_CUST_ACCOUNTS cust

702: l_from_clause := l_from_clause || ' , HZ_PARTIES party ';
703: l_where_clause := l_where_clause ||
704: 'AND party.party_id = cust.party_id ';
705: ELSE
706: l_from_clause := l_from_clause || ' , HZ_CUST_ACCOUNTS cust
707: , HZ_PARTIES party ';
708: l_where_clause := l_where_clause ||
709: ' AND party.party_id = cust.party_id
710: AND cust.cust_account_id = NVL(ref.customer_id, cr.pay_from_customer)';

Line 1268: hz_cust_accounts acc

1264: AND ARP_STANDARD.sysparm.pay_unrelated_invoices_flag <> 'Y'
1265: UNION ALL
1266: SELECT rel.related_cust_account_id
1267: FROM ar_paying_relationships_v rel,
1268: hz_cust_accounts acc
1269: WHERE acc.cust_account_id = cr.pay_from_customer
1270: AND acc.party_id = rel.party_id
1271: AND cr.receipt_date >= effective_start_date
1272: AND cr.receipt_date <= effective_end_date

Line 1514: hz_cust_accounts acc

1510: AND ARP_STANDARD.sysparm.pay_unrelated_invoices_flag <> 'Y'
1511: UNION ALL
1512: SELECT rel.related_cust_account_id
1513: FROM ar_paying_relationships_v rel,
1514: hz_cust_accounts acc
1515: WHERE acc.cust_account_id = cr.pay_from_customer
1516: AND acc.party_id = rel.party_id
1517: AND cr.receipt_date >= effective_start_date
1518: AND cr.receipt_date <= effective_end_date

Line 1759: hz_cust_accounts acc

1755: AND ARP_STANDARD.sysparm.pay_unrelated_invoices_flag <> 'Y'
1756: UNION ALL
1757: SELECT rel.related_cust_account_id
1758: FROM ar_paying_relationships_v rel,
1759: hz_cust_accounts acc
1760: WHERE acc.cust_account_id = cr.pay_from_customer
1761: AND acc.party_id = rel.party_id
1762: AND cr.receipt_date >= effective_start_date
1763: AND cr.receipt_date <= effective_end_date

Line 2003: hz_cust_accounts acc

1999: AND ARP_STANDARD.sysparm.pay_unrelated_invoices_flag <> 'Y'
2000: UNION ALL
2001: SELECT rel.related_cust_account_id
2002: FROM ar_paying_relationships_v rel,
2003: hz_cust_accounts acc
2004: WHERE acc.cust_account_id = cr.pay_from_customer
2005: AND acc.party_id = rel.party_id
2006: AND cr.receipt_date >= effective_start_date
2007: AND cr.receipt_date <= effective_end_date

Line 2248: hz_cust_accounts acc

2244: AND :b_pay_unrelated_invoices_flag <> ''Y''
2245: UNION ALL
2246: SELECT rel.related_cust_account_id
2247: FROM ar_paying_relationships_v rel,
2248: hz_cust_accounts acc
2249: WHERE acc.cust_account_id = cr.pay_from_customer
2250: AND acc.party_id = rel.party_id
2251: AND cr.receipt_date >= effective_start_date
2252: AND cr.receipt_date <= effective_end_date

Line 2507: hz_cust_accounts acc

2503: AND ARP_STANDARD.sysparm.pay_unrelated_invoices_flag <> 'Y'
2504: UNION ALL
2505: SELECT rel.related_cust_account_id
2506: FROM ar_paying_relationships_v rel,
2507: hz_cust_accounts acc
2508: WHERE acc.cust_account_id = cr.pay_from_customer
2509: AND acc.party_id = rel.party_id
2510: AND cr.receipt_date >= effective_start_date
2511: AND cr.receipt_date <= effective_end_date

Line 2728: hz_cust_accounts acc

2724: AND ARP_STANDARD.sysparm.pay_unrelated_invoices_flag <> 'Y'
2725: UNION ALL
2726: SELECT rel.related_cust_account_id
2727: FROM ar_paying_relationships_v rel,
2728: hz_cust_accounts acc
2729: WHERE acc.cust_account_id = cr.pay_from_customer
2730: AND acc.party_id = rel.party_id
2731: AND cr.receipt_date >= effective_start_date
2732: AND cr.receipt_date <= effective_end_date

Line 2976: hz_cust_accounts acc

2972: AND ARP_STANDARD.sysparm.pay_unrelated_invoices_flag <> 'Y'
2973: UNION ALL
2974: SELECT rel.related_cust_account_id
2975: FROM ar_paying_relationships_v rel,
2976: hz_cust_accounts acc
2977: WHERE acc.cust_account_id = cr.pay_from_customer
2978: AND acc.party_id = rel.party_id
2979: AND cr.receipt_date >= effective_start_date
2980: AND cr.receipt_date <= effective_end_date

Line 4589: , hz_cust_accounts cust_acct

4585: INTO l_grace_days
4586: FROM
4587: hz_customer_profiles cust
4588: , hz_customer_profiles site
4589: , hz_cust_accounts cust_acct
4590: WHERE
4591: cust_acct.cust_account_id = l_customer_id
4592: AND cust.cust_account_id = cust_acct.cust_account_id
4593: AND cust.site_use_id IS NULL