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.

[Home] [Help]

APPS.ZX_TDS_IMPORT_DOCUMENT_PKG dependencies on ZX_IMPORT_TAX_LINES_GT

Line 13: summary_tax_line_number zx_import_tax_lines_gt.summary_tax_line_number%TYPE,

9:
10: NUMBER_DUMMY CONSTANT NUMBER := -999999999999;
11:
12: TYPE tax_line_rec_type is RECORD (
13: summary_tax_line_number zx_import_tax_lines_gt.summary_tax_line_number%TYPE,
14: internal_organization_id zx_import_tax_lines_gt.internal_organization_id%TYPE,
15: tax_regime_code zx_import_tax_lines_gt.tax_regime_code%TYPE,
16: tax zx_import_tax_lines_gt.tax%TYPE,
17: tax_status_code zx_import_tax_lines_gt.tax_status_code%TYPE,

Line 14: internal_organization_id zx_import_tax_lines_gt.internal_organization_id%TYPE,

10: NUMBER_DUMMY CONSTANT NUMBER := -999999999999;
11:
12: TYPE tax_line_rec_type is RECORD (
13: summary_tax_line_number zx_import_tax_lines_gt.summary_tax_line_number%TYPE,
14: internal_organization_id zx_import_tax_lines_gt.internal_organization_id%TYPE,
15: tax_regime_code zx_import_tax_lines_gt.tax_regime_code%TYPE,
16: tax zx_import_tax_lines_gt.tax%TYPE,
17: tax_status_code zx_import_tax_lines_gt.tax_status_code%TYPE,
18: tax_rate_code zx_import_tax_lines_gt.tax_rate_code%TYPE,

Line 15: tax_regime_code zx_import_tax_lines_gt.tax_regime_code%TYPE,

11:
12: TYPE tax_line_rec_type is RECORD (
13: summary_tax_line_number zx_import_tax_lines_gt.summary_tax_line_number%TYPE,
14: internal_organization_id zx_import_tax_lines_gt.internal_organization_id%TYPE,
15: tax_regime_code zx_import_tax_lines_gt.tax_regime_code%TYPE,
16: tax zx_import_tax_lines_gt.tax%TYPE,
17: tax_status_code zx_import_tax_lines_gt.tax_status_code%TYPE,
18: tax_rate_code zx_import_tax_lines_gt.tax_rate_code%TYPE,
19: tax_rate zx_import_tax_lines_gt.tax_rate%TYPE,

Line 16: tax zx_import_tax_lines_gt.tax%TYPE,

12: TYPE tax_line_rec_type is RECORD (
13: summary_tax_line_number zx_import_tax_lines_gt.summary_tax_line_number%TYPE,
14: internal_organization_id zx_import_tax_lines_gt.internal_organization_id%TYPE,
15: tax_regime_code zx_import_tax_lines_gt.tax_regime_code%TYPE,
16: tax zx_import_tax_lines_gt.tax%TYPE,
17: tax_status_code zx_import_tax_lines_gt.tax_status_code%TYPE,
18: tax_rate_code zx_import_tax_lines_gt.tax_rate_code%TYPE,
19: tax_rate zx_import_tax_lines_gt.tax_rate%TYPE,
20: summary_tax_amt zx_import_tax_lines_gt.tax_amt%TYPE,

Line 17: tax_status_code zx_import_tax_lines_gt.tax_status_code%TYPE,

13: summary_tax_line_number zx_import_tax_lines_gt.summary_tax_line_number%TYPE,
14: internal_organization_id zx_import_tax_lines_gt.internal_organization_id%TYPE,
15: tax_regime_code zx_import_tax_lines_gt.tax_regime_code%TYPE,
16: tax zx_import_tax_lines_gt.tax%TYPE,
17: tax_status_code zx_import_tax_lines_gt.tax_status_code%TYPE,
18: tax_rate_code zx_import_tax_lines_gt.tax_rate_code%TYPE,
19: tax_rate zx_import_tax_lines_gt.tax_rate%TYPE,
20: summary_tax_amt zx_import_tax_lines_gt.tax_amt%TYPE,
21: tax_jurisdiction_code zx_import_tax_lines_gt.tax_jurisdiction_code%TYPE,

Line 18: tax_rate_code zx_import_tax_lines_gt.tax_rate_code%TYPE,

14: internal_organization_id zx_import_tax_lines_gt.internal_organization_id%TYPE,
15: tax_regime_code zx_import_tax_lines_gt.tax_regime_code%TYPE,
16: tax zx_import_tax_lines_gt.tax%TYPE,
17: tax_status_code zx_import_tax_lines_gt.tax_status_code%TYPE,
18: tax_rate_code zx_import_tax_lines_gt.tax_rate_code%TYPE,
19: tax_rate zx_import_tax_lines_gt.tax_rate%TYPE,
20: summary_tax_amt zx_import_tax_lines_gt.tax_amt%TYPE,
21: tax_jurisdiction_code zx_import_tax_lines_gt.tax_jurisdiction_code%TYPE,
22: tax_amt_included_flag zx_import_tax_lines_gt.tax_amt_included_flag%TYPE,

Line 19: tax_rate zx_import_tax_lines_gt.tax_rate%TYPE,

15: tax_regime_code zx_import_tax_lines_gt.tax_regime_code%TYPE,
16: tax zx_import_tax_lines_gt.tax%TYPE,
17: tax_status_code zx_import_tax_lines_gt.tax_status_code%TYPE,
18: tax_rate_code zx_import_tax_lines_gt.tax_rate_code%TYPE,
19: tax_rate zx_import_tax_lines_gt.tax_rate%TYPE,
20: summary_tax_amt zx_import_tax_lines_gt.tax_amt%TYPE,
21: tax_jurisdiction_code zx_import_tax_lines_gt.tax_jurisdiction_code%TYPE,
22: tax_amt_included_flag zx_import_tax_lines_gt.tax_amt_included_flag%TYPE,
23: tax_exception_id zx_import_tax_lines_gt.tax_exception_id%TYPE,

Line 20: summary_tax_amt zx_import_tax_lines_gt.tax_amt%TYPE,

16: tax zx_import_tax_lines_gt.tax%TYPE,
17: tax_status_code zx_import_tax_lines_gt.tax_status_code%TYPE,
18: tax_rate_code zx_import_tax_lines_gt.tax_rate_code%TYPE,
19: tax_rate zx_import_tax_lines_gt.tax_rate%TYPE,
20: summary_tax_amt zx_import_tax_lines_gt.tax_amt%TYPE,
21: tax_jurisdiction_code zx_import_tax_lines_gt.tax_jurisdiction_code%TYPE,
22: tax_amt_included_flag zx_import_tax_lines_gt.tax_amt_included_flag%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,

Line 21: tax_jurisdiction_code zx_import_tax_lines_gt.tax_jurisdiction_code%TYPE,

17: tax_status_code zx_import_tax_lines_gt.tax_status_code%TYPE,
18: tax_rate_code zx_import_tax_lines_gt.tax_rate_code%TYPE,
19: tax_rate zx_import_tax_lines_gt.tax_rate%TYPE,
20: summary_tax_amt zx_import_tax_lines_gt.tax_amt%TYPE,
21: tax_jurisdiction_code zx_import_tax_lines_gt.tax_jurisdiction_code%TYPE,
22: tax_amt_included_flag zx_import_tax_lines_gt.tax_amt_included_flag%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,

Line 22: tax_amt_included_flag zx_import_tax_lines_gt.tax_amt_included_flag%TYPE,

18: tax_rate_code zx_import_tax_lines_gt.tax_rate_code%TYPE,
19: tax_rate zx_import_tax_lines_gt.tax_rate%TYPE,
20: summary_tax_amt zx_import_tax_lines_gt.tax_amt%TYPE,
21: tax_jurisdiction_code zx_import_tax_lines_gt.tax_jurisdiction_code%TYPE,
22: tax_amt_included_flag zx_import_tax_lines_gt.tax_amt_included_flag%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,

Line 23: tax_exception_id zx_import_tax_lines_gt.tax_exception_id%TYPE,

19: tax_rate zx_import_tax_lines_gt.tax_rate%TYPE,
20: summary_tax_amt zx_import_tax_lines_gt.tax_amt%TYPE,
21: tax_jurisdiction_code zx_import_tax_lines_gt.tax_jurisdiction_code%TYPE,
22: tax_amt_included_flag zx_import_tax_lines_gt.tax_amt_included_flag%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,

Line 24: tax_exemption_id zx_import_tax_lines_gt.tax_exemption_id%TYPE,

20: summary_tax_amt zx_import_tax_lines_gt.tax_amt%TYPE,
21: tax_jurisdiction_code zx_import_tax_lines_gt.tax_jurisdiction_code%TYPE,
22: tax_amt_included_flag zx_import_tax_lines_gt.tax_amt_included_flag%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,

Line 25: exempt_reason_code zx_import_tax_lines_gt.exempt_reason_code%TYPE,

21: tax_jurisdiction_code zx_import_tax_lines_gt.tax_jurisdiction_code%TYPE,
22: tax_amt_included_flag zx_import_tax_lines_gt.tax_amt_included_flag%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,

Line 26: exempt_certificate_number zx_import_tax_lines_gt.exempt_certificate_number%TYPE,

22: tax_amt_included_flag zx_import_tax_lines_gt.tax_amt_included_flag%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,

Line 36: interface_entity_code zx_import_tax_lines_gt.interface_entity_code%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,
40: -- added for bug 5018766

Line 37: interface_tax_line_id zx_import_tax_lines_gt.interface_tax_line_id%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,
40: -- added for bug 5018766
41: tax_date zx_transaction_lines_gt.tax_date%type,

Line 84: INDEX(sumgt ZX_IMPORT_TAX_LINES_GT_U1)

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,
88: sumgt.internal_organization_id,

Line 119: zx_import_tax_lines_gt sumgt,

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
123: AND headergt.event_class_code = p_event_class_rec.event_class_code

Line 147: INDEX(sumgt ZX_IMPORT_TAX_LINES_GT_U1)

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,
151: sumgt.tax_regime_code,

Line 181: zx_import_tax_lines_gt sumgt,

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
185: AND headergt.entity_code = p_event_class_rec.entity_code

Line 203: INDEX(sumgt ZX_IMPORT_TAX_LINES_GT_U1)

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,
207: sumgt.tax_regime_code,

Line 237: zx_import_tax_lines_gt sumgt,

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
241: AND headergt.entity_code = p_event_class_rec.entity_code

Line 945: l_tax_amt_included_flag zx_import_tax_lines_gt.tax_amt_included_flag%TYPE;

941: l_tax_id ZX_TAXES_B.tax_id%TYPE;
942: l_def_reg_type ZX_TAXES_B.def_registr_party_type_code%TYPE;
943: l_reg_rule_flg ZX_TAXES_B.registration_type_rule_flag%TYPE;
944: l_tax_rate zx_lines.tax_rate%TYPE;
945: l_tax_amt_included_flag zx_import_tax_lines_gt.tax_amt_included_flag%TYPE;
946:
947: BEGIN
948:
949: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;