View: PA_XLA_BC_BUDGET_LINES_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_XLA_BC_BUDGET_LINES_V

View Text

SELECT BC_EVENT_ID
, XEV.SOURCE_ID_INT_1
, PBL.BUDGET_LINE_ID
, PBL.BUDGET_LINE_ID
, PRA.PROJECT_ID
, PRA.TASK_ID
, PRLM.EXPENDITURE_TYPE
, PRLM.EVENT_TYPE
, PRLM.EXPENDITURE_CATEGORY
, PRLM.REVENUE_CATEGORY
, PRLM.PERSON_ID
, PRLM.JOB_ID
, PRLM.VENDOR_ID
, PBL.PERIOD_NAME
, DECODE(NVL(PBCO.BALANCE_TYPE
, 'X')
, 'E'
, DECODE(NVL(PBL.BURDENED_COST
, 0)
, 0
, NVL(PBL.RAW_COST
, 0)
, PBL.BURDENED_COST )
, 'B'
, DECODE(PBT.BUDGET_AMOUNT_CODE
, 'R'
, NVL(PBL.REVENUE
, 0)
, 'C'
, DECODE(NVL(PBL.BURDENED_COST
, 0)
, 0
, NVL(PBL.RAW_COST
, 0)
, PBL.BURDENED_COST )
, 0 )
, 0 ) ACCT_AMOUNT
, DECODE(NVL(PBCO.BALANCE_TYPE
, 'X')
, 'E'
, DECODE(NVL(PBL.BURDENED_COST
, 0)
, 0
, NVL(PBL.RAW_COST
, 0)
, PBL.BURDENED_COST )
, 'B'
, DECODE(PBT.BUDGET_AMOUNT_CODE
, 'R'
, NVL(PBL.REVENUE
, 0)
, 'C'
, DECODE(NVL(PBL.BURDENED_COST
, 0)
, 0
, NVL(PBL.RAW_COST
, 0)
, PBL.BURDENED_COST )
, 0 )
, 0 ) ENTERED_AMOUNT
, PRLM.ORGANIZATION_ID
, CODE_COMBINATION_ID
, 'N'
, DECODE(PBCO.BALANCE_TYPE
, 'E'
, 'PA_BUDGET_ENC'
, 'B'
, 'BUDGET')
, GLL.CURRENCY_CODE
, GLL.CURRENCY_CODE
, NULL
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, XEV.LEDGER_ID
, 'N'
, DECODE(PBCO.BALANCE_TYPE
, 'E'
, 'PA_BUDGET_ENC'
, 'B'
, 'BUDGET')
, NULL
, PBL.ATTRIBUTE1
, PBL.ATTRIBUTE2
, PBL.ATTRIBUTE3
, PBL.ATTRIBUTE4
, PBL.ATTRIBUTE5
, PBL.ATTRIBUTE6
, PBL.ATTRIBUTE7
, PBL.ATTRIBUTE8
, PBL.ATTRIBUTE9
, PBL.ATTRIBUTE10
, PBL.ATTRIBUTE11
, PBL.ATTRIBUTE12
, PBL.ATTRIBUTE13
, PBL.ATTRIBUTE14
, PBL.ATTRIBUTE15
FROM PA_BUDGET_LINES PBL
, PA_RESOURCE_ASSIGNMENTS PRA
, PA_RESOURCE_LIST_MEMBERS PRLM
, XLA_EVENTS_GT XEV
, GL_LEDGERS GLL
, PA_BUDGETARY_CONTROL_OPTIONS PBCO
, PA_BUDGET_VERSIONS PBV
, PA_BUDGET_TYPES PBT
WHERE PBL.RESOURCE_ASSIGNMENT_ID = PRA.RESOURCE_ASSIGNMENT_ID
AND PRLM.RESOURCE_LIST_MEMBER_ID = PRA.RESOURCE_LIST_MEMBER_ID
AND XEV.EVENT_ID = PBL.BC_EVENT_ID
AND XEV.LEDGER_ID = GLL.LEDGER_ID
AND PRA.PROJECT_ID = PBCO.PROJECT_ID
AND PBL.BUDGET_VERSION_ID = PBV.BUDGET_VERSION_ID
AND PBV.BUDGET_TYPE_CODE = PBT.BUDGET_TYPE_CODE
AND PBCO.BUDGET_TYPE_CODE = PBV.BUDGET_TYPE_CODE UNION ALL SELECT BC_REV_EVENT_ID
, XEV.SOURCE_ID_INT_1
, PBL.BUDGET_LINE_ID
, PBL.BUDGET_LINE_ID
, PRA.PROJECT_ID
, PRA.TASK_ID
, PRLM.EXPENDITURE_TYPE
, PRLM.EVENT_TYPE
, PRLM.EXPENDITURE_CATEGORY
, PRLM.REVENUE_CATEGORY
, PRLM.PERSON_ID
, PRLM.JOB_ID
, PRLM.VENDOR_ID
, PBL.PERIOD_NAME
, DECODE(NVL(PBCO.BALANCE_TYPE
, 'X')
, 'E'
, DECODE(NVL(-(PBL.BURDENED_COST)
, 0)
, 0
, NVL(-(PBL.RAW_COST)
, 0)
, -(PBL.BURDENED_COST) )
, 'B'
, DECODE(PBT.BUDGET_AMOUNT_CODE
, 'R'
, NVL(-(PBL.REVENUE)
, 0)
, 'C'
, DECODE(NVL(-(PBL.BURDENED_COST)
, 0)
, 0
, NVL(-(PBL.RAW_COST)
, 0)
, -(PBL.BURDENED_COST) )
, 0 )
, 0 ) ACCT_AMOUNT
, DECODE(NVL(PBCO.BALANCE_TYPE
, 'X')
, 'E'
, DECODE(NVL(-(PBL.BURDENED_COST)
, 0)
, 0
, NVL(-(PBL.RAW_COST)
, 0)
, -(PBL.BURDENED_COST) )
, 'B'
, DECODE(PBT.BUDGET_AMOUNT_CODE
, 'R'
, NVL(-(PBL.REVENUE)
, 0)
, 'C'
, DECODE(NVL(-(PBL.BURDENED_COST)
, 0)
, 0
, NVL(-(PBL.RAW_COST)
, 0)
, -(PBL.BURDENED_COST) )
, 0 )
, 0 ) ENTERED_AMOUNT
, PRLM.ORGANIZATION_ID
, DECODE(NVL(BC_EVENT_ID
, -999)
, -999
, PBL.CODE_COMBINATION_ID
, NULL)
, DECODE(NVL(BC_EVENT_ID
, -999)
, -999
, 'Y'
, 'N')
, DECODE(PBCO.BALANCE_TYPE
, 'E'
, 'PA_BUDGET_ENC'
, 'B'
, 'BUDGET')
, GLL.CURRENCY_CODE
, GLL.CURRENCY_CODE
, NULL
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, XEV.LEDGER_ID
, DECODE(NVL(BC_EVENT_ID
, -999)
, -999
, 'N'
, 'Y')
, DECODE(PBCO.BALANCE_TYPE
, 'E'
, 'PA_BUDGET_ENC'
, 'B'
, 'BUDGET')
, DECODE(NVL(BC_EVENT_ID
, -999)
, -999
, PA_FUNDS_CONTROL_UTILS.GET_ENCUM_TYPE_ID(PRA.PROJECT_ID
, 'STD')
, NULL)
, PBL.ATTRIBUTE1
, PBL.ATTRIBUTE2
, PBL.ATTRIBUTE3
, PBL.ATTRIBUTE4
, PBL.ATTRIBUTE5
, PBL.ATTRIBUTE6
, PBL.ATTRIBUTE7
, PBL.ATTRIBUTE8
, PBL.ATTRIBUTE9
, PBL.ATTRIBUTE10
, PBL.ATTRIBUTE11
, PBL.ATTRIBUTE12
, PBL.ATTRIBUTE13
, PBL.ATTRIBUTE14
, PBL.ATTRIBUTE15
FROM PA_BUDGET_LINES PBL
, PA_RESOURCE_ASSIGNMENTS PRA
, PA_RESOURCE_LIST_MEMBERS PRLM
, XLA_EVENTS_GT XEV
, GL_LEDGERS GLL
, PA_BUDGETARY_CONTROL_OPTIONS PBCO
, PA_BUDGET_VERSIONS PBV
, PA_BUDGET_TYPES PBT
WHERE PBL.RESOURCE_ASSIGNMENT_ID = PRA.RESOURCE_ASSIGNMENT_ID
AND PRLM.RESOURCE_LIST_MEMBER_ID = PRA.RESOURCE_LIST_MEMBER_ID
AND XEV.EVENT_ID = PBL.BC_REV_EVENT_ID
AND XEV.LEDGER_ID = GLL.LEDGER_ID
AND PRA.PROJECT_ID = PBCO.PROJECT_ID
AND PBL.BUDGET_VERSION_ID = PBV.BUDGET_VERSION_ID
AND PBV.BUDGET_TYPE_CODE = PBT.BUDGET_TYPE_CODE
AND PBCO.BUDGET_TYPE_CODE = PBV.BUDGET_TYPE_CODE

Columns