IGI Inflation Accounting : Adjustments - draft

Description
Categories: BI Publisher, Financials
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
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
Category Struct ID
 
Number
Transaction Type
 
LOV Oracle
Category
 
Period To
 
LOV Oracle
Period From
 
LOV Oracle
Book
 
LOV Oracle