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 HZ_CUST_ACCT_RELATE_ALL

Line 1260: FROM hz_cust_acct_relate_all rel

1256: NVL(cr.pay_from_customer, ps.customer_id))
1257: FROM DUAL
1258: UNION ALL
1259: SELECT related_cust_account_id
1260: FROM hz_cust_acct_relate_all rel
1261: WHERE rel.cust_account_id = cr.pay_from_customer
1262: AND rel.bill_to_flag = 'Y'
1263: AND rel.status = 'A'
1264: AND ARP_STANDARD.sysparm.pay_unrelated_invoices_flag <> 'Y'

Line 1506: FROM hz_cust_acct_relate_all rel

1502: NVL(cr.pay_from_customer, ps.customer_id))
1503: FROM DUAL
1504: UNION ALL
1505: SELECT related_cust_account_id
1506: FROM hz_cust_acct_relate_all rel
1507: WHERE rel.cust_account_id = cr.pay_from_customer
1508: AND rel.bill_to_flag = 'Y'
1509: AND rel.status = 'A'
1510: AND ARP_STANDARD.sysparm.pay_unrelated_invoices_flag <> 'Y'

Line 1751: FROM hz_cust_acct_relate_all rel

1747: NVL(cr.pay_from_customer, ps.customer_id))
1748: FROM DUAL
1749: UNION ALL
1750: SELECT related_cust_account_id
1751: FROM hz_cust_acct_relate_all rel
1752: WHERE rel.cust_account_id = cr.pay_from_customer
1753: AND rel.bill_to_flag = 'Y'
1754: AND rel.status = 'A'
1755: AND ARP_STANDARD.sysparm.pay_unrelated_invoices_flag <> 'Y'

Line 1995: FROM hz_cust_acct_relate_all rel

1991: NVL(cr.pay_from_customer, ps.customer_id))
1992: FROM DUAL
1993: UNION ALL
1994: SELECT related_cust_account_id
1995: FROM hz_cust_acct_relate_all rel
1996: WHERE rel.cust_account_id = cr.pay_from_customer
1997: AND rel.bill_to_flag = 'Y'
1998: AND rel.status = 'A'
1999: AND ARP_STANDARD.sysparm.pay_unrelated_invoices_flag <> 'Y'

Line 2240: FROM hz_cust_acct_relate_all rel

2236: NVL(cr.pay_from_customer, ps.customer_id))
2237: FROM DUAL
2238: UNION ALL
2239: SELECT related_cust_account_id
2240: FROM hz_cust_acct_relate_all rel
2241: WHERE rel.cust_account_id = cr.pay_from_customer
2242: AND rel.bill_to_flag = ''Y''
2243: AND rel.status = ''A''
2244: AND :b_pay_unrelated_invoices_flag <> ''Y''

Line 2499: FROM hz_cust_acct_relate_all rel

2495: NVL(cr.pay_from_customer, ps.customer_id))
2496: FROM DUAL
2497: UNION ALL
2498: SELECT related_cust_account_id
2499: FROM hz_cust_acct_relate_all rel
2500: WHERE rel.cust_account_id = cr.pay_from_customer
2501: AND rel.bill_to_flag = 'Y'
2502: AND rel.status = 'A'
2503: AND ARP_STANDARD.sysparm.pay_unrelated_invoices_flag <> 'Y'

Line 2720: FROM hz_cust_acct_relate_all rel

2716: NVL(cr.pay_from_customer, ps.customer_id))
2717: FROM DUAL
2718: UNION ALL
2719: SELECT related_cust_account_id
2720: FROM hz_cust_acct_relate_all rel
2721: WHERE rel.cust_account_id = cr.pay_from_customer
2722: AND rel.bill_to_flag = 'Y'
2723: AND rel.status = 'A'
2724: AND ARP_STANDARD.sysparm.pay_unrelated_invoices_flag <> 'Y'

Line 2968: FROM hz_cust_acct_relate_all rel

2964: NVL(cr.pay_from_customer, ps.customer_id))
2965: FROM DUAL
2966: UNION ALL
2967: SELECT related_cust_account_id
2968: FROM hz_cust_acct_relate_all rel
2969: WHERE rel.cust_account_id = cr.pay_from_customer
2970: AND rel.bill_to_flag = 'Y'
2971: AND rel.status = 'A'
2972: AND ARP_STANDARD.sysparm.pay_unrelated_invoices_flag <> 'Y'