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.

APPS.ZX_JL_EXTRACT_PKG dependencies on RA_CUSTOMER_TRX

Line 2052: -- ra_customer_trx rct

2048: l_tax_rate_tbl,
2049: l_document_sub_type_tbl,
2050: l_exchange_rate_tbl
2051: FROM zx_rep_trx_detail_t itf1
2052: -- ra_customer_trx rct
2053: WHERE itf1.request_id = P_REQUEST_ID
2054: -- AND rct.customer_trx_id = itf1.trx_id
2055: AND itf1.trx_line_class in ('INVOICE','DEBIT_MEMO','CREDIT_MEMO')
2056: AND NVL(itf1.application_doc_status,'$') <>'VD'

Line 3259: ra_customer_trx_all ratrx,

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

Line 3770: FROM ra_customer_trx_all

3766: BEGIN
3767:
3768: SELECT decode(global_attribute19,NULL,'IS_NULL','NOT_NULL')
3769: INTO l_gdf_ra_cust_trx_att19_tbl(p_trx_id_tbl(i))
3770: FROM ra_customer_trx_all
3771: WHERE customer_trx_id = p_trx_id_tbl(i);
3772:
3773: EXCEPTION
3774: WHEN OTHERS THEN

Line 3995: FROM ra_customer_trx_all

3991: END IF;
3992:
3993: SELECT decode(global_attribute19,NULL,'IS_NULL','NOT_NULL')
3994: INTO l_gdf_ra_cust_trx_att19_tbl(p_trx_id_tbl(i))
3995: FROM ra_customer_trx_all
3996: WHERE customer_trx_id = p_trx_id_tbl(i);
3997:
3998: IF (g_level_procedure >= g_current_runtime_level ) THEN
3999: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JL_EXTRACT_PKG.get_vat_amount',

Line 4053: FROM ra_customer_trx

4049: BEGIN
4050:
4051: SELECT decode(global_attribute19,NULL,'IS_NULL','NOT_NULL')
4052: INTO l_gdf_ra_cust_trx_att19_tbl(p_trx_id_tbl(i))
4053: FROM ra_customer_trx
4054: WHERE customer_trx_id = p_trx_id_tbl(i);
4055:
4056: EXCEPTION
4057: WHEN OTHERS THEN

Line 4485: FROM ra_customer_trx_lines_all ctl

4481: SELECT (SUM(DECODE(ctl.line_type,'LINE', NVL(ctl.extended_amount,0),0))
4482: + SUM(DECODE(ctl.line_type,'FREIGHT',NVL(ctl.extended_amount,0),0))
4483: + SUM(DECODE(ctl.line_type,'CHARGE',NVL(ctl.extended_amount,0),0)))
4484: INTO l_taxable_amt_tbl(k)
4485: FROM ra_customer_trx_lines_all ctl
4486: WHERE ctl.customer_trx_line_id = p_trx_line_id(i)
4487: AND ctl.customer_trx_id = p_trx_id_tbl(i);
4488: END;
4489: X_TAXABLE_AMT_TBL(i):=l_taxable_amt_tbl(k);

Line 4524: FROM ra_customer_trx_all

4520:
4521: BEGIN
4522: SELECT decode(global_attribute19,NULL,'IS_NULL','NOT_NULL')
4523: INTO l_gdf_ra_cust_trx_att19_tbl(k)
4524: FROM ra_customer_trx_all
4525: WHERE customer_trx_id = p_trx_id_tbl(i);
4526:
4527: IF (g_level_statement >= g_current_runtime_level ) THEN
4528: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.get_taxable_amount',

Line 4689: FROM ra_customer_trx_all

4685:
4686: BEGIN
4687: SELECT decode(global_attribute19,NULL,'IS_NULL','NOT_NULL')
4688: INTO l_gdf_ra_cust_trx_att19_tbl(p_trx_id_tbl(i))
4689: FROM ra_customer_trx_all
4690: WHERE customer_trx_id = p_trx_id_tbl(i);
4691:
4692: EXCEPTION
4693: WHEN OTHERS THEN

Line 4935: FROM ra_customer_trx

4931: BEGIN
4932:
4933: SELECT decode(global_attribute19,NULL,'IS_NULL','NOT_NULL')
4934: INTO l_gdf_ra_cust_trx_att19_tbl(p_trx_id_tbl(i))
4935: FROM ra_customer_trx
4936: WHERE customer_trx_id = p_trx_id_tbl(i);
4937:
4938: EXCEPTION
4939: WHEN OTHERS THEN

Line 5489: FROM ra_customer_trx

5485: END IF;
5486:
5487: SELECT decode(global_attribute19,NULL,'IS_NULL','NOT_NULL')
5488: INTO l_gdf_ra_cust_trx_att19_tbl(p_trx_id_tbl(i))
5489: FROM ra_customer_trx
5490: WHERE customer_trx_id = p_trx_id_tbl(i);
5491:
5492: EXCEPTION
5493: WHEN OTHERS THEN

