Oracle EBS GST-Asia Pasific Lookups

Oracle EBS GST-Asia Pasific Lookups
Configuration:Update GSTIN Lookup,
Responsibility:Oracle Financials For India,
Navigation:Asia/Pasific Lookups

Tables:-
FND_LOOKUP_TYPES_VL
FND_APPLICATION_TL
FND_LOOKUP_VALUES

SQL Example:-
SELECT
fltv.LOOKUP_TYPE "Type"
,fltv.MEANING  "Meaning"
,fatl.APPLICATION_NAME "Application"
,fltv.DESCRIPTION  "Description"
,decode(fltv.CUSTOMIZATION_LEVEL, 'U','User','S','System','E','Extensible')  "User"
,flv.LOOKUP_CODE  "Code"
,flv.MEANING  "Meaning"
,flv.DESCRIPTION  "Description"
,flv.TAG  "Tag"
,flv.START_DATE_ACTIVE  "From"
,flv.END_DATE_ACTIVE  "To"
,flv.ENABLED_FLAG "Enable"
FROM
APPS.FND_LOOKUP_TYPES_VL  fltv,
APPS.FND_APPLICATION_TL  fatl,
APPS.FND_LOOKUP_VALUES flv
WHERE 1=1
AND fltv.APPLICATION_ID=fatl.APPLICATION_ID
AND fatl.LANGUAGE='US'
AND fltv.LOOKUP_TYPE='JAI_REGISTRATION_TYPES'
AND fltv.LOOKUP_TYPE=flv.LOOKUP_TYPE
AND flv.LANGUAGE='US';