[Home] [Help] [Dependency Information]

VIEW: APPS.OE_PRICE_ADJUSTMENTS_V

Object Details

Object Name:	OE_PRICE_ADJUSTMENTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ONT.OE_PRICE_ADJUSTMENTS_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Query Text

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

SELECT ROW_ID
,      PRICE_ADJUSTMENT_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      HEADER_ID
,      DISCOUNT_ID
,      DISCOUNT_LINE_ID
,      AUTOMATIC_FLAG
,      PERCENT
,      LINE_ID
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ORIG_SYS_DISCOUNT_REF
,      LIST_HEADER_ID
,      LIST_LINE_ID
,      LIST_LINE_TYPE_CODE
,      MODIFIER_MECHANISM_TYPE_CODE
,      MODIFIED_FROM
,      MODIFIED_TO
,      UPDATED_FLAG
,      UPDATE_ALLOWED
,      APPLIED_FLAG
,      CHANGE_REASON_CODE
,      CHANGE_REASON_TEXT
,      ADJUSTMENT_NAME
,      ADJUSTMENT_TYPE_CODE
,      OVERRIDE_ALLOWED_FLAG
,      ADJUSTMENT_TYPE_NAME
,      OPERAND
,      ARITHMETIC_OPERATOR
,      COST_ID
,      TAX_CODE
,      TAX_EXEMPT_FLAG
,      TAX_EXEMPT_NUMBER
,      TAX_EXEMPT_REASON_CODE
,      PARENT_ADJUSTMENT_ID
,      INVOICED_FLAG
,      ESTIMATED_FLAG
,      INC_IN_SALES_PERFORMANCE
,      SPLIT_ACTION_CODE
,      PRICING_PHASE_ID
,      ADJUSTED_AMOUNT
,      CHARGE_TYPE_CODE
,      CHARGE_SUBTYPE_CODE
,      LIST_LINE_NO
,      SOURCE_SYSTEM_CODE
,      BENEFIT_QTY
,      BENEFIT_UOM_CODE
,      PRINT_ON_INVOICE_FLAG
,      EXPIRATION_DATE
,      REBATE_TRANSACTION_TYPE_CODE
,      REBATE_TRANSACTION_REFERENCE
,      REBATE_PAYMENT_SYSTEM_CODE
,      REDEEMED_DATE
,      REDEEMED_FLAG
,      ACCRUAL_FLAG
,      RANGE_BREAK_QUANTITY
,      ACCRUAL_CONVERSION_RATE
,      PRICING_GROUP_SEQUENCE
,      MODIFIER_LEVEL_CODE
,      PRICE_BREAK_TYPE_CODE
,      SUBSTITUTION_ATTRIBUTE
,      PRORATION_TYPE_CODE
,      CREDIT_OR_CHARGE_FLAG
,      INCLUDE_ON_RETURNS_FLAG
,      ADJUSTMENT_DESCRIPTION
,      AC_CONTEXT
,      AC_ATTRIBUTE1
,      AC_ATTRIBUTE2
,      AC_ATTRIBUTE3
,      AC_ATTRIBUTE4
,      AC_ATTRIBUTE5
,      AC_ATTRIBUTE6
,      AC_ATTRIBUTE7
,      AC_ATTRIBUTE8
,      AC_ATTRIBUTE9
,      AC_ATTRIBUTE10
,      AC_ATTRIBUTE11
,      AC_ATTRIBUTE12
,      AC_ATTRIBUTE13
,      AC_ATTRIBUTE14
,      AC_ATTRIBUTE15
,      LOCK_CONTROL
,      OPERAND_PER_PQTY
,      ADJUSTED_AMOUNT_PER_PQTY
,      INVOICED_AMOUNT
,      RETROBILL_REQUEST_ID
,      TAX_RATE_ID
FROM APPS.OE_PRICE_ADJUSTMENTS_V;

Dependencies

[top of page]

APPS

OE_PRICE_ADJUSTMENTS

QP_LIST_HEADERS_TL

APPS

OE_AK_HEADER_PRCADJS_V

OE_AK_LINE_PRCADJS_V

OE_CHARGE_PVT - show dependent code

OE_HEADER_ADJ_UTIL - show dependent code

ONT_FREIGHT_UTIL - show dependent code

PMI_SALES_PKG - show dependent code