DBA Data[Home] [Help]

APPS.ARP_ACCT_MAIN dependencies on RA_CUSTOMER_TRX

Line 630: RA_CUSTOMER_TRX trx

626: trx.customer_trx_id,
627: il.org_id
628: FROM RA_INTERFACE_LINES_GT il,
629: AR_ADJUSTMENTS adj,
630: RA_CUSTOMER_TRX trx
631: WHERE il.request_id = p_request_id
632: AND nvl(il.interface_status, '~') <> 'P'
633: AND il.customer_trx_id = trx.customer_trx_id
634: AND nvl(adj.subsequent_trx_id, adj.customer_trx_id) = trx.customer_trx_id

Line 649: RA_CUSTOMER_TRX trx

645: arp_standard.fnd_message(p_message_code),
646: trx.customer_trx_id,
647: il.org_id
648: FROM RA_INTERFACE_LINES_GT il,
649: RA_CUSTOMER_TRX trx
650: WHERE il.request_id = p_request_id
651: AND nvl(il.interface_status, '~') <> 'P'
652: AND il.customer_trx_id = trx.customer_trx_id
653: AND trx.customer_trx_id = p_document_id;

Line 699: RA_CUSTOMER_TRX trx

695: CURSOR get_cm_info (p_request_id IN number) IS
696: select rec.customer_trx_id customer_trx_id,
697: rec.receivable_application_id rec_app_id
698: from AR_RECEIVABLE_APPLICATIONS rec,
699: RA_CUSTOMER_TRX trx
700: where trx.customer_trx_id = rec.customer_trx_id
701: and trx.request_id = p_request_id;
702:
703: CURSOR get_adj_info (p_request_id IN number) IS