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_TRX_HEADERS_GT

Line 29: trx_date zx_trx_headers_gt.trx_date%TYPE,

25: exempt_reason_code zx_import_tax_lines_gt.exempt_reason_code%TYPE,
26: exempt_certificate_number zx_import_tax_lines_gt.exempt_certificate_number%TYPE,
27: trx_line_id zx_trx_tax_link_gt.trx_line_id%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,

Line 30: minimum_accountable_unit zx_trx_headers_gt.minimum_accountable_unit%TYPE,

26: exempt_certificate_number zx_import_tax_lines_gt.exempt_certificate_number%TYPE,
27: trx_line_id zx_trx_tax_link_gt.trx_line_id%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,

Line 31: precision zx_trx_headers_gt.precision%TYPE,

27: trx_line_id zx_trx_tax_link_gt.trx_line_id%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,

Line 38: related_doc_date zx_trx_headers_gt.related_doc_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,
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,

Line 39: provnl_tax_determination_date zx_trx_headers_gt.provnl_tax_determination_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,
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,

Line 100: INDEX(headergt ZX_TRX_HEADERS_GT_U1)

96: x_return_status OUT NOCOPY VARCHAR2) IS
97:
98: CURSOR get_alloc_detail_tax_lines_csr IS
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,

Line 152: FROM zx_trx_headers_gt headergt,

148: sumgt.attribute13,
149: sumgt.attribute14,
150: sumgt.attribute15,
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

Line 180: INDEX(headergt ZX_TRX_HEADERS_GT_U1)

176: ORDER BY sumgt.summary_tax_line_number;
177:
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,

Line 231: FROM zx_trx_headers_gt headergt,

227: sumgt.attribute13,
228: sumgt.attribute14,
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

Line 253: INDEX(headergt ZX_TRX_HEADERS_GT_U1)

249: ORDER BY sumgt.summary_tax_line_number;
250:
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,

Line 304: FROM zx_trx_headers_gt headergt,

300: sumgt.attribute13,
301: sumgt.attribute14,
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