DBA Data[Home] [Help]

APPS.IGI_EXP_UTILS dependencies on RA_CUSTOMER_TRX_ALL

Line 263: FROM ra_customer_trx_all trx

259: , ctt.accounting_affect_flag
260: , ctt.creation_sign
261: , ctt.allow_overapplication_flag
262: , ctt.natural_application_only_flag
263: FROM ra_customer_trx_all trx
264: , ra_cust_trx_types_all ctt
265: WHERE trx.customer_trx_id = p_trx_id
266: AND trx.cust_trx_type_id = ctt.cust_trx_type_id
267: AND trx.org_id = ctt.org_id;

Line 281: FROM ra_customer_trx_all trx

277:
278: CURSOR c_get_prev_trx_info(p_trx_id RA_CUSTOMER_TRX.CUSTOMER_TRX_ID%TYPE)
279: IS
280: SELECT ctt.accounting_affect_flag
281: FROM ra_customer_trx_all trx
282: , ra_cust_trx_types_all ctt
283: WHERE trx.customer_trx_id = p_trx_id
284: AND trx.cust_trx_type_id = ctt.cust_trx_type_id
285: AND trx.org_id = ctt.org_id;

Line 780: FROM ra_customer_trx_all rct

776: SELECT rct.customer_trx_id
777: , rct.trx_number
778: , rctt.name
779: , arl.meaning
780: FROM ra_customer_trx_all rct
781: , igi_exp_ar_trans i
782: , ar_lookups arl
783: , ra_cust_trx_types_all rctt
784: WHERE i.du_id = pv_du_id