FA Mass Additions Purge - draft

Description
Categories: BI Publisher
Application: Assets
Source: Mass Additions Purge Report (XML) - Not Supported: Reserved For Future Use
Short Name: FAS826_XML
DB package: FA_FAS826_XMLP_PKG
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
Parameter Name SQL text Validation
Batch Number
 
LOV Oracle
Ask a question