DBA Data[Home] [Help]

APPS.ZX_JL_EXTRACT_PKG dependencies on RA_CUST_TRX_TYPES_ALL

Line 3206: ra_cust_trx_types_all types

3202: zx_rates_b rates,
3203: -- zx_report_codes_assoc repc,
3204: -- zx_reporting_types_b reptypes,--Bug 5438742
3205: ra_customer_trx_all ratrx,
3206: ra_cust_trx_types_all types
3207: WHERE itf.request_id = P_REQUEST_ID
3208: AND itf.trx_id = ratrx.customer_trx_id
3209: AND itf.tax_rate_id = rates.tax_rate_id
3210: AND ratrx.cust_trx_type_id = types.cust_trx_type_id

Line 3381: ra_cust_trx_types_all tt

3377: l_tax_rate_tbl,
3378: l_tax_rate_id_tbl,
3379: l_document_sub_type_tbl
3380: FROM zx_rep_trx_detail_t dtl, --Bug 5396444
3381: ra_cust_trx_types_all tt
3382: WHERE dtl.request_id = P_REQUEST_ID
3383: AND dtl.trx_type_id = tt.cust_trx_type_id
3384: AND tt.accounting_affect_flag = 'Y';
3385:

Line 7434: ra_cust_trx_types_all rctt

7430:
7431: SELECT dgi_code
7432: INTO x_dgi_code_tbl(i)
7433: FROM jl_ar_ap_trx_dgi_codes dgi,
7434: ra_cust_trx_types_all rctt
7435: WHERE trx_letter = substr(p_trx_number_tbl(i),1,1)
7436: AND rctt.cust_trx_type_id = P_TRX_CATEGORY_TBL(i)
7437: AND rctt.org_id = p_org_id_tbl(i)
7438: AND trx_category = rctt.type;