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

Copy

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

Download

Related Blitz Reports

FA Cost Clearing Reconciliation - draft FA Additions By Source - draft FA CIP Statistics for the Central Statistical Office (KSH) (Hungary) FA Cost Adjustments by Source - draft FA CIP Assets - draft FA Mass Additions Create - draft FA Asset Book Details FA Unposted Mass Additions - draft FA Mass Additions Invoice Merge - draft