View: PA_CINT_TXN_DETAILS_V

Product:	PA - Projects
Description:	This is an Internal view created for Generate Capitalized interest Transaction process
Implementation/DBA Data:	APPS.PA_CINT_TXN_DETAILS_V

View Text

SELECT PP.PROJECT_ID
, PP.SEGMENT1
, PP.CARRYING_OUT_ORGANIZATION_ID
, PP.CINT_RATE_SCH_ID
, PP.START_DATE
, PP.COMPLETION_DATE
, PP.CINT_STOP_DATE
, PT.TASK_ID
, PT.TASK_NUMBER
, PT.CARRYING_OUT_ORGANIZATION_ID
, PT.START_DATE
, PT.COMPLETION_DATE
, PT.CINT_STOP_DATE
, PPT.CAPITAL_COST_TYPE_CODE
, PPT.BURDEN_AMT_DISPLAY_METHOD
, PPT.TOTAL_BURDEN_FLAG
, PEI.EXPENDITURE_ITEM_ID
, PEI.EXPENDITURE_ITEM_DATE
, DECODE(PCDL.LINE_TYPE
, 'D'
, PCDL.AMOUNT
, DECODE(PPT.CAPITAL_COST_TYPE_CODE
, 'B'
, PCDL.BURDENED_COST
, PCDL.AMOUNT) )
, PCDL.LINE_TYPE
, PCDL.LINE_NUM
, TRUNC(NVL(PCDL.RECVR_GL_DATE
, PCDL.GL_DATE))
, PCDL.BILLABLE_FLAG
, PCDL.ORG_ID
, PICC.IND_COST_CODE
, PA_CLIENT_EXTN_CAP_INT.GROUPING_METHOD (GPS.PERIOD_NAME
, PP.PROJECT_ID
, PT.TASK_ID
, PEI.EXPENDITURE_ITEM_ID
, PCDL.LINE_NUM
, PEI.EXPENDITURE_ID
, PET.EXPENDITURE_TYPE
, PET.EXPENDITURE_CATEGORY
, PEI.ATTRIBUTE1
, PEI.ATTRIBUTE2
, PEI.ATTRIBUTE3
, PEI.ATTRIBUTE4
, PEI.ATTRIBUTE5
, PEI.ATTRIBUTE6
, PEI.ATTRIBUTE7
, PEI.ATTRIBUTE8
, PEI.ATTRIBUTE9
, PEI.ATTRIBUTE10
, PEI.ATTRIBUTE_CATEGORY
, PEI.TRANSACTION_SOURCE
, PICC.IND_COST_CODE )
, DECODE(NVL(PCRI.EXP_ORG_SOURCE
, 'TASK_OWNING_ORG')
, 'PROJ_OWNING_ORG'
, PP.CARRYING_OUT_ORGANIZATION_ID
, 'TASK_OWNING_ORG'
, PT.CARRYING_OUT_ORGANIZATION_ID
, PA_CLIENT_EXTN_CAP_INT.EXPENDITURE_ORG (PEI.EXPENDITURE_ITEM_ID
, PCDL.LINE_NUM
, PICC.IND_COST_CODE) )
, PA_CLIENT_EXTN_CAP_INT.RATE_MULTIPLIER (PEI.EXPENDITURE_ITEM_ID
, PCDL.LINE_NUM
, PICC.IND_COST_CODE )
, NVL((SELECT DECODE(PPALD.EXPENDITURE_ITEM_ID
, NULL
, 'OPEN'
, 'CLOSED')
FROM PA_PROJECT_ASSET_LINE_DETAILS PPALD
WHERE PPALD.REVERSED_FLAG = 'N'
AND PPALD.LINE_NUM = PCDL.LINE_NUM
AND ROWNUM = 1
AND PPALD.EXPENDITURE_ITEM_ID = PEI.EXPENDITURE_ITEM_ID)
, 'OPEN') CDL_STATUS
, GPS.PERIOD_NAME
FROM PA_COST_DISTRIBUTION_LINES_ALL PCDL
, PA_EXPENDITURE_TYPES PET
, PA_EXPENDITURE_ITEMS_ALL PEI
, PA_TASKS PT
, PA_PROJECTS PP
, PA_PROJECT_TYPES PPT
, PA_CINT_RATE_INFO PCRI
, PA_IND_COST_CODES PICC
, PA_IMPLEMENTATIONS IMP
, GL_PERIOD_STATUSES GPS
WHERE PCDL.LINE_TYPE IN ('R'
, 'I'
, 'D')
AND PCDL.LINE_TYPE = DECODE(PPT.CAPITAL_COST_TYPE_CODE
, 'B'
, DECODE(PPT.TOTAL_BURDEN_FLAG
, 'Y'
, 'D'
, DECODE(PCDL.LINE_TYPE
, 'R'
, 'R'
, 'I'
, 'I'))
, DECODE(PCDL.LINE_TYPE
, 'R'
, 'R'
, 'I'
, 'I') )
AND PCDL.BILLABLE_FLAG = 'Y'
AND PCDL.EXPENDITURE_ITEM_ID = PEI.EXPENDITURE_ITEM_ID
AND PET.EXPENDITURE_TYPE = PEI.EXPENDITURE_TYPE
AND NVL(PT.CINT_ELIGIBLE_FLAG
, 'Y') = 'Y'
AND NVL(PT.RETIREMENT_COST_FLAG
, 'N') = 'N'
AND PCDL.TASK_ID = PT.TASK_ID
AND PCDL.PROJECT_ID = PP.PROJECT_ID
AND PP.PROJECT_TYPE = PPT.PROJECT_TYPE
AND PICC.IND_COST_CODE_USAGE = 'CAPITALIZED_INTEREST'
AND PICC.IND_COST_CODE = PCRI.IND_COST_CODE(+)
AND GPS.SET_OF_BOOKS_ID = IMP.SET_OF_BOOKS_ID
AND GPS.APPLICATION_ID = 101
AND ((NVL(PCRI.INTEREST_CALCULATION_METHOD
, 'SIMPLE')= 'SIMPLE'
AND NOT EXISTS (SELECT NULL
FROM PA_IND_COST_CODES PCODE
WHERE PCODE.IND_COST_CODE = PICC.IND_COST_CODE
AND PCODE.IND_COST_CODE_USAGE = 'CAPITALIZED_INTEREST'
AND PCODE.EXPENDITURE_TYPE = PEI.EXPENDITURE_TYPE ) ) OR ( NVL(PCRI.INTEREST_CALCULATION_METHOD
, 'SIMPLE') <> 'SIMPLE') )
AND NOT EXISTS (SELECT NULL
FROM PA_CINT_EXP_TYPE_EXCL_ALL EXCL
WHERE EXCL.IND_COST_CODE = PICC.IND_COST_CODE
AND EXCL.EXPENDITURE_TYPE = PEI.EXPENDITURE_TYPE
AND NVL(EXCL.ORG_ID
, -99) = NVL(PP.ORG_ID
, -99) )
AND ((NVL(PCRI.THRESHOLD_AMT_TYPE
, 'TOTAL_CIP') = 'TOTAL_CIP') OR (NVL(PCRI.THRESHOLD_AMT_TYPE
, 'TOTAL_CIP') <> 'TOTAL_CIP'
AND NOT EXISTS (SELECT NULL
FROM PA_PROJECT_ASSET_LINE_DETAILS PPALD
WHERE PPALD.REVERSED_FLAG = 'N'
AND PPALD.LINE_NUM = PCDL.LINE_NUM
AND PPALD.EXPENDITURE_ITEM_ID = PEI.EXPENDITURE_ITEM_ID ) ) )

Columns