[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | FA_INS_LINES |
|---|---|
| Object Type: | TABLE |
| Owner: | FA |
| FND Design Data: |  OFA.FA_INS_LINES
|
| Subobject Name: | |
| Status: | VALID |
FA_INS_LINES contains policy line information relating to an asset's
insurance policy and is populated through the Fixed Assets Insurance
window.
.
This table stores the policy line number, insurance category, and
hazard class of the policy. The policy line number is unique
within the policy, even though the policy may apply to several
assets.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| FA_INS_LINES_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 ASSET_POLICY_ID
POLICY_LINE
|
| FA_INS_LINES_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
VENDOR_ID
POLICY_NUMBER
POLICY_LINE
|
| FA_INS_LINES_U3 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
ASSET_ID
INSURANCE_CATEGORY
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ASSET_POLICY_ID | NUMBER | Yes | Insurance record identifier | |
| POLICY_LINE | NUMBER | Yes | Insurance policy line number | |
| INSURANCE_CATEGORY | VARCHAR2 | (30) | Yes | Type of insurance for policy line |
| HAZARD_CLASS | VARCHAR2 | (30) | Type of hazard associated with policy line | |
| COMMENTS | VARCHAR2 | (1000) | Comment about policy line | |
| LAST_UPDATE_DATE | DATE | Standard Who column | ||
| LAST_UPDATED_BY | NUMBER | (15) | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
| CREATION_DATE | DATE | Standard Who column | ||
| CREATED_BY | NUMBER | (15) | Standard Who column | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield segment | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| VENDOR_ID | NUMBER | Yes | Insurance company identifier | |
| POLICY_NUMBER | VARCHAR2 | (18) | Yes | Insurance policy number |
| ASSET_ID | NUMBER | (15) | Yes | Unique indentifier of asset |
Cut, paste (and edit) the following text to query this object:
SELECT ASSET_POLICY_ID
, POLICY_LINE
, INSURANCE_CATEGORY
, HAZARD_CLASS
, COMMENTS
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, VENDOR_ID
, POLICY_NUMBER
, ASSET_ID
FROM FA.FA_INS_LINES;
FA.FA_INS_LINES does not reference any database object
FA.FA_INS_LINES is referenced by following:
FA
FA_INS_LINES#
|
|
|
|