eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: OKL.OKL_OPEN_INT_PRTY

Object Details

Object Name:	OKL_OPEN_INT_PRTY
Object Type:	TABLE
Owner:	OKL
FND Design Data:	OKL.OKL_OPEN_INT_PRTY
Subobject Name:
Status:	VALID

Open interface guarantor details for report to credit Bureau/transfer to external agency.
Guarantor 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:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKL_OIP_U01	NORMAL	UNIQUE	APPS_TS_TX_IDX	KHR_ID PARTY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER		Yes	Primary key column
KHR_ID	NUMBER		Yes	Foreign key to table OKL_K_HEADERS
PARTY_ID	NUMBER		Yes	Party id of the guarantor on the contract.Foreign key to HZ_PARTIES
PARTY_NAME	VARCHAR2	(360)	Yes	Party name of the guarantor on the contract
COUNTRY	VARCHAR2	(25)		Country for identifying address
ADDRESS1	VARCHAR2	(240)		First line for identifying address
ADDRESS2	VARCHAR2	(240)		Second line for identifying address
ADDRESS3	VARCHAR2	(240)		Third line for identifying address
ADDRESS4	VARCHAR2	(240)		Fourth line for identifying address
CITY	VARCHAR2	(240)		City for identifying address
POSTAL_CODE	VARCHAR2	(240)		Postal code for identifying address
STATE	VARCHAR2	(240)		State for identifying address
PROVINCE	VARCHAR2	(240)		Province for identifying address
COUNTY	VARCHAR2	(150)		County for identifying address
PO_BOX_NUMBER	VARCHAR2	(240)		PO box number for identifying address
HOUSE_NUMBER	VARCHAR2	(240)		House number for identifying address
STREET_SUFFIX	VARCHAR2	(240)		Street suffix for identifying address
APARTMENT_NUMBER	VARCHAR2	(240)		Apartment number for identifying address
STREET	VARCHAR2	(240)		Street for identifying 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 for identifying address
BUILDING	VARCHAR2	(240)		Building number for identifying address
FLOOR	VARCHAR2	(240)		Floor number for identifying address
SUITE	VARCHAR2	(240)		Suite number for identifying address
ROOM	VARCHAR2	(240)		Room number for identifying address
POSTAL_PLUS4_CODE	VARCHAR2	(240)		Four digit extension to the United States postal zip code
PHONE_COUNTRY_CODE	VARCHAR2	(10)		Phone country code
PHONE_AREA_CODE	VARCHAR2	(10)		Phone area code
PHONE_NUMBER	VARCHAR2	(40)		Phone number
PHONE_EXTENSION	VARCHAR2	(20)		Phone extension
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
,      PARTY_ID
,      PARTY_NAME
,      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
,      PHONE_COUNTRY_CODE
,      PHONE_AREA_CODE
,      PHONE_NUMBER
,      PHONE_EXTENSION
,      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_PRTY;

Dependencies

[top of page]

OKL.OKL_OPEN_INT_PRTY does not reference any database object

OKL.OKL_OPEN_INT_PRTY is referenced by following:

APPS: OKL_OPEN_INT_PRTY