FA Mass Additions Delete - draft
Description
- Categories
- BI Publisher
- Application
- Assets
- Source
- Mass Additions Delete Report (XML) - Not Supported: Reserved For Future Use
- Short Name
- FAS829_XML
- DB package
- FA_FAS829_XMLP_PKG
SQL 33 lines
SELECT FAMA.MASS_ADDITION_ID ASSET, FAMA.DESCRIPTION DESCRIPTION, FAMA.FIXED_ASSETS_COST COST, FAMA.REVIEWER_COMMENTS COMMENTS --Added during DT Fixes ,FA_FAS829_XMLP_PKG.D_COSTFormula Temp_RP_DATA_FOUND --End of DT Fixes FROM FA_MASS_ADDITIONS FAMA WHERE POSTING_STATUS = 'DELETE' AND BOOK_TYPE_CODE = :P_BOOK union SELECT fama.MASS_ADDITION_ID ASSET, fama.DESCRIPTION DESCRIPTION, fama.FIXED_ASSETS_COST COST, fama.REVIEWER_COMMENTS COMMENTS --Added during DT Fixes ,FA_FAS829_XMLP_PKG.D_COSTFormula Temp_RP_DATA_FOUND --End of DT Fixes FROM FA_MASS_ADDITIONS ma2, fa_mass_additions fama WHERE ma2.POSTING_STATUS = 'DELETE' AND fama.BOOK_TYPE_CODE = :P_BOOK AND fama.MERGE_PARENT_MASS_ADDITIONS_ID = ma2.mass_ADDITION_ID AND fama.MERGED_CODE = 'MC' ORDER BY -- 1,2 1, 2, 3, 4 |
Parameters 1
| Parameter | Type | List of values SQL |
|---|---|---|
| Book | LOV Oracle |