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.JAI_FBT_SETUP_HEADER_V

Source

View Text - Preformatted


SELECT DISTINCT JFS.LEGAL_ENTITY_ID , NAME LEGAL_ENTITY , JFS.ASSESSMENT_STATUS_CODE , AJ.MEANING ASSESSMENT_STATUS , JFS.BUSINESS_TYPE_CODE , BJ.MEANING BUSINESS_TYPE , JFS.FBT_RATE , JFS.SURCHARGE_RATE , JFS.EDU_CESS_RATE , JFS.SH_CESS_RATE , JFS.FBT_ACCOUNT_CCID FROM JAI_FBT_SETUP JFS , XLE_ENTITY_PROFILES XEP , JA_LOOKUPS AJ , JA_LOOKUPS BJ WHERE AJ.LOOKUP_TYPE = 'JAI_ASSESSMENT_STATUS' AND AJ.LOOKUP_CODE = JFS.ASSESSMENT_STATUS_CODE AND BJ.LOOKUP_TYPE = 'JAI_BUSINESS_TYPE' AND BJ.LOOKUP_CODE = JFS.BUSINESS_TYPE_CODE AND XEP.LEGAL_ENTITY_ID = JFS.LEGAL_ENTITY_ID

View Text - HTML Formatted

SELECT DISTINCT JFS.LEGAL_ENTITY_ID
, NAME LEGAL_ENTITY
, JFS.ASSESSMENT_STATUS_CODE
, AJ.MEANING ASSESSMENT_STATUS
, JFS.BUSINESS_TYPE_CODE
, BJ.MEANING BUSINESS_TYPE
, JFS.FBT_RATE
, JFS.SURCHARGE_RATE
, JFS.EDU_CESS_RATE
, JFS.SH_CESS_RATE
, JFS.FBT_ACCOUNT_CCID
FROM JAI_FBT_SETUP JFS
, XLE_ENTITY_PROFILES XEP
, JA_LOOKUPS AJ
, JA_LOOKUPS BJ
WHERE AJ.LOOKUP_TYPE = 'JAI_ASSESSMENT_STATUS'
AND AJ.LOOKUP_CODE = JFS.ASSESSMENT_STATUS_CODE
AND BJ.LOOKUP_TYPE = 'JAI_BUSINESS_TYPE'
AND BJ.LOOKUP_CODE = JFS.BUSINESS_TYPE_CODE
AND XEP.LEGAL_ENTITY_ID = JFS.LEGAL_ENTITY_ID