DBA Data[Home] [Help]

APPS.AR_INVOICE_UTILS dependencies on AR_PAYING_RELATIONSHIPS_V

Line 495: FROM ar_paying_relationships_v rel, hz_cust_accounts acc

491: SELECT to_number(gt.bill_to_customer_id)
492: FROM DUAL
493: UNION
494: SELECT acc.cust_account_id
495: FROM ar_paying_relationships_v rel, hz_cust_accounts acc
496: WHERE rel.party_id = acc.party_id
497: AND rel.related_cust_account_id = gt.bill_to_customer_id
498: AND gt.trx_date BETWEEN effective_start_date
499: AND effective_end_date)

Line 2535: FROM ar_paying_relationships_v rel,

2531: --select to_number(gt.bill_to_customer_id)
2532: --from dual
2533: UNION
2534: SELECT acc.cust_account_id
2535: FROM ar_paying_relationships_v rel,
2536: hz_cust_accounts acc
2537: WHERE rel.party_id = acc.party_id
2538: AND rel.related_cust_account_id = gt.bill_to_customer_id
2539: AND gt.trx_date BETWEEN effective_start_date