DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.JAI_FA_AST_RETIR_INAYR_V

Object Details
Object Name: JAI_FA_AST_RETIR_INAYR_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewJA.JAI_FA_AST_RETIR_INAYR_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ASSET_ID NUMBER (15) Yes Asset identification number
ASSET_NUMBER VARCHAR2 (15) Yes
DESCRIPTION VARCHAR2 (80)
PO_NUMBER VARCHAR2 (20)
DATE_RETIRED DATE
Yes
START_DATE DATE
Yes
DATE_PLACED_IN_SERVICE DATE
Yes
BOOK_TYPE_CODE VARCHAR2 (15) Yes
SET_OF_BOOKS_ID NUMBER (15) Yes
END_DATE DATE
Yes
FISCAL_YEAR NUMBER (4) Yes
INVOICE_ID NUMBER (15)
AP_DISTRIBUTION_LINE_NUMBER NUMBER (15)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ASSET_ID
,      ASSET_NUMBER
,      DESCRIPTION
,      PO_NUMBER
,      DATE_RETIRED
,      START_DATE
,      DATE_PLACED_IN_SERVICE
,      BOOK_TYPE_CODE
,      SET_OF_BOOKS_ID
,      END_DATE
,      FISCAL_YEAR
,      INVOICE_ID
,      AP_DISTRIBUTION_LINE_NUMBER
FROM APPS.JAI_FA_AST_RETIR_INAYR_V;

Dependencies

[top of page]

APPS.JAI_FA_AST_RETIR_INAYR_V references the following:

SchemaAPPS
SynonymFA_ADDITIONS
SynonymFA_ASSET_INVOICES
SynonymFA_BOOKS
SynonymFA_BOOK_CONTROLS
SynonymFA_FISCAL_YEAR
SynonymFA_RETIREMENTS

APPS.JAI_FA_AST_RETIR_INAYR_V is not referenced by any database object