[Home] [Help]
519: RETURN;
520: END IF;
521:
522: -- When no tax line found for the historical transaction, check if the trx line
523: -- exists in zx_lines_det_factors. If yes, it means the historical transaction
524: -- was migrated, but don't have tax. Otherwise, migrate the historical
525: -- transaction on-the-fly and call ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines
526: -- again to fetch the tax lines for the historical transaction.
527:
629: END IF;
630:
631: -- bug fix 4642405 : handle on the fly migration
632: -- When no tax line found for the adjusted doc, check if the trx line
633: -- exists in zx_lines_det_factors. If yes, it means the adjusted doc was
634: -- migrated, but don't have tax. Otherwise, migrate the adjusted doc
635: -- on-the-fly and call ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_adjust
636: -- again to fetch the tax lines for the adjusted doc.
637:
746: END IF;
747:
748: -- bug fix 4642405 : handle on the fly migration
749: -- When no tax line found for the applied_from doc, check if the trx line
750: -- exists in zx_lines_det_factors. If yes, it means the applied_from doc was
751: -- migrated, but don't have tax. Otherwise, migrate the applied_from doc
752: -- on-the-fly and call ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied
753: -- again to fetch the tax lines for the applied_from doc.
754:
879: END IF;
880:
881: -- bug fix 4642405 : handle on the fly migration
882: -- When no tax line found for docto be updated, check if the trx line
883: -- exists in zx_lines_det_factors. If yes, it means current doc was
884: -- migrated, but don't have tax. Otherwise, migrate current doc
885: -- on-the-fly and call ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines
886: -- again to fetch the tax lines for current doc.
887:
1000: END IF;
1001:
1002: -- bug fix 4653504 : handle on the fly migration
1003: -- When no tax line found for doc to be updated, check if the trx line
1004: -- exists in zx_lines_det_factors. If yes, it means current doc was
1005: -- migrated, but don't have tax. Otherwise, migrate current doc
1006: -- on-the-fly and call ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines
1007: -- again to fetch the tax lines for current doc.
1008:
1068: --Bug 10631930 (continuation of bug 9587918, relaxing event class code check for intercompany invoices)
1069:
1070: IF l_upg_trx_info_rec.trx_line_id IS NOT NULL THEN
1071: SELECT count(*) into l_count
1072: FROM zx_lines_det_factors
1073: WHERE application_id = l_upg_trx_info_rec.application_id
1074: AND entity_code = l_upg_trx_info_rec.entity_code
1075: AND trx_id = l_upg_trx_info_rec.trx_id
1076: AND trx_line_id = l_upg_trx_info_rec.trx_line_id
1076: AND trx_line_id = l_upg_trx_info_rec.trx_line_id
1077: AND trx_level_type = l_upg_trx_info_rec.trx_level_type;
1078: ELSE
1079: SELECT count(*) into l_count
1080: FROM zx_lines_det_factors
1081: WHERE application_id = l_upg_trx_info_rec.application_id
1082: AND entity_code = l_upg_trx_info_rec.entity_code
1083: AND trx_id = l_upg_trx_info_rec.trx_id;
1084: END IF;
3104: tax_line.trx_id,
3105: trx_line.ctrl_total_hdr_tx_amt,
3106: ROUND(SUM(tax_line.unrounded_tax_amt), 20)
3107: FROM zx_detail_tax_lines_gt tax_line,
3108: zx_lines_det_factors trx_line
3109: WHERE tax_line.application_id = trx_line.application_id
3110: AND tax_line.event_class_code = trx_line.event_class_code
3111: AND tax_line.entity_code = trx_line.entity_code
3112: AND tax_line.trx_id = trx_line.trx_id
3135: tax_line.entity_code,
3136: tax_line.trx_id,
3137: ROUND(SUM(tax_line.unrounded_tax_amt), 20) total_trx_tax_amt
3138: FROM zx_detail_tax_lines_gt tax_line,
3139: zx_lines_det_factors trx_line
3140: WHERE tax_line.application_id = trx_line.application_id
3141: AND tax_line.event_class_code = trx_line.event_class_code
3142: AND tax_line.entity_code = trx_line.entity_code
3143: AND tax_line.trx_id = trx_line.trx_id
3582: tax_line.entity_code,
3583: tax_line.trx_id,
3584: trx_line.ctrl_total_hdr_tx_amt
3585: FROM zx_detail_tax_lines_gt tax_line,
3586: zx_lines_det_factors trx_line
3587: WHERE tax_line.application_id = trx_line.application_id
3588: AND tax_line.event_class_code = trx_line.event_class_code
3589: AND tax_line.entity_code = trx_line.entity_code
3590: AND tax_line.trx_id = trx_line.trx_id