IGI Inflation Accounting : Adjustments Report- Not Supported: Reserved For Future Use
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Inflation Accounting : Adjustments Report
Application: Public Sector Financials International
Source: Inflation Accounting : Adjustments Report (XML) - Not Supported: Reserved For Future Use
Short Name: IGIIACAR_XML
DB package: IGI_IGIIACAR_XMLP_PKG
Description: Inflation Accounting : Adjustments Report
Application: Public Sector Financials International
Source: Inflation Accounting : Adjustments Report (XML) - Not Supported: Reserved For Future Use
Short Name: IGIIACAR_XML
DB package: IGI_IGIIACAR_XMLP_PKG
Run
IGI Inflation Accounting : Adjustments Report- Not Supported: Reserved For Future Use and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT A.DESCRIPTION CATEGORY, B.ASSET_NUMBER ASSET_NUMBER, C.PERIOD_COUNTER PERIOD_COUNTER, C.PERIOD_NAME PERIOD, DECODE(D.transaction_type_code, 'PARTIAL RETIRE','RETIREMENT', 'FULL RETIREMENT','RETIREMENT', 'REINSTATEMENT','RETIREMENT', D.transaction_type_code) TRANSACTION_TYPE, E.CODE_COMBINATION_ID ACCOUNT, E.AMOUNT AMOUNT, E.DR_CR_FLAG, decode(e.code_combination_Id,NULL,NULL,null) FLEXITEM, A.category_id category_id, IGI_IGIIACAR_XMLP_PKG.cf_data_foundformula(A.category_id) CF_DATA_FOUND, fnd_flex_xml_publisher_apis.process_kff_combination_1('flexitem_dsp', 'SQLGL', 'GL#', GL_ITEM.CHART_OF_ACCOUNTS_ID, NULL, GL_ITEM.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') FLEXITEM_DSP, IGI_IGIIACAR_XMLP_PKG.cf_dr_amountformula(E.DR_CR_FLAG, E.AMOUNT) CF_DR_AMOUNT, IGI_IGIIACAR_XMLP_PKG.cf_cr_amountformula(E.DR_CR_FLAG, E.AMOUNT) CF_CR_AMOUNT, IGI_IGIIACAR_XMLP_PKG.CP_DR_AMOUNT_p CP_DR_AMOUNT, IGI_IGIIACAR_XMLP_PKG.CP_CR_AMOUNT_p CP_CR_AMOUNT, DECODE(DR_CR_FLAG,'DR',E.AMOUNT,0) AMOUNT_DR, DECODE(DR_CR_FLAG,'CR',E.AMOUNT,0) AMOUNT_CR, 'x' DUMMY FROM FA_CATEGORIES A, FA_ADDITIONS B, FA_DEPRN_PERIODS C, IGI_IAC_TRANSACTION_HEADERS D, IGI_IAC_ADJUSTMENTS E, GL_CODE_COMBINATIONS GL_ITEM WHERE A.CATEGORY_ID = NVL(:P_CATEGORY_ID, A.CATEGORY_ID) AND B.ASSET_ID = E.ASSET_ID AND C.BOOK_TYPE_CODE = :P_BOOK_TYPE_CODE AND C.PERIOD_COUNTER = E.PERIOD_COUNTER AND C.PERIOD_COUNTER BETWEEN NVL(:P_PERIOD_COUNTER_FROM, C.PERIOD_COUNTER) AND NVL(:P_PERIOD_COUNTER_TO, C.PERIOD_COUNTER) AND DECODE(D.TRANSACTION_TYPE_CODE, 'PARTIAL RETIRE', 'RETIREMENT', 'FULL RETIREMENT', 'RETIREMENT', 'REINSTATEMENT', 'RETIREMENT', D.TRANSACTION_TYPE_CODE) = NVL(:P_TRANSACTION_TYPE, DECODE(D.TRANSACTION_TYPE_CODE, 'PARTIAL RETIRE', 'RETIREMENT', 'FULL RETIREMENT', 'RETIREMENT', 'REINSTATEMENT', 'RETIREMENT', D.TRANSACTION_TYPE_CODE)) AND D.BOOK_TYPE_CODE = C.BOOK_TYPE_CODE AND D.ASSET_ID = B.ASSET_ID AND D.PERIOD_COUNTER = C.PERIOD_COUNTER AND D.CATEGORY_ID = A.CATEGORY_ID AND E.ADJUSTMENT_ID = D.ADJUSTMENT_ID AND E.BOOK_TYPE_CODE = D.BOOK_TYPE_CODE AND GL_ITEM.CODE_COMBINATION_ID = E.CODE_COMBINATION_ID ORDER BY 1 ASC,10 ASC,2 ASC,3 ASC,5 ASC,9 ASC,6 ASC , A.DESCRIPTION , B.ASSET_NUMBER , D.TRANSACTION_TYPE_CODE , C.PERIOD_COUNTER |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Book |
|
LOV Oracle | |
Period From |
|
LOV Oracle | |
Period To |
|
LOV Oracle | |
Category |
|
Char | |
Transaction Type |
|
LOV Oracle |