DBA Data[Home] [Help]

APPS.JAI_CMN_RGM_RECORDING_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 456: , ra_customer_trx_all trx

452: SELECT trx_types.type
453: FROM
454: jai_ar_trx_tax_lines jattl --Added by Qiong for bug14253668
455: , ra_customer_trx_lines_all trxl
456: , ra_customer_trx_all trx
457: , ra_cust_trx_types_all trx_types
458: WHERE trxl.customer_trx_id = trx.customer_trx_id
459: AND trx_types.cust_trx_type_id = trx.cust_trx_type_id
460: AND jattl.link_to_cust_trx_line_id = trxl.customer_trx_line_id --Added by Qiong for bug14253668

Line 1304: FROM RA_customer_trx_all

1300: WHERE RECEIVABLE_APPLICATION_ID = p_source_document_id;
1301:
1302: CURSOR get_ar_trx_num(c_customer_trx_id NUMBER) IS
1303: SELECT trx_number
1304: FROM RA_customer_trx_all
1305: WHERE customer_trx_id = c_customer_trx_id;
1306: ln_cash_receipt_id NUMBER;
1307: ln_customer_trx_id NUMBER;
1308: --Added by Wenqiong end