FA Parent Asset - draft
Description
Categories: BI Publisher
Application: Assets
Source: Parent Asset Report (XML) - Not Supported: Reserved For Future Use
Short Name: FASPARAS_XML
DB package: FA_FASPARAS_XMLP_PKG
Source: Parent Asset Report (XML) - Not Supported: Reserved For Future Use
Short Name: FASPARAS_XML
DB package: FA_FASPARAS_XMLP_PKG
SELECT P_AD.ASSET_NUMBER || ' - ' || P_AD.DESCRIPTION PARENT_ASSET, P_AD.SERIAL_NUMBER PARENT_SERIAL, P_BOOK.COST PARENT_COST, C_AD.ASSET_NUMBER || ' - ' || C_AD.DESCRIPTION CHILD_ASSET, C_AD.SERIAL_NUMBER CHILD_SERIAL, C_BOOK.COST CHILD_COST FROM FA_BOOKS C_BOOK, FA_BOOKS P_BOOK, FA_ADDITIONS C_AD, FA_ADDITIONS P_AD WHERE C_AD.PARENT_ASSET_ID IS NOT NULL AND P_AD.ASSET_ID = C_AD.PARENT_ASSET_ID AND ( P_AD.ASSET_NUMBER BETWEEN NVL( :P_FROM_ASSET, P_AD.ASSET_NUMBER ) AND NVL( :P_TO_ASSET, P_AD.ASSET_NUMBER)) AND C_BOOK.ASSET_ID = C_AD.ASSET_ID AND C_BOOK.BOOK_TYPE_CODE = :P_BOOK AND C_BOOK.TRANSACTION_HEADER_ID_OUT IS NULL and c_book.period_counter_fully_retired is null AND P_BOOK.ASSET_ID = P_AD.ASSET_ID AND P_BOOK.BOOK_TYPE_CODE = :P_BOOK AND P_BOOK.TRANSACTION_HEADER_ID_OUT IS NULL and P_book.period_counter_fully_retired is null ORDER BY P_AD.ASSET_NUMBER, C_AD.ASSET_NUMBER |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Book |
|
LOV Oracle | |
From Asset Number |
|
Char | |
To Asset Number |
|
Char |