SELECT
ZFB.ROWID AS ROW_ID,
ZFB.LAST_UPDATE_DATE,
ZFB.LAST_UPDATE_LOGIN,
ZFB.REQUEST_ID,
ZFB.PROGRAM_APPLICATION_ID,
ZFB.PROGRAM_ID,
ZFB.PROGRAM_LOGIN_ID,
ZFB.CONTENT_OWNER_ID,
ZFB.FORMULA_TYPE_CODE,
ZFB.FORMULA_CODE,
ZFB.TAX_REGIME_CODE,
ZFB.TAX,
ZFB.EFFECTIVE_FROM,
ZFB.EFFECTIVE_TO,
ZFB.ENABLED_FLAG,
ZFB.TAXABLE_BASIS_TYPE_CODE,
ZFB.RECORD_TYPE_CODE,
ZFB.BASE_RATE_MODIFIER,
ZFB.CASH_DISCOUNT_APPL_FLAG,
ZFB.CREATION_DATE,
ZFB.LAST_UPDATED_BY,
ZFB.FORMULA_ID,
ZFB.CREATED_BY,
ZFB.VOLUME_DISCOUNT_APPL_FLAG,
ZFB.TRADING_DISCOUNT_APPL_FLAG,
ZFB.TRANSFER_CHARGE_APPL_FLAG,
ZFB.TRANSPORT_CHARGE_APPL_FLAG,
ZFB.INSURANCE_CHARGE_APPL_FLAG,
ZFB.OTHER_CHARGE_APPL_FLAG,
ZFB.ATTRIBUTE_CATEGORY,
ZFB.ATTRIBUTE1,
ZFB.ATTRIBUTE2,
ZFB.ATTRIBUTE3,
ZFB.ATTRIBUTE4,
ZFB.ATTRIBUTE5,
ZFB.ATTRIBUTE6,
ZFB.ATTRIBUTE7,
ZFB.ATTRIBUTE8,
ZFB.ATTRIBUTE9,
ZFB.ATTRIBUTE10,
ZFB.ATTRIBUTE11,
ZFB.ATTRIBUTE12,
ZFB.ATTRIBUTE13,
ZFB.ATTRIBUTE14,
ZFB.ATTRIBUTE15,
ZFB.ATTRIBUTE16,
ZFB.ATTRIBUTE17,
ZFB.ATTRIBUTE18,
ZFB.ATTRIBUTE19,
ZFB.ATTRIBUTE20,
ZFB.OBJECT_VERSION_NUMBER,
ZFT.FORMULA_NAME,
ZFT.FORMULA_DESCRIPTION,
ZFPOMV.PARTY_NAME AS CONTENT_OWNER_NAME,
NVL(ZMCAV.UPDATE_ACCESS,'Y') AS UPDATE_ACCESS,
NVL(ZMCAV.DUPLICATE_ACCESS,'Y') AS DUPLICATE_ACCESS
FROM ZX_FORMULA_B ZFB,
ZX_FORMULA_TL ZFT,
ZX_FIRST_PARTY_ORGS_MOAC_V ZFPOMV,
ZX_MCO_CHECK_ACCESS_V ZMCAV
WHERE ZFT.FORMULA_ID = ZFB.FORMULA_ID
AND ZFT.LANGUAGE = USERENV('LANG')
AND ZFPOMV.PARTY_TAX_PROFILE_ID = ZFB.CONTENT_OWNER_ID
AND ZMCAV.TAX_REGIME_CODE(+) = ZFB.TAX_REGIME_CODE
AND ZMCAV.PARENT_FIRST_PTY_ORG_ID(+) = ZFB.CONTENT_OWNER_ID
SELECT
ZFB.ROWID AS ROW_ID
,
ZFB.LAST_UPDATE_DATE
,
ZFB.LAST_UPDATE_LOGIN
,
ZFB.REQUEST_ID
,
ZFB.PROGRAM_APPLICATION_ID
,
ZFB.PROGRAM_ID
,
ZFB.PROGRAM_LOGIN_ID
,
ZFB.CONTENT_OWNER_ID
,
ZFB.FORMULA_TYPE_CODE
,
ZFB.FORMULA_CODE
,
ZFB.TAX_REGIME_CODE
,
ZFB.TAX
,
ZFB.EFFECTIVE_FROM
,
ZFB.EFFECTIVE_TO
,
ZFB.ENABLED_FLAG
,
ZFB.TAXABLE_BASIS_TYPE_CODE
,
ZFB.RECORD_TYPE_CODE
,
ZFB.BASE_RATE_MODIFIER
,
ZFB.CASH_DISCOUNT_APPL_FLAG
,
ZFB.CREATION_DATE
,
ZFB.LAST_UPDATED_BY
,
ZFB.FORMULA_ID
,
ZFB.CREATED_BY
,
ZFB.VOLUME_DISCOUNT_APPL_FLAG
,
ZFB.TRADING_DISCOUNT_APPL_FLAG
,
ZFB.TRANSFER_CHARGE_APPL_FLAG
,
ZFB.TRANSPORT_CHARGE_APPL_FLAG
,
ZFB.INSURANCE_CHARGE_APPL_FLAG
,
ZFB.OTHER_CHARGE_APPL_FLAG
,
ZFB.ATTRIBUTE_CATEGORY
,
ZFB.ATTRIBUTE1
,
ZFB.ATTRIBUTE2
,
ZFB.ATTRIBUTE3
,
ZFB.ATTRIBUTE4
,
ZFB.ATTRIBUTE5
,
ZFB.ATTRIBUTE6
,
ZFB.ATTRIBUTE7
,
ZFB.ATTRIBUTE8
,
ZFB.ATTRIBUTE9
,
ZFB.ATTRIBUTE10
,
ZFB.ATTRIBUTE11
,
ZFB.ATTRIBUTE12
,
ZFB.ATTRIBUTE13
,
ZFB.ATTRIBUTE14
,
ZFB.ATTRIBUTE15
,
ZFB.ATTRIBUTE16
,
ZFB.ATTRIBUTE17
,
ZFB.ATTRIBUTE18
,
ZFB.ATTRIBUTE19
,
ZFB.ATTRIBUTE20
,
ZFB.OBJECT_VERSION_NUMBER
,
ZFT.FORMULA_NAME
,
ZFT.FORMULA_DESCRIPTION
,
ZFPOMV.PARTY_NAME AS CONTENT_OWNER_NAME
,
NVL(ZMCAV.UPDATE_ACCESS
, 'Y') AS UPDATE_ACCESS
,
NVL(ZMCAV.DUPLICATE_ACCESS
, 'Y') AS DUPLICATE_ACCESS
FROM ZX_FORMULA_B ZFB
,
ZX_FORMULA_TL ZFT
,
ZX_FIRST_PARTY_ORGS_MOAC_V ZFPOMV
,
ZX_MCO_CHECK_ACCESS_V ZMCAV
WHERE ZFT.FORMULA_ID = ZFB.FORMULA_ID
AND ZFT.LANGUAGE = USERENV('LANG')
AND ZFPOMV.PARTY_TAX_PROFILE_ID = ZFB.CONTENT_OWNER_ID
AND ZMCAV.TAX_REGIME_CODE(+) = ZFB.TAX_REGIME_CODE
AND ZMCAV.PARENT_FIRST_PTY_ORG_ID(+) = ZFB.CONTENT_OWNER_ID
|
|
|