View: ZX_SIM_RULES_VL

Product:	FND - Application Object Library
Description:
Implementation/DBA Data:	APPS.ZX_SIM_RULES_VL

View Text

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')