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.JE_IT_INVOICES_ABOVE_THRESHOLD dependencies on JE_IT_ABOVE_THR_HDR_ALL

Line 61: FROM je_it_above_thr_hdr_all

57: AND vat_reporting_entity_id = p_vat_reporting_entity_id;
58:
59: CURSOR cur_report_mode(p_vat_reporting_entity_id NUMBER,p_year NUMBER,p_type_of_upload NUMBER) IS
60: SELECT report_mode
61: FROM je_it_above_thr_hdr_all
62: WHERE year_of_declaration = p_year
63: AND vat_reporting_entity_id = p_vat_reporting_entity_id
64: AND type_of_upload = p_type_of_upload;
65:

Line 200: FROM je_it_above_thr_hdr_all

196: IF p_type_of_upload = 1 THEN -- If type of upload is 'Substitution'
197:
198: SELECT COUNT(*)
199: INTO l_count
200: FROM je_it_above_thr_hdr_all
201: WHERE year_of_declaration = p_year
202: AND vat_reporting_entity_id = p_vat_reporting_entity_id
203: AND type_of_upload in (0,2)
204: AND report_mode = 'F';

Line 218: FROM je_it_above_thr_hdr_all

214: ELSIF p_type_of_upload = 2 THEN -- If type of upload is 'cancellation'
215:
216: SELECT COUNT(*)
217: INTO l_count
218: FROM je_it_above_thr_hdr_all
219: WHERE year_of_declaration = p_year
220: AND vat_reporting_entity_id = p_vat_reporting_entity_id
221: AND type_of_upload in (0,1)
222: AND report_mode = 'F';

Line 309: INSERT INTO je_it_above_thr_hdr_all (vat_reporting_entity_id,

305: g_b2c_trx_date := NVL(g_b2c_trx_start_date,g_end_date_for_cm_dm+1);
306:
307:
308: BEGIN
309: INSERT INTO je_it_above_thr_hdr_all (vat_reporting_entity_id,
310: year_of_declaration, -- no need of storing the company details in hdr table. write a separate query in xml file.
311: org_id,
312: report_mode,
313: type_of_upload,

Line 355: errbuf := 'Error while inserting data into JE_IT_ABOVE_THR_HDR_ALL table '||SQLCODE||'-'||SQLERRM;

351: FROM dual;
352:
353: EXCEPTION
354: WHEN OTHERS THEN
355: errbuf := 'Error while inserting data into JE_IT_ABOVE_THR_HDR_ALL table '||SQLCODE||'-'||SQLERRM;
356: retcode := 2;
357: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
358: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
359: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error while inserting data into je_it_list_hdr_all table');

Line 507: FROM je_it_above_thr_hdr_all

503:
504: debug_message('in purge_trx_data');
505: SELECT REQUEST_ID
506: INTO l_conc_request_id
507: FROM je_it_above_thr_hdr_all
508: WHERE year_of_declaration = p_year
509: AND vat_reporting_entity_id = p_vat_reporting_entity_id
510: AND type_of_upload = p_type_of_upload;
511:

Line 520: DELETE je_it_above_thr_hdr_all

516:
517: DELETE je_it_trx_above_thr_all
518: WHERE REQUEST_ID = l_conc_request_id;
519:
520: DELETE je_it_above_thr_hdr_all
521: WHERE REQUEST_ID = l_conc_request_id;
522:
523: debug_message('after delete');
524: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 867: je_it_above_thr_hdr_all h

863: AND (a.trx_type = 'CREDIT' OR a.trx_type = 'DEBIT' OR a.adj_inv_flag = 'Y')
864: AND (a.orig_trx_id IS NULL
865: OR EXISTS (SELECT 1
866: FROM je_it_trx_lines_all b,
867: je_it_above_thr_hdr_all h
868: WHERE h.year_of_declaration in (g_year-1,g_year-2)
869: AND h.request_id = b.request_id
870: AND b.application_id = 200
871: AND b.trx_id = a.orig_trx_id

Line 1489: je_it_above_thr_hdr_all h

1485: AND (a.trx_type = 'CM' OR a.trx_type = 'DM' OR a.adj_inv_flag = 'Y')
1486: AND (a.orig_trx_id IS NULL
1487: OR EXISTS (SELECT 1
1488: FROM je_it_trx_lines_all b,
1489: je_it_above_thr_hdr_all h
1490: WHERE h.year_of_declaration in (g_year-1,g_year-2)
1491: AND h.request_id = b.request_id
1492: AND b.application_id = 222
1493: AND b.trx_id = a.orig_trx_id

Line 1632: je_it_above_thr_hdr_all hdr

1628: WHERE request_id = g_conc_request_id
1629: )
1630: AND (application_id,ORIG_TRX_ID) not in (SELECT application_id,trx_id
1631: FROM je_it_trx_lines_all trx_lines,
1632: je_it_above_thr_hdr_all hdr
1633: WHERE trx_lines.request_id = hdr.request_id
1634: AND hdr.year_of_declaration in (g_year-1,g_year-2)
1635: AND is_above_threshold = 'Y')
1636: AND request_id = g_conc_request_id;

Line 1655: je_it_above_thr_hdr_all hdr

1651: UNION
1652: SELECT t2.rowid
1653: FROM je_it_trx_lines_all t2,
1654: je_it_trx_lines_all trx_lines,
1655: je_it_above_thr_hdr_all hdr
1656: WHERE trx_lines.request_id = hdr.request_id
1657: AND hdr.year_of_declaration IN(g_year -1,g_year-2)
1658: AND trx_lines.is_above_threshold = 'Y'
1659: AND t2.request_id = g_conc_request_id

Line 1776: je_it_above_thr_hdr_all b

1772: AND NVL(trx_lines.partial_adj_inv_flag,'N') = 'N'
1773: AND (trx_lines.orig_trx_id IS NULL
1774: OR NOT EXISTS (SELECT 1 --to filter credit memo lines already reported.
1775: FROM je_it_trx_lines_all a,
1776: je_it_above_thr_hdr_all b
1777: WHERE a.request_id = b.request_id
1778: AND b.year_of_declaration in (g_year-1,g_year-2)
1779: AND a.trx_id = trx_lines.trx_id
1780: AND nvl(a.trx_line_id,0) = nvl(trx_lines.trx_line_id,0)

Line 2257: je_it_above_thr_hdr_all hdr

2253: orig_trx_gl_date,orig_trx_acctg_status,
2254: orig_trx_payment_method) = (SELECT MAX(trx_num),NVL(MAX(trx_date),g_end_date),NVL(MAX(trx_gl_date),g_end_date),
2255: MAX(trx_lines.trx_accounting_status),MAX(payment_method)
2256: FROM je_it_trx_lines_all trx_lines,
2257: je_it_above_thr_hdr_all hdr
2258: WHERE trx_lines.request_id = hdr.request_id
2259: AND year_of_declaration in (g_year,g_year-1,g_year-2)
2260: AND trx_lines.application_id = trx.application_id
2261: AND trx_lines.trx_id = trx.orig_trx_id

Line 2312: UPDATE je_it_above_thr_hdr_all

2308: IF l_exist = 0 THEN
2309: IF p_report_mode = 'F' THEN
2310:
2311: --BEGIN
2312: UPDATE je_it_above_thr_hdr_all
2313: SET report_mode = 'F'
2314: WHERE request_id = p_concurrent_request_id;
2315:
2316: RETURN TRUE;