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_PRODUCT_INTEGRATION_PKG dependencies on ZX_IMPORT_TAX_LINES_GT

Line 30: summary_tax_line_number zx_import_tax_lines_gt.summary_tax_line_number%TYPE,

26: pg_adhoc_tax_code VARCHAR2(1);
27:
28: -- Record Type modified as a fix for Bug#7530930
29: TYPE tax_line_rec_type is RECORD (
30: summary_tax_line_number zx_import_tax_lines_gt.summary_tax_line_number%TYPE,
31: internal_organization_id zx_import_tax_lines_gt.internal_organization_id%TYPE,
32: tax_regime_code zx_import_tax_lines_gt.tax_regime_code%TYPE,
33: tax zx_import_tax_lines_gt.tax%TYPE,
34: tax_status_code zx_import_tax_lines_gt.tax_status_code%TYPE,

Line 31: internal_organization_id zx_import_tax_lines_gt.internal_organization_id%TYPE,

27:
28: -- Record Type modified as a fix for Bug#7530930
29: TYPE tax_line_rec_type is RECORD (
30: summary_tax_line_number zx_import_tax_lines_gt.summary_tax_line_number%TYPE,
31: internal_organization_id zx_import_tax_lines_gt.internal_organization_id%TYPE,
32: tax_regime_code zx_import_tax_lines_gt.tax_regime_code%TYPE,
33: tax zx_import_tax_lines_gt.tax%TYPE,
34: tax_status_code zx_import_tax_lines_gt.tax_status_code%TYPE,
35: tax_rate_code zx_import_tax_lines_gt.tax_rate_code%TYPE,

Line 32: tax_regime_code zx_import_tax_lines_gt.tax_regime_code%TYPE,

28: -- Record Type modified as a fix for Bug#7530930
29: TYPE tax_line_rec_type is RECORD (
30: summary_tax_line_number zx_import_tax_lines_gt.summary_tax_line_number%TYPE,
31: internal_organization_id zx_import_tax_lines_gt.internal_organization_id%TYPE,
32: tax_regime_code zx_import_tax_lines_gt.tax_regime_code%TYPE,
33: tax zx_import_tax_lines_gt.tax%TYPE,
34: tax_status_code zx_import_tax_lines_gt.tax_status_code%TYPE,
35: tax_rate_code zx_import_tax_lines_gt.tax_rate_code%TYPE,
36: tax_rate zx_import_tax_lines_gt.tax_rate%TYPE,

Line 33: tax zx_import_tax_lines_gt.tax%TYPE,

29: TYPE tax_line_rec_type is RECORD (
30: summary_tax_line_number zx_import_tax_lines_gt.summary_tax_line_number%TYPE,
31: internal_organization_id zx_import_tax_lines_gt.internal_organization_id%TYPE,
32: tax_regime_code zx_import_tax_lines_gt.tax_regime_code%TYPE,
33: tax zx_import_tax_lines_gt.tax%TYPE,
34: tax_status_code zx_import_tax_lines_gt.tax_status_code%TYPE,
35: tax_rate_code zx_import_tax_lines_gt.tax_rate_code%TYPE,
36: tax_rate zx_import_tax_lines_gt.tax_rate%TYPE,
37: tax_amt zx_import_tax_lines_gt.tax_amt%TYPE,

Line 34: tax_status_code zx_import_tax_lines_gt.tax_status_code%TYPE,

30: summary_tax_line_number zx_import_tax_lines_gt.summary_tax_line_number%TYPE,
31: internal_organization_id zx_import_tax_lines_gt.internal_organization_id%TYPE,
32: tax_regime_code zx_import_tax_lines_gt.tax_regime_code%TYPE,
33: tax zx_import_tax_lines_gt.tax%TYPE,
34: tax_status_code zx_import_tax_lines_gt.tax_status_code%TYPE,
35: tax_rate_code zx_import_tax_lines_gt.tax_rate_code%TYPE,
36: tax_rate zx_import_tax_lines_gt.tax_rate%TYPE,
37: tax_amt zx_import_tax_lines_gt.tax_amt%TYPE,
38: tax_jurisdiction_code zx_import_tax_lines_gt.tax_jurisdiction_code%TYPE,

Line 35: tax_rate_code zx_import_tax_lines_gt.tax_rate_code%TYPE,

31: internal_organization_id zx_import_tax_lines_gt.internal_organization_id%TYPE,
32: tax_regime_code zx_import_tax_lines_gt.tax_regime_code%TYPE,
33: tax zx_import_tax_lines_gt.tax%TYPE,
34: tax_status_code zx_import_tax_lines_gt.tax_status_code%TYPE,
35: tax_rate_code zx_import_tax_lines_gt.tax_rate_code%TYPE,
36: tax_rate zx_import_tax_lines_gt.tax_rate%TYPE,
37: tax_amt zx_import_tax_lines_gt.tax_amt%TYPE,
38: tax_jurisdiction_code zx_import_tax_lines_gt.tax_jurisdiction_code%TYPE,
39: tax_amt_included_flag zx_import_tax_lines_gt.tax_amt_included_flag%TYPE,

Line 36: tax_rate zx_import_tax_lines_gt.tax_rate%TYPE,

32: tax_regime_code zx_import_tax_lines_gt.tax_regime_code%TYPE,
33: tax zx_import_tax_lines_gt.tax%TYPE,
34: tax_status_code zx_import_tax_lines_gt.tax_status_code%TYPE,
35: tax_rate_code zx_import_tax_lines_gt.tax_rate_code%TYPE,
36: tax_rate zx_import_tax_lines_gt.tax_rate%TYPE,
37: tax_amt zx_import_tax_lines_gt.tax_amt%TYPE,
38: tax_jurisdiction_code zx_import_tax_lines_gt.tax_jurisdiction_code%TYPE,
39: tax_amt_included_flag zx_import_tax_lines_gt.tax_amt_included_flag%TYPE,
40: tax_rate_id zx_import_tax_lines_gt.tax_rate_id%TYPE,

Line 37: tax_amt zx_import_tax_lines_gt.tax_amt%TYPE,

33: tax zx_import_tax_lines_gt.tax%TYPE,
34: tax_status_code zx_import_tax_lines_gt.tax_status_code%TYPE,
35: tax_rate_code zx_import_tax_lines_gt.tax_rate_code%TYPE,
36: tax_rate zx_import_tax_lines_gt.tax_rate%TYPE,
37: tax_amt zx_import_tax_lines_gt.tax_amt%TYPE,
38: tax_jurisdiction_code zx_import_tax_lines_gt.tax_jurisdiction_code%TYPE,
39: tax_amt_included_flag zx_import_tax_lines_gt.tax_amt_included_flag%TYPE,
40: tax_rate_id zx_import_tax_lines_gt.tax_rate_id%TYPE,
41: tax_provider_id zx_import_tax_lines_gt.tax_provider_id%TYPE,

Line 38: tax_jurisdiction_code zx_import_tax_lines_gt.tax_jurisdiction_code%TYPE,

34: tax_status_code zx_import_tax_lines_gt.tax_status_code%TYPE,
35: tax_rate_code zx_import_tax_lines_gt.tax_rate_code%TYPE,
36: tax_rate zx_import_tax_lines_gt.tax_rate%TYPE,
37: tax_amt zx_import_tax_lines_gt.tax_amt%TYPE,
38: tax_jurisdiction_code zx_import_tax_lines_gt.tax_jurisdiction_code%TYPE,
39: tax_amt_included_flag zx_import_tax_lines_gt.tax_amt_included_flag%TYPE,
40: tax_rate_id zx_import_tax_lines_gt.tax_rate_id%TYPE,
41: tax_provider_id zx_import_tax_lines_gt.tax_provider_id%TYPE,
42: tax_exception_id zx_import_tax_lines_gt.tax_exception_id%TYPE,

Line 39: tax_amt_included_flag zx_import_tax_lines_gt.tax_amt_included_flag%TYPE,

35: tax_rate_code zx_import_tax_lines_gt.tax_rate_code%TYPE,
36: tax_rate zx_import_tax_lines_gt.tax_rate%TYPE,
37: tax_amt zx_import_tax_lines_gt.tax_amt%TYPE,
38: tax_jurisdiction_code zx_import_tax_lines_gt.tax_jurisdiction_code%TYPE,
39: tax_amt_included_flag zx_import_tax_lines_gt.tax_amt_included_flag%TYPE,
40: tax_rate_id zx_import_tax_lines_gt.tax_rate_id%TYPE,
41: tax_provider_id zx_import_tax_lines_gt.tax_provider_id%TYPE,
42: tax_exception_id zx_import_tax_lines_gt.tax_exception_id%TYPE,
43: tax_exemption_id zx_import_tax_lines_gt.tax_exemption_id%TYPE,

Line 40: tax_rate_id zx_import_tax_lines_gt.tax_rate_id%TYPE,

36: tax_rate zx_import_tax_lines_gt.tax_rate%TYPE,
37: tax_amt zx_import_tax_lines_gt.tax_amt%TYPE,
38: tax_jurisdiction_code zx_import_tax_lines_gt.tax_jurisdiction_code%TYPE,
39: tax_amt_included_flag zx_import_tax_lines_gt.tax_amt_included_flag%TYPE,
40: tax_rate_id zx_import_tax_lines_gt.tax_rate_id%TYPE,
41: tax_provider_id zx_import_tax_lines_gt.tax_provider_id%TYPE,
42: tax_exception_id zx_import_tax_lines_gt.tax_exception_id%TYPE,
43: tax_exemption_id zx_import_tax_lines_gt.tax_exemption_id%TYPE,
44: exempt_reason_code zx_import_tax_lines_gt.exempt_reason_code%TYPE,

Line 41: tax_provider_id zx_import_tax_lines_gt.tax_provider_id%TYPE,

37: tax_amt zx_import_tax_lines_gt.tax_amt%TYPE,
38: tax_jurisdiction_code zx_import_tax_lines_gt.tax_jurisdiction_code%TYPE,
39: tax_amt_included_flag zx_import_tax_lines_gt.tax_amt_included_flag%TYPE,
40: tax_rate_id zx_import_tax_lines_gt.tax_rate_id%TYPE,
41: tax_provider_id zx_import_tax_lines_gt.tax_provider_id%TYPE,
42: tax_exception_id zx_import_tax_lines_gt.tax_exception_id%TYPE,
43: tax_exemption_id zx_import_tax_lines_gt.tax_exemption_id%TYPE,
44: exempt_reason_code zx_import_tax_lines_gt.exempt_reason_code%TYPE,
45: exempt_certificate_number zx_import_tax_lines_gt.exempt_certificate_number%TYPE,

Line 42: tax_exception_id zx_import_tax_lines_gt.tax_exception_id%TYPE,

38: tax_jurisdiction_code zx_import_tax_lines_gt.tax_jurisdiction_code%TYPE,
39: tax_amt_included_flag zx_import_tax_lines_gt.tax_amt_included_flag%TYPE,
40: tax_rate_id zx_import_tax_lines_gt.tax_rate_id%TYPE,
41: tax_provider_id zx_import_tax_lines_gt.tax_provider_id%TYPE,
42: tax_exception_id zx_import_tax_lines_gt.tax_exception_id%TYPE,
43: tax_exemption_id zx_import_tax_lines_gt.tax_exemption_id%TYPE,
44: exempt_reason_code zx_import_tax_lines_gt.exempt_reason_code%TYPE,
45: exempt_certificate_number zx_import_tax_lines_gt.exempt_certificate_number%TYPE,
46: trx_line_id zx_transaction_lines_gt.trx_line_id%TYPE,

Line 43: tax_exemption_id zx_import_tax_lines_gt.tax_exemption_id%TYPE,

39: tax_amt_included_flag zx_import_tax_lines_gt.tax_amt_included_flag%TYPE,
40: tax_rate_id zx_import_tax_lines_gt.tax_rate_id%TYPE,
41: tax_provider_id zx_import_tax_lines_gt.tax_provider_id%TYPE,
42: tax_exception_id zx_import_tax_lines_gt.tax_exception_id%TYPE,
43: tax_exemption_id zx_import_tax_lines_gt.tax_exemption_id%TYPE,
44: exempt_reason_code zx_import_tax_lines_gt.exempt_reason_code%TYPE,
45: exempt_certificate_number zx_import_tax_lines_gt.exempt_certificate_number%TYPE,
46: trx_line_id zx_transaction_lines_gt.trx_line_id%TYPE,
47: line_amt zx_transaction_lines_gt.line_amt%TYPE,

Line 44: exempt_reason_code zx_import_tax_lines_gt.exempt_reason_code%TYPE,

40: tax_rate_id zx_import_tax_lines_gt.tax_rate_id%TYPE,
41: tax_provider_id zx_import_tax_lines_gt.tax_provider_id%TYPE,
42: tax_exception_id zx_import_tax_lines_gt.tax_exception_id%TYPE,
43: tax_exemption_id zx_import_tax_lines_gt.tax_exemption_id%TYPE,
44: exempt_reason_code zx_import_tax_lines_gt.exempt_reason_code%TYPE,
45: exempt_certificate_number zx_import_tax_lines_gt.exempt_certificate_number%TYPE,
46: trx_line_id zx_transaction_lines_gt.trx_line_id%TYPE,
47: line_amt zx_transaction_lines_gt.line_amt%TYPE,
48: trx_date zx_trx_headers_gt.trx_date%TYPE,

Line 45: exempt_certificate_number zx_import_tax_lines_gt.exempt_certificate_number%TYPE,

41: tax_provider_id zx_import_tax_lines_gt.tax_provider_id%TYPE,
42: tax_exception_id zx_import_tax_lines_gt.tax_exception_id%TYPE,
43: tax_exemption_id zx_import_tax_lines_gt.tax_exemption_id%TYPE,
44: exempt_reason_code zx_import_tax_lines_gt.exempt_reason_code%TYPE,
45: exempt_certificate_number zx_import_tax_lines_gt.exempt_certificate_number%TYPE,
46: trx_line_id zx_transaction_lines_gt.trx_line_id%TYPE,
47: line_amt zx_transaction_lines_gt.line_amt%TYPE,
48: trx_date zx_trx_headers_gt.trx_date%TYPE,
49: minimum_accountable_unit zx_trx_headers_gt.minimum_accountable_unit%TYPE,

Line 55: interface_entity_code zx_import_tax_lines_gt.interface_entity_code%TYPE,

51: trx_level_type zx_transaction_lines_gt.trx_level_type%TYPE,
52: trx_line_date zx_transaction_lines_gt.trx_line_date%TYPE,
53: adjusted_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE,
54: line_level_action zx_transaction_lines_gt.line_level_action%TYPE,
55: interface_entity_code zx_import_tax_lines_gt.interface_entity_code%TYPE,
56: interface_tax_line_id zx_import_tax_lines_gt.interface_tax_line_id%TYPE,
57: related_doc_date zx_trx_headers_gt.related_doc_date%TYPE,
58: provnl_tax_determination_date zx_trx_headers_gt.provnl_tax_determination_date%TYPE,
59: tax_date zx_transaction_lines_gt.tax_date%type,

Line 56: interface_tax_line_id zx_import_tax_lines_gt.interface_tax_line_id%TYPE,

52: trx_line_date zx_transaction_lines_gt.trx_line_date%TYPE,
53: adjusted_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE,
54: line_level_action zx_transaction_lines_gt.line_level_action%TYPE,
55: interface_entity_code zx_import_tax_lines_gt.interface_entity_code%TYPE,
56: interface_tax_line_id zx_import_tax_lines_gt.interface_tax_line_id%TYPE,
57: related_doc_date zx_trx_headers_gt.related_doc_date%TYPE,
58: provnl_tax_determination_date zx_trx_headers_gt.provnl_tax_determination_date%TYPE,
59: tax_date zx_transaction_lines_gt.tax_date%type,
60: tax_determine_date zx_transaction_lines_gt.tax_determine_date%type,

Line 1829: INDEX(taxgt ZX_IMPORT_TAX_LINES_GT_U1)

1825:
1826: CURSOR get_detail_tax_lines_csr IS
1827: SELECT /*+ ORDERED
1828: INDEX(headergt ZX_TRX_HEADERS_GT_U1)
1829: INDEX(taxgt ZX_IMPORT_TAX_LINES_GT_U1)
1830: INDEX(linegt ZX_TRANSACTION_LINES_GT_U1)*/
1831: taxgt.summary_tax_line_number,
1832: taxgt.internal_organization_id,
1833: taxgt.tax_regime_code,

Line 1864: zx_import_tax_lines_gt taxgt,

1860: linegt.tax_date ,
1861: linegt.tax_determine_date,
1862: linegt.tax_point_date
1863: FROM zx_trx_headers_gt headergt,
1864: zx_import_tax_lines_gt taxgt,
1865: zx_transaction_lines_gt linegt
1866: WHERE headergt.application_id = p_event_class_rec.application_id
1867: AND headergt.event_class_code = p_event_class_rec.event_class_code
1868: AND headergt.entity_code = p_event_class_rec.entity_code