DBA Data[Home] [Help]

APPS.AR_RECEIPT_LIB_PVT dependencies on HZ_CUST_ACCT_RELATE

Line 3673: FROM hz_cust_acct_relate rcr

3669: AND ps.status=decode(p_show_closed_invoices,'Y',ps.status,'OP')
3670: AND ps.terms_sequence_number = p_installment
3671: AND ps.customer_id IN (
3672: SELECT rcr.related_cust_account_id
3673: FROM hz_cust_acct_relate rcr
3674: WHERE rcr.status='A' and
3675: rcr.cust_account_id= p_cr_customer_id
3676: and rcr.bill_to_flag = 'Y'
3677: UNION

Line 3848: FROM hz_cust_acct_relate rcr

3844: ot.status=decode(p_show_closed_invoices,'Y',ot.status,'OP') and
3845: ot.terms_sequence_number = p_installment and
3846: ot.customer_id IN (
3847: SELECT rcr.related_cust_account_id
3848: FROM hz_cust_acct_relate rcr
3849: WHERE rcr.status='A' and
3850: rcr.cust_account_id= p_cr_customer_id
3851: and rcr.bill_to_flag = 'Y'
3852: UNION