Tax code filtering
Hi,
I am trying to filter the list of tax available in the LOV in the transaction window,
I am using the following sql (which is fine on sql dev)
SELECT DISTINCT LOOKUP_CODE TAX_CODE,TAX_TYPE
FROM ZX_PARTY_TAX_PROFILE ZPTP,
ZX_SUBSCRIPTION_DETAILS ZSD,
ZX_RATES_B ZRB,
ZX_OUTPUT_CLASSIFICATIONS_V ZOCV
WHERE ZPTP.PARTY_TYPE_CODE = 'OU'
AND ZPTP.PARTY_ID = FND_GLOBAL.ORG_ID
AND ZPTP.PARTY_TAX_PROFILE_ID = ZSD.FIRST_PTY_ORG_ID
AND ZSD.TAX_REGIME_CODE = ZRB.TAX_REGIME_CODE
AND ZRB.RATE_TYPE_CODE = 'PERCENTAGE'
AND ZRB.TAX_RATE_CODE = ZOCV.LOOKUP_CODE
I am using the following sql (which is fine on sql dev)
SELECT DISTINCT LOOKUP_CODE TAX_CODE,TAX_TYPE
FROM ZX_PARTY_TAX_PROFILE ZPTP,
ZX_SUBSCRIPTION_DETAILS ZSD,
ZX_RATES_B ZRB,
ZX_OUTPUT_CLASSIFICATIONS_V ZOCV
WHERE ZPTP.PARTY_TYPE_CODE = 'OU'
AND ZPTP.PARTY_ID = FND_GLOBAL.ORG_ID
AND ZPTP.PARTY_TAX_PROFILE_ID = ZSD.FIRST_PTY_ORG_ID
AND ZSD.TAX_REGIME_CODE = ZRB.TAX_REGIME_CODE
AND ZRB.RATE_TYPE_CODE = 'PERCENTAGE'
AND ZRB.TAX_RATE_CODE = ZOCV.LOOKUP_CODE
0