DBA Data[Home] [Help]

APPS.AR_RECEIPT_LIB_PVT dependencies on AR_PAYING_RELATIONSHIPS_V

Line 3867: FROM ar_paying_relationships_v rel,

3863: SELECT p_cr_customer_id
3864: FROM dual
3865: UNION
3866: SELECT rel.related_cust_account_id
3867: FROM ar_paying_relationships_v rel,
3868: hz_cust_accounts acc
3869: WHERE rel.party_id = acc.party_id
3870: AND acc.cust_account_id = p_cr_customer_id
3871: AND p_cr_date BETWEEN effective_start_date

Line 4081: FROM ar_paying_relationships_v rel,

4077: FROM dual
4078: WHERE ot.customer_id = p_cr_customer_id
4079: UNION ALL
4080: SELECT /*+ no_unnest */ 'x'
4081: FROM ar_paying_relationships_v rel,
4082: hz_cust_accounts acc
4083: WHERE rel.party_id = acc.party_id
4084: AND acc.cust_account_id = p_cr_customer_id
4085: AND p_cr_date BETWEEN effective_start_date