VIEW: APPS.OKX_TAX_EXEMPTIONS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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