FA Assets Not Assigned To Any Books Listing - draft

➜ Back to Library
XLSExcel example XMLXML import file

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

SQL 14 lines

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