eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.ZX_JL_EXTRACT_PKG dependencies on RA_CUSTOMER_TRX

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 2075: -- ra_customer_trx rct

2071: l_tax_rate_tbl,
2072: l_document_sub_type_tbl,
2073: l_exchange_rate_tbl
2074: FROM zx_rep_trx_detail_t itf1
2075: -- ra_customer_trx rct
2076: WHERE itf1.request_id = P_REQUEST_ID
2077: -- AND rct.customer_trx_id = itf1.trx_id
2078: AND itf1.trx_line_class in ('INVOICE','DEBIT_MEMO','CREDIT_MEMO')
2079: AND NVL(itf1.application_doc_status,'$') <>'VD'

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 3963: FROM ra_customer_trx

3959: BEGIN
3960:
3961: SELECT decode(global_attribute19,NULL,'IS_NULL','NOT_NULL')
3962: INTO l_gdf_ra_cust_trx_att19_tbl(p_trx_id_tbl(i))
3963: FROM ra_customer_trx
3964: WHERE customer_trx_id = p_trx_id_tbl(i);
3965:
3966: EXCEPTION
3967: WHEN OTHERS THEN

Line 4346: FROM ra_customer_trx_lines_all ctl

4342: SELECT (SUM(DECODE(ctl.line_type,'LINE', NVL(ctl.extended_amount,0),0))
4343: + SUM(DECODE(ctl.line_type,'FREIGHT',NVL(ctl.extended_amount,0),0))
4344: + SUM(DECODE(ctl.line_type,'CHARGE',NVL(ctl.extended_amount,0),0))) --* p_exchange_rate_tbl(i)
4345: INTO l_taxable_amt_tbl(p_trx_line_id(i))
4346: FROM ra_customer_trx_lines_all ctl
4347: WHERE ctl.customer_trx_line_id = p_trx_line_id(i)
4348: AND ctl.customer_trx_id = p_trx_id_tbl(i);
4349:
4350: END;

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 4802: FROM ra_customer_trx

4798: BEGIN
4799:
4800: SELECT decode(global_attribute19,NULL,'IS_NULL','NOT_NULL')
4801: INTO l_gdf_ra_cust_trx_att19_tbl(p_trx_id_tbl(i))
4802: FROM ra_customer_trx
4803: WHERE customer_trx_id = p_trx_id_tbl(i);
4804:
4805: EXCEPTION
4806: WHEN OTHERS THEN

Line 5321: FROM ra_customer_trx

5317: END IF;
5318:
5319: SELECT decode(global_attribute19,NULL,'IS_NULL','NOT_NULL')
5320: INTO l_gdf_ra_cust_trx_att19_tbl(p_trx_id_tbl(i))
5321: FROM ra_customer_trx
5322: WHERE customer_trx_id = p_trx_id_tbl(i);
5323:
5324: EXCEPTION
5325: 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 5650: FROM ra_customer_trx

5646: BEGIN
5647:
5648: SELECT decode(global_attribute19,NULL,'IS_NULL','NOT_NULL')
5649: INTO l_gdf_ra_cust_trx_att19_tbl(k)
5650: FROM ra_customer_trx
5651: WHERE customer_trx_id = p_trx_id_tbl(i);
5652:
5653: EXCEPTION
5654: WHEN OTHERS THEN

Line 5757: FROM ra_customer_trx

5753: BEGIN
5754:
5755: SELECT decode(global_attribute19,NULL,'IS_NULL','NOT_NULL')
5756: INTO l_gdf_ra_cust_trx_att19_tbl(p_trx_id_tbl(i))
5757: FROM ra_customer_trx
5758: WHERE customer_trx_id = p_trx_id_tbl(i);
5759:
5760: EXCEPTION
5761: WHEN OTHERS THEN

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 6530: FROM ra_customer_trx

6526:
6527: BEGIN
6528: SELECT decode(global_attribute19,NULL,'IS_NULL','NOT_NULL')
6529: INTO l_gdf_ra_cust_trx_att19_tbl(p_trx_id_tbl(i))
6530: FROM ra_customer_trx
6531: WHERE customer_trx_id = p_trx_id_tbl(i);
6532:
6533: EXCEPTION
6534: WHEN OTHERS THEN

Line 6736: FROM ra_customer_trx

6732:
6733: BEGIN
6734: SELECT decode(global_attribute19,NULL,'IS_NULL','NOT_NULL')
6735: INTO l_gdf_ra_cust_trx_att19_tbl(p_trx_id_tbl(i))
6736: FROM ra_customer_trx
6737: WHERE customer_trx_id = p_trx_id_tbl(i);
6738:
6739: EXCEPTION
6740: WHEN OTHERS THEN

Line 6954: FROM ra_customer_trx

6950: IF l_gdf_ra_cust_trx_att19_tbl(p_trx_id_tbl(i)) IS NULL THEN
6951: BEGIN
6952: SELECT decode(global_attribute19,NULL,'IS_NULL','NOT_NULL')
6953: INTO l_gdf_ra_cust_trx_att19_tbl(p_trx_id_tbl(i))
6954: FROM ra_customer_trx
6955: WHERE customer_trx_id = p_trx_id_tbl(i);
6956:
6957: IF ( g_level_statement>= g_current_runtime_level ) THEN
6958: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.GET_EXCISE_TAX_AMOUNT',

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 8356: FROM ra_customer_trx_lines

8352: IF P_REPORT_NAME = 'JLARTPFF' THEN
8353:
8354: SELECT abs(sum(nvl(extended_amount,0) * nvl(p_exchange_rate_tbl(i),1)))
8355: INTO l_total_doc_amt_tbl(p_trx_id_tbl(i))
8356: FROM ra_customer_trx_lines
8357: WHERE customer_trx_id = p_trx_id_tbl(i);
8358:
8359: ELSIF P_REPORT_NAME = 'ZXCOARSB' THEN -- : Total Doc Amt.
8360:

Line 8365: FROM ra_customer_trx_lines_all ctl --Bug 5396444

8361: SELECT (SUM(DECODE(ctl.line_type,'LINE', NVL(ctl.extended_amount,0),0))
8362: + SUM(DECODE(ctl.line_type,'FREIGHT',NVL(ctl.extended_amount,0),0))
8363: + SUM(DECODE(ctl.line_type,'CHARGE',NVL(ctl.extended_amount,0),0)))-- * p_exchange_rate_tbl(i)
8364: INTO l_total_doc_amt_tbl(p_trx_id_tbl(i))
8365: FROM ra_customer_trx_lines_all ctl --Bug 5396444
8366: WHERE ctl.customer_trx_id = p_trx_id_tbl(i);
8367:
8368: ELSIF P_REPORT_NAME = 'ZXZZTVSR' THEN
8369:

Line 8372: FROM RA_CUSTOMER_TRX_LINES L

8368: ELSIF P_REPORT_NAME = 'ZXZZTVSR' THEN
8369:
8370: SELECT (nvl(SUM(NVL(L.GROSS_EXTENDED_AMOUNT, nvl(L.EXTENDED_AMOUNT,0))),0) * p_exchange_rate_tbl(i))
8371: INTO l_total_doc_amt_tbl(p_trx_id_tbl(i))
8372: FROM RA_CUSTOMER_TRX_LINES L
8373: WHERE L.CUSTOMER_TRX_ID = p_trx_id_tbl(i);
8374:
8375: ELSIF P_REPORT_NAME in ('JLARTSFF','JLARTDFF') THEN
8376:

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',

Line 8421: FROM ra_customer_trx_lines

8417: IF P_REPORT_NAME= 'JLARTDFF' THEN
8418:
8419: SELECT nvl(SUM(abs(NVL(GROSS_EXTENDED_AMOUNT, nvl(EXTENDED_AMOUNT,0)))),0)
8420: INTO l_total_doc_amt_tbl(p_trx_id_tbl(i))
8421: FROM ra_customer_trx_lines
8422: WHERE customer_trx_id = p_trx_id_tbl(i);
8423:
8424: ELSIF P_REPORT_NAME = 'JLARTSFF' THEN
8425:

Line 8434: FROM RA_CUSTOMER_TRX_LINES L

8430:
8431: SELECT (nvl(SUM(NVL(L.GROSS_EXTENDED_AMOUNT, nvl(L.EXTENDED_AMOUNT,0))),0)
8432: * nvl(p_exchange_rate_tbl(i),1))
8433: INTO l_total_doc_amt_tbl(p_trx_id_tbl(i))
8434: FROM RA_CUSTOMER_TRX_LINES L
8435: WHERE L.CUSTOMER_TRX_ID = p_trx_id_tbl(i);
8436: END IF;
8437:
8438: ELSE

Line 9099: FROM ra_customer_trx

9095: BEGIN
9096: SELECT global_attribute17,global_attribute18
9097: INTO l_cai_num_tbl(p_trx_id_tbl(i)),
9098: l_cai_due_date_tbl(p_trx_id_tbl(i))
9099: FROM ra_customer_trx
9100: WHERE customer_trx_id = p_trx_id_tbl(i);
9101:
9102: EXCEPTION
9103: WHEN NO_DATA_FOUND THEN