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

TABLE: OKL.OKL_OPEN_INT_ASST

Object Details
Object Name: OKL_OPEN_INT_ASST
Object Type: TABLE
Owner: OKL
FND Design Data: TableOKL.OKL_OPEN_INT_ASST
Subobject Name:
Status: VALID


Open interface asset details for report to credit bureau/transfer to external agency.
Asset details, for contracts in the open interface table, are written to this table. These records are then made available to credit bureaus and external agencies based on the action/status in the history table.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OKL_OIA_U01 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnKHR_ID
ColumnINSTANCE_NUMBER
Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Yes Primary key column
KHR_ID NUMBER
Yes Foreign key to table OKL_K_HEADERS
INSTANCE_NUMBER VARCHAR2 (30) Yes Instance number of the asset
ASSET_ID NUMBER (15) Yes System generated asset identification number
ASSET_NUMBER VARCHAR2 (240)
Asset number
DESCRIPTION VARCHAR2 (240)
User entered description
ASSET_TYPE VARCHAR2 (240)
Indicates whether the asset is cip, capitalized, or expensed
MANUFACTURER_NAME VARCHAR2 (360)
Name of manufacturer
MODEL_NUMBER VARCHAR2 (240)
Model number of asset
SERIAL_NUMBER VARCHAR2 (240)
Serial number of asset
TAG_NUMBER VARCHAR2 (240)
Tag number of the asset
ORIGINAL_COST NUMBER

Original cost of the asset
QUANTITY VARCHAR2 (240)
Quantity of the asset
COUNTRY VARCHAR2 (25)
Country of installation address
ADDRESS1 VARCHAR2 (240)
First line of installation address
ADDRESS2 VARCHAR2 (240)
Second line of installation address
ADDRESS3 VARCHAR2 (240)
Third line of installation address
ADDRESS4 VARCHAR2 (240)
Fourth line of installation address
CITY VARCHAR2 (240)
City of installation address
POSTAL_CODE VARCHAR2 (240)
Postal code of installation address
STATE VARCHAR2 (240)
State of installation address
PROVINCE VARCHAR2 (240)
Province of installation address
COUNTY VARCHAR2 (150)
County of installation address
PO_BOX_NUMBER VARCHAR2 (240)
PO box number of installation address
HOUSE_NUMBER VARCHAR2 (240)
House number of installation address
STREET_SUFFIX VARCHAR2 (240)
Street suffix of installation address
APARTMENT_NUMBER VARCHAR2 (240)
Apartment number of installation address
STREET VARCHAR2 (240)
Street of installation address
RURAL_ROUTE_NUMBER VARCHAR2 (240)
Rural route number for identifying address.The rural route number assigned by a postal authority
STREET_NUMBER VARCHAR2 (240)
Street number of installation address
BUILDING VARCHAR2 (240)
Building number of installation address
FLOOR VARCHAR2 (240)
Floor number of installation address
SUITE VARCHAR2 (240)
Suite number of installation address
ROOM VARCHAR2 (240)
Room number of installation address
POSTAL_PLUS4_CODE VARCHAR2 (240)
Four digit extension to the United States postal zip code
OBJECT_VERSION_NUMBER NUMBER (9) Yes Column used for locking records during updates
ORG_ID NUMBER (15)
Operating unit identifier
REQUEST_ID NUMBER (15)
Concurrent Manager column
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Manager column
PROGRAM_ID NUMBER (15)
Concurrent Manager column
PROGRAM_UPDATE_DATE DATE

Concurrent Manager column
ATTRIBUTE_CATEGORY VARCHAR2 (240)
Descriptive flexfield category column
ATTRIBUTE1 VARCHAR2 (240)
Descriptive flexfield column
ATTRIBUTE2 VARCHAR2 (240)
Descriptive flexfield column
ATTRIBUTE3 VARCHAR2 (240)
Descriptive flexfield column
ATTRIBUTE4 VARCHAR2 (240)
Descriptive flexfield column
ATTRIBUTE5 VARCHAR2 (240)
Descriptive flexfield column
ATTRIBUTE6 VARCHAR2 (240)
Descriptive flexfield column
ATTRIBUTE7 VARCHAR2 (240)
Descriptive flexfield column
ATTRIBUTE8 VARCHAR2 (240)
Descriptive flexfield column
ATTRIBUTE9 VARCHAR2 (240)
Descriptive flexfield column
ATTRIBUTE10 VARCHAR2 (240)
Descriptive flexfield column
ATTRIBUTE11 VARCHAR2 (240)
Descriptive flexfield column
ATTRIBUTE12 VARCHAR2 (240)
Descriptive flexfield column
ATTRIBUTE13 VARCHAR2 (240)
Descriptive flexfield column
ATTRIBUTE14 VARCHAR2 (240)
Descriptive flexfield column
ATTRIBUTE15 VARCHAR2 (240)
Descriptive flexfield column
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
Query Text

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


SELECT ID
,      KHR_ID
,      INSTANCE_NUMBER
,      ASSET_ID
,      ASSET_NUMBER
,      DESCRIPTION
,      ASSET_TYPE
,      MANUFACTURER_NAME
,      MODEL_NUMBER
,      SERIAL_NUMBER
,      TAG_NUMBER
,      ORIGINAL_COST
,      QUANTITY
,      COUNTRY
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      CITY
,      POSTAL_CODE
,      STATE
,      PROVINCE
,      COUNTY
,      PO_BOX_NUMBER
,      HOUSE_NUMBER
,      STREET_SUFFIX
,      APARTMENT_NUMBER
,      STREET
,      RURAL_ROUTE_NUMBER
,      STREET_NUMBER
,      BUILDING
,      FLOOR
,      SUITE
,      ROOM
,      POSTAL_PLUS4_CODE
,      OBJECT_VERSION_NUMBER
,      ORG_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM OKL.OKL_OPEN_INT_ASST;

Dependencies

[top of page]

OKL.OKL_OPEN_INT_ASST does not reference any database object

OKL.OKL_OPEN_INT_ASST is referenced by following:

SchemaOKL
ViewOKL_OPEN_INT_ASST#