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

VIEW: APPS.OE_LINE_PRC_ADJ_HIST_V

Object Details
Object Name: OE_LINE_PRC_ADJ_HIST_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewONT.OE_LINE_PRC_ADJ_HIST_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
USER_ID NUMBER

Standard Who column
RESPONSIBILITY_ID NUMBER
Yes Responsibility using which Order was changed
HIST_CREATION_DATE DATE

Standard Who column
HEADER_ID NUMBER

Order Header
LINE_ID NUMBER

ORDER LINE_ID
PRICE_ADJUSTMENT_ID NUMBER

System generated Primary key
SOLD_TO_ORG_ID NUMBER

Sold to customer
ORDER_TYPE_ID NUMBER
Yes Order Transaction Type Identifier
ORDER_NUMBER NUMBER
Yes User-visible number of the order
LINE_NUMBER NUMBER
Yes Line sequence number within the order
HIST_TYPE_CODE VARCHAR2 (30)
Type of transaction for which history was created.
DISCOUNT_ID NUMBER

Not Used
DISCOUNT_LINE_ID NUMBER

Not Used
AUTOMATIC_FLAG VARCHAR2 (1)
Indicates if the discount was applied automatically
PERCENT NUMBER

Not Used
ACCRUAL_FLAG VARCHAR2 (1)
Indicates , if the adjustment is accrued
ACCRUAL_CONVERSION_RATE NUMBER

Conversion rate used in accruals
INVOICED_FLAG VARCHAR2 (1)
Flag indicating whether the charge is invoiced or not.
INC_IN_SALES_PERFORMANCE VARCHAR2 (1)
For future use
ESTIMATED_FLAG VARCHAR2 (1)
Flag indicating whether the charge amount is estimated or fixed.
SUBSTITUTION_ATTRIBUTE VARCHAR2 (30)
Indicates the type of terms upgrade given . Holds the flex strucure segment name for context TERM
PRORATION_TYPE_CODE VARCHAR2 (30)
For future use
PRICING_GROUP_SEQUENCE NUMBER

used in price calculation , from qp_list_lines
COST_ID NUMBER

Reference to the COST record in WSH_FREIGHT_COSTS table.
ARITHMETIC_OPERATOR VARCHAR2 (30)
Qualifies the value in operand , ( % , Amount or a New Price)
APPLIED_FLAG VARCHAR2 (1)
Tells , if the adjustment has been applied to the order line. Used for string manual discounts , which are not yet applied by the user
INCLUDE_ON_RETURNS_FLAG VARCHAR2 (1)
Indicates, if the adjustment is returnable
CREDIT_OR_CHARGE_FLAG VARCHAR2 (1)
Indicates if the adjustment record is a credit or charge to a customer.
PRICING_PHASE_ID NUMBER

Phase Id , in which this adjustment was created
ADJUSTED_AMOUNT NUMBER

Stores the Adjusted Amount at the adjustment level .
REBATE_TRANSACTION_REFERENCE VARCHAR2 (80)
Reference for rebate Transaction
REBATE_PAYMENT_SYSTEM_CODE VARCHAR2 (30)
Rebate Payment Code
RANGE_BREAK_QUANTITY NUMBER

Breakup of Order line quantity, used when the price break is of type range
PRINT_ON_INVOICE_FLAG VARCHAR2 (1)
Flag used to indicate if the adjustment is to be printed on invoice
LIST_LINE_NO VARCHAR2 (240)
List Line Number from qp_list_lines
EXPIRATION_DATE DATE

Expiration date of Coupon issued
BENEFIT_UOM_CODE VARCHAR2 (3)
UOM of BENEFIT_QTY
BENEFIT_QTY NUMBER

Quantity accrued
CHARGE_TYPE_CODE VARCHAR2 (30)
Type code of charge
CHARGE_SUBTYPE_CODE VARCHAR2 (30)
Charge Sub Type Code
TAX_EXEMPT_REASON_CODE VARCHAR2 (30)
For future use
TAX_EXEMPT_NUMBER VARCHAR2 (80)
For future use
TAX_EXEMPT_FLAG VARCHAR2 (1)
For future use
TAX_CODE VARCHAR2 (50)
Tax code applied on the Order Line. If the Tax Code associated with an order line is a Tax Group code then this column will store tax code included in the group.
SPLIT_ACTION_CODE VARCHAR2 (30)
Not in use
PARENT_ADJUSTMENT_ID NUMBER

For future use
UPDATE_ALLOWED VARCHAR2 (1)
Indicates if this adjustment is overridable
UPDATED_FLAG VARCHAR2 (1)
Flag to indicate if the user has modied this row
OPERAND NUMBER

Stores the Adjustment value , Qualified by Arithmetic_Operator
MODIFIED_TO VARCHAR2 (240)
Used for Storing Value of the item code , to which an item was upgraded
MODIFIED_FROM VARCHAR2 (240)
Used for storing value of the item code, which was upgraded.
LIST_LINE_TYPE_CODE VARCHAR2 (30)
Line Type of the Modifier
LIST_LINE_ID NUMBER

