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_TDS_IMPORT_DOCUMENT_PKG dependencies on ZX_TRANSACTION_LINES_GT

Line 32: trx_level_type zx_transaction_lines_gt.trx_level_type%TYPE,

28: line_amt zx_trx_tax_link_gt.line_amt%TYPE,
29: trx_date zx_trx_headers_gt.trx_date%TYPE,
30: minimum_accountable_unit zx_trx_headers_gt.minimum_accountable_unit%TYPE,
31: precision zx_trx_headers_gt.precision%TYPE,
32: trx_level_type zx_transaction_lines_gt.trx_level_type%TYPE,
33: trx_line_date zx_transaction_lines_gt.trx_line_date%TYPE,
34: adjusted_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE,
35: line_level_action zx_transaction_lines_gt.line_level_action%TYPE,
36: interface_entity_code zx_import_tax_lines_gt.interface_entity_code%TYPE,

Line 33: trx_line_date zx_transaction_lines_gt.trx_line_date%TYPE,

29: trx_date zx_trx_headers_gt.trx_date%TYPE,
30: minimum_accountable_unit zx_trx_headers_gt.minimum_accountable_unit%TYPE,
31: precision zx_trx_headers_gt.precision%TYPE,
32: trx_level_type zx_transaction_lines_gt.trx_level_type%TYPE,
33: trx_line_date zx_transaction_lines_gt.trx_line_date%TYPE,
34: adjusted_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE,
35: line_level_action zx_transaction_lines_gt.line_level_action%TYPE,
36: interface_entity_code zx_import_tax_lines_gt.interface_entity_code%TYPE,
37: interface_tax_line_id zx_import_tax_lines_gt.interface_tax_line_id%TYPE,

Line 34: adjusted_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE,

30: minimum_accountable_unit zx_trx_headers_gt.minimum_accountable_unit%TYPE,
31: precision zx_trx_headers_gt.precision%TYPE,
32: trx_level_type zx_transaction_lines_gt.trx_level_type%TYPE,
33: trx_line_date zx_transaction_lines_gt.trx_line_date%TYPE,
34: adjusted_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE,
35: line_level_action zx_transaction_lines_gt.line_level_action%TYPE,
36: interface_entity_code zx_import_tax_lines_gt.interface_entity_code%TYPE,
37: interface_tax_line_id zx_import_tax_lines_gt.interface_tax_line_id%TYPE,
38: related_doc_date zx_trx_headers_gt.related_doc_date%TYPE,

Line 35: line_level_action zx_transaction_lines_gt.line_level_action%TYPE,

31: precision zx_trx_headers_gt.precision%TYPE,
32: trx_level_type zx_transaction_lines_gt.trx_level_type%TYPE,
33: trx_line_date zx_transaction_lines_gt.trx_line_date%TYPE,
34: adjusted_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE,
35: line_level_action zx_transaction_lines_gt.line_level_action%TYPE,
36: interface_entity_code zx_import_tax_lines_gt.interface_entity_code%TYPE,
37: interface_tax_line_id zx_import_tax_lines_gt.interface_tax_line_id%TYPE,
38: related_doc_date zx_trx_headers_gt.related_doc_date%TYPE,
39: provnl_tax_determination_date zx_trx_headers_gt.provnl_tax_determination_date%TYPE,

Line 41: tax_date zx_transaction_lines_gt.tax_date%type,

37: interface_tax_line_id zx_import_tax_lines_gt.interface_tax_line_id%TYPE,
38: related_doc_date zx_trx_headers_gt.related_doc_date%TYPE,
39: provnl_tax_determination_date zx_trx_headers_gt.provnl_tax_determination_date%TYPE,
40: -- added for bug 5018766
41: tax_date zx_transaction_lines_gt.tax_date%type,
42: tax_determine_date zx_transaction_lines_gt.tax_determine_date%type,
43: tax_point_date zx_transaction_lines_gt.tax_point_date%type,
44: -- Bug 7117340 -- DFF ER
45: attribute1 zx_import_tax_lines_gt.attribute1%TYPE,

Line 42: tax_determine_date zx_transaction_lines_gt.tax_determine_date%type,

38: related_doc_date zx_trx_headers_gt.related_doc_date%TYPE,
39: provnl_tax_determination_date zx_trx_headers_gt.provnl_tax_determination_date%TYPE,
40: -- added for bug 5018766
41: tax_date zx_transaction_lines_gt.tax_date%type,
42: tax_determine_date zx_transaction_lines_gt.tax_determine_date%type,
43: tax_point_date zx_transaction_lines_gt.tax_point_date%type,
44: -- Bug 7117340 -- DFF ER
45: attribute1 zx_import_tax_lines_gt.attribute1%TYPE,
46: attribute2 zx_import_tax_lines_gt.attribute2%TYPE,

Line 43: tax_point_date zx_transaction_lines_gt.tax_point_date%type,

39: provnl_tax_determination_date zx_trx_headers_gt.provnl_tax_determination_date%TYPE,
40: -- added for bug 5018766
41: tax_date zx_transaction_lines_gt.tax_date%type,
42: tax_determine_date zx_transaction_lines_gt.tax_determine_date%type,
43: tax_point_date zx_transaction_lines_gt.tax_point_date%type,
44: -- Bug 7117340 -- DFF ER
45: attribute1 zx_import_tax_lines_gt.attribute1%TYPE,
46: attribute2 zx_import_tax_lines_gt.attribute2%TYPE,
47: attribute3 zx_import_tax_lines_gt.attribute3%TYPE,

