FND Design Data [Home] [Help]

View: PA_TRX_FUNDS_CHK_DET_V

Product: PA - Projects
Description:
Implementation/DBA Data: ViewAPPS.PA_TRX_FUNDS_CHK_DET_V
View Text

SELECT BC.ROWID
, BC.PACKET_ID
, BC.BC_PACKET_ID
, BC.PARENT_BC_PACKET_ID
, BC.REQUEST_ID
, BC.PROJECT_ID
, BC.TASK_ID
, BC.TOP_TASK_ID
, BC.BUDGET_CCID
, BC.EXPENDITURE_TYPE
, BC.EXPENDITURE_ITEM_DATE
, BC.ACTUAL_FLAG
, BC.STATUS_CODE
, BC.SET_OF_BOOKS_ID
, BC.JE_CATEGORY_NAME
, BC.JE_SOURCE_NAME
, BC.DOCUMENT_TYPE
, BC.EXPENDITURE_ORGANIZATION_ID
, BC.PERIOD_NAME
, BC.PERIOD_YEAR
, BC.PERIOD_NUM
, BC.DOCUMENT_HEADER_ID
, BC.DOCUMENT_DISTRIBUTION_ID
, BC.BUDGET_VERSION_ID
, NVL(BC.ACCOUNTED_DR
, 0)
, NVL(BC.ACCOUNTED_CR
, 0)
, BC.EFFECT_ON_FUNDS_CODE
, BC.RESULT_CODE
, BC.GL_ROW_NUMBER
, BC.RESOURCE_LIST_MEMBER_ID
, BC.PARENT_RESOURCE_ID
, BC.BUD_RESOURCE_LIST_MEMBER_ID
, BC.BUD_TASK_ID
, BC.R_FUNDS_CONTROL_LEVEL_CODE
, BC.RG_FUNDS_CONTROL_LEVEL_CODE
, BC.T_FUNDS_CONTROL_LEVEL_CODE
, BC.TT_FUNDS_CONTROL_LEVEL_CODE
, BC.P_FUNDS_CONTROL_LEVEL_CODE
, NVL(BC.PROJECT_BUDGET_POSTED
, 0)
, NVL(BC.PROJECT_BUDGET_POSTED
, 0)
, NVL(BC.PROJECT_ENC_POSTED
, 0)
, NVL(BC.PROJECT_ENC_APPROVED
, 0)
, NVL(BC.PROJECT_ENC_POSTED
, 0) +NVL(BC.PROJECT_ENC_APPROVED
, 0) - DECODE(BC.ACTUAL_FLAG
, 'E'
, (NVL(BC.ENTERED_DR
, 0) - NVL(BC.ENTERED_CR
, 0))
, 0)
, NVL(BC.PROJECT_ACTUAL_POSTED
, 0)
, NVL(BC.PROJECT_ACTUAL_APPROVED
, 0)
, NVL(BC.PROJECT_ACTUAL_POSTED
, 0) +NVL(BC.PROJECT_ACTUAL_APPROVED
, 0) - DECODE(BC.ACTUAL_FLAG
, 'A'
, (NVL(BC.ENTERED_DR
, 0) - NVL(BC.ENTERED_CR
, 0))
, 0)
, BC.PROJECT_RESULT_CODE
, NVL(BC.TOP_TASK_BUDGET_POSTED
, 0)
, NVL(BC.TOP_TASK_BUDGET_POSTED
, 0)
, NVL(BC.TOP_TASK_ENC_POSTED
, 0)
, NVL(BC.TOP_TASK_ENC_APPROVED
, 0)
, NVL(BC.TOP_TASK_ENC_POSTED
, 0) +NVL(BC.TOP_TASK_ENC_APPROVED
, 0) - DECODE(BC.ACTUAL_FLAG
, 'E'
, (NVL(BC.ENTERED_DR
, 0) - NVL(BC.ENTERED_CR
, 0))
, 0)
, NVL(BC.TOP_TASK_ACTUAL_POSTED
, 0)
, NVL(BC.TOP_TASK_ACTUAL_APPROVED
, 0)
, NVL(BC.TOP_TASK_ACTUAL_POSTED
, 0) +NVL(BC.TOP_TASK_ACTUAL_APPROVED
, 0) - DECODE(BC.ACTUAL_FLAG
, 'A'
, (NVL(BC.ENTERED_DR
, 0) - NVL(BC.ENTERED_CR
, 0))
, 0)
, BC.TOP_TASK_RESULT_CODE
, NVL(BC.TASK_BUDGET_POSTED
, 0)
, NVL(BC.TASK_BUDGET_POSTED
, 0)
, NVL(BC.TASK_ENC_POSTED
, 0)
, NVL(BC.TASK_ENC_APPROVED
, 0)
, NVL(BC.TASK_ENC_POSTED
, 0) +NVL(BC.TASK_ENC_APPROVED
, 0) - DECODE(BC.ACTUAL_FLAG
, 'E'
, (NVL(BC.ENTERED_DR
, 0) - NVL(BC.ENTERED_CR
, 0))
, 0)
, NVL(BC.TASK_ACTUAL_POSTED
, 0)
, NVL(BC.TASK_ACTUAL_APPROVED
, 0)
, NVL(BC.TASK_ACTUAL_POSTED
, 0) +NVL(BC.TASK_ACTUAL_APPROVED
, 0) - DECODE(BC.ACTUAL_FLAG
, 'A'
, (NVL(BC.ENTERED_DR
, 0) - NVL(BC.ENTERED_CR
, 0))
, 0)
, BC.TASK_RESULT_CODE
, NVL(BC.RES_GRP_BUDGET_POSTED
, 0)
, NVL(BC.RES_GRP_BUDGET_POSTED
, 0)
, NVL(BC.RES_GRP_ENC_POSTED
, 0)
, NVL(BC.RES_GRP_ENC_APPROVED
, 0)
, NVL(BC.RES_GRP_ENC_POSTED
, 0) +NVL(BC.RES_GRP_ENC_APPROVED
, 0) - DECODE(BC.ACTUAL_FLAG
, 'E'
, (NVL(BC.ENTERED_DR
, 0) - NVL(BC.ENTERED_CR
, 0))
, 0)
, NVL(BC.RES_GRP_ACTUAL_POSTED
, 0)
, NVL(BC.RES_GRP_ACTUAL_APPROVED
, 0)
, NVL(BC.RES_GRP_ACTUAL_POSTED
, 0) +NVL(BC.RES_GRP_ACTUAL_APPROVED
, 0) - DECODE(BC.ACTUAL_FLAG
, 'A'
, (NVL(BC.ENTERED_DR
, 0) - NVL(BC.ENTERED_CR
, 0))
, 0)
, BC.RES_GRP_RESULT_CODE
, NVL(BC.RES_BUDGET_POSTED
, 0)
, NVL(BC.RES_BUDGET_POSTED
, 0)
, NVL(BC.RES_ENC_POSTED
, 0)
, NVL(BC.RES_ENC_APPROVED
, 0)
, NVL(BC.RES_ENC_POSTED
, 0) +NVL(BC.RES_ENC_APPROVED
, 0) - DECODE(BC.ACTUAL_FLAG
, 'E'
, (NVL(BC.ENTERED_DR
, 0) - NVL(BC.ENTERED_CR
, 0))
, 0)
, NVL(BC.RES_ACTUAL_POSTED
, 0)
, NVL(BC.RES_ACTUAL_APPROVED
, 0)
, NVL(BC.RES_ACTUAL_POSTED
, 0) +NVL(BC.RES_ACTUAL_APPROVED
, 0) - DECODE(BC.ACTUAL_FLAG
, 'A'
, (NVL(BC.ENTERED_DR
, 0) - NVL(BC.ENTERED_CR
, 0))
, 0)
, BC.RES_RESULT_CODE
, NVL(BC.PROJECT_BUDGET_POSTED
, 0)-NVL(BC.PROJECT_ACTUAL_POSTED
, 0)- NVL(BC.PROJECT_ENC_POSTED
, 0)
, NVL(BC.TOP_TASK_BUDGET_POSTED
, 0)-NVL(BC.TOP_TASK_ACTUAL_POSTED
, 0)- NVL(BC.TOP_TASK_ENC_POSTED
, 0)
, NVL(BC.TASK_BUDGET_POSTED
, 0)-NVL(BC.TASK_ACTUAL_POSTED
, 0)- NVL(BC.TASK_ENC_POSTED
, 0)
, NVL(BC.RES_BUDGET_POSTED
, 0)-NVL(BC.RES_ACTUAL_POSTED
, 0)- NVL(BC.RES_ENC_POSTED
, 0)
, NVL(BC.RES_GRP_BUDGET_POSTED
, 0)-NVL(BC.RES_GRP_ACTUAL_POSTED
, 0)- NVL(BC.RES_GRP_ENC_POSTED
, 0)
, NVL(BC.PROJECT_BUDGET_POSTED
, 0) -NVL(BC.PROJECT_ACTUAL_POSTED
, 0) - NVL(BC.PROJECT_ENC_POSTED
, 0) -NVL(BC.PROJECT_ACTUAL_APPROVED
, 0) -NVL(BC.PROJECT_ENC_APPROVED
, 0) - (NVL(ACCOUNTED_DR
, 0) -NVL(ACCOUNTED_CR
, 0))
, NVL(BC.TASK_BUDGET_POSTED
, 0) -NVL(BC.TASK_ACTUAL_POSTED
, 0) - NVL(BC.TASK_ENC_POSTED
, 0) -NVL(BC.TASK_ACTUAL_APPROVED
, 0) -NVL(BC.TASK_ENC_APPROVED
, 0) - (NVL(ACCOUNTED_DR
, 0) -NVL(ACCOUNTED_CR
, 0))
, NVL(BC.TOP_TASK_BUDGET_POSTED
, 0) -NVL(BC.TOP_TASK_ACTUAL_POSTED
, 0) - NVL(BC.TOP_TASK_ENC_POSTED
, 0) -NVL(BC.TOP_TASK_ACTUAL_APPROVED
, 0) - NVL(BC.TOP_TASK_ENC_APPROVED
, 0) - (NVL(ACCOUNTED_DR
, 0) -NVL(ACCOUNTED_CR
, 0))
, NVL(BC.RES_BUDGET_POSTED
, 0) -NVL(BC.RES_ACTUAL_POSTED
, 0) - NVL(BC.RES_ENC_POSTED
, 0) -NVL(BC.RES_ACTUAL_APPROVED
, 0) - NVL(BC.RES_ENC_APPROVED
, 0) - (NVL(ACCOUNTED_DR
, 0) -NVL(ACCOUNTED_CR
, 0))
, NVL(BC.RES_GRP_BUDGET_POSTED
, 0) -NVL(BC.RES_GRP_ACTUAL_POSTED
, 0) -NVL(BC.RES_GRP_ENC_POSTED
, 0) -NVL(BC.RES_GRP_ACTUAL_APPROVED
, 0) -NVL(BC.RES_GRP_ENC_APPROVED
, 0) - (NVL(ACCOUNTED_DR
, 0) -NVL(ACCOUNTED_CR
, 0))
, PR.SEGMENT1
, TA.TASK_NUMBER
, BV.VERSION_NAME
, L1.MEANING
, L2.MEANING
, L3.MEANING
, L4.MEANING
, L5.MEANING
, L6.MEANING
FROM PA_BC_PACKETS BC
, PA_PROJECTS_ALL PR
, PA_TASKS TA
, PA_LOOKUPS L1
, PA_LOOKUPS L2
, PA_LOOKUPS L3
, PA_LOOKUPS L4
, PA_LOOKUPS L5
, PA_LOOKUPS L6
, PA_BUDGET_VERSIONS BV
WHERE BC.PROJECT_ID = PR.PROJECT_ID
AND BC.TASK_ID = TA.TASK_ID
AND BV.BUDGET_VERSION_ID(+) = BC.BUDGET_VERSION_ID
AND L1.LOOKUP_TYPE(+) = 'FC_RESULT_CODE'
AND L1.LOOKUP_CODE(+) = BC.RESULT_CODE
AND L2.LOOKUP_TYPE(+) = 'FC_RESULT_CODE'
AND L2.LOOKUP_CODE(+) = BC.PROJECT_RESULT_CODE
AND L3.LOOKUP_TYPE(+) = 'FC_RESULT_CODE'
AND L3.LOOKUP_CODE(+) = BC.TASK_RESULT_CODE
AND L4.LOOKUP_TYPE(+) = 'FC_RESULT_CODE'
AND L4.LOOKUP_CODE(+) = BC.RES_RESULT_CODE
AND L5.LOOKUP_TYPE(+) = 'FC_RESULT_CODE'
AND L5.LOOKUP_CODE(+) = BC.RES_GRP_RESULT_CODE
AND L6.LOOKUP_TYPE(+) = 'FC_RESULT_CODE'
AND L6.LOOKUP_CODE(+) = BC.TOP_TASK_RESULT_CODE