Line id of the Modifier
LIST_HEADER_ID NUMBER

Header Id of the Modifier
HIST_COMMENTS VARCHAR2 (2000)
Free form text for the reason code
REASON_CODE VARCHAR2 (30)
User entered reason code for making a change to the adjustment value
PRICE_BREAK_TYPE_CODE VARCHAR2 (30)
Indicates the type of pricebreaks - point or range.
MODIFIER_LEVEL_CODE VARCHAR2 (30)
This signifies whether the modifier list line( discount, surcharge or rebate ) is to be applied at order, line or group of lines level.
SOURCE_SYSTEM_CODE VARCHAR2 (30)
Source system which has generated this adjustment
REDEEMED_FLAG VARCHAR2 (1)
Indicates if the accraul is redeemed
REDEEMED_DATE DATE

Date of redeeming an accrual
REBATE_TRANSACTION_TYPE_CODE VARCHAR2 (30)
Rebate Transaction Type code from qp_list_lines
CONTEXT VARCHAR2 (30)
Descriptive Flexfield segment
ATTRIBUTE1 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (240)
Descriptive Flexfield segment
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER

Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Application of concurrent program that last updated row.
PROGRAM_ID NUMBER

Concurrent program that last updated row.
PROGRAM_UPDATE_DATE DATE

Last date changed by concurrent program
REQUEST_ID NUMBER

Concurrent request that last changed row
REASON_ID NUMBER

AUDIT_FLAG VARCHAR2 (1)
VERSION_FLAG VARCHAR2 (1)
PHASE_CHANGE_FLAG VARCHAR2 (1)
VERSION_NUMBER NUMBER

RETROBILL_REQUEST_ID NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT USER_ID
,      RESPONSIBILITY_ID
,      HIST_CREATION_DATE
,      HEADER_ID
,      LINE_ID
,      PRICE_ADJUSTMENT_ID
,      SOLD_TO_ORG_ID
,      ORDER_TYPE_ID
,      ORDER_NUMBER
,      LINE_NUMBER
,      HIST_TYPE_CODE
,      DISCOUNT_ID
,      DISCOUNT_LINE_ID
,      AUTOMATIC_FLAG
,      PERCENT
,      ACCRUAL_FLAG
,      ACCRUAL_CONVERSION_RATE
,      INVOICED_FLAG
,      INC_IN_SALES_PERFORMANCE
,      ESTIMATED_FLAG
,      SUBSTITUTION_ATTRIBUTE
,      PRORATION_TYPE_CODE
,      PRICING_GROUP_SEQUENCE
,      COST_ID
,      ARITHMETIC_OPERATOR
,      APPLIED_FLAG
,      INCLUDE_ON_RETURNS_FLAG
,      CREDIT_OR_CHARGE_FLAG
,      PRICING_PHASE_ID
,      ADJUSTED_AMOUNT
,      REBATE_TRANSACTION_REFERENCE
,      REBATE_PAYMENT_SYSTEM_CODE
,      RANGE_BREAK_QUANTITY
,      PRINT_ON_INVOICE_FLAG
,      LIST_LINE_NO
,      EXPIRATION_DATE
,      BENEFIT_UOM_CODE
,      BENEFIT_QTY
,      CHARGE_TYPE_CODE
,      CHARGE_SUBTYPE_CODE
,      TAX_EXEMPT_REASON_CODE
,      TAX_EXEMPT_NUMBER
,      TAX_EXEMPT_FLAG
,      TAX_CODE
,      SPLIT_ACTION_CODE
,      PARENT_ADJUSTMENT_ID
,      UPDATE_ALLOWED
,      UPDATED_FLAG
,      OPERAND
,      MODIFIED_TO
,      MODIFIED_FROM
,      LIST_LINE_TYPE_CODE
,      LIST_LINE_ID
,      LIST_HEADER_ID
,      HIST_COMMENTS
,      REASON_CODE
,      PRICE_BREAK_TYPE_CODE
,      MODIFIER_LEVEL_CODE
,      SOURCE_SYSTEM_CODE
,      REDEEMED_FLAG
,      REDEEMED_DATE
,      REBATE_TRANSACTION_TYPE_CODE
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      REASON_ID
,      AUDIT_FLAG
,      VERSION_FLAG
,      PHASE_CHANGE_FLAG
,      VERSION_NUMBER
,      RETROBILL_REQUEST_ID
FROM APPS.OE_LINE_PRC_ADJ_HIST_V;

Dependencies

[top of page]

APPS.OE_LINE_PRC_ADJ_HIST_V references the following:

SchemaAPPS
SynonymOE_ORDER_HEADERS_ALL
SynonymOE_ORDER_LINES_ALL
SynonymOE_PRICE_ADJS_HISTORY

APPS.OE_LINE_PRC_ADJ_HIST_V is not referenced by any database object