eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.ZX_MCO_LV_FORMULA_V

Source

View Text - Preformatted


SELECT DISTINCT
 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,
 ZFT.FORMULA_NAME,
 ZFT.FORMULA_DESCRIPTION
FROM ZX_FORMULA_B ZFB,
    ZX_FORMULA_TL ZFT,
    ZX_SUBSCRIPTION_DETAILS ZSD,
    ZX_FIRST_PARTY_ORGS_MOAC_V ZFPOMV
WHERE ZFT.FORMULA_ID = ZFB.FORMULA_ID
AND   ZFT.LANGUAGE = USERENV('LANG')
AND   ZSD.PARENT_FIRST_PTY_ORG_ID(+) = ZFB.CONTENT_OWNER_ID
AND   ZSD.TAX_REGIME_CODE(+) = ZFB.TAX_REGIME_CODE
AND   ZFPOMV.PARTY_TAX_PROFILE_ID = ZFB.CONTENT_OWNER_ID
AND   (ZSD.VIEW_OPTIONS_CODE IS NULL OR ZSD.VIEW_OPTIONS_CODE IN  ('VFC','VFR'))
AND   (ZSD.FIRST_PTY_ORG_ID IS NULL OR (ZSD.FIRST_PTY_ORG_ID = -99
       AND FND_PROFILE.VALUE('ZX_GCO_WRITE_ACCESS') = 'Y'
      ) OR (ZSD.FIRST_PTY_ORG_ID <> -99))

View Text - HTML Formatted

SELECT DISTINCT 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
, ZFT.FORMULA_NAME
, ZFT.FORMULA_DESCRIPTION FROM ZX_FORMULA_B ZFB
, ZX_FORMULA_TL ZFT
, ZX_SUBSCRIPTION_DETAILS ZSD
, ZX_FIRST_PARTY_ORGS_MOAC_V ZFPOMV WHERE ZFT.FORMULA_ID = ZFB.FORMULA_ID AND ZFT.LANGUAGE = USERENV('LANG') AND ZSD.PARENT_FIRST_PTY_ORG_ID(+) = ZFB.CONTENT_OWNER_ID AND ZSD.TAX_REGIME_CODE(+) = ZFB.TAX_REGIME_CODE AND ZFPOMV.PARTY_TAX_PROFILE_ID = ZFB.CONTENT_OWNER_ID AND (ZSD.VIEW_OPTIONS_CODE IS NULL OR ZSD.VIEW_OPTIONS_CODE IN ('VFC'
, 'VFR')) AND (ZSD.FIRST_PTY_ORG_ID IS NULL OR (ZSD.FIRST_PTY_ORG_ID = -99
AND FND_PROFILE.VALUE('ZX_GCO_WRITE_ACCESS') = 'Y' ) OR (ZSD.FIRST_PTY_ORG_ID <> -99))