View: ZX_SIM_PROCESS_RESULTS_VL

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

View Text

SELECT SPR.SIM_RESULT_ID
, SPR.CONDITION_GROUP_CODE
, CGP.CONDITION_GROUP_NAME
, SPR.SIM_TAX_RULE_ID
, SPR.PRIORITY
, SPR.RESULT_TYPE_CODE
, SPR.TAX_STATUS_CODE
, TST.TAX_STATUS_NAME
, SPR.NUMERIC_RESULT
, SPR.ALPHANUMERIC_RESULT
, SPR.CREATED_BY
, SPR.CREATION_DATE
, SPR.LAST_UPDATED_BY
, SPR.LAST_UPDATE_DATE
, SPR.LAST_UPDATE_LOGIN
, SPR.REQUEST_ID
, SPR.PROGRAM_APPLICATION_ID
, SPR.PROGRAM_ID
, SPR.PROGRAM_LOGIN_ID
FROM ZX_SIM_PROCESS_RESULTS SPR
, ZX_CONDITION_GROUPS_VL CGP
, ZX_STATUS_VL TST
WHERE SPR.CONDITION_GROUP_CODE = CGP.CONDITION_GROUP_CODE ( + )
AND SPR.TAX_STATUS_CODE = TST.TAX_STATUS_CODE ( + )