Columns

Name
ROW_ID
PACKET_ID
BC_PACKET_ID
PARENT_BC_PACKET_ID
REQUEST_ID
PROJECT_ID
TASK_ID
TOP_TASK_ID
BUDGET_CCID
EXPENDITURE_TYPE
EXPENDITURE_ITEM_DATE
ACTUAL_FLAG
STATUS_CODE
SET_OF_BOOKS_ID
JE_CATEGORY_NAME
JE_SOURCE_NAME
DOCUMENT_TYPE
EXPENDITURE_ORGANIZATION_ID
PERIOD_NAME
PERIOD_YEAR
PERIOD_NUM
DOCUMENT_HEADER_ID
DOCUMENT_DISTRIBUTION_ID
BUDGET_VERSION_ID
ACCOUNTED_DR
ACCOUNTED_CR
EFFECT_ON_FUNDS_CODE
RESULT_CODE
GL_ROW_NUMBER
RESOURCE_LIST_MEMBER_ID
PARENT_RESOURCE_ID
BUD_RESOURCE_LIST_MEMBER_ID
BUD_TASK_ID
R_FUNDS_CONTROL_LEVEL_CODE
RG_FUNDS_CONTROL_LEVEL_CODE
T_FUNDS_CONTROL_LEVEL_CODE
TT_FUNDS_CONTROL_LEVEL_CODE
P_FUNDS_CONTROL_LEVEL_CODE
PROJECT_BUDGET_POSTED
TOTAL_PROJECT_BUDGET
PROJECT_ENC_POSTED
PROJECT_ENC_APPROVED
TOTAL_PROJECT_ENCUMBRANCE
PROJECT_ACTUAL_POSTED
PROJECT_ACTUAL_APPROVED
TOTAL_PROJECT_ACTUAL
PROJECT_RESULT_CODE
TOP_TASK_BUDGET_POSTED
TOTAL_TOP_TASK_BUDGET
TOP_TASK_ENC_POSTED
TOP_TASK_ENC_APPROVED
TOTAL_TOP_TASK_ENCUMBRANCE
TOP_TASK_ACTUAL_POSTED
TOP_TASK_ACTUAL_APPROVED
TOTAL_TOP_TASK_ACTUAL
TOP_TASK_RESULT_CODE
TASK_BUDGET_POSTED
TOTAL_TASK_BUDGET
TASK_ENC_POSTED
TASK_ENC_APPROVED
TOTAL_TASK_ENCUMBRANCE
TASK_ACTUAL_POSTED
TASK_ACTUAL_APPROVED
TOTAL_TASK_ACTUAL
TASK_RESULT_CODE
RES_GRP_BUDGET_POSTED
TOTAL_RES_GRP_BUDGET
RES_GRP_ENC_POSTED
RES_GRP_ENC_APPROVED
TOTAL_RES_GRP_ENC
RES_GRP_ACTUAL_POSTED
RES_GRP_ACTUAL_APPROVED
TOTAL_RES_GRP_ACTUAL
RES_GRP_RESULT_CODE
RES_BUDGET_POSTED
TOTAL_RES_BUDGET
RES_ENC_POSTED
RES_ENC_APPROVED
TOTAL_RES_ENC
RES_ACTUAL_POSTED
RES_ACTUAL_APPROVED
TOTAL_RES_ACTUAL
RES_RESULT_CODE
PROJECT_FA_POSTED
TOP_TASK_FA_POSTED
TASK_FA_POSTED
RES_FA_POSTED
RES_GRP_FA_POSTED
TOTAL_PROJECT_FA
TOTAL_TASK_FA
TOTAL_TOP_TASK_FA
TOTAL_RES_FA
TOTAL_RES_GRP_FA
PROJECT
TASK
VERSION_NAME
PA_RESULT_CODE_MEAN
PROJECT_RESULT_CODE_MEAN
TASK_RESULT_CODE_MEAN
RES_RESULT_CODE_MEAN
RES_GRP_RESULT_CODE_MEAN
TOP_TASK_RESULT_CODE_MEAN