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


VIEW: APPS.OE_ORD_PRC_ADJ_HIST_V

Object Details
Object Name: OE_ORD_PRC_ADJ_HIST_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewONT.OE_ORD_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 VARCHAR2 (0)
HIST_TYPE_CODE VARCHAR2 (30)
DISCOUNT_ID NUMBER

DISCOUNT_LINE_ID NUMBER

AUTOMATIC_FLAG VARCHAR2 (1)
PERCENT NUMBER

ACCRUAL_FLAG VARCHAR2 (1)
ACCRUAL_CONVERSION_RATE NUMBER

INVOICED_FLAG VARCHAR2 (1)
INC_IN_SALES_PERFORMANCE VARCHAR2 (1)
ESTIMATED_FLAG VARCHAR2 (1)
SUBSTITUTION_ATTRIBUTE VARCHAR2 (30)
PRORATION_TYPE_CODE VARCHAR2 (30)
PRICING_GROUP_SEQUENCE NUMBER

COST_ID NUMBER

ARITHMETIC_OPERATOR VARCHAR2 (30)
APPLIED_FLAG VARCHAR2 (1)
INCLUDE_ON_RETURNS_FLAG VARCHAR2 (1)
CREDIT_OR_CHARGE_FLAG VARCHAR2 (1)
PRICING_PHASE_ID NUMBER

ADJUSTED_AMOUNT NUMBER

REBATE_TRANSACTION_REFERENCE VARCHAR2 (80)
REBATE_PAYMENT_SYSTEM_CODE VARCHAR2 (30)
RANGE_BREAK_QUANTITY NUMBER

PRINT_ON_INVOICE_FLAG VARCHAR2 (1)
LIST_LINE_NO VARCHAR2 (240)
EXPIRATION_DATE DATE

BENEFIT_UOM_CODE VARCHAR2 (3)
BENEFIT_QTY NUMBER

CHARGE_TYPE_CODE VARCHAR2 (30)
CHARGE_SUBTYPE_CODE VARCHAR2 (30)
TAX_EXEMPT_REASON_CODE VARCHAR2 (30)
TAX_EXEMPT_NUMBER VARCHAR2 (80)
TAX_EXEMPT_FLAG VARCHAR2 (1)
TAX_CODE VARCHAR2 (50)
SPLIT_ACTION_CODE VARCHAR2 (30)
PARENT_ADJUSTMENT_ID NUMBER

UPDATE_ALLOWED VARCHAR2 (1)
UPDATED_FLAG VARCHAR2 (1)
OPERAND NUMBER

MODIFIED_TO VARCHAR2 (240)
MODIFIED_FROM VARCHAR2 (240)
LIST_LINE_TYPE_CODE VARCHAR2 (30)
LIST_LINE_ID NUMBER

LIST_HEADER_ID NUMBER

HIST_COMMENTS VARCHAR2 (2000)
REASON_CODE VARCHAR2 (30)
PRICE_BREAK_TYPE_CODE VARCHAR2 (30)
MODIFIER_LEVEL_CODE VARCHAR2 (30)
SOURCE_SYSTEM_CODE VARCHAR2 (30)
REDEEMED_FLAG VARCHAR2 (1)
REDEEMED_DATE DATE

REBATE_TRANSACTION_TYPE_CODE VARCHAR2 (30)
CONTEXT VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (240)
ATTRIBUTE2 VARCHAR2 (240)
ATTRIBUTE3 VARCHAR2 (240)
ATTRIBUTE4 VARCHAR2 (240)
ATTRIBUTE5 VARCHAR2 (240)
ATTRIBUTE6 VARCHAR2 (240)
ATTRIBUTE7 VARCHAR2 (240)
ATTRIBUTE8 VARCHAR2 (240)
ATTRIBUTE9 VARCHAR2 (240)
ATTRIBUTE10 VARCHAR2 (240)
ATTRIBUTE11 VARCHAR2 (240)
ATTRIBUTE12 VARCHAR2 (240)
ATTRIBUTE13 VARCHAR2 (240)
ATTRIBUTE14 VARCHAR2 (240)
ATTRIBUTE15 VARCHAR2 (240)
CREATION_DATE DATE

CREATED_BY NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

REQUEST_ID NUMBER

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_ORD_PRC_ADJ_HIST_V;

Dependencies

[top of page]

APPS.OE_ORD_PRC_ADJ_HIST_V references the following:

SchemaAPPS
SynonymOE_ORDER_HEADERS_ALL
SynonymOE_PRICE_ADJS_HISTORY

APPS.OE_ORD_PRC_ADJ_HIST_V is not referenced by any database object