FA Transaction History - draft
Description
Categories: BI Publisher
Application: Assets
Source: Transaction History Report (XML) - Not Supported: Reserved For Future Use
Short Name: FAS530_XML
DB package: FA_FAS530_XMLP_PKG
Source: Transaction History Report (XML) - Not Supported: Reserved For Future Use
Short Name: FAS530_XML
DB package: FA_FAS530_XMLP_PKG
Run
FA Transaction History - draft and other Oracle EBS reports with Blitz Report™ on our demo environment
Select AD.ASSET_NUMBER ASSET_NUMBER, AD.DESCRIPTION ASSET_DESC, AD.SERIAL_NUMBER S_NUMBER, AD.TAG_NUMBER T_NUMBER, LU.MEANING TRAN_TYPE, TH.TRANSACTION_HEADER_ID TRAN_ID, TH.TRANSACTION_DATE_ENTERED TRAN_DATE, DP.PERIOD_NAME PERIOD_NAME FROM FA_TRANSACTION_HEADERS TH, FA_ADDITIONS AD, FA_DEPRN_PERIODS DP, FA_LOOKUPS LU WHERE TH.BOOK_TYPE_CODE = UPPER(:P_BOOK) AND TH.ASSET_ID = AD.ASSET_ID AND LU.LOOKUP_TYPE = 'FAXOLTRX' AND LU.LOOKUP_CODE = TH.TRANSACTION_TYPE_CODE AND AD.ASSET_NUMBER >= nvl(:P_start_asset,AD.ASSET_NUMBER) AND AD.ASSET_NUMBER <= nvl(:P_end_asset,AD.ASSET_NUMBER) AND TH.DATE_EFFECTIVE BETWEEN DP.PERIOD_OPEN_DATE AND nvl(DP.PERIOD_CLOSE_DATE, SYSDATE) AND TH.BOOK_TYPE_CODE = DP.BOOK_TYPE_CODE order by AD.ASSET_NUMBER, TH.TRANSACTION_HEADER_ID |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Book |
|
LOV Oracle | |
From Asset No |
|
LOV Oracle | |
To Asset No |
|
LOV Oracle |