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

VIEW: APPS.OKL_CURE_REPORT_AMOUNTS_V

Object Details
Object Name: OKL_CURE_REPORT_AMOUNTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_CURE_REPORT_AMOUNTS_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Stores line level information for OKL_CURE_REPORTS table. The lines are represented at contract level, and it obtains its data from OKL_CURE_AMOUNTS table.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row Identifier in the database
CURE_REPORT_AMOUNT_ID NUMBER
Yes Primary key column
CURE_AMOUNT_ID NUMBER
Yes Foreign key to OKL_CURE_AMOUNTS
CURE_REPORT_ID NUMBER
Yes Foreign key to OKL_CURE_REPORTS
REQUEST_TYPE VARCHAR2 (10) Yes Cure request type
CURES_IN_POSSESSION NUMBER (14)
Total cure cmount in possession
CLAIMED_CURE_AMOUNT NUMBER (14)
Calimed cure amount
PAST_DUE_AMOUNT NUMBER (14)
Past due amount
ELIGIBLE_CURE_AMOUNT NUMBER (14)
Eligible cure amount
REPURCHASE_AMOUNT NUMBER (14)
Repurchase amount
OUTSTANDING_AMOUNT NUMBER (14)
Outstanding amount
TIMES_CURED NUMBER (5)
Number of times contract is cured
PAYMENTS_REMAINING NUMBER (5)
Ramaining payments
STATUS VARCHAR2 (30)
Status
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 ROW_ID
,      CURE_REPORT_AMOUNT_ID
,      CURE_AMOUNT_ID
,      CURE_REPORT_ID
,      REQUEST_TYPE
,      CURES_IN_POSSESSION
,      CLAIMED_CURE_AMOUNT
,      PAST_DUE_AMOUNT
,      ELIGIBLE_CURE_AMOUNT
,      REPURCHASE_AMOUNT
,      OUTSTANDING_AMOUNT
,      TIMES_CURED
,      PAYMENTS_REMAINING
,      STATUS
,      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 APPS.OKL_CURE_REPORT_AMOUNTS_V;

Dependencies

[top of page]

APPS.OKL_CURE_REPORT_AMOUNTS_V references the following:

SchemaAPPS
SynonymOKL_CURE_REPORT_AMOUNTS

APPS.OKL_CURE_REPORT_AMOUNTS_V is not referenced by any database object