SELECT
JAW.REGIME_CODE
, JAW.ACTUAL_SECTION_CODE
, JAI.TDS_TAX_RATE
, JAW.TAX_AMOUNT
, JAW.PROCESS_MESSAGE
, (
SELECT
CONCATENATED_SEGMENTS
FROM
GL_CODE_COMBINATIONS_KFV
WHERE
CODE_COMBINATION_ID=DIST_CODE_COMBINATION_ID
)
ACCOUNT
, JTC.TAX_CATEGORY_NAME
, JCT.TAX_NAME
FROM
JAI_AP_WTHLD_INV_TAXES JAW
, JAI_TAX_CATEGORIES JTC
, JAI_CMN_TAXES_ALL JCT
, JAI_AP_TDS_INVOICES JAI
WHERE
JAI.INVOICE_ID =JAW.INVOICE_ID
AND JAI.INVOICE_ID = :P_INVOICE_ID
AND JAW.TAX_CATEGORY_ID=JTC.TAX_CATEGORY_ID
AND JCT.TAX_ID =JAW.TAX_TYPE_ID
JAW.REGIME_CODE
, JAW.ACTUAL_SECTION_CODE
, JAI.TDS_TAX_RATE
, JAW.TAX_AMOUNT
, JAW.PROCESS_MESSAGE
, (
SELECT
CONCATENATED_SEGMENTS
FROM
GL_CODE_COMBINATIONS_KFV
WHERE
CODE_COMBINATION_ID=DIST_CODE_COMBINATION_ID
)
ACCOUNT
, JTC.TAX_CATEGORY_NAME
, JCT.TAX_NAME
FROM
JAI_AP_WTHLD_INV_TAXES JAW
, JAI_TAX_CATEGORIES JTC
, JAI_CMN_TAXES_ALL JCT
, JAI_AP_TDS_INVOICES JAI
WHERE
JAI.INVOICE_ID =JAW.INVOICE_ID
AND JAI.INVOICE_ID = :P_INVOICE_ID
AND JAW.TAX_CATEGORY_ID=JTC.TAX_CATEGORY_ID
AND JCT.TAX_ID =JAW.TAX_TYPE_ID