View: IGC_CBC_AUDIT_TRAILS_V

Product:	IGC - Contract Commitment
Description:
Implementation/DBA Data:	APPS.IGC_CBC_AUDIT_TRAILS_V

View Text

SELECT CCHD.CC_HEADER_ID "CONTRACT COMMITMENT ID"
, CCHD.CC_NUM "CONTRACT COMMITMENT NUMBER"
, CCHD.CC_TYPE "CONTRACT COMMITMENT TYPE"
, CCHD.SET_OF_BOOKS_ID "SET OF BOOKS ID"
, GLSB.NAME "SET OF BOOKS NAME"
, GLSB.SHORT_NAME "SET OF BOOKS SHORT NAME"
, CCHD.ORG_ID "ORGANIZATION ID"
, HROU.NAME "ORGANIZATION NAME"
, 'COMMITMENT' "BUDGET TYPE"
, BCJL.REFERENCE_3 "VERSION"
, BCJB.NAME "BATCH NAME"
, NULL "JOURNAL"
, BCJL.PERIOD_YEAR "PERIOD YEAR"
, BCJL.PERIOD_NUM "PERIOD NUMBER"
, BCJL.PERIOD_NAME "PERIOD NAME"
, GLET.ENCUMBRANCE_TYPE "ENCUMBRANCE TYPE NAME"
, GLCC.SEGMENT1 || '.' || GLCC.SEGMENT2 || '.' || GLCC.SEGMENT3 || '.' || GLCC.SEGMENT4 || '.' || GLCC.SEGMENT5 || '.' || GLCC.SEGMENT6 || '.' || GLCC.SEGMENT7 || '.' || GLCC.SEGMENT8 "GL ACCOUNT"
, BCJL.ENTERED_DR "RUNNING TOTAL DR"
, BCJL.ENTERED_CR "RUNNING TOTAL CR"
FROM IGC.IGC_CC_HEADERS CCHD
, IGC.IGC_CBC_JE_BATCHES BCJB
, IGC.IGC_CBC_JE_LINES BCJL
, GL.GL_CODE_COMBINATIONS GLCC
, GL.GL_ENCUMBRANCE_TYPES GLET
, GL.GL_SETS_OF_BOOKS GLSB
, HR.HR_ALL_ORGANIZATION_UNITS HROU
WHERE CCHD.CC_HEADER_ID = BCJB.CC_HEADER_ID
AND CCHD.SET_OF_BOOKS_ID = GLSB.SET_OF_BOOKS_ID
AND CCHD.ORG_ID = HROU.ORGANIZATION_ID
AND BCJB.CBC_JE_BATCH_ID = BCJL.CBC_JE_BATCH_ID
AND BCJL.CODE_COMBINATION_ID = GLCC.CODE_COMBINATION_ID
AND BCJL.ENCUMBRANCE_TYPE_ID = GLET.ENCUMBRANCE_TYPE_ID (+) UNION SELECT CCHD.CC_HEADER_ID "CONTRACT COMMITMENT ID"
, CCHD.CC_NUM "CONTRACT COMMITMENT NUMBER"
, CCHD.CC_TYPE "CONTRACT COMMITMENT TYPE"
, CCHD.SET_OF_BOOKS_ID "SET OF BOOKS ID"
, GLSB.NAME "SET OF BOOKS NAME"
, GLSB.SHORT_NAME "SET OF BOOKS SHORT NAME"
, CCHD.ORG_ID "ORGANIZATION ID"
, HROU.NAME "ORGANIZATION NAME"
, 'STANDARD' "BUDGET TYPE"
, GLJL.REFERENCE_3 "VERSION"
, GLJB.NAME "BATCH NAME"
, GLJH.NAME "JOURNAL"
, GLPD.PERIOD_YEAR "PERIOD YEAR"
, GLPD.PERIOD_NUM "PERIOD NUMBER"
, GLJL.PERIOD_NAME "PERIOD NAME"
, GLET.ENCUMBRANCE_TYPE "ENCUMBRANCE TYPE NAME"
, GLCC.SEGMENT1 || '.' || GLCC.SEGMENT2 || '.' || GLCC.SEGMENT3 || '.' || GLCC.SEGMENT4 || '.' || GLCC.SEGMENT5 || '.' || GLCC.SEGMENT6 || '.' || GLCC.SEGMENT7 || '.' || GLCC.SEGMENT8 "GL ACCOUNT"
, GLJL.ENTERED_DR "RUNNING TOTAL DR"
, GLJL.ENTERED_CR "RUNNING TOTAL CR"
FROM IGC.IGC_CC_HEADERS CCHD
, GL.GL_JE_HEADERS GLJH
, GL.GL_JE_BATCHES GLJB
, GL.GL_JE_LINES GLJL
, GL.GL_CODE_COMBINATIONS GLCC
, GL.GL_ENCUMBRANCE_TYPES GLET
, GL.GL_PERIODS GLPD
, GL.GL_SETS_OF_BOOKS GLSB
, HR.HR_ALL_ORGANIZATION_UNITS HROU
WHERE TO_CHAR(CCHD.CC_HEADER_ID) = GLJL.REFERENCE_1
AND CCHD.SET_OF_BOOKS_ID = GLSB.SET_OF_BOOKS_ID
AND CCHD.ORG_ID = HROU.ORGANIZATION_ID
AND GLJH.JE_HEADER_ID = GLJL.JE_HEADER_ID
AND GLJH.JE_BATCH_ID = GLJB.JE_BATCH_ID (+)
AND GLJL.CODE_COMBINATION_ID = GLCC.CODE_COMBINATION_ID
AND GLJH.ENCUMBRANCE_TYPE_ID = GLET.ENCUMBRANCE_TYPE_ID (+)
AND GLJL.PERIOD_NAME = GLPD.PERIOD_NAME

Columns