[Home] [Help]
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