DBA Data[Home] [Help]

APPS.ARP_CORRECT_CC_ERRORS dependencies on RA_CUST_TRX_TYPES

Line 1864: ra_cust_trx_types trx_type

1860: trx.cc_error_code,
1861: trx.cc_error_text,
1862: trx.payment_server_order_num
1863: FROM ra_customer_trx trx,
1864: ra_cust_trx_types trx_type
1865: WHERE trx.cust_trx_type_id = trx_type.cust_trx_type_id
1866: AND trx.request_id = p_request_id
1867: AND trx.cc_error_flag = 'Y'
1868: AND cc_error_code IS NOT NULL;

Line 2108: ra_cust_trx_types trx_types

2104: cr.receipt_number
2105: FROM ra_customer_trx trx,
2106: ar_receivable_applications ra,
2107: ar_cash_receipts cr,
2108: ra_cust_trx_types trx_types
2109: WHERE trx.customer_trx_id = ra.applied_customer_trx_id
2110: AND ra.cash_receipt_id = cr.cash_receipt_id
2111: AND cr.customer_bank_account_id = trx.customer_bank_account_id
2112: AND cr.receipt_method_id = trx.receipt_method_id