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 83: INDEX(headergt ZX_TRX_HEADERS_GT_U1)

79: x_return_status OUT NOCOPY VARCHAR2) IS
80:
81: CURSOR get_alloc_detail_tax_lines_csr IS
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,

Line 118: FROM zx_trx_headers_gt headergt,

114: -- added for bug 5018766
115: linegt.tax_date ,
116: linegt.tax_determine_date ,
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

Line 146: INDEX(headergt ZX_TRX_HEADERS_GT_U1)

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

Line 180: FROM zx_trx_headers_gt headergt,

176: -- added for bug 5018766
177: linegt.tax_date ,
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

Line 202: INDEX(headergt ZX_TRX_HEADERS_GT_U1)

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

Line 236: FROM zx_trx_headers_gt headergt,

232: -- added for bug 5018766
233: linegt.tax_date ,
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