2147: ZX_TAXES_B tax,
2148: ZX_STATUS_B status,
2149: ZX_TRANSACTION_LINES_GT lines_gt,
2150: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
2151: ZX_SUBSCRIPTION_DETAILS sd_reg,
2152: ZX_SUBSCRIPTION_DETAILS sd_tax,
2153: ZX_SUBSCRIPTION_DETAILS sd_status
2154:
2155: WHERE
2148: ZX_STATUS_B status,
2149: ZX_TRANSACTION_LINES_GT lines_gt,
2150: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
2151: ZX_SUBSCRIPTION_DETAILS sd_reg,
2152: ZX_SUBSCRIPTION_DETAILS sd_tax,
2153: ZX_SUBSCRIPTION_DETAILS sd_status
2154:
2155: WHERE
2156: lines_gt.trx_id = header.trx_id
2149: ZX_TRANSACTION_LINES_GT lines_gt,
2150: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
2151: ZX_SUBSCRIPTION_DETAILS sd_reg,
2152: ZX_SUBSCRIPTION_DETAILS sd_tax,
2153: ZX_SUBSCRIPTION_DETAILS sd_status
2154:
2155: WHERE
2156: lines_gt.trx_id = header.trx_id
2157: AND taxlines_gt.trx_id = header.trx_id
2448: FROM ZX_TRX_HEADERS_GT header,
2449: ZX_RATES_B rate ,
2450: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
2451: ZX_TRANSACTION_LINES_GT lines_gt,
2452: ZX_SUBSCRIPTION_DETAILS sd_rates
2453: WHERE taxlines_gt.trx_id = header.trx_id
2454: AND taxlines_gt.application_id = Header.application_id
2455: AND taxlines_gt.entity_code = Header.entity_code
2456: AND taxlines_gt.event_class_code = Header.event_class_code