APPS.ZX_JL_EXTRACT_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 1933: ra_customer_trx_all rcta

1929: l_internal_org_id_tbl,
1930: l_tax_rate_tbl,
1931: l_document_sub_type_tbl
1932: FROM zx_rep_trx_detail_t itf,
1933: ra_customer_trx_all rcta
1934: WHERE itf.request_id = P_REQUEST_ID
1935: AND rcta.customer_trx_id = itf.trx_id
1936: AND itf.extract_source_ledger = 'AR'
1937: AND itf.trx_line_class = 'CREDIT_MEMO'

Line 3205: ra_customer_trx_all ratrx,

3201: FROM zx_rep_trx_detail_t itf,
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

Line 3674: FROM ra_customer_trx_all

3670: BEGIN
3671:
3672: SELECT decode(global_attribute19,NULL,'IS_NULL','NOT_NULL')
3673: INTO l_gdf_ra_cust_trx_att19_tbl(p_trx_id_tbl(i))
3674: FROM ra_customer_trx_all
3675: WHERE customer_trx_id = p_trx_id_tbl(i);
3676:
3677: EXCEPTION
3678: WHEN OTHERS THEN

Line 3905: FROM ra_customer_trx_all

3901: END IF;
3902:
3903: SELECT decode(global_attribute19,NULL,'IS_NULL','NOT_NULL')
3904: INTO l_gdf_ra_cust_trx_att19_tbl(p_trx_id_tbl(i))
3905: FROM ra_customer_trx_all
3906: WHERE customer_trx_id = p_trx_id_tbl(i);
3907:
3908: IF (g_level_procedure >= g_current_runtime_level ) THEN
3909: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JL_EXTRACT_PKG.get_vat_amount',

Line 4390: FROM ra_customer_trx_all

4386:
4387: BEGIN
4388: SELECT decode(global_attribute19,NULL,'IS_NULL','NOT_NULL')
4389: INTO l_gdf_ra_cust_trx_att19_tbl(p_trx_line_id(i))
4390: FROM ra_customer_trx_all
4391: WHERE customer_trx_id = p_trx_id_tbl(i);
4392:
4393: IF (g_level_statement >= g_current_runtime_level ) THEN
4394: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.get_taxable_amount',

Line 4569: FROM ra_customer_trx_all

4565:
4566: BEGIN
4567: SELECT decode(global_attribute19,NULL,'IS_NULL','NOT_NULL')
4568: INTO l_gdf_ra_cust_trx_att19_tbl(p_trx_id_tbl(i))
4569: FROM ra_customer_trx_all
4570: WHERE customer_trx_id = p_trx_id_tbl(i);
4571:
4572: EXCEPTION
4573: WHEN OTHERS THEN

Line 5373: FROM ra_customer_trx_all

5369: BEGIN
5370:
5371: SELECT decode(global_attribute19,NULL,'IS_NULL','NOT_NULL')
5372: INTO l_gdf_ra_cust_trx_att19_tbl(p_trx_id_tbl(i))
5373: FROM ra_customer_trx_all
5374: WHERE customer_trx_id = p_trx_id_tbl(i);
5375:
5376: EXCEPTION
5377:

Line 6103: FROM ra_customer_trx_all

6099: IF ( l_gdf_ra_cust_trx_att19_tbl(p_trx_id_tbl(i)) <> 'IS_NULL' and l_gdf_ra_cust_trx_att19_tbl(p_trx_id_tbl(i)) <> 'NOT_NULL' ) THEN
6100: BEGIN
6101: SELECT decode(global_attribute19,NULL,'IS_NULL','NOT_NULL')
6102: INTO l_gdf_ra_cust_trx_att19_tbl(p_trx_id_tbl(i))
6103: FROM ra_customer_trx_all
6104: WHERE customer_trx_id = p_trx_id_tbl(i);
6105:
6106: EXCEPTION
6107:

Line 6286: FROM ra_customer_trx_all

6282: END IF;
6283:
6284: SELECT decode(global_attribute19,NULL,'IS_NULL','NOT_NULL')
6285: INTO l_gdf_ra_cust_trx_att19_tbl(p_trx_id_tbl(i))
6286: FROM ra_customer_trx_all
6287: WHERE customer_trx_id = p_trx_id_tbl(i);
6288:
6289: EXCEPTION
6290: WHEN OTHERS THEN

Line 7571: FROM ra_customer_trx_all trx,

7567: NVL(add1.global_attribute9,'N')
7568: INTO l_address_id,
7569: l_contributor_class,
7570: l_use_site_prof
7571: FROM ra_customer_trx_all trx,
7572: hz_cust_accounts cust,
7573: hz_cust_acct_sites_all add1,
7574: hz_cust_site_uses_all site
7575: WHERE trx.customer_trx_id = p_trx_id_tbl(i)

Line 7889: FROM ra_customer_trx_all trx,

7885: NVL(add1.global_attribute9,'N')
7886: INTO l_address_id,
7887: l_class_code,
7888: l_use_site_prof
7889: FROM ra_customer_trx_all trx,
7890: hz_cust_accounts cust,
7891: hz_cust_acct_sites_all add1,
7892: hz_cust_site_uses_all site
7893: WHERE trx.customer_trx_id = p_trx_id_tbl(i)

Line 8397: FROM ra_customer_trx_all

8393: BEGIN
8394:
8395: SELECT decode(global_attribute19,NULL,'IS_NULL','NOT_NULL')
8396: INTO l_gdf_ra_cust_trx_att19_tbl(p_trx_id_tbl(i))
8397: FROM ra_customer_trx_all
8398: WHERE customer_trx_id = p_trx_id_tbl(i);
8399:
8400: IF ( g_level_statement>= g_current_runtime_level ) THEN
8401: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG',