[Home] [Help] [Dependency Information]
Object Name: | OKL_CURE_REPORTS_ALL |
---|---|
Object Type: | TABLE |
Owner: | OKL |
FND Design Data: | OKL.OKL_CURE_REPORTS_ALL |
Subobject Name: | |
Status: | VALID |
Stores request header details for cure repurcahse request. Details such as vendor, vendor contact and vendor site are stored. The actual report lines are contained in OKL CURE REPORT AMOUNTS table.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CURE_REPORT_ID | NUMBER | Yes | Primary key column | |
REPORT_NUMBER | VARCHAR2 | (150) | Yes | Report number |
REPORT_DATE | DATE | Yes | Report date | |
VENDOR_ID | NUMBER | Yes | Foreign key to PO_VENDORS | |
VENDOR_SITE_ID | NUMBER | Yes | Foreign key to PO_VENDOR_SITES_ALL | |
VENDOR_CONTACT_ID | NUMBER | Yes | Foreign key to PO_VENDOR_CONTACTS | |
APPROVAL_STATUS | VARCHAR2 | (50) | Approval status | |
APPROVAL_REASON | VARCHAR2 | (1995) | Approval reason | |
EXPIRATION_DATE | DATE | Report expiration date | ||
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 | |
CURRENCY_CODE | VARCHAR2 | (15) | Yes | Currency code as defined in FND_CURRENCIES. |
REPORT_TYPE | VARCHAR2 | (20) | The possible values are ' CURE' , REPURCHASE' or ''BOTH' |
Cut, paste (and edit) the following text to query this object:
SELECT CURE_REPORT_ID
, REPORT_NUMBER
, REPORT_DATE
, VENDOR_ID
, VENDOR_SITE_ID
, VENDOR_CONTACT_ID
, APPROVAL_STATUS
, APPROVAL_REASON
, EXPIRATION_DATE
, 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
, CURRENCY_CODE
, REPORT_TYPE
FROM OKL.OKL_CURE_REPORTS_ALL;
OKL.OKL_CURE_REPORTS_ALL does not reference any database object
OKL.OKL_CURE_REPORTS_ALL is referenced by following:
|
|
|