Line 103: INDEX(linegt ZX_TRANSACTION_LINES_GT_U1 )*/

99: SELECT /*+ ORDERED
100: INDEX(headergt ZX_TRX_HEADERS_GT_U1)
101: INDEX(sumgt ZX_IMPORT_TAX_LINES_GT_U1)
102: INDEX(allocgt ZX_TRX_TAX_LINK_GT_U1)
103: INDEX(linegt ZX_TRANSACTION_LINES_GT_U1 )*/
104: sumgt.summary_tax_line_number,
105: sumgt.internal_organization_id,
106: sumgt.tax_regime_code,
107: sumgt.tax,

Line 155: zx_transaction_lines_gt linegt

151: sumgt.attribute_category
152: FROM zx_trx_headers_gt headergt,
153: zx_import_tax_lines_gt sumgt,
154: zx_trx_tax_link_gt allocgt,
155: zx_transaction_lines_gt linegt
156: WHERE headergt.application_id = p_event_class_rec.application_id
157: AND headergt.event_class_code = p_event_class_rec.event_class_code
158: AND headergt.entity_code = p_event_class_rec.entity_code
159: AND headergt.trx_id = p_event_class_rec.trx_id

Line 182: INDEX(linegt ZX_TRANSACTION_LINES_GT_U1)*/

178: CURSOR get_one_alloc_det_tax_lines_cr IS
179: SELECT /*+ ORDERED
180: INDEX(headergt ZX_TRX_HEADERS_GT_U1)
181: INDEX(sumgt ZX_IMPORT_TAX_LINES_GT_U1)
182: INDEX(linegt ZX_TRANSACTION_LINES_GT_U1)*/
183: sumgt.summary_tax_line_number,
184: sumgt.internal_organization_id,
185: sumgt.tax_regime_code,
186: sumgt.tax,

Line 233: zx_transaction_lines_gt linegt

229: sumgt.attribute15,
230: sumgt.attribute_category
231: FROM zx_trx_headers_gt headergt,
232: zx_import_tax_lines_gt sumgt,
233: zx_transaction_lines_gt linegt
234: WHERE headergt.application_id = p_event_class_rec.application_id
235: AND headergt.event_class_code = p_event_class_rec.event_class_code
236: AND headergt.entity_code = p_event_class_rec.entity_code
237: AND headergt.trx_id = p_event_class_rec.trx_id

Line 255: INDEX(linegt ZX_TRANSACTION_LINES_GT_U1) */

251: CURSOR get_all_detail_tax_lines_csr IS
252: SELECT /*+ ORDERED
253: INDEX(headergt ZX_TRX_HEADERS_GT_U1)
254: INDEX(sumgt ZX_IMPORT_TAX_LINES_GT_U1)
255: INDEX(linegt ZX_TRANSACTION_LINES_GT_U1) */
256: sumgt.summary_tax_line_number,
257: sumgt.internal_organization_id,
258: sumgt.tax_regime_code,
259: sumgt.tax,

Line 306: zx_transaction_lines_gt linegt

302: sumgt.attribute15,
303: sumgt.attribute_category
304: FROM zx_trx_headers_gt headergt,
305: zx_import_tax_lines_gt sumgt,
306: zx_transaction_lines_gt linegt
307: WHERE headergt.application_id = p_event_class_rec.application_id
308: AND headergt.event_class_code = p_event_class_rec.event_class_code
309: AND headergt.entity_code = p_event_class_rec.entity_code
310: AND headergt.trx_id = p_event_class_rec.trx_id

Line 346: SELECT /+ INDEX(ZX_TRANSACTION_LINES_GT ZX_TRANSACTION_LINES_GT_U1) /

342: -- AND linegt.applied_to_application_id IS NULL --bug#6773534
343: ORDER BY sumgt.summary_tax_line_number;
344:
345: CURSOR get_total_trx_lines_amt_csr IS
346: SELECT /*+ INDEX(ZX_TRANSACTION_LINES_GT ZX_TRANSACTION_LINES_GT_U1) */
347: SUM(line_amt)
348: FROM zx_transaction_lines_gt
349: WHERE application_id = p_event_class_rec.application_id
350: AND event_class_code = p_event_class_rec.event_class_code

Line 348: FROM zx_transaction_lines_gt

344:
345: CURSOR get_total_trx_lines_amt_csr IS
346: SELECT /*+ INDEX(ZX_TRANSACTION_LINES_GT ZX_TRANSACTION_LINES_GT_U1) */
347: SUM(line_amt)
348: FROM zx_transaction_lines_gt
349: WHERE application_id = p_event_class_rec.application_id
350: AND event_class_code = p_event_class_rec.event_class_code
351: AND entity_code = p_event_class_rec.entity_code
352: AND trx_id = p_event_class_rec.trx_id

Line 381: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;

377: l_tax_id NUMBER;
378: l_begin_index BINARY_INTEGER;
379: l_end_index BINARY_INTEGER;
380: l_error_buffer VARCHAR2(240);
381: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
382: l_tax_class zx_rates_b.tax_class%TYPE;
383:
384: BEGIN
385: