VIEW: APPS.ZX_SIM_RULES_VL

Source

View Text - Preformatted

SELECT SRB.SIM_TAX_RULE_ID, SRB.CONTENT_OWNER_ID, SRB.TAX_RULE_CODE, SRT.TAX_RULE_NAME, SRB.TAX_REGIME_CODE, TRV.TAX_REGIME_NAME, SRB.TAX, TV.TAX_FULL_NAME, SRB.SERVICE_TYPE_CODE, SRB.APPLICATION_ID, SRB.RECOVERY_TYPE_CODE, SRB.PRIORITY, SRB.DET_FACTOR_TEMPL_CODE, SRB.EFFECTIVE_FROM, SRB.EFFECTIVE_TO, SRB.SIMULATED_FLAG, SRB.CREATED_BY, SRB.CREATION_DATE, SRB.LAST_UPDATED_BY, SRB.LAST_UPDATE_DATE, SRB.LAST_UPDATE_LOGIN, SRB.REQUEST_ID, SRB.PROGRAM_APPLICATION_ID, SRB.PROGRAM_ID, SRB.PROGRAM_LOGIN_ID FROM ZX_SIM_RULES_TL SRT, ZX_SIM_RULES_B SRB, ZX_REGIMES_VL TRV, ZX_TAXES_VL TV WHERE SRB.SIM_TAX_RULE_ID = SRT.SIM_TAX_RULE_ID AND SRB.TAX_REGIME_CODE = TRV.TAX_REGIME_CODE AND SRB.TAX = TV.TAX AND SRT.LANGUAGE = userenv ( 'LANG') 
   

View Text - HTML Formatted

SELECT SRB.SIM_TAX_RULE_ID
, SRB.CONTENT_OWNER_ID
, SRB.TAX_RULE_CODE
, SRT.TAX_RULE_NAME
, SRB.TAX_REGIME_CODE
, TRV.TAX_REGIME_NAME
, SRB.TAX
, TV.TAX_FULL_NAME
, SRB.SERVICE_TYPE_CODE
, SRB.APPLICATION_ID
, SRB.RECOVERY_TYPE_CODE
, SRB.PRIORITY
, SRB.DET_FACTOR_TEMPL_CODE
, SRB.EFFECTIVE_FROM
, SRB.EFFECTIVE_TO
, SRB.SIMULATED_FLAG
, SRB.CREATED_BY
, SRB.CREATION_DATE
, SRB.LAST_UPDATED_BY
, SRB.LAST_UPDATE_DATE
, SRB.LAST_UPDATE_LOGIN
, SRB.REQUEST_ID
, SRB.PROGRAM_APPLICATION_ID
, SRB.PROGRAM_ID
, SRB.PROGRAM_LOGIN_ID
FROM ZX_SIM_RULES_TL SRT
, ZX_SIM_RULES_B SRB
, ZX_REGIMES_VL TRV
, ZX_TAXES_VL TV
WHERE SRB.SIM_TAX_RULE_ID = SRT.SIM_TAX_RULE_ID
AND SRB.TAX_REGIME_CODE = TRV.TAX_REGIME_CODE
AND SRB.TAX = TV.TAX
AND SRT.LANGUAGE = USERENV ( 'LANG')