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

TABLE: OKL.OKL_OPEN_INT_ALL

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


Open Interface for report to credit bureau/transfer to external agency.
Interface records consisting of customer, contract and case details 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_OPEN_INT_ALL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnKHR_ID
Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Yes Primary key column
PARTY_ID NUMBER
Yes Party id of the party on the contract.Foreign key to hz_parties
PARTY_NAME VARCHAR2 (360) Yes Name of the party on the contract
PARTY_TYPE VARCHAR2 (30) Yes Type of the party on the contract (e.g.Person, Organization, etc)
DATE_OF_BIRTH DATE

Date of birth of the party (for party of type PERSON)
PLACE_OF_BIRTH VARCHAR2 (60)
Place of birth of the party (for party of type PERSON)
PERSON_IDENTIFIER VARCHAR2 (60)
Identity reference field for things like social security, tax identity number, or driver's license number
PERSON_IDEN_TYPE VARCHAR2 (30)
Lookup representing main person identification number used in country. For example, social security number
COUNTRY VARCHAR2 (25)
Country for identifying address
ADDRESS1 VARCHAR2 (240)
First line identifying address
ADDRESS2 VARCHAR2 (240)
Second line identifying address
ADDRESS3 VARCHAR2 (240)
Third line identifying address
ADDRESS4 VARCHAR2 (240)
Fourth line identifying address
CITY VARCHAR2 (60)
City for identifying address
POSTAL_CODE VARCHAR2 (60)
Postal code for identifying address
STATE VARCHAR2 (150)
State for identifying address
PROVINCE VARCHAR2 (150)
Province for identifying address
COUNTY VARCHAR2 (150)
County code for identifying address
PO_BOX_NUMBER VARCHAR2 (50)
PO box number for identifying address
HOUSE_NUMBER VARCHAR2 (50)
House number for identifying address
STREET_SUFFIX VARCHAR2 (50)
Street suffix for identifying address
APARTMENT_NUMBER VARCHAR2 (50)
Apartment number for identifying address
STREET VARCHAR2 (50)
Street for identifying address
RURAL_ROUTE_NUMBER VARCHAR2 (50)
Rural route number for identifying address.The rural route number assigned by a postal authority
STREET_NUMBER VARCHAR2 (50)
Street number for identifying address
BUILDING VARCHAR2 (50)
A number assigned to an entire building within an address
FLOOR VARCHAR2 (50)
A number or name assigned to a level within a building or within an address
SUITE VARCHAR2 (50)
A number or name to indicate a number of rooms (therefore termed a suite)
ROOM VARCHAR2 (50)
A number or name for a room within a building
POSTAL_PLUS4_CODE VARCHAR2 (50)
Four digit extension to the United States postal zip code
CAS_ID NUMBER
Yes Foreign key to IEX_CASES_ALL_B. Identifies the case to which the contract is assigned
CASE_NUMBER VARCHAR2 (240) Yes Number of the case to which the contract is assigned
KHR_ID NUMBER
Yes Foreign key to table OKL_K_HEADERS
CONTRACT_NUMBER VARCHAR2 (120) Yes Contract number
CONTRACT_TYPE VARCHAR2 (30) Yes Contract type e.g. LEASE
CONTRACT_STATUS VARCHAR2 (30) Yes Contract status e.g. NEW, COMPLETE
ORIGINAL_AMOUNT NUMBER (14)
original contract amount = original equipment cost + capitailzed fees - tradein - capital reduction
START_DATE DATE

Start date
CLOSE_DATE DATE

Termination date of the contract
TERM_DURATION NUMBER (10)
Contract duration
MONTHLY_PAYMENT_AMOUNT NUMBER (14)
Monthly payment amount
LAST_PAYMENT_DATE DATE

Date on which the last payment was received
DELINQUENCY_OCCURANCE_DATE DATE

Date on which delinquency occured
PAST_DUE_AMOUNT NUMBER (14)
Past due amount
REMAINING_AMOUNT NUMBER (14)
Outstanding receivable amount
CREDIT_INDICATOR VARCHAR2 (30)
Indicates whether the remaining amount is a credit/debit
NOTIFICATION_DATE DATE

Date on which last notification was sent to inform of intent to report.
CREDIT_BUREAU_REPORT_DATE DATE

Date on which contract was reported to the credit bureau
EXTERNAL_AGENCY_TRANSFER_DATE DATE

Date on which contract was transferred to the external agency
EXTERNAL_AGENCY_RECALL_DATE DATE

Date on which contract was recalled from the external agency
REFERRAL_NUMBER NUMBER

Number of times the contract has been transferred to an external agency
CONTACT_ID NUMBER

Case owner id
CONTACT_NAME VARCHAR2 (360)
Case owner name
CONTACT_PHONE VARCHAR2 (2000)
Case owner phone
CONTACT_EMAIL VARCHAR2 (2000)
Case owner email
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 (90)
Descriptive flexfield category column
ATTRIBUTE1 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE2 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE3 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE4 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE5 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE6 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE7 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE8 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE9 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE10 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE11 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE12 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE13 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE14 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE15 VARCHAR2 (450)
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
,      PARTY_ID
,      PARTY_NAME
,      PARTY_TYPE
,      DATE_OF_BIRTH
,      PLACE_OF_BIRTH
,      PERSON_IDENTIFIER
,      PERSON_IDEN_TYPE
,      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
,      CAS_ID
,      CASE_NUMBER
,      KHR_ID
,      CONTRACT_NUMBER
,      CONTRACT_TYPE
,      CONTRACT_STATUS
,      ORIGINAL_AMOUNT
,      START_DATE
,      CLOSE_DATE
,      TERM_DURATION
,      MONTHLY_PAYMENT_AMOUNT
,      LAST_PAYMENT_DATE
,      DELINQUENCY_OCCURANCE_DATE
,      PAST_DUE_AMOUNT
,      REMAINING_AMOUNT
,      CREDIT_INDICATOR
,      NOTIFICATION_DATE
,      CREDIT_BUREAU_REPORT_DATE
,      EXTERNAL_AGENCY_TRANSFER_DATE
,      EXTERNAL_AGENCY_RECALL_DATE
,      REFERRAL_NUMBER
,      CONTACT_ID
,      CONTACT_NAME
,      CONTACT_PHONE
,      CONTACT_EMAIL
,      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_ALL;

Dependencies

[top of page]

OKL.OKL_OPEN_INT_ALL does not reference any database object

OKL.OKL_OPEN_INT_ALL is referenced by following:

SchemaOKL
ViewOKL_OPEN_INT_ALL#