VIEW: APPS.JE_BE_VAT_REP_RULES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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