[Home] [Help] [Dependency Information]
Object Name: | JL_CO_FA_APPRAISALS |
---|---|
Object Type: | TABLE |
Owner: | JL |
FND Design Data: | JL.JL_CO_FA_APPRAISALS |
Subobject Name: | |
Status: | VALID |
JL_CO_FA_APPRAISALS stores technical appraisal headers including appraiser information, currency and fiscal year of the appraisal.
When the appraisal is validated, Error status is assigned to the appraisal when one or more assets in the appraisal are invalid and the appraisal level information is valid.
Scope: public
Product: JL
Display Name: Colombian Technical Appraisals Mass Upload
Lifecycle: active
Category: BUSINESS_ENTITY FA_ASSET
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JL_CO_FA_APPRAISALS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | APPRAISAL_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPRAISAL_ID | NUMBER | (15) | Yes | System generated appraisal identification number |
APPRAISAL_DATE | DATE | Yes | Appraisal date | |
CURRENCY_CODE | VARCHAR2 | (15) | Yes | Currency Code |
FISCAL_YEAR | NUMBER | (4) | Yes | Fiscal year of the appraisal. The fiscal year must be higher than 1990. |
APPRAISER_NAME | VARCHAR2 | (60) | Yes | Appraiser's name |
APPRAISER_ADDRESS1 | VARCHAR2 | (60) | Yes | Appraiser's address line 1 |
APPRAISER_ADDRESS2 | VARCHAR2 | (60) | Appraiser's address line 2 | |
APPRAISER_PHONE | VARCHAR2 | (15) | Appraiser's phone number | |
APPRAISER_CITY | VARCHAR2 | (20) | Appraiser's city of residence | |
APPRAISAL_STATUS | VARCHAR2 | (1) | Yes | Appraisal status |
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
CREATION_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
REQUEST_ID | NUMBER | (15) | Standard Who Column | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard Who Column | |
PROGRAM_ID | NUMBER | (15) | Standard Who Column | |
PROGRAM_UPDATE_DATE | DATE | Standard Who Column |
Cut, paste (and edit) the following text to query this object:
SELECT APPRAISAL_ID
, APPRAISAL_DATE
, CURRENCY_CODE
, FISCAL_YEAR
, APPRAISER_NAME
, APPRAISER_ADDRESS1
, APPRAISER_ADDRESS2
, APPRAISER_PHONE
, APPRAISER_CITY
, APPRAISAL_STATUS
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM JL.JL_CO_FA_APPRAISALS;
JL.JL_CO_FA_APPRAISALS does not reference any database object
JL.JL_CO_FA_APPRAISALS is referenced by following:
|
|
|