View: ZX_SIM_RULES_V

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

View Text

SELECT SRL.SIM_TAX_RULE_ID
, SRL.CONTENT_OWNER_ID
, HOU.NAME
, SRL.APPLICATION_ID
, FAP.DESCRIPTION
, SRL.TAX_REGIME_CODE
, SRL.TAX_REGIME_NAME
, SRL.TAX
, SRL.TAX_FULL_NAME
, SRL.SERVICE_TYPE_CODE
FROM ZX_SIM_RULES_VL SRL
, FND_APPLICATION_VL FAP
, HR_OPERATING_UNITS HOU
WHERE SRL.APPLICATION_ID = FAP.APPLICATION_ID
AND SRL.CONTENT_OWNER_ID = HOU.ORGANIZATION_ID GROUP BY SRL.SIM_TAX_RULE_ID
, SRL.TAX_REGIME_CODE
, SRL.TAX_REGIME_NAME
, SRL.TAX
, SRL.TAX_FULL_NAME
, SRL.APPLICATION_ID
, FAP.DESCRIPTION
, SRL.CONTENT_OWNER_ID
, HOU.NAME
, SRL.SERVICE_TYPE_CODE