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: OKX_TAX_EXEMPTIONS_V

Product:	OKX - Contracts Integration
Description:	Tax exemptions
Implementation/DBA Data:	APPS.OKX_TAX_EXEMPTIONS_V

View Text

SELECT TE.TAX_EXEMPTION_ID ID1
, '#' ID2
, TE.STATUS APPROVAL_STATUS
, TE.EXEMPTION_TYPE NAME
, TE.TAX_CODE TAX_CODE
, TE.PERCENT_EXEMPT PERCENT_EXEMPT
, TE.START_DATE START_DATE_ACTIVE
, TE.END_DATE END_DATE_ACTIVE
, TE.STATUS B_STATUS
, DECODE(TE.STATUS
, 'MANUAL'
, 'A'
, 'PRIMARY'
, 'A'
, 'I') STATUS
, TE.REASON_CODE DESCRIPTION
, TE.ORG_ID ORG_ID
, TE.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, TE.CUSTOMER_ID CUSTOMER_ID
, TE.SITE_USE_ID SITE_USE_ID
, TE.CUSTOMER_EXEMPTION_NUMBER CUSTOMER_EXCEPTION_NUMBER
, TE.IN_USE_FLAG IN_USE_FLAG
FROM RA_TAX_EXEMPTIONS_ALL TE

Columns

Name
ID1
ID2
APPROVAL_STATUS
NAME
TAX_CODE
PERCENT_EXEMPT
START_DATE_ACTIVE
END_DATE_ACTIVE
B_STATUS
STATUS
DESCRIPTION
ORG_ID
INVENTORY_ITEM_ID
CUSTOMER_ID
SITE_USE_ID
CUSTOMER_EXCEPTION_NUMBER
IN_USE_FLAG