VIEW: APPS.JAI_FA_AST_RETIR_INAYR_V

Source

View Text - Preformatted

SELECT a.asset_id, D.ASSET_NUMBER, D.DESCRIPTION, E.PO_NUMBER, a.date_retired, C.START_DATE, F.DATE_PLACED_IN_SERVICE, B.BOOK_TYPE_CODE, B.SET_OF_BOOKS_ID, C.END_DATE, C.FISCAL_YEAR, E.INVOICE_ID, E.AP_DISTRIBUTION_LINE_NUMBER FROM fa_retirements a, fa_book_controls b, FA_FISCAL_YEAR c, FA_ADDITIONS D,FA_ASSET_INVOICES E,FA_BOOKS F WHERE a.book_type_code = b.book_type_code AND B.FISCAL_YEAR_NAME = C.FISCAL_YEAR_NAME AND B.CURRENT_FISCAL_YEAR = C.FISCAL_YEAR AND c.END_DATE >= a.date_retired AND SYSDATE BETWEEN C.START_DATE AND C.END_DATE AND A.ASSET_ID =D.ASSET_ID AND A.ASSET_ID =F.ASSET_ID AND A.ASSET_ID =E.ASSET_ID AND A.BOOK_TYPE_CODE = F.BOOK_TYPE_CODE AND C.START_DATE <= F.DATE_PLACED_IN_SERVICE AND E.AP_DISTRIBUTION_LINE_NUMBER=1

View Text - HTML Formatted

SELECT A.ASSET_ID
, D.ASSET_NUMBER
, D.DESCRIPTION
, E.PO_NUMBER
, A.DATE_RETIRED
, C.START_DATE
, F.DATE_PLACED_IN_SERVICE
, B.BOOK_TYPE_CODE
, B.SET_OF_BOOKS_ID
, C.END_DATE
, C.FISCAL_YEAR
, E.INVOICE_ID
, E.AP_DISTRIBUTION_LINE_NUMBER
FROM FA_RETIREMENTS A
, FA_BOOK_CONTROLS B
, FA_FISCAL_YEAR C
, FA_ADDITIONS D
, FA_ASSET_INVOICES E
, FA_BOOKS F
WHERE A.BOOK_TYPE_CODE = B.BOOK_TYPE_CODE
AND B.FISCAL_YEAR_NAME = C.FISCAL_YEAR_NAME
AND B.CURRENT_FISCAL_YEAR = C.FISCAL_YEAR
AND C.END_DATE >= A.DATE_RETIRED
AND SYSDATE BETWEEN C.START_DATE
AND C.END_DATE
AND A.ASSET_ID =D.ASSET_ID
AND A.ASSET_ID =F.ASSET_ID
AND A.ASSET_ID =E.ASSET_ID
AND A.BOOK_TYPE_CODE = F.BOOK_TYPE_CODE
AND C.START_DATE <= F.DATE_PLACED_IN_SERVICE
AND E.AP_DISTRIBUTION_LINE_NUMBER=1