APPS.ZX_PRODUCT_INTEGRATION_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 2416: from ra_customer_trx_all inv_trx,

2412: IF tax_info_rec.customer_trx_line_id is null THEN
2413:
2414: select inv_trx.trx_date
2415: into l_inv_trx_date
2416: from ra_customer_trx_all inv_trx,
2417: ra_cust_trx_types_all trx_type,
2418: ra_customer_trx_all trx
2419: where trx.cust_trx_type_id = trx_type.cust_trx_type_id
2420: and trx_type.type = 'CM'

Line 2418: ra_customer_trx_all trx

2414: select inv_trx.trx_date
2415: into l_inv_trx_date
2416: from ra_customer_trx_all inv_trx,
2417: ra_cust_trx_types_all trx_type,
2418: ra_customer_trx_all trx
2419: where trx.cust_trx_type_id = trx_type.cust_trx_type_id
2420: and trx_type.type = 'CM'
2421: and trx_type.org_id = trx.org_id
2422: and trx.previous_customer_trx_id = inv_trx.customer_trx_id

Line 2429: from ra_customer_trx_all inv_trx,

2425: ELSE
2426:
2427: select inv_trx.trx_date
2428: into l_inv_trx_date
2429: from ra_customer_trx_all inv_trx,
2430: ra_cust_trx_types_all trx_type,
2431: ra_customer_trx_all trx,
2432: ra_customer_trx_lines_all line
2433: where trx.cust_trx_type_id = trx_type.cust_trx_type_id

Line 2431: ra_customer_trx_all trx,

2427: select inv_trx.trx_date
2428: into l_inv_trx_date
2429: from ra_customer_trx_all inv_trx,
2430: ra_cust_trx_types_all trx_type,
2431: ra_customer_trx_all trx,
2432: ra_customer_trx_lines_all line
2433: where trx.cust_trx_type_id = trx_type.cust_trx_type_id
2434: and trx_type.type = 'CM'
2435: and trx_type.org_id = trx.org_id

Line 3188: FROM ra_batch_sources_all bsrc, ra_customer_trx_all trx

3184: DECLARE
3185:
3186: CURSOR sel_batch_src_tax_rule(c_trx_id IN NUMBER ) IS
3187: SELECT invalid_tax_rate_rule
3188: FROM ra_batch_sources_all bsrc, ra_customer_trx_all trx
3189: WHERE trx.batch_source_id = bsrc.batch_source_id
3190: AND trx.org_id = bsrc.org_id
3191: AND trx.customer_trx_id = c_trx_id;
3192: