FA Mass Additions Purge - draft

SELECT
	nvl(DMA.STATUS, '  A')					STATUS,
	DMA.MASS_ADDITION_ID	MA_ID,
	INV.INVOICE_NUM		INV_NUM,
	DMA.INVOICE_LINE_NUMBER||' - '||DMA.AP_DISTRIBUTION_LINE_NUMBER			AP_NUM,
	DMA.DESCRIPTION					DESCRIPTION,
	DMA.POST_BATCH_ID				POST_ID,
	FA_FAS826_XMLP_PKG.d_statusformula(nvl(DMA.STATUS, '  A'))
FROM	
	FA_DELETED_MASS_ADDITIONS		DMA,
	AP_INVOICES_all	INV
WHERE	
	DMA.CREATE_BATCH_ID		= :P_BATCH_ID 
AND
	INV.INVOICE_ID (+)	= DMA.INVOICE_ID
ORDER BY 
	DMA.MASS_ADDITION_ID,
	DMA.INVOICE_ID,
	DMA.INVOICE_LINE_NUMBER||' - '||DMA.AP_DISTRIBUTION_LINE_NUMBER