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
Source: Mass Additions Purge Report (XML) - Not Supported: Reserved For Future Use
Short Name: FAS826_XML
DB package: FA_FAS826_XMLP_PKG
Run
FA Mass Additions Purge - draft and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |