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_TRL_ALLOCATIONS_PKG dependencies on ZX_LINES_SUMMARY

Line 144: FROM zx_lines_det_factors zxd, zx_lines_summary zxs

140: FROM dual;
141:
142: SELECT DISTINCT precision,minimum_accountable_unit,trx_currency_code
143: INTO l_precision, l_minimum_accountable_unit, l_trx_currency_code
144: FROM zx_lines_det_factors zxd, zx_lines_summary zxs
145: WHERE zxd.trx_id = zxs.trx_id
146: AND zxs.summary_tax_line_id = p_summary_tax_line_id;
147:
148: ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_row

Line 526: FROM ZX_LINES_SUMMARY

522:
523: IF p_tax_amt IS NULL THEN
524: SELECT TAX_AMT
525: INTO l_summary_tax_amt
526: FROM ZX_LINES_SUMMARY
527: WHERE SUMMARY_TAX_LINE_ID = p_summary_tax_line_id;
528: ELSE
529: l_summary_tax_amt := p_tax_amt;
530: END IF;

Line 838: l_ledger_id ZX_LINES_SUMMARY.ledger_id%TYPE;

834: AND tax_regime_code = c_tax_regime_code
835: ORDER BY subscription_level_code;
836:
837: -- Added for reallocation feature --
838: l_ledger_id ZX_LINES_SUMMARY.ledger_id%TYPE;
839: l_legal_entity_id ZX_LINES_SUMMARY.legal_entity_id%TYPE;
840: l_establishment_id ZX_LINES_SUMMARY.establishment_id%TYPE;
841: l_currency_conversion_date ZX_LINES_SUMMARY.currency_conversion_date%TYPE;
842: l_currency_conversion_type ZX_LINES_SUMMARY.currency_conversion_type%TYPE;

Line 839: l_legal_entity_id ZX_LINES_SUMMARY.legal_entity_id%TYPE;

835: ORDER BY subscription_level_code;
836:
837: -- Added for reallocation feature --
838: l_ledger_id ZX_LINES_SUMMARY.ledger_id%TYPE;
839: l_legal_entity_id ZX_LINES_SUMMARY.legal_entity_id%TYPE;
840: l_establishment_id ZX_LINES_SUMMARY.establishment_id%TYPE;
841: l_currency_conversion_date ZX_LINES_SUMMARY.currency_conversion_date%TYPE;
842: l_currency_conversion_type ZX_LINES_SUMMARY.currency_conversion_type%TYPE;
843: l_currency_conversion_rate ZX_LINES_SUMMARY.currency_conversion_rate%TYPE;

Line 840: l_establishment_id ZX_LINES_SUMMARY.establishment_id%TYPE;

836:
837: -- Added for reallocation feature --
838: l_ledger_id ZX_LINES_SUMMARY.ledger_id%TYPE;
839: l_legal_entity_id ZX_LINES_SUMMARY.legal_entity_id%TYPE;
840: l_establishment_id ZX_LINES_SUMMARY.establishment_id%TYPE;
841: l_currency_conversion_date ZX_LINES_SUMMARY.currency_conversion_date%TYPE;
842: l_currency_conversion_type ZX_LINES_SUMMARY.currency_conversion_type%TYPE;
843: l_currency_conversion_rate ZX_LINES_SUMMARY.currency_conversion_rate%TYPE;
844: l_taxable_basis_formula ZX_LINES_SUMMARY.taxable_basis_formula%TYPE;

Line 841: l_currency_conversion_date ZX_LINES_SUMMARY.currency_conversion_date%TYPE;

837: -- Added for reallocation feature --
838: l_ledger_id ZX_LINES_SUMMARY.ledger_id%TYPE;
839: l_legal_entity_id ZX_LINES_SUMMARY.legal_entity_id%TYPE;
840: l_establishment_id ZX_LINES_SUMMARY.establishment_id%TYPE;
841: l_currency_conversion_date ZX_LINES_SUMMARY.currency_conversion_date%TYPE;
842: l_currency_conversion_type ZX_LINES_SUMMARY.currency_conversion_type%TYPE;
843: l_currency_conversion_rate ZX_LINES_SUMMARY.currency_conversion_rate%TYPE;
844: l_taxable_basis_formula ZX_LINES_SUMMARY.taxable_basis_formula%TYPE;
845: l_tax_calculation_formula ZX_LINES_SUMMARY.tax_calculation_formula%TYPE;

Line 842: l_currency_conversion_type ZX_LINES_SUMMARY.currency_conversion_type%TYPE;

838: l_ledger_id ZX_LINES_SUMMARY.ledger_id%TYPE;
839: l_legal_entity_id ZX_LINES_SUMMARY.legal_entity_id%TYPE;
840: l_establishment_id ZX_LINES_SUMMARY.establishment_id%TYPE;
841: l_currency_conversion_date ZX_LINES_SUMMARY.currency_conversion_date%TYPE;
842: l_currency_conversion_type ZX_LINES_SUMMARY.currency_conversion_type%TYPE;
843: l_currency_conversion_rate ZX_LINES_SUMMARY.currency_conversion_rate%TYPE;
844: l_taxable_basis_formula ZX_LINES_SUMMARY.taxable_basis_formula%TYPE;
845: l_tax_calculation_formula ZX_LINES_SUMMARY.tax_calculation_formula%TYPE;
846: l_tax_exemption_id ZX_LINES_SUMMARY.tax_exemption_id%TYPE;

Line 843: l_currency_conversion_rate ZX_LINES_SUMMARY.currency_conversion_rate%TYPE;

839: l_legal_entity_id ZX_LINES_SUMMARY.legal_entity_id%TYPE;
840: l_establishment_id ZX_LINES_SUMMARY.establishment_id%TYPE;
841: l_currency_conversion_date ZX_LINES_SUMMARY.currency_conversion_date%TYPE;
842: l_currency_conversion_type ZX_LINES_SUMMARY.currency_conversion_type%TYPE;
843: l_currency_conversion_rate ZX_LINES_SUMMARY.currency_conversion_rate%TYPE;
844: l_taxable_basis_formula ZX_LINES_SUMMARY.taxable_basis_formula%TYPE;
845: l_tax_calculation_formula ZX_LINES_SUMMARY.tax_calculation_formula%TYPE;
846: l_tax_exemption_id ZX_LINES_SUMMARY.tax_exemption_id%TYPE;
847: l_exempt_certificate_number ZX_LINES_SUMMARY.exempt_certificate_number%TYPE;

Line 844: l_taxable_basis_formula ZX_LINES_SUMMARY.taxable_basis_formula%TYPE;

840: l_establishment_id ZX_LINES_SUMMARY.establishment_id%TYPE;
841: l_currency_conversion_date ZX_LINES_SUMMARY.currency_conversion_date%TYPE;
842: l_currency_conversion_type ZX_LINES_SUMMARY.currency_conversion_type%TYPE;
843: l_currency_conversion_rate ZX_LINES_SUMMARY.currency_conversion_rate%TYPE;
844: l_taxable_basis_formula ZX_LINES_SUMMARY.taxable_basis_formula%TYPE;
845: l_tax_calculation_formula ZX_LINES_SUMMARY.tax_calculation_formula%TYPE;
846: l_tax_exemption_id ZX_LINES_SUMMARY.tax_exemption_id%TYPE;
847: l_exempt_certificate_number ZX_LINES_SUMMARY.exempt_certificate_number%TYPE;
848: l_exempt_reason_code ZX_LINES_SUMMARY.exempt_reason_code%TYPE;

Line 845: l_tax_calculation_formula ZX_LINES_SUMMARY.tax_calculation_formula%TYPE;

841: l_currency_conversion_date ZX_LINES_SUMMARY.currency_conversion_date%TYPE;
842: l_currency_conversion_type ZX_LINES_SUMMARY.currency_conversion_type%TYPE;
843: l_currency_conversion_rate ZX_LINES_SUMMARY.currency_conversion_rate%TYPE;
844: l_taxable_basis_formula ZX_LINES_SUMMARY.taxable_basis_formula%TYPE;
845: l_tax_calculation_formula ZX_LINES_SUMMARY.tax_calculation_formula%TYPE;
846: l_tax_exemption_id ZX_LINES_SUMMARY.tax_exemption_id%TYPE;
847: l_exempt_certificate_number ZX_LINES_SUMMARY.exempt_certificate_number%TYPE;
848: l_exempt_reason_code ZX_LINES_SUMMARY.exempt_reason_code%TYPE;
849: l_tax_exception_id ZX_LINES_SUMMARY.tax_exception_id%TYPE;

Line 846: l_tax_exemption_id ZX_LINES_SUMMARY.tax_exemption_id%TYPE;

842: l_currency_conversion_type ZX_LINES_SUMMARY.currency_conversion_type%TYPE;
843: l_currency_conversion_rate ZX_LINES_SUMMARY.currency_conversion_rate%TYPE;
844: l_taxable_basis_formula ZX_LINES_SUMMARY.taxable_basis_formula%TYPE;
845: l_tax_calculation_formula ZX_LINES_SUMMARY.tax_calculation_formula%TYPE;
846: l_tax_exemption_id ZX_LINES_SUMMARY.tax_exemption_id%TYPE;
847: l_exempt_certificate_number ZX_LINES_SUMMARY.exempt_certificate_number%TYPE;
848: l_exempt_reason_code ZX_LINES_SUMMARY.exempt_reason_code%TYPE;
849: l_tax_exception_id ZX_LINES_SUMMARY.tax_exception_id%TYPE;
850: l_tax_provider_id ZX_LINES_SUMMARY.tax_provider_id%TYPE;

Line 847: l_exempt_certificate_number ZX_LINES_SUMMARY.exempt_certificate_number%TYPE;

843: l_currency_conversion_rate ZX_LINES_SUMMARY.currency_conversion_rate%TYPE;
844: l_taxable_basis_formula ZX_LINES_SUMMARY.taxable_basis_formula%TYPE;
845: l_tax_calculation_formula ZX_LINES_SUMMARY.tax_calculation_formula%TYPE;
846: l_tax_exemption_id ZX_LINES_SUMMARY.tax_exemption_id%TYPE;
847: l_exempt_certificate_number ZX_LINES_SUMMARY.exempt_certificate_number%TYPE;
848: l_exempt_reason_code ZX_LINES_SUMMARY.exempt_reason_code%TYPE;
849: l_tax_exception_id ZX_LINES_SUMMARY.tax_exception_id%TYPE;
850: l_tax_provider_id ZX_LINES_SUMMARY.tax_provider_id%TYPE;
851:

Line 848: l_exempt_reason_code ZX_LINES_SUMMARY.exempt_reason_code%TYPE;

844: l_taxable_basis_formula ZX_LINES_SUMMARY.taxable_basis_formula%TYPE;
845: l_tax_calculation_formula ZX_LINES_SUMMARY.tax_calculation_formula%TYPE;
846: l_tax_exemption_id ZX_LINES_SUMMARY.tax_exemption_id%TYPE;
847: l_exempt_certificate_number ZX_LINES_SUMMARY.exempt_certificate_number%TYPE;
848: l_exempt_reason_code ZX_LINES_SUMMARY.exempt_reason_code%TYPE;
849: l_tax_exception_id ZX_LINES_SUMMARY.tax_exception_id%TYPE;
850: l_tax_provider_id ZX_LINES_SUMMARY.tax_provider_id%TYPE;
851:
852: -- Added this cursor for reallocation feature

Line 849: l_tax_exception_id ZX_LINES_SUMMARY.tax_exception_id%TYPE;

845: l_tax_calculation_formula ZX_LINES_SUMMARY.tax_calculation_formula%TYPE;
846: l_tax_exemption_id ZX_LINES_SUMMARY.tax_exemption_id%TYPE;
847: l_exempt_certificate_number ZX_LINES_SUMMARY.exempt_certificate_number%TYPE;
848: l_exempt_reason_code ZX_LINES_SUMMARY.exempt_reason_code%TYPE;
849: l_tax_exception_id ZX_LINES_SUMMARY.tax_exception_id%TYPE;
850: l_tax_provider_id ZX_LINES_SUMMARY.tax_provider_id%TYPE;
851:
852: -- Added this cursor for reallocation feature
853: -- to fetch the values of some summarization columns

Line 850: l_tax_provider_id ZX_LINES_SUMMARY.tax_provider_id%TYPE;

846: l_tax_exemption_id ZX_LINES_SUMMARY.tax_exemption_id%TYPE;
847: l_exempt_certificate_number ZX_LINES_SUMMARY.exempt_certificate_number%TYPE;
848: l_exempt_reason_code ZX_LINES_SUMMARY.exempt_reason_code%TYPE;
849: l_tax_exception_id ZX_LINES_SUMMARY.tax_exception_id%TYPE;
850: l_tax_provider_id ZX_LINES_SUMMARY.tax_provider_id%TYPE;
851:
852: -- Added this cursor for reallocation feature
853: -- to fetch the values of some summarization columns
854: CURSOR get_summary_columns (c_summary_tax_line_id NUMBER)

Line 869: FROM zx_lines_summary

865: exempt_certificate_number,
866: exempt_reason_code,
867: tax_exception_id,
868: tax_provider_id
869: FROM zx_lines_summary
870: WHERE summary_tax_line_id = c_summary_tax_line_id;
871:
872: BEGIN
873:

Line 1078: -- Fetch summarization columns from ZX_LINES_SUMMARY for re-allocation

1074: 'exception : ' || sqlerrm);
1075: END IF;
1076: END ;
1077:
1078: -- Fetch summarization columns from ZX_LINES_SUMMARY for re-allocation
1079: OPEN get_summary_columns(p_summary_tax_line_id);
1080: FETCH get_summary_columns INTO
1081: l_ledger_id,
1082: l_legal_entity_id,