FA Mass Additions Status - draft

SELECT	
	--MA.BOOK_TYPE_CODE				BOOK,
	MA.BOOK_TYPE_CODE				BOOK2,
	MA.MASS_ADDITION_ID				MASS_ADD_ID,
	decode (MA.ASSET_TYPE,
		'CIP',CB.CIP_COST_ACCT,
		      CB.ASSET_COST_ACCT)		ASSET_ACCOUNT,
	MA.PAYABLES_BATCH_NAME				PAYABLES_REFER,
	MA.INVOICE_NUMBER				INVOICE_NUMBER,	
	VEND.VENDOR_NAME				VENDOR_NAME,
	MA.DESCRIPTION					DESCRIPTION,
	/*decode(fama.deprn_expense_ccid, null, null,
                &ACCT_FLEX_ALL_SEG)                     GL_NUMBER,*/
	decode(fama.deprn_expense_ccid, null, null,fnd_flex_xml_publisher_apis.process_kff_combination_1('d_gl_number', 'SQLGL', 'GL#', glcc.CHART_OF_ACCOUNTS_ID, NULL, glcc.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE')) D_GL_NUMBER1, 
	MA.ASSET_NUMBER					ASSET_NUMBER,
                  MA.SUM_UNITS					SUM_UNITS,
	MA.FIXED_ASSETS_UNITS				FIXED_ASSETS_UNITS,
	(MA.FIXED_ASSETS_COST * FAMA.UNITS) 			COST, 
	--fnd_flex_xml_publisher_apis.process_kff_combination_1('d_gl_number', 'SQLGL', 'GL#', glcc.CHART_OF_ACCOUNTS_ID, NULL, glcc.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') D_GL_NUMBER, 
	FA_FAS823_XMLP_PKG.new_costformula(MA.SUM_UNITS, MA.MASS_ADDITION_ID, ( MA.FIXED_ASSETS_COST * FAMA.UNITS ), MA.FIXED_ASSETS_UNITS) NEW_COST
--Added during DT Fixes
	,FA_FAS823_XMLP_PKG.D_COSTFormula Temp_RP_DATA_FOUND
--End of DT Fixes
FROM 
	FA_MASSADD_DISTRIBUTIONS				FAMA,
	FA_MASS_ADDITIONS				MA,
	PO_VENDORS					VEND,
	GL_CODE_COMBINATIONS				GLCC,
	FA_CATEGORY_BOOKS				CB
WHERE
	MA.BOOK_TYPE_CODE		= :P_BOOK  AND
	DECODE (MA.SPLIT_CODE, 
		'SP', MA.POSTING_STATUS,
		DECODE(MA.MERGED_CODE, 'MC', MA.POSTING_STATUS,
		      MA.QUEUE_NAME))	= :P_STATUS
AND
	VEND.VENDOR_ID (+)		= MA.PO_VENDOR_ID
AND
	FAMA.MASS_ADDITION_ID(+)		= MA.MASS_ADDITION_ID
AND
	GLCC.CODE_COMBINATION_ID (+)	= FAMA.DEPRN_EXPENSE_CCID
AND
	CB.BOOK_TYPE_CODE (+)	= :P_BOOK  AND
	CB.CATEGORY_ID (+)	= MA.ASSET_CATEGORY_ID
ORDER BY
	lpad (decode (MA.asset_type, 
		      'CIP', CB.CIP_COST_ACCT,
			     CB.ASSET_COST_ACCT), 25, 0),
	lpad (MA.PAYABLES_BATCH_NAME, 50, 0),	
	lpad (MA.INVOICE_NUMBER, 15, 0),
	lpad (&ACCT_FLEX_ALL_SEG, 25, 0),
	MA.ASSET_NUMBER,
	MA.MASS_ADDITION_ID,
3, 10, 11, 1, 2, 4, 5, 6, 7, 8, 9, 12