APPS.ZX_PRODUCT_INTEGRATION_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 2735: from ra_customer_trx_all inv_trx,

2731: IF tax_info_rec.customer_trx_line_id is null THEN
2732:
2733: select inv_trx.trx_date
2734: into l_inv_trx_date
2735: from ra_customer_trx_all inv_trx,
2736: ra_cust_trx_types_all trx_type,
2737: ra_customer_trx_all trx
2738: where trx.cust_trx_type_id = trx_type.cust_trx_type_id
2739: and trx_type.type = 'CM'

Line 2737: ra_customer_trx_all trx

2733: select inv_trx.trx_date
2734: into l_inv_trx_date
2735: from ra_customer_trx_all inv_trx,
2736: ra_cust_trx_types_all trx_type,
2737: ra_customer_trx_all trx
2738: where trx.cust_trx_type_id = trx_type.cust_trx_type_id
2739: and trx_type.type = 'CM'
2740: and trx_type.org_id = trx.org_id
2741: and trx.previous_customer_trx_id = inv_trx.customer_trx_id

Line 2748: from ra_customer_trx_all inv_trx,

2744: ELSE
2745:
2746: select inv_trx.trx_date
2747: into l_inv_trx_date
2748: from ra_customer_trx_all inv_trx,
2749: ra_cust_trx_types_all trx_type,
2750: ra_customer_trx_all trx,
2751: ra_customer_trx_lines_all line
2752: where trx.cust_trx_type_id = trx_type.cust_trx_type_id

Line 2750: ra_customer_trx_all trx,

2746: select inv_trx.trx_date
2747: into l_inv_trx_date
2748: from ra_customer_trx_all inv_trx,
2749: ra_cust_trx_types_all trx_type,
2750: ra_customer_trx_all trx,
2751: ra_customer_trx_lines_all line
2752: where trx.cust_trx_type_id = trx_type.cust_trx_type_id
2753: and trx_type.type = 'CM'
2754: and trx_type.org_id = trx.org_id

Line 3506: FROM ra_batch_sources_all bsrc, ra_customer_trx_all trx

3502: DECLARE
3503:
3504: CURSOR sel_batch_src_tax_rule(c_trx_id IN NUMBER ) IS
3505: SELECT invalid_tax_rate_rule
3506: FROM ra_batch_sources_all bsrc, ra_customer_trx_all trx
3507: WHERE trx.batch_source_id = bsrc.batch_source_id
3508: AND trx.org_id = bsrc.org_id
3509: AND trx.customer_trx_id = c_trx_id;
3510: