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 29: summary_tax_line_number zx_import_tax_lines_gt.summary_tax_line_number%TYPE,

25: pg_tax_rate_passed ar_vat_tax.tax_rate%TYPE;
26: pg_adhoc_tax_code VARCHAR2(1);
27:
28: TYPE tax_line_rec_type is RECORD (
29: summary_tax_line_number zx_import_tax_lines_gt.summary_tax_line_number%TYPE,
30: internal_organization_id zx_import_tax_lines_gt.internal_organization_id%TYPE,
31: tax_regime_code zx_import_tax_lines_gt.tax_regime_code%TYPE,
32: tax zx_import_tax_lines_gt.tax%TYPE,
33: tax_status_code zx_import_tax_lines_gt.tax_status_code%TYPE,

Line 30: internal_organization_id zx_import_tax_lines_gt.internal_organization_id%TYPE,

26: pg_adhoc_tax_code VARCHAR2(1);
27:
28: TYPE tax_line_rec_type is RECORD (
29: summary_tax_line_number zx_import_tax_lines_gt.summary_tax_line_number%TYPE,
30: internal_organization_id zx_import_tax_lines_gt.internal_organization_id%TYPE,
31: tax_regime_code zx_import_tax_lines_gt.tax_regime_code%TYPE,
32: tax zx_import_tax_lines_gt.tax%TYPE,
33: tax_status_code zx_import_tax_lines_gt.tax_status_code%TYPE,
34: tax_rate_code zx_import_tax_lines_gt.tax_rate_code%TYPE,

Line 31: tax_regime_code zx_import_tax_lines_gt.tax_regime_code%TYPE,

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

Line 32: tax zx_import_tax_lines_gt.tax%TYPE,

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

Line 33: tax_status_code zx_import_tax_lines_gt.tax_status_code%TYPE,

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

Line 34: tax_rate_code zx_import_tax_lines_gt.tax_rate_code%TYPE,

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

Line 35: tax_rate zx_import_tax_lines_gt.tax_rate%TYPE,

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

Line 36: tax_amt zx_import_tax_lines_gt.tax_amt%TYPE,

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

Line 37: tax_jurisdiction_code zx_import_tax_lines_gt.tax_jurisdiction_code%TYPE,

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

Line 38: tax_amt_included_flag zx_import_tax_lines_gt.tax_amt_included_flag%TYPE,

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

Line 39: tax_rate_id zx_import_tax_lines_gt.tax_rate_id%TYPE,

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

Line 40: tax_provider_id zx_import_tax_lines_gt.tax_provider_id%TYPE,

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

Line 41: tax_exception_id zx_import_tax_lines_gt.tax_exception_id%TYPE,

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

Line 42: tax_exemption_id zx_import_tax_lines_gt.tax_exemption_id%TYPE,

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

Line 43: exempt_reason_code zx_import_tax_lines_gt.exempt_reason_code%TYPE,

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

Line 44: exempt_certificate_number zx_import_tax_lines_gt.exempt_certificate_number%TYPE,

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

Line 1557: FROM zx_import_tax_lines_gt taxgt,

1553: ,taxgt.EXEMPT_CERTIFICATE_NUMBER
1554: ,allocgt.TRX_LEVEL_TYPE
1555: ,allocgt.TRX_LINE_ID
1556: ,allocgt.LINE_AMT
1557: FROM zx_import_tax_lines_gt taxgt,
1558: zx_trx_tax_link_gt allocgt
1559: WHERE taxgt.application_id = p_event_class_rec.application_id
1560: AND taxgt.entity_code = p_event_class_rec.entity_code
1561: AND taxgt.event_class_code = p_event_class_rec.event_class_code