Receivables - EBS (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center