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: );
45:

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: );
45:
46: PROCEDURE create_detail_tax_line (

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: );
45:
46: PROCEDURE create_detail_tax_line (
47: p_event_class_rec IN zx_api_pub.event_class_rec_type,

Line 86: INDEX(linegt ZX_TRANSACTION_LINES_GT_U1 )*/

82: SELECT /*+ ORDERED
83: INDEX(headergt ZX_TRX_HEADERS_GT_U1)
84: INDEX(sumgt ZX_IMPORT_TAX_LINES_GT_U1)
85: INDEX(allocgt ZX_TRX_TAX_LINK_GT_U1)
86: INDEX(linegt ZX_TRANSACTION_LINES_GT_U1 )*/
87: sumgt.summary_tax_line_number,
88: sumgt.internal_organization_id,
89: sumgt.tax_regime_code,
90: sumgt.tax,

Line 121: zx_transaction_lines_gt linegt

117: linegt.tax_point_date
118: FROM zx_trx_headers_gt headergt,
119: zx_import_tax_lines_gt sumgt,
120: zx_trx_tax_link_gt allocgt,
121: zx_transaction_lines_gt linegt
122: WHERE headergt.application_id = p_event_class_rec.application_id
123: AND headergt.event_class_code = p_event_class_rec.event_class_code
124: AND headergt.entity_code = p_event_class_rec.entity_code
125: AND headergt.trx_id = p_event_class_rec.trx_id

Line 148: INDEX(linegt ZX_TRANSACTION_LINES_GT_U1)*/

144: CURSOR get_one_alloc_det_tax_lines_cr IS
145: SELECT /*+ ORDERED
146: INDEX(headergt ZX_TRX_HEADERS_GT_U1)
147: INDEX(sumgt ZX_IMPORT_TAX_LINES_GT_U1)
148: INDEX(linegt ZX_TRANSACTION_LINES_GT_U1)*/
149: sumgt.summary_tax_line_number,
150: sumgt.internal_organization_id,
151: sumgt.tax_regime_code,
152: sumgt.tax,

Line 182: zx_transaction_lines_gt linegt

178: linegt.tax_determine_date ,
179: linegt.tax_point_date
180: FROM zx_trx_headers_gt headergt,
181: zx_import_tax_lines_gt sumgt,
182: zx_transaction_lines_gt linegt
183: WHERE headergt.application_id = p_event_class_rec.application_id
184: AND headergt.event_class_code = p_event_class_rec.event_class_code
185: AND headergt.entity_code = p_event_class_rec.entity_code
186: AND headergt.trx_id = p_event_class_rec.trx_id

Line 204: INDEX(linegt ZX_TRANSACTION_LINES_GT_U1) */

200: CURSOR get_all_detail_tax_lines_csr IS
201: SELECT /*+ ORDERED
202: INDEX(headergt ZX_TRX_HEADERS_GT_U1)
203: INDEX(sumgt ZX_IMPORT_TAX_LINES_GT_U1)
204: INDEX(linegt ZX_TRANSACTION_LINES_GT_U1) */
205: sumgt.summary_tax_line_number,
206: sumgt.internal_organization_id,
207: sumgt.tax_regime_code,
208: sumgt.tax,

Line 238: zx_transaction_lines_gt linegt

234: linegt.tax_determine_date ,
235: linegt.tax_point_date
236: FROM zx_trx_headers_gt headergt,
237: zx_import_tax_lines_gt sumgt,
238: zx_transaction_lines_gt linegt
239: WHERE headergt.application_id = p_event_class_rec.application_id
240: AND headergt.event_class_code = p_event_class_rec.event_class_code
241: AND headergt.entity_code = p_event_class_rec.entity_code
242: AND headergt.trx_id = p_event_class_rec.trx_id

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

274: -- AND linegt.applied_to_application_id IS NULL --bug#6773534
275: ORDER BY sumgt.summary_tax_line_number;
276:
277: CURSOR get_total_trx_lines_amt_csr IS
278: SELECT /*+ INDEX(ZX_TRANSACTION_LINES_GT ZX_TRANSACTION_LINES_GT_U1) */
279: SUM(line_amt)
280: FROM zx_transaction_lines_gt
281: WHERE application_id = p_event_class_rec.application_id
282: AND event_class_code = p_event_class_rec.event_class_code

Line 280: FROM zx_transaction_lines_gt

276:
277: CURSOR get_total_trx_lines_amt_csr IS
278: SELECT /*+ INDEX(ZX_TRANSACTION_LINES_GT ZX_TRANSACTION_LINES_GT_U1) */
279: SUM(line_amt)
280: FROM zx_transaction_lines_gt
281: WHERE application_id = p_event_class_rec.application_id
282: AND event_class_code = p_event_class_rec.event_class_code
283: AND entity_code = p_event_class_rec.entity_code
284: AND trx_id = p_event_class_rec.trx_id

Line 313: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;

309: l_tax_id NUMBER;
310: l_begin_index BINARY_INTEGER;
311: l_end_index BINARY_INTEGER;
312: l_error_buffer VARCHAR2(240);
313: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
314: l_tax_class zx_rates_b.tax_class%TYPE;
315:
316: BEGIN
317: