View: ZX_SCO_STATUS_V

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

View Text

SELECT A.ROWID ROW_ID
, A.TAX_STATUS_ID
, A.TAX_STATUS_CODE
, A.CONTENT_OWNER_ID
, A.EFFECTIVE_FROM
, A.EFFECTIVE_TO
, A.TAX
, A.TAX_REGIME_CODE
, A.RULE_BASED_RATE_FLAG
, A.ALLOW_RATE_OVERRIDE_FLAG
, A.ALLOW_EXEMPTIONS_FLAG
, A.ALLOW_EXCEPTIONS_FLAG
, A.DEFAULT_STATUS_FLAG
, A.DEFAULT_FLG_EFFECTIVE_FROM
, A.DEFAULT_FLG_EFFECTIVE_TO
, A.DEF_REC_SETTLEMENT_OPTION_CODE
, A.OBJECT_VERSION_NUMBER
, A.RECORD_TYPE_CODE
, A.CREATED_BY
, A.CREATION_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATE_LOGIN
, A.REQUEST_ID
, A.PROGRAM_APPLICATION_ID
, A.PROGRAM_ID
, A.PROGRAM_LOGIN_ID
, A.ATTRIBUTE1
, A.ATTRIBUTE2
, A.ATTRIBUTE3
, A.ATTRIBUTE4
, A.ATTRIBUTE5
, A.ATTRIBUTE6
, A.ATTRIBUTE7
, A.ATTRIBUTE8
, A.ATTRIBUTE9
, A.ATTRIBUTE10
, A.ATTRIBUTE11
, A.ATTRIBUTE12
, A.ATTRIBUTE13
, A.ATTRIBUTE14
, A.ATTRIBUTE15
, A.ATTRIBUTE_CATEGORY
, TL.TAX_STATUS_NAME
, SD.FIRST_PTY_ORG_ID SDCO_ID
, SD.EFFECTIVE_FROM SDEFF_FROM
, SD.EFFECTIVE_TO SDEFF_TO
FROM ZX_STATUS_B A
, ZX_STATUS_TL TL
, ZX_SUBSCRIPTION_DETAILS SD
WHERE A.TAX_STATUS_ID = TL.TAX_STATUS_ID
AND TL.LANGUAGE = USERENV('LANG')
AND A.TAX_REGIME_CODE = SD.TAX_REGIME_CODE
AND A.CONTENT_OWNER_ID = SD.PARENT_FIRST_PTY_ORG_ID
AND (SD.VIEW_OPTIONS_CODE IN ('NONE'
, 'VFC') OR (SD.VIEW_OPTIONS_CODE = 'VFR'
AND NOT EXISTS ( SELECT /*+ NO UNNEST*/ 1
FROM ZX_STATUS_B B
WHERE B.TAX_REGIME_CODE = A.TAX_REGIME_CODE
AND B.TAX = A.TAX
AND B.TAX_STATUS_CODE = A.TAX_STATUS_CODE
AND B.CONTENT_OWNER_ID = SD.FIRST_PTY_ORG_ID ) ) )