[Home] [Help]
517: RETURN;
518: END IF;
519:
520: -- When no tax line found for the historical transaction, check if the trx line
521: -- exists in zx_lines_det_factors. If yes, it means the historical transaction
522: -- was migrated, but don't have tax. Otherwise, migrate the historical
523: -- transaction on-the-fly and call ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines
524: -- again to fetch the tax lines for the historical transaction.
525:
627: END IF;
628:
629: -- bug fix 4642405 : handle on the fly migration
630: -- When no tax line found for the adjusted doc, check if the trx line
631: -- exists in zx_lines_det_factors. If yes, it means the adjusted doc was
632: -- migrated, but don't have tax. Otherwise, migrate the adjusted doc
633: -- on-the-fly and call ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_adjust
634: -- again to fetch the tax lines for the adjusted doc.
635:
744: END IF;
745:
746: -- bug fix 4642405 : handle on the fly migration
747: -- When no tax line found for the applied_from doc, check if the trx line
748: -- exists in zx_lines_det_factors. If yes, it means the applied_from doc was
749: -- migrated, but don't have tax. Otherwise, migrate the applied_from doc
750: -- on-the-fly and call ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied
751: -- again to fetch the tax lines for the applied_from doc.
752:
870: END IF;
871:
872: -- bug fix 4642405 : handle on the fly migration
873: -- When no tax line found for docto be updated, check if the trx line
874: -- exists in zx_lines_det_factors. If yes, it means current doc was
875: -- migrated, but don't have tax. Otherwise, migrate current doc
876: -- on-the-fly and call ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines
877: -- again to fetch the tax lines for current doc.
878:
991: END IF;
992:
993: -- bug fix 4653504 : handle on the fly migration
994: -- When no tax line found for doc to be updated, check if the trx line
995: -- exists in zx_lines_det_factors. If yes, it means current doc was
996: -- migrated, but don't have tax. Otherwise, migrate current doc
997: -- on-the-fly and call ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines
998: -- again to fetch the tax lines for current doc.
999:
2997: tax_line.entity_code,
2998: tax_line.trx_id,
2999: trx_line.ctrl_total_hdr_tx_amt
3000: FROM zx_detail_tax_lines_gt tax_line,
3001: zx_lines_det_factors trx_line
3002: WHERE tax_line.application_id = trx_line.application_id
3003: AND tax_line.event_class_code = trx_line.event_class_code
3004: AND tax_line.entity_code = trx_line.entity_code
3005: AND tax_line.trx_id = trx_line.trx_id
3021: CURSOR get_mismatch_tax_lines_csr IS
3022: SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
3023: SUM(tax_line.unrounded_tax_amt)
3024: FROM zx_detail_tax_lines_gt tax_line,
3025: zx_lines_det_factors trx_line
3026: WHERE tax_line.application_id = trx_line.application_id
3027: AND tax_line.event_class_code = trx_line.event_class_code
3028: AND tax_line.entity_code = trx_line.entity_code
3029: AND tax_line.trx_id = trx_line.trx_id
3366: tax_line.entity_code,
3367: tax_line.trx_id,
3368: trx_line.ctrl_total_hdr_tx_amt
3369: FROM zx_detail_tax_lines_gt tax_line,
3370: zx_lines_det_factors trx_line
3371: WHERE tax_line.application_id = trx_line.application_id
3372: AND tax_line.event_class_code = trx_line.event_class_code
3373: AND tax_line.entity_code = trx_line.entity_code
3374: AND tax_line.trx_id = trx_line.trx_id