[Home] [Help] [Dependency Information]
Object Name: | AMS_OFFER_ADJUSTMENTS_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMS.AMS_OFFER_ADJUSTMENTS_VL |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view is based on base table and translation table that contains translated data based on current language. This view provides infomation about offer adjustments.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OFFER_ADJUSTMENT_ID | NUMBER | Yes | Unique identifier | |
EFFECTIVE_DATE | DATE | Effective date of the offer adjustment | ||
APPROVED_DATE | DATE | Approval date of the offer adjustment | ||
SETTLEMENT_CODE | VARCHAR2 | (30) | Settlement code | |
STATUS_CODE | VARCHAR2 | (30) | Status of the adjustment | |
LIST_HEADER_ID | NUMBER | Yes | Identifier of list header | |
VERSION | NUMBER | Version of the offer adjustment | ||
BUDGET_ADJUSTED_FLAG | VARCHAR2 | (1) | Budget adjusted flag | |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard WHO column | |
CREATION_DATE | DATE | Yes | Standard WHO column | |
CREATED_BY | NUMBER | Yes | Standard WHO column | |
LAST_UPDATE_LOGIN | NUMBER | Standard WHO column | ||
OBJECT_VERSION_NUMBER | NUMBER | Standard WHO column | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Desciptive Flexfield structure defining column. | |
ATTRIBUTE1 | VARCHAR2 | (240) | Desciptive Flexfield | |
ATTRIBUTE2 | VARCHAR2 | (240) | Desciptive Flexfield | |
ATTRIBUTE3 | VARCHAR2 | (240) | Desciptive Flexfield | |
ATTRIBUTE4 | VARCHAR2 | (240) | Desciptive Flexfield | |
ATTRIBUTE5 | VARCHAR2 | (240) | Desciptive Flexfield | |
ATTRIBUTE6 | VARCHAR2 | (240) | Desciptive Flexfield | |
ATTRIBUTE7 | VARCHAR2 | (240) | Desciptive Flexfield | |
ATTRIBUTE8 | VARCHAR2 | (240) | Desciptive Flexfield | |
ATTRIBUTE9 | VARCHAR2 | (240) | Desciptive Flexfield | |
ATTRIBUTE10 | VARCHAR2 | (240) | Desciptive Flexfield | |
ATTRIBUTE11 | VARCHAR2 | (240) | Desciptive Flexfield | |
ATTRIBUTE12 | VARCHAR2 | (240) | Desciptive Flexfield | |
ATTRIBUTE13 | VARCHAR2 | (240) | Desciptive Flexfield | |
ATTRIBUTE14 | VARCHAR2 | (240) | Desciptive Flexfield | |
ATTRIBUTE15 | VARCHAR2 | (240) | Desciptive Flexfield | |
DESCRIPTION | VARCHAR2 | (4000) | Description of offer adjustment | |
OFFER_ADJUSTMENT_NAME | VARCHAR2 | (120) | Yes | Name of offer adjustment |
Cut, paste (and edit) the following text to query this object:
SELECT OFFER_ADJUSTMENT_ID
, EFFECTIVE_DATE
, APPROVED_DATE
, SETTLEMENT_CODE
, STATUS_CODE
, LIST_HEADER_ID
, VERSION
, BUDGET_ADJUSTED_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, DESCRIPTION
, OFFER_ADJUSTMENT_NAME
FROM APPS.AMS_OFFER_ADJUSTMENTS_VL;
APPS.AMS_OFFER_ADJUSTMENTS_VL is not referenced by any database object
|
|
|