FA Assets Not Assigned To Any Books Listing - draft
Description
Categories: BI Publisher
Application: Assets
Source: Assets Not Assigned To Any Books Listing (XML) - Not Supported: Reserved For Future Use
Short Name: FAS700_XML
DB package: FA_FAS700_XMLP_PKG
Source: Assets Not Assigned To Any Books Listing (XML) - Not Supported: Reserved For Future Use
Short Name: FAS700_XML
DB package: FA_FAS700_XMLP_PKG
Run
FA Assets Not Assigned To Any Books Listing - draft and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT AD.ASSET_NUMBER ASSET_NUMBER, AD.TAG_NUMBER TAG_NUMBER, AD.DESCRIPTION DESCRIPTION FROM FA_ADDITIONS AD, FA_BOOKS BOOKS WHERE AD.ASSET_ID = BOOKS.ASSET_ID(+) AND BOOKS.ASSET_ID IS NULL ORDER BY AD.ASSET_NUMBER |