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

VIEW: APPS.JA_AU_SOURCE_ADDITIONS_BOOKS_V

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ASSET_ID NUMBER (15) Yes
BOOK_TYPE_CODE VARCHAR2 (15) Yes
DATE_RETIRED DATE


ASSET_NUMBER VARCHAR2 (15) Yes
TAG_NUMBER VARCHAR2 (15)

DESCRIPTION VARCHAR2 (80)

ASSET_CATEGORY_ID NUMBER (15) Yes
ATTRIBUTE_CATEGORY_CODE VARCHAR2 (210) Yes
ASSET_KEY_CCID NUMBER (15)

ASSET_TYPE VARCHAR2 (11) Yes
MANUFACTURER_NAME VARCHAR2 (30)

MODEL_NUMBER VARCHAR2 (40)

SERIAL_NUMBER VARCHAR2 (35)

BAL_CHG_TOTAL NUMBER


BAL_CHG_APPLIED NUMBER


BAL_CHG_REMAINING NUMBER


Query Text

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


SELECT ASSET_ID
,      BOOK_TYPE_CODE
,      DATE_RETIRED
,      ASSET_NUMBER
,      TAG_NUMBER
,      DESCRIPTION
,      ASSET_CATEGORY_ID
,      ATTRIBUTE_CATEGORY_CODE
,      ASSET_KEY_CCID
,      ASSET_TYPE
,      MANUFACTURER_NAME
,      MODEL_NUMBER
,      SERIAL_NUMBER
,      BAL_CHG_TOTAL
,      BAL_CHG_APPLIED
,      BAL_CHG_REMAINING
FROM APPS.JA_AU_SOURCE_ADDITIONS_BOOKS_V;

Dependencies

[top of page]

APPS.JA_AU_SOURCE_ADDITIONS_BOOKS_V references the following:

SchemaAPPS
SynonymFA_ADDITIONS
SynonymJA_AU_BAL_CHG_SOURCE

APPS.JA_AU_SOURCE_ADDITIONS_BOOKS_V is not referenced by any database object