[Home] [Help] [Dependency Information]
Object Name: | OKL_AM_ASSET_CNDTN_LNS_UV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_AM_ASSET_CNDTN_LNS_UV |
Subobject Name: | |
Status: | VALID |
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.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row Identifier in the database | |
ID | NUMBER | Yes | Primary key column | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
SFWT_FLAG | VARCHAR2 | (3) | Yes | Column used by the translation batch program |
CTP_CODE | VARCHAR2 | (30) | claim type code | |
DTY_CODE | VARCHAR2 | (30) | ||
CDN_CODE | VARCHAR2 | (30) | Yes | |
ACS_CODE | VARCHAR2 | (30) | Yes | |
ISQ_ID | NUMBER | |||
PZT_ID | NUMBER | |||
ACD_ID | NUMBER | Yes | Foreign key to view OKL_ASSET_CNDTNS_V | |
RPC_ID | NUMBER | Foreign key to view OKL_REPAIR_COSTS_V | ||
SEQUENCE_NUMBER | NUMBER | (5) | Sequence Number | |
DAMAGE_DESCRIPTION | VARCHAR2 | (1995) | ||
CLAIM_DESCRIPTION | VARCHAR2 | (1995) | ||
ESTIMATED_REPAIR_COST | NUMBER | (14) | The estimated repair cost. | |
ACTUAL_REPAIR_COST | NUMBER | (14) | The actual repair cost,not currently entered in any UI, however, this process needs to be revisited. | |
APPROVED_BY | NUMBER | (15) | Who approved the repair. | |
APPROVED_YN | VARCHAR2 | (3) | Has this repair line been approved. | |
DATE_APPROVED | DATE | The date the repair is approved. | ||
DATE_REPORTED | DATE | This is the date that the asset condition line was identified & reported. (Not the date of the report, because additional lines may be entered later after with further information) | ||
RECOMMENDED_REPAIR | VARCHAR2 | (720) | ||
PART_NAME | VARCHAR2 | (150) | ||
REPAIR_TYPE | VARCHAR2 | (240) | A brief summary of the repair, should include the item that this is applicable to. | |
DESCRIPTION | VARCHAR2 | (1995) | User entered description | |
REPAIR_COST | NUMBER | (14) | The recommended cost to repair an item referenced in either the repair type or description columns.. | |
STATUS_DESC | VARCHAR2 | (80) | Yes | QuickCode meaning |
CONDITION_DESC | VARCHAR2 | (80) | Yes | QuickCode meaning |
DAMAGE_DESC | VARCHAR2 | (80) | Yes | QuickCode meaning |
ACN_ID_COST | NUMBER | |||
KLE_ID | NUMBER | Foreign key to view OKL_K_LINES_V | ||
RPC_ORG_ID | NUMBER | (15) | ||
ACN_ORG_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ID
, OBJECT_VERSION_NUMBER
, SFWT_FLAG
, CTP_CODE
, DTY_CODE
, CDN_CODE
, ACS_CODE
, ISQ_ID
, PZT_ID
, ACD_ID
, RPC_ID
, SEQUENCE_NUMBER
, DAMAGE_DESCRIPTION
, CLAIM_DESCRIPTION
, ESTIMATED_REPAIR_COST
, ACTUAL_REPAIR_COST
, APPROVED_BY
, APPROVED_YN
, DATE_APPROVED
, DATE_REPORTED
, RECOMMENDED_REPAIR
, PART_NAME
, REPAIR_TYPE
, DESCRIPTION
, REPAIR_COST
, STATUS_DESC
, CONDITION_DESC
, DAMAGE_DESC
, ACN_ID_COST
, KLE_ID
, RPC_ORG_ID
, ACN_ORG_ID
FROM APPS.OKL_AM_ASSET_CNDTN_LNS_UV;
APPS.OKL_AM_ASSET_CNDTN_LNS_UV is not referenced by any database object
|
|
|