DBA Data[Home] [Help]

APPS.AR_INVOICE_UTILS dependencies on AR_PAYING_RELATIONSHIPS_V

Line 488: FROM ar_paying_relationships_v rel, hz_cust_accounts acc

484: SELECT to_number(gt.bill_to_customer_id)
485: FROM DUAL
486: UNION
487: SELECT acc.cust_account_id
488: FROM ar_paying_relationships_v rel, hz_cust_accounts acc
489: WHERE rel.party_id = acc.party_id
490: AND rel.related_cust_account_id = gt.bill_to_customer_id
491: AND gt.trx_date BETWEEN effective_start_date
492: AND effective_end_date)

Line 2458: FROM ar_paying_relationships_v rel,

2454: --select to_number(gt.bill_to_customer_id)
2455: --from dual
2456: UNION
2457: SELECT acc.cust_account_id
2458: FROM ar_paying_relationships_v rel,
2459: hz_cust_accounts acc
2460: WHERE rel.party_id = acc.party_id
2461: AND rel.related_cust_account_id = gt.bill_to_customer_id
2462: AND gt.trx_date BETWEEN effective_start_date