View: JE_BE_VAT_REP_RULES_V

Product:	JE - European Localizations
Description:
Implementation/DBA Data:	APPS.JE_BE_VAT_REP_RULES_V

View Text

SELECT JV.ROWID ROW_ID
, JV.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, S.LOOKUP_CODE SOURCE
, S.MEANING SOURCE_DSP
, T.LOOKUP_CODE OF_TRANS_TYPE
, T.MEANING OF_TRANS_TYPE_DSP
, V.LOOKUP_CODE VAT_TRANS_TYPE
, V.MEANING VAT_TRANS_TYPE_DSP
, V.DESCRIPTION VAT_TRANS_TYPE_DESC
, JV.TAX_NAME TAX_NAME
, L.LOOKUP_CODE LINE_TYPE
, L.MEANING LINE_TYPE_DSP
, B.LOOKUP_CODE VAT_REPORT_BOX
, B.MEANING VAT_REPORT_BOX_DSP
, B1.LOOKUP_CODE NOREC_VAT_REP_BOX
, B1.MEANING NOREC_VAT_REP_BOX_DSP
, G.LOOKUP_CODE SIGN_FLAG
, JV.START_DATE_ACTIVE START_DATE_ACTIVE
, JV.END_DATE_ACTIVE END_DATE_ACTIVE
, E.LOOKUP_CODE ENABLED_FLAG
, JV.LAST_UPDATE_DATE LAST_UPDATE_DATE
, JV.LAST_UPDATED_BY LAST_UPDATED_BY
, JV.CREATED_BY CREATED_BY
, JV.CREATION_DATE CREATION_DATE
, JV.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM FND_LOOKUPS S
, FND_LOOKUPS T
, FND_LOOKUPS V
, FND_LOOKUPS L
, FND_LOOKUPS B
, FND_LOOKUPS B1
, FND_LOOKUPS E
, FND_LOOKUPS G
, JE_BE_VAT_REP_RULES JV
WHERE JV.SOURCE = S.LOOKUP_CODE
AND S.LOOKUP_TYPE ='JEBE_SOURCE'
AND JV.OF_TRANS_TYPE = T.LOOKUP_CODE
AND T.LOOKUP_TYPE = DECODE(JV.SOURCE
, 'AP'
, 'JEBE_AP_OF_TRANS_TYPE'
, 'AR'
, 'JEBE_AR_OF_TRANS_TYPE'
, 'GL'
, 'JEBE_GL_OF_TRANS_TYPE'
, 'CR'
, 'JEBE_CR_OF_TRANS_TYPE')
AND JV.VAT_TRANS_TYPE = V.LOOKUP_CODE
AND V.LOOKUP_TYPE = 'JEBE_VAT_TRANS_TYPE'
AND JV.LINE_TYPE = L.LOOKUP_CODE
AND L.LOOKUP_TYPE ='JEBE_LINE_TYPE'
AND NVL(B.LOOKUP_TYPE
, 'JEBE_VAT_REPORT_BOXES')='JEBE_VAT_REPORT_BOXES'
AND JV.VAT_REPORT_BOX = B.LOOKUP_CODE(+)
AND JV.NOREC_VAT_REP_BOX = B1.LOOKUP_CODE(+)
AND NVL(B1.LOOKUP_TYPE
, 'JEBE_VAT_REPORT_BOXES')= 'JEBE_VAT_REPORT_BOXES'
AND JV.SIGN_FLAG = G.LOOKUP_CODE
AND G.LOOKUP_TYPE ='JEBE_SIGN_FLAG'
AND E.LOOKUP_TYPE= 'YES_NO'
AND JV.ENABLED_FLAG = E.LOOKUP_CODE

Columns