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.

VIEW: APPS.PA_CINT_TXN_DETAILS_V

Source

View Text - Preformatted


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 ) ) )

View Text - HTML Formatted

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 ) ) )