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.ARP_AUTOAPPLY_API dependencies on AR_PAYING_RELATIONSHIPS_V

Line 1267: FROM ar_paying_relationships_v rel,

1263: AND rel.status = 'A'
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

Line 1513: FROM ar_paying_relationships_v rel,

1509: AND rel.status = 'A'
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

Line 1758: FROM ar_paying_relationships_v rel,

1754: AND rel.status = 'A'
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

Line 2002: FROM ar_paying_relationships_v rel,

1998: AND rel.status = 'A'
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

Line 2247: FROM ar_paying_relationships_v rel,

2243: AND rel.status = ''A''
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

Line 2506: FROM ar_paying_relationships_v rel,

2502: AND rel.status = 'A'
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

Line 2727: FROM ar_paying_relationships_v rel,

2723: AND rel.status = 'A'
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

Line 2975: FROM ar_paying_relationships_v rel,

2971: AND rel.status = 'A'
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