View: JAI_FBT_SETUP_HEADER_V

Product:	JA - Asia/Pacific Localizations
Description:	This view is used to populate the header information in Fringe Benefit Tax Setup form
Implementation/DBA Data:	APPS.JAI_FBT_SETUP_HEADER_V

View Text

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

Columns