View: JAI_FA_AST_RETIR_INAYR_V

Product:	JA - Asia/Pacific Localizations
Description:
Implementation/DBA Data:	APPS.JAI_FA_AST_RETIR_INAYR_V

View Text

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

Columns