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

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