FA Mass Additions Purge - draft
Description
Categories: BI Publisher
Columns: Status, Ma Id, Inv Num, Ap Num, Description, Post Id, Fa Fas826 Xmlp Pkg.D Statusformula(Nvl(Dma.Status,'A')) ...
Columns: Status, Ma Id, Inv Num, Ap Num, Description, Post Id, Fa Fas826 Xmlp Pkg.D Statusformula(Nvl(Dma.Status,'A')) ...
Application: Assets
Source: Mass Additions Purge Report (XML) - Not Supported: Reserved For Future Use
Short Name: FAS826_XML
DB package: FA_FAS826_XMLP_PKG
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 |