View: IGI_INT_DETAILS_V

Product:	IGI - Public Sector Financials International
Description:	Based on GL_JE_BATCHES, IGI_INT_DESCRIPTRS, GL_JE_HEADERS, GL_JE_LINES and GL_IMPORT_REFERENCES
Implementation/DBA Data:	APPS.IGI_INT_DETAILS_V

View Text

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_IMPORT_REFERENCES R
, GL_JE_BATCHES B
, GL_JE_HEADERS H
, GL_JE_LINES L
, IGI_INT_DESCRIPTRS D
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

Columns