DBA Data[Home] [Help]

APPS.AR_RECEIPT_LIB_PVT dependencies on HZ_CUST_ACCT_RELATE

Line 3858: FROM hz_cust_acct_relate rcr

3854: AND ps.status=decode(p_show_closed_invoices,'Y',ps.status,'OP')
3855: AND ps.terms_sequence_number = p_installment
3856: AND ps.customer_id IN (
3857: SELECT rcr.related_cust_account_id
3858: FROM hz_cust_acct_relate rcr
3859: WHERE rcr.status='A' and
3860: rcr.cust_account_id= p_cr_customer_id
3861: and rcr.bill_to_flag = 'Y'
3862: UNION

Line 4070: FROM hz_cust_acct_relate rcr

4066: exists
4067: -- Fix for bug 12635079
4068: --SELECT rcr.related_cust_account_id
4069: (SELECT /*+ no_unnest */ 'x'
4070: FROM hz_cust_acct_relate rcr
4071: WHERE rcr.status='A' and
4072: rcr.cust_account_id= p_cr_customer_id
4073: and rcr.bill_to_flag = 'Y'
4074: and ot.customer_id = rcr.related_cust_account_id