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_TAX_LINK_GT

Line 27: trx_line_id zx_trx_tax_link_gt.trx_line_id%TYPE,

23: tax_exception_id zx_import_tax_lines_gt.tax_exception_id%TYPE,
24: tax_exemption_id zx_import_tax_lines_gt.tax_exemption_id%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,

Line 28: line_amt zx_trx_tax_link_gt.line_amt%TYPE,

24: tax_exemption_id zx_import_tax_lines_gt.tax_exemption_id%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,

Line 102: INDEX(allocgt ZX_TRX_TAX_LINK_GT_U1)

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,
105: sumgt.internal_organization_id,
106: sumgt.tax_regime_code,

Line 154: zx_trx_tax_link_gt allocgt,

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
157: AND headergt.event_class_code = p_event_class_rec.event_class_code
158: AND headergt.entity_code = p_event_class_rec.entity_code

Line 359: SELECT /+ INDEX(ZX_TRX_TAX_LINK_GT ZX_TRX_TAX_LINK_GT_U1) /

355: AND adjusted_doc_application_id IS NULL;
356: -- AND applied_to_application_id IS NULL; --bug#6773534
357:
358: CURSOR get_total_alloc_lines_amt_csr(p_summary_tax_line_number NUMBER) IS
359: SELECT /*+ INDEX(ZX_TRX_TAX_LINK_GT ZX_TRX_TAX_LINK_GT_U1) */
360: SUM(line_amt)
361: FROM zx_trx_tax_link_gt
362: WHERE application_id = p_event_class_rec.application_id
363: AND event_class_code = p_event_class_rec.event_class_code

Line 361: FROM zx_trx_tax_link_gt

357:
358: CURSOR get_total_alloc_lines_amt_csr(p_summary_tax_line_number NUMBER) IS
359: SELECT /*+ INDEX(ZX_TRX_TAX_LINK_GT ZX_TRX_TAX_LINK_GT_U1) */
360: SUM(line_amt)
361: FROM zx_trx_tax_link_gt
362: WHERE application_id = p_event_class_rec.application_id
363: AND event_class_code = p_event_class_rec.event_class_code
364: AND entity_code = p_event_class_rec.entity_code
365: AND trx_id = p_event_class_rec.trx_id