VIEW: APPS.IGI_INT_DETAILS_V

Source

View Text - Preformatted

SELECT h.je_source , b.actual_flag , h.currency_code , h.period_name , b.status , b.je_batch_id , h.je_header_id , l.je_line_num , l.code_combination_id , r.reference_1 , r.reference_2 , r.reference_3 , r.reference_4 , r.reference_5 , r.reference_6 , r.reference_7 , r.reference_8 , r.reference_9 , r.reference_10 , d.secure_source_flag FROM GL_JE_BATCHES B, IGI_INT_DESCRIPTRS D, GL_JE_HEADERS H, GL_JE_LINES L, GL_IMPORT_REFERENCES R WHERE b.je_batch_id = h.je_batch_id AND h.je_header_id = l.je_header_id AND b.je_batch_id = r.je_batch_id AND h.je_header_id = r.je_header_id AND l.je_line_num = r.je_line_num AND h.je_source = d.je_source_name

View Text - HTML Formatted

SELECT H.JE_SOURCE
, B.ACTUAL_FLAG
, H.CURRENCY_CODE
, H.PERIOD_NAME
, B.STATUS
, B.JE_BATCH_ID
, H.JE_HEADER_ID
, L.JE_LINE_NUM
, L.CODE_COMBINATION_ID
, R.REFERENCE_1
, R.REFERENCE_2
, R.REFERENCE_3
, R.REFERENCE_4
, R.REFERENCE_5
, R.REFERENCE_6
, R.REFERENCE_7
, R.REFERENCE_8
, R.REFERENCE_9
, R.REFERENCE_10
, D.SECURE_SOURCE_FLAG
FROM GL_JE_BATCHES B
, IGI_INT_DESCRIPTRS D
, GL_JE_HEADERS H
, GL_JE_LINES L
, GL_IMPORT_REFERENCES R
WHERE B.JE_BATCH_ID = H.JE_BATCH_ID
AND H.JE_HEADER_ID = L.JE_HEADER_ID
AND B.JE_BATCH_ID = R.JE_BATCH_ID
AND H.JE_HEADER_ID = R.JE_HEADER_ID
AND L.JE_LINE_NUM = R.JE_LINE_NUM
AND H.JE_SOURCE = D.JE_SOURCE_NAME