APPS.ZX_JL_EXTRACT_PKG dependencies on RA_CUST_TRX_TYPES_ALL

Line 3260: ra_cust_trx_types_all types

3256: zx_rates_b rates,
3257:
3258:
3259: ra_customer_trx_all ratrx,
3260: ra_cust_trx_types_all types
3261: WHERE itf.request_id = P_REQUEST_ID
3262: AND itf.trx_id = ratrx.customer_trx_id
3263: AND itf.tax_rate_id = rates.tax_rate_id
3264: AND ratrx.cust_trx_type_id = types.cust_trx_type_id

Line 3458: ra_cust_trx_types_all tt

3454: l_tax_rate_id_tbl,
3455: l_document_sub_type_tbl,
3456: l_trx_line_dist_id_tbl
3457: FROM zx_rep_trx_detail_t dtl, --Bug 5396444
3458: ra_cust_trx_types_all tt
3459: WHERE dtl.request_id = P_REQUEST_ID
3460: AND dtl.internal_organization_id = tt.org_id
3461: AND dtl.trx_type_id = tt.cust_trx_type_id
3462: AND tt.accounting_affect_flag = 'Y'

Line 7835: ra_cust_trx_types_all rctt

7831: END IF;
7832: SELECT dgi_code
7833: INTO x_dgi_code_tbl(i)
7834: FROM jl_ar_ap_trx_dgi_codes dgi,
7835: ra_cust_trx_types_all rctt
7836: WHERE trx_letter = substr(p_trx_number_tbl(i),1,1)
7837: AND rctt.cust_trx_type_id = P_TRX_CATEGORY_TBL(i)
7838: AND rctt.org_id = p_org_id_tbl(i)
7839: AND trx_category = decode(rctt.type,'INV','FC','DM','ND','CM','NC');