DBA Data[Home] [Help]

APPS.ARP_PROCESS_RCTS dependencies on RA_CUSTOMER_TRX

Line 793: FROM RA_CUSTOMER_TRX

789: ELSIF (p_reference_type = 'CREDIT_MEMO') THEN
790:
791: SELECT trx_number
792: INTO p_reference_id_dsp
793: FROM RA_CUSTOMER_TRX
794: WHERE customer_trx_id = p_reference_id;
795:
796: END IF;
797:

Line 1071: ra_customer_trx ct_dm,

1067: p_debit_memo_type,
1068: p_debit_memo_number,
1069: p_debit_memo_doc_number
1070: from ra_cust_trx_types ctt_dm,
1071: ra_customer_trx ct_dm,
1072: ra_cust_trx_line_gl_dist dm_gld
1073: where ct_dm.reversed_cash_receipt_id = p_cr_id
1074: and ct_dm.cust_trx_type_id = ctt_dm.cust_trx_type_id
1075: and ct_dm.customer_trx_id = dm_gld.customer_trx_id