Product: | AR - Receivables |
---|---|
Description: | (Release 115 Only) |
Implementation/DBA Data: | APPS.RA_TAX_EXEMPTIONS_STRC_V |
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