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
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
Ask a question