eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PA_CC_GL_COST_AUDIT_REP_MRC_V

Product:	PA - Projects
Description:	View for Cross Charge Audit by GL Account showing the Cross Charge Distribution Lines and the corresponding entries in Oracle General Ledger. This view shows the cross charge transactions in Oracle Projects for both GL Categories (Borrowed
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT CCD.CC_DIST_LINE_ID CC_DIST_LINE_ID
, CCD.LINE_TYPE CC_DIST_LINE_TYPE
, EI.EXPENDITURE_ITEM_ID EXPENDITURE_ITEM_ID
, CCD.LINE_NUM CC_DIST_LINE_NUM
, JEL.CODE_COMBINATION_ID CODE_COMBINATION_ID
, PRJ.PROJECT_ID PROJECT_ID
, PRJ.SEGMENT1 PROJECT_NUMBER
, TASK.TASK_ID TASK_ID
, TASK.TASK_NUMBER TASK_NUMBER
, EI.EXPENDITURE_TYPE EXPENDITURE_TYPE
, EI.EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, DECODE(EMP.FULL_NAME
, NULL
, HR.NAME
, EMP.FULL_NAME ) EMP_OR_ORG_NAME
, JEB.NAME JE_BATCH_NAME
, REPLACE(JEB.NAME
, JES.USER_JE_SOURCE_NAME || ' ') JE_REP_BATCH_NAME
, JEB.JE_BATCH_ID JE_BATCH_ID
, JEH.PERIOD_NAME PERIOD_NAME
, JEH.JE_HEADER_ID JE_HEADER_ID
, JEL.JE_LINE_NUM JE_LINE_NUMBER
, CCD.GL_DATE GL_DATE
, CCD.TRANSFERRED_DATE TRANSFERRED_DATE
, CCD.AMOUNT GL_DR_AMOUNT
, TO_NUMBER(NULL) GL_CR_AMOUNT
FROM GL_JE_SOURCES JES
, HR_ALL_ORGANIZATION_UNITS_TL HR
, PER_PEOPLE_F EMP
, PA_PROJECTS_ALL PRJ
, PA_TASKS TASK
, PA_EXPENDITURES_ALL EXP
, PA_EXPEND_ITEMS_ALL_MRC_V2 EI
, PA_CC_DIST_LINES_ALL_MRC_V2 CCD
, GL_JE_LINES JEL
, GL_JE_HEADERS JEH
, GL_JE_BATCHES JEB
WHERE PRJ.PROJECT_ID = CCD.PROJECT_ID
AND CCD.TASK_ID = TASK.TASK_ID
AND CCD.EXPENDITURE_ITEM_ID = EI.EXPENDITURE_ITEM_ID
AND CCD.TRANSFER_STATUS_CODE||'' = 'A'
AND CCD.GL_BATCH_NAME = JEL.REFERENCE_1 || ''
AND CCD.DR_CODE_COMBINATION_ID = JEL.CODE_COMBINATION_ID
AND JEL.REFERENCE_3 = 'CROSS CHARGE DEBIT'
AND JEH.JE_BATCH_ID = JEB.JE_BATCH_ID
AND JEH.JE_HEADER_ID = JEL.JE_HEADER_ID
AND EXP.EXPENDITURE_ID = EI.EXPENDITURE_ID
AND EXP.INCURRED_BY_PERSON_ID = EMP.PERSON_ID (+)
AND (EI.EXPENDITURE_ITEM_DATE BETWEEN NVL(EMP.EFFECTIVE_START_DATE
, EI.EXPENDITURE_ITEM_DATE)
AND NVL(EMP.EFFECTIVE_END_DATE
, EI.EXPENDITURE_ITEM_DATE ))
AND JES.JE_SOURCE_NAME = 'PROJECT ACCOUNTING'
AND NVL(EI.OVERRIDE_TO_ORGANIZATION_ID
, EXP.INCURRED_BY_ORGANIZATION_ID) = HR.ORGANIZATION_ID
AND DECODE(HR.ORGANIZATION_ID
, NULL
, '1'
, HR.LANGUAGE) = DECODE(HR.ORGANIZATION_ID
, NULL
, '1'
, USERENV('LANG'))
AND NVL(CCD.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTR(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTR(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99) UNION ALL SELECT CCD.CC_DIST_LINE_ID CC_DIST_LINE_ID
, CCD.LINE_TYPE CC_DIST_LINE_TYPE
, EI.EXPENDITURE_ITEM_ID EXPENDITURE_ITEM_ID
, CCD.LINE_NUM CC_DIST_LINE_NUM
, JEL.CODE_COMBINATION_ID CODE_COMBINATION_ID
, PRJ.PROJECT_ID PROJECT_ID
, PRJ.SEGMENT1 PROJECT_NUMBER
, TASK.TASK_ID TASK_ID
, TASK.TASK_NUMBER TASK_NUMBER
, EI.EXPENDITURE_TYPE EXPENDITURE_TYPE
, EI.EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, DECODE(EMP.FULL_NAME
, NULL
, HR.NAME
, EMP.FULL_NAME ) EMP_OR_ORG_NAME
, JEB.NAME JE_BATCH_NAME
, REPLACE(JEB.NAME
, JES.USER_JE_SOURCE_NAME || ' ') JE_REP_BATCH_NAME
, JEB.JE_BATCH_ID JE_BATCH_ID
, JEH.PERIOD_NAME PERIOD_NAME
, JEH.JE_HEADER_ID JE_HEADER_ID
, JEL.JE_LINE_NUM JE_LINE_NUMBER
, CCD.GL_DATE GL_DATE
, CCD.TRANSFERRED_DATE TRANSFERRED_DATE
, TO_NUMBER(NULL) GL_DR_AMOUNT
, CCD.AMOUNT GL_CR_AMOUNT
FROM GL_JE_SOURCES JES
, HR_ALL_ORGANIZATION_UNITS_TL HR
, PER_PEOPLE_F EMP
, PA_PROJECTS_ALL PRJ
, PA_TASKS TASK
, PA_EXPENDITURES_ALL EXP
, PA_EXPEND_ITEMS_ALL_MRC_V2 EI
, PA_CC_DIST_LINES_ALL_MRC_V2 CCD
, GL_JE_LINES JEL
, GL_JE_HEADERS JEH
, GL_JE_BATCHES JEB
WHERE PRJ.PROJECT_ID = CCD.PROJECT_ID
AND CCD.TASK_ID = TASK.TASK_ID
AND CCD.EXPENDITURE_ITEM_ID = EI.EXPENDITURE_ITEM_ID
AND CCD.TRANSFER_STATUS_CODE||'' = 'A'
AND CCD.GL_BATCH_NAME = JEL.REFERENCE_1 || ''
AND CCD.CR_CODE_COMBINATION_ID = JEL.CODE_COMBINATION_ID
AND JEL.REFERENCE_3 = 'CROSS CHARGE CREDIT'
AND JEH.JE_BATCH_ID = JEB.JE_BATCH_ID
AND JEH.JE_HEADER_ID = JEL.JE_HEADER_ID
AND EXP.EXPENDITURE_ID = EI.EXPENDITURE_ID
AND EXP.INCURRED_BY_PERSON_ID = EMP.PERSON_ID (+)
AND (EI.EXPENDITURE_ITEM_DATE BETWEEN NVL(EMP.EFFECTIVE_START_DATE
, EI.EXPENDITURE_ITEM_DATE)
AND NVL(EMP.EFFECTIVE_END_DATE
, EI.EXPENDITURE_ITEM_DATE ))
AND JES.JE_SOURCE_NAME = 'PROJECT ACCOUNTING'
AND NVL(EI.OVERRIDE_TO_ORGANIZATION_ID
, EXP.INCURRED_BY_ORGANIZATION_ID) = HR.ORGANIZATION_ID
AND DECODE(HR.ORGANIZATION_ID
, NULL
, '1'
, HR.LANGUAGE) = DECODE(HR.ORGANIZATION_ID
, NULL
, '1'
, USERENV('LANG'))
AND NVL(CCD.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTR(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTR(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)

Columns

Name
CC_DIST_LINE_ID
CC_DIST_LINE_TYPE
EXPENDITURE_ITEM_ID
CC_DIST_LINE_NUM
CODE_COMBINATION_ID
PROJECT_ID
PROJECT_NUMBER
TASK_ID
TASK_NUMBER
EXPENDITURE_TYPE
EXPENDITURE_ITEM_DATE
EMP_OR_ORG_NAME
JE_BATCH_NAME
JE_REP_BATCH_NAME
JE_BATCH_ID
PERIOD_NAME
JE_HEADER_ID
JE_LINE_NUMBER
GL_DATE
TRANSFERRED_DATE
GL_DR_AMOUNT
GL_CR_AMOUNT