FA CIP Detail Report- Not Supported: Reserved For Future Use
Description
- Categories
- BI Publisher
- Application
- Assets
- Source
- CIP Detail Report (XML) - Not Supported: Reserved For Future Use
- Short Name
- FASWIPDR_XML
- DB package
- FA_FASCOSTD_XMLP_PKG
Imported from BI Publisher
Construction in Process Detail Report
Construction in Process Detail Report
SQL 64 lines
SELECT --&ACCT_FLEX_BAL_SEG COMP_CODE, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_comp_code', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') D_COMP_CODE1, --NVL(&ACCT_FLEX_ACCT_SEG, BAL.Category_Books_Account) ACCOUNT, NVL(fnd_flex_xml_publisher_apis.process_kff_combination_1('d_account', 'SQLGL', 'GL#', ajcc.CHART_OF_ACCOUNTS_ID, NULL, ajcc.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'VALUE'), BAL.Category_Books_Account) D_ACCOUNT1, BAL.Category_Books_Account D_ACCOUNT2, --&ACCT_FLEX_COST_SEG COST_CTR, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_cost_ctr', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'FA_COST_CTR', 'Y', 'VALUE') D_COST_CTR1, AD.Asset_Number ASSET, NVL(SUM (DECODE (BAL.Source_Type_Code, 'BEGIN', NVL(BAL.Amount,0), NULL)), 0) BEGIN, SUM (DECODE (BAL.Source_Type_Code, DECODE(:P_REPORT_TYPE, 'COST', 'ADDITION', 'CIP ADDITION'), NVL(BAL.Amount,0), NULL)) ADDITION, SUM (DECODE (BAL.Source_Type_Code, DECODE(:P_REPORT_TYPE, 'CIP COST', 'ADDITION'), -NVL(BAL.Amount,0), NULL)) CAPITALIZATION, SUM (DECODE (BAL.Source_Type_Code, DECODE(:P_REPORT_TYPE, 'COST', 'ADJUSTMENT', 'CIP ADJUSTMENT'), NVL(BAL.Amount,0), NULL)) ADJUSTMENT, SUM (DECODE (BAL.Source_Type_Code, 'RECLASS', NVL(BAL.Amount,0), NULL)) RECLASS, SUM (DECODE (BAL.Source_Type_Code, DECODE(:P_REPORT_TYPE, 'COST', 'RETIREMENT', 'CIP RETIREMENT'), -NVL(BAL.Amount,0), NULL)) RETIREMENT, SUM (DECODE (BAL.Source_Type_Code, 'REVALUATION', NVL(BAL.Amount,0), NULL)) REVALUATION, SUM (DECODE (BAL.Source_Type_Code, 'TRANSFER', NVL(BAL.Amount,0), NULL)) TRANSFER, NVL(SUM (DECODE (BAL.Source_Type_Code, 'END', NVL(BAL.Amount,0), NULL)), 0) END, --fnd_flex_xml_publisher_apis.process_kff_combination_1('d_comp_code', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') d_comp_code, FA_FASCOSTD_XMLP_PKG.bal_out_of_balanceformula(:BAL_BEGIN, :BAL_ADD, :BAL_REVAL, :BAL_RECLASS, :BAL_RETIRE, :BAL_ADJUST, :BAL_TRANS, :BAL_CAPITAL, :BAL_END) BAL_OUT_OF_BALANCE, --fnd_flex_xml_publisher_apis.process_kff_combination_1('d_account', 'SQLGL', 'GL#', ajcc.CHART_OF_ACCOUNTS_ID, NULL, ajcc.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'VALUE') d_account, FA_FASCOSTD_XMLP_PKG.acct_out_of_balanceformula(:ACCT_BEGIN, :ACCT_ADD, :ACCT_REVAL, :ACCT_RECLASS, :ACCT_RETIRE, :ACCT_ADJUST, :ACCT_TRANS, :ACCT_CAPITAL, :ACCT_END) ACCT_OUT_OF_BALANCE, --fnd_flex_xml_publisher_apis.process_kff_combination_1('d_cost_ctr', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'FA_COST_CTR', 'Y', 'VALUE') d_cost_ctr, FA_FASCOSTD_XMLP_PKG.ctr_out_of_balanceformula(:CTR_BEGIN, :CTR_ADD, :CTR_REVAL, :CTR_RECLASS, :CTR_RETIRE, :CTR_ADJUST, :CTR_TRANS, :CTR_CAPITAL, :CTR_END) CTR_OUT_OF_BALANCE, FA_FASCOSTD_XMLP_PKG.caprevalformula(SUM ( DECODE ( BAL.Source_Type_Code , 'REVALUATION' , NVL ( BAL.Amount , 0 ) , NULL ) ), SUM ( DECODE ( BAL.Source_Type_Code , DECODE ( :P_REPORT_TYPE , 'CIP COST' , 'ADDITION' ) , - NVL ( BAL.Amount , 0 ) , NULL ) )) CAPREVAL, FA_FASCOSTD_XMLP_PKG.out_of_balanceformula(NVL ( SUM ( DECODE ( BAL.Source_Type_Code , 'BEGIN' , NVL ( BAL.Amount , 0 ) , NULL ) ) , 0 ), SUM ( DECODE ( BAL.Source_Type_Code , DECODE ( :P_REPORT_TYPE , 'COST' , 'ADDITION' , 'CIP ADDITION' ) , NVL ( BAL.Amount , 0 ) , NULL ) ), SUM ( DECODE ( BAL.Source_Type_Code , 'REVALUATION' , NVL ( BAL.Amount , 0 ) , NULL ) ), SUM ( DECODE ( BAL.Source_Type_Code , 'RECLASS' , NVL ( BAL.Amount , 0 ) , NULL ) ), SUM ( DECODE ( BAL.Source_Type_Code , DECODE ( :P_REPORT_TYPE , 'COST' , 'RETIREMENT' , 'CIP RETIREMENT' ) , - NVL ( BAL.Amount , 0 ) , NULL ) ), SUM ( DECODE ( BAL.Source_Type_Code , DECODE ( :P_REPORT_TYPE , 'COST' , 'ADJUSTMENT' , 'CIP ADJUSTMENT' ) , NVL ( BAL.Amount , 0 ) , NULL ) ), SUM ( DECODE ( BAL.Source_Type_Code , 'TRANSFER' , NVL ( BAL.Amount , 0 ) , NULL ) ), SUM ( DECODE ( BAL.Source_Type_Code , DECODE ( :P_REPORT_TYPE , 'CIP COST' , 'ADDITION' ) , - NVL ( BAL.Amount , 0 ) , NULL ) ), NVL ( SUM ( DECODE ( BAL.Source_Type_Code , 'END' , NVL ( BAL.Amount , 0 ) , NULL ) ) , 0 )) OUT_OF_BALANCE FROM FA_BALANCES_REPORT_GT BAL, FA_ADDITIONS AD, GL_CODE_COMBINATIONS DHCC, GL_CODE_COMBINATIONS AJCC WHERE AD.Asset_ID = BAL.Asset_ID AND DHCC.Code_Combination_ID = BAL.Distribution_CCID AND AJCC.Code_Combination_ID (+) = BAL.Adjustment_CCID AND :DO_INSERT = 1 GROUP BY --&ACCT_FLEX_BAL_SEG, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_comp_code', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE'), --NVL(&ACCT_FLEX_ACCT_SEG, BAL.Category_Books_Account), NVL(fnd_flex_xml_publisher_apis.process_kff_combination_1('d_account', 'SQLGL', 'GL#', ajcc.CHART_OF_ACCOUNTS_ID, NULL, ajcc.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'VALUE'), BAL.Category_Books_Account), --&ACCT_FLEX_COST_SEG, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_cost_ctr', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'FA_COST_CTR', 'Y', 'VALUE'), AD.ASSET_NUMBER, BAL.Category_Books_Account ORDER BY 1, 2, 3, 4 |
Parameters 4
| Parameter | Type | List of values SQL |
|---|---|---|
| Book | LOV Oracle | |
| Ledger Currency | LOV Oracle | |
| From Period | LOV Oracle | |
| To Period | LOV Oracle |