Line 5557: FROM ra_customer_trx_all

5553: BEGIN
5554:
5555: SELECT decode(global_attribute19,NULL,'IS_NULL','NOT_NULL')
5556: INTO l_gdf_ra_cust_trx_att19_tbl(p_trx_id_tbl(i))
5557: FROM ra_customer_trx_all
5558: WHERE customer_trx_id = p_trx_id_tbl(i);
5559:
5560: EXCEPTION
5561:

Line 5855: FROM ra_customer_trx

5851: BEGIN
5852:
5853: SELECT decode(global_attribute19,NULL,'IS_NULL','NOT_NULL')
5854: INTO l_gdf_ra_cust_trx_att19_tbl(k)
5855: FROM ra_customer_trx
5856: WHERE customer_trx_id = p_trx_id_tbl(i);
5857:
5858: EXCEPTION
5859: WHEN OTHERS THEN

Line 5976: FROM ra_customer_trx

5972: BEGIN
5973:
5974: SELECT decode(global_attribute19,NULL,'IS_NULL','NOT_NULL')
5975: INTO l_gdf_ra_cust_trx_att19_tbl(p_trx_id_tbl(i))
5976: FROM ra_customer_trx
5977: WHERE customer_trx_id = p_trx_id_tbl(i);
5978:
5979: EXCEPTION
5980: WHEN OTHERS THEN

Line 6352: FROM ra_customer_trx_all

6348: l_gdf_ra_cust_trx_att19_tbl(p_trx_id_tbl(i)) <> 'NOT_NULL' ) THEN
6349: BEGIN
6350: SELECT decode(global_attribute19,NULL,'IS_NULL','NOT_NULL')
6351: INTO l_gdf_ra_cust_trx_att19_tbl(p_trx_id_tbl(i))
6352: FROM ra_customer_trx_all
6353: WHERE customer_trx_id = p_trx_id_tbl(i);
6354:
6355: EXCEPTION
6356:

Line 6517: FROM ra_customer_trx_all

6513: END IF;
6514:
6515: SELECT decode(global_attribute19,NULL,'IS_NULL','NOT_NULL')
6516: INTO l_gdf_ra_cust_trx_att19_tbl(p_trx_id_tbl(i))
6517: FROM ra_customer_trx_all
6518: WHERE customer_trx_id = p_trx_id_tbl(i);
6519:
6520: EXCEPTION
6521: WHEN OTHERS THEN

Line 6773: FROM ra_customer_trx

6769:
6770: BEGIN
6771: SELECT decode(global_attribute19,NULL,'IS_NULL','NOT_NULL')
6772: INTO l_gdf_ra_cust_trx_att19_tbl(p_trx_id_tbl(i))
6773: FROM ra_customer_trx
6774: WHERE customer_trx_id = p_trx_id_tbl(i);
6775:
6776: EXCEPTION
6777: WHEN OTHERS THEN

Line 6989: FROM ra_customer_trx

6985:
6986: BEGIN
6987: SELECT decode(global_attribute19,NULL,'IS_NULL','NOT_NULL')
6988: INTO l_gdf_ra_cust_trx_att19_tbl(p_trx_id_tbl(i))
6989: FROM ra_customer_trx
6990: WHERE customer_trx_id = p_trx_id_tbl(i);
6991:
6992: EXCEPTION
6993: WHEN OTHERS THEN

Line 7218: FROM ra_customer_trx

7214: IF l_gdf_ra_cust_trx_att19_tbl(p_trx_id_tbl(i)) IS NULL THEN
7215: BEGIN
7216: SELECT decode(global_attribute19,NULL,'IS_NULL','NOT_NULL')
7217: INTO l_gdf_ra_cust_trx_att19_tbl(p_trx_id_tbl(i))
7218: FROM ra_customer_trx
7219: WHERE customer_trx_id = p_trx_id_tbl(i);
7220:
7221: IF ( g_level_statement>= g_current_runtime_level ) THEN
7222: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.GET_EXCISE_TAX_AMOUNT',

Line 8045: FROM ra_customer_trx_all trx,

8041: NVL(add1.global_attribute9,'N')
8042: INTO l_address_id,
8043: l_contributor_class,
8044: l_use_site_prof
8045: FROM ra_customer_trx_all trx,
8046: hz_cust_accounts cust,
8047: hz_cust_acct_sites_all add1,
8048: hz_cust_site_uses_all site
8049: WHERE trx.customer_trx_id = p_trx_id_tbl(i)

Line 8365: FROM ra_customer_trx_all trx,

8361: NVL(add1.global_attribute9,'N')
8362: INTO l_address_id,
8363: l_class_code,
8364: l_use_site_prof
8365: FROM ra_customer_trx_all trx,
8366: hz_cust_accounts cust,
8367: hz_cust_acct_sites_all add1,
8368: hz_cust_site_uses_all site
8369: WHERE trx.customer_trx_id = p_trx_id_tbl(i)

Line 8832: FROM ra_customer_trx_lines

8828: IF P_REPORT_NAME = 'JLARTPFF' THEN
8829:
8830: SELECT abs(sum(nvl(extended_amount,0) * nvl(p_exchange_rate_tbl(i),1)))
8831: INTO l_total_doc_amt_tbl(p_trx_id_tbl(i))
8832: FROM ra_customer_trx_lines
8833: WHERE customer_trx_id = p_trx_id_tbl(i);
8834:
8835: ELSIF P_REPORT_NAME = 'ZXCOARSB' THEN -- : Total Doc Amt.
8836:

Line 8841: FROM ra_customer_trx_lines_all ctl --Bug 5396444

8837: SELECT (SUM(DECODE(ctl.line_type,'LINE', NVL(ctl.extended_amount,0),0))
8838: + SUM(DECODE(ctl.line_type,'FREIGHT',NVL(ctl.extended_amount,0),0))
8839: + SUM(DECODE(ctl.line_type,'CHARGE',NVL(ctl.extended_amount,0),0)))-- * p_exchange_rate_tbl(i)
8840: INTO l_total_doc_amt_tbl(p_trx_id_tbl(i))
8841: FROM ra_customer_trx_lines_all ctl --Bug 5396444
8842: WHERE ctl.customer_trx_id = p_trx_id_tbl(i);
8843:
8844: ELSIF P_REPORT_NAME = 'ZXZZTVSR' THEN
8845:

Line 8848: FROM RA_CUSTOMER_TRX_LINES L

8844: ELSIF P_REPORT_NAME = 'ZXZZTVSR' THEN
8845:
8846: SELECT (nvl(SUM(NVL(L.GROSS_EXTENDED_AMOUNT, nvl(L.EXTENDED_AMOUNT,0))),0) * p_exchange_rate_tbl(i))
8847: INTO l_total_doc_amt_tbl(p_trx_id_tbl(i))
8848: FROM RA_CUSTOMER_TRX_LINES L
8849: WHERE L.CUSTOMER_TRX_ID = p_trx_id_tbl(i);
8850:
8851: ELSIF P_REPORT_NAME in ('JLARTSFF','JLZZTCFF','JLARTDFF') THEN
8852:

Line 8873: FROM ra_customer_trx_all

8869: BEGIN
8870:
8871: SELECT decode(global_attribute19,NULL,'IS_NULL','NOT_NULL')
8872: INTO l_gdf_ra_cust_trx_att19_tbl(p_trx_id_tbl(i))
8873: FROM ra_customer_trx_all
8874: WHERE customer_trx_id = p_trx_id_tbl(i);
8875:
8876: IF ( g_level_statement>= g_current_runtime_level ) THEN
8877: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG',

Line 8897: FROM ra_customer_trx_lines

8893: IF P_REPORT_NAME= 'JLARTDFF' THEN
8894:
8895: SELECT nvl(SUM(abs(NVL(GROSS_EXTENDED_AMOUNT, nvl(EXTENDED_AMOUNT,0)))),0)
8896: INTO l_total_doc_amt_tbl(p_trx_id_tbl(i))
8897: FROM ra_customer_trx_lines
8898: WHERE customer_trx_id = p_trx_id_tbl(i);
8899:
8900: ELSIF P_REPORT_NAME IN ('JLARTSFF','JLZZTCFF') THEN
8901:

Line 8910: FROM RA_CUSTOMER_TRX_LINES L

8906:
8907: SELECT (nvl(SUM(NVL(L.GROSS_EXTENDED_AMOUNT, nvl(L.EXTENDED_AMOUNT,0))),0)
8908: * nvl(p_exchange_rate_tbl(i),1))
8909: INTO l_total_doc_amt_tbl(p_trx_id_tbl(i))
8910: FROM RA_CUSTOMER_TRX_LINES L
8911: WHERE L.CUSTOMER_TRX_ID = p_trx_id_tbl(i);
8912: END IF;
8913:
8914: ELSE

Line 9609: FROM ra_customer_trx

9605: BEGIN
9606: SELECT global_attribute17,global_attribute18
9607: INTO l_cai_num_tbl(p_trx_id_tbl(i)),
9608: l_cai_due_date_tbl(p_trx_id_tbl(i))
9609: FROM ra_customer_trx
9610: WHERE customer_trx_id = p_trx_id_tbl(i);
9611:
9612: EXCEPTION
9613: WHEN NO_DATA_FOUND THEN