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.

[Home] [Help]

View: JAI_AP_TDS_SECTION_TAX_V

Product:	JA - Asia/Pacific Localizations
Description:
Implementation/DBA Data:	APPS.JAI_AP_TDS_SECTION_TAX_V

View Text

SELECT B.LOOKUP_TYPE SECTION_TYPE
, B.LOOKUP_CODE SECTION_CODE
, B.MEANING SECTION_DESCRIPTION
, B.START_DATE_ACTIVE START_DATE_SECTION
, B.END_DATE_ACTIVE END_DATE_SECTION
, C.TAX_ID
, C.TAX_NAME
, C.TAX_DESCR TAX_DESCRIPTION
, C.TAX_TYPE
, C.TAX_RATE
, C.START_DATE START_DATE_TAX
, C.END_DATE END_DATE_TAX
, C.ORG_ID
FROM JA_LOOKUPS B
, JAI_CMN_TAXES_ALL C
WHERE B.LOOKUP_TYPE = 'JAI_AP_TDS_SECTION_TYPES'
AND B.LOOKUP_CODE = C.SECTION_TYPE

Columns

Name
SECTION_TYPE
SECTION_CODE
SECTION_DESCRIPTION
START_DATE_SECTION
END_DATE_SECTION
TAX_ID
TAX_NAME
TAX_DESCRIPTION
TAX_TYPE
TAX_RATE
START_DATE_TAX
END_DATE_TAX
ORG_ID