VIEW: APPS.RA_TAX_EXEMPTIONS_STRC_V

Source

View Text - Preformatted

SELECT EX.ROWID ROW_ID , EX.ORG_ID , EX.TAX_EXEMPTION_ID , EX.LAST_UPDATED_BY , EX.LAST_UPDATE_DATE , EX.CREATED_BY , EX.CREATION_DATE , EX.STATUS , LK1.MEANING STATUS_DISP , EX.INVENTORY_ITEM_ID , EX.CUSTOMER_ID , EX.SITE_USE_ID , EX.EXEMPTION_TYPE , EX.TAX_CODE , EX.PERCENT_EXEMPT , EX.CUSTOMER_EXEMPTION_NUMBER , EX.START_DATE , EX.END_DATE , EX.LOCATION_CONTEXT , EX.LOCATION_ID_SEGMENT_1 , EX.LOCATION_ID_SEGMENT_2 , EX.LOCATION_ID_SEGMENT_3 , EX.LOCATION_ID_SEGMENT_4 , EX.LOCATION_ID_SEGMENT_5 , EX.LOCATION_ID_SEGMENT_6 , EX.LOCATION_ID_SEGMENT_7 , EX.LOCATION_ID_SEGMENT_8 , EX.LOCATION_ID_SEGMENT_9 , EX.LOCATION_ID_SEGMENT_10 , EX.ATTRIBUTE_CATEGORY , EX.ATTRIBUTE1 , EX.ATTRIBUTE2 , EX.ATTRIBUTE3 , EX.ATTRIBUTE4 , EX.ATTRIBUTE5 , EX.ATTRIBUTE6 , EX.ATTRIBUTE7 , EX.ATTRIBUTE8 , EX.ATTRIBUTE9 , EX.ATTRIBUTE10 , EX.ATTRIBUTE11 , EX.ATTRIBUTE12 , EX.ATTRIBUTE13 , EX.ATTRIBUTE14 , EX.ATTRIBUTE15 , EX.IN_USE_FLAG , EX.PROGRAM_ID , EX.PROGRAM_UPDATE_DATE , EX.REQUEST_ID , EX.PROGRAM_APPLICATION_ID , EX.REASON_CODE , LK2.MEANING REASON_CODE_DISP , EX.EXEMPT_CONTEXT , EX.EXEMPT_PERCENT1 , EX.EXEMPT_PERCENT2 , EX.EXEMPT_PERCENT3 , EX.EXEMPT_PERCENT4 , EX.EXEMPT_PERCENT5 , EX.EXEMPT_PERCENT6 , EX.EXEMPT_PERCENT7 , EX.EXEMPT_PERCENT8 , EX.EXEMPT_PERCENT9 , EX.EXEMPT_PERCENT10 FROM RA_TAX_EXEMPTIONS EX, AR_LOOKUPS LK1, AR_LOOKUPS LK2 WHERE LK1.LOOKUP_TYPE = 'TAX_EXEMPT_STATUS' AND LK1.LOOKUP_CODE = EX.STATUS AND LK2.LOOKUP_TYPE(+) = 'TAX_REASON' AND LK2.LOOKUP_CODE(+) = EX.REASON_CODE

View Text - HTML Formatted

SELECT EX.ROWID ROW_ID
, EX.ORG_ID
, EX.TAX_EXEMPTION_ID
, EX.LAST_UPDATED_BY
, EX.LAST_UPDATE_DATE
, EX.CREATED_BY
, EX.CREATION_DATE
, EX.STATUS
, LK1.MEANING STATUS_DISP
, EX.INVENTORY_ITEM_ID
, EX.CUSTOMER_ID
, EX.SITE_USE_ID
, EX.EXEMPTION_TYPE
, EX.TAX_CODE
, EX.PERCENT_EXEMPT
, EX.CUSTOMER_EXEMPTION_NUMBER
, EX.START_DATE
, EX.END_DATE
, EX.LOCATION_CONTEXT
, EX.LOCATION_ID_SEGMENT_1
, EX.LOCATION_ID_SEGMENT_2
, EX.LOCATION_ID_SEGMENT_3
, EX.LOCATION_ID_SEGMENT_4
, EX.LOCATION_ID_SEGMENT_5
, EX.LOCATION_ID_SEGMENT_6
, EX.LOCATION_ID_SEGMENT_7
, EX.LOCATION_ID_SEGMENT_8
, EX.LOCATION_ID_SEGMENT_9
, EX.LOCATION_ID_SEGMENT_10
, EX.ATTRIBUTE_CATEGORY
, EX.ATTRIBUTE1
, EX.ATTRIBUTE2
, EX.ATTRIBUTE3
, EX.ATTRIBUTE4
, EX.ATTRIBUTE5
, EX.ATTRIBUTE6
, EX.ATTRIBUTE7
, EX.ATTRIBUTE8
, EX.ATTRIBUTE9
, EX.ATTRIBUTE10
, EX.ATTRIBUTE11
, EX.ATTRIBUTE12
, EX.ATTRIBUTE13
, EX.ATTRIBUTE14
, EX.ATTRIBUTE15
, EX.IN_USE_FLAG
, EX.PROGRAM_ID
, EX.PROGRAM_UPDATE_DATE
, EX.REQUEST_ID
, EX.PROGRAM_APPLICATION_ID
, EX.REASON_CODE
, LK2.MEANING REASON_CODE_DISP
, EX.EXEMPT_CONTEXT
, EX.EXEMPT_PERCENT1
, EX.EXEMPT_PERCENT2
, EX.EXEMPT_PERCENT3
, EX.EXEMPT_PERCENT4
, EX.EXEMPT_PERCENT5
, EX.EXEMPT_PERCENT6
, EX.EXEMPT_PERCENT7
, EX.EXEMPT_PERCENT8
, EX.EXEMPT_PERCENT9
, EX.EXEMPT_PERCENT10
FROM RA_TAX_EXEMPTIONS EX
, AR_LOOKUPS LK1
, AR_LOOKUPS LK2
WHERE LK1.LOOKUP_TYPE = 'TAX_EXEMPT_STATUS'
AND LK1.LOOKUP_CODE = EX.STATUS
AND LK2.LOOKUP_TYPE(+) = 'TAX_REASON'
AND LK2.LOOKUP_CODE(+) = EX.REASON_CODE