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

TABLE: PO.PO_PRICE_ADJUSTMENTS

Object Details
Object Name: PO_PRICE_ADJUSTMENTS
Object Type: TABLE
Owner: PO
FND Design Data: TablePO.PO_PRICE_ADJUSTMENTS
Subobject Name:
Status: VALID


Price Adjustment Details for PO Line


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PO_PRICE_ADJUSTMENTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPRICE_ADJUSTMENT_ID
PO_PRICE_ADJUSTMENTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPO_HEADER_ID
PO_PRICE_ADJUSTMENTS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPO_LINE_ID
PO_PRICE_ADJUSTMENTS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLIST_HEADER_ID
Columns
Name Datatype Length Mandatory Comments
PRICE_ADJUSTMENT_ID NUMBER
Yes Price Adjustment Unique Identifier
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER
Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
REQUEST_ID NUMBER

Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PO_HEADER_ID NUMBER
Yes PO Header Unique identifier
AUTOMATIC_FLAG VARCHAR2 (1) Yes Indicates whether this is an automatic price adjustment
PO_LINE_ID NUMBER
Yes PO Line Unique Identifier
ADJ_LINE_NUM NUMBER

Price Adjustment Line Number
CONTEXT VARCHAR2 (30)
Descriptive flexfield Context
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
ORIG_SYS_DISCOUNT_REF VARCHAR2 (50)
Original system discount reference
CHANGE_SEQUENCE VARCHAR2 (50)
Change sequence
LIST_HEADER_ID NUMBER

Unique identifier of QP List Header
LIST_TYPE_CODE VARCHAR2 (30)
This stores the type of modifier list, for example price list, discount list or promotion
LIST_LINE_ID NUMBER

Unique Identifier of List Line
LIST_LINE_TYPE_CODE VARCHAR2 (30)
Type of list line
MODIFIED_FROM VARCHAR2 (240)
Modified from
MODIFIED_TO VARCHAR2 (240)
Modified to
UPDATE_ALLOWED VARCHAR2 (1)
Indicates whether the price adjustment is updatable
CHANGE_REASON_CODE VARCHAR2 (30)
Change reason code
CHANGE_REASON_TEXT VARCHAR2 (2000)
Change reason text
UPDATED_FLAG VARCHAR2 (1)
Indicates whether the price adjustment has been updated by user
APPLIED_FLAG VARCHAR2 (1)
The lists or list lines that the pricing event applied
OPERAND NUMBER

Pricing operand
ARITHMETIC_OPERATOR VARCHAR2 (30)
Type of operand
COST_ID NUMBER

Cost Id
TAX_CODE VARCHAR2 (50)
Tax Code
TAX_EXEMPT_FLAG VARCHAR2 (1)
Indicates whether tax is exempted
TAX_EXEMPT_NUMBER VARCHAR2 (80)
Tax exempt number
TAX_EXEMPT_REASON_CODE VARCHAR2 (30)
Tax exempt reason code
PARENT_ADJUSTMENT_ID NUMBER

Parent adjustment id
INVOICED_FLAG VARCHAR2 (1)
Indicates whether the line has been invoiced
ESTIMATED_FLAG VARCHAR2 (1)
Estimated flag
INC_IN_SALES_PERFORMANCE VARCHAR2 (1)
Reserved for future use
ADJUSTED_AMOUNT NUMBER

Adjusted amount
PRICING_PHASE_ID NUMBER

Pricing Phase identifier
CHARGE_TYPE_CODE VARCHAR2 (30)
Indicates the type of charge, used for Freight/Special Charge-type modifiers
CHARGE_SUBTYPE_CODE VARCHAR2 (30)
Indicates the type of charge
RANGE_BREAK_QUANTITY NUMBER

Pricing request line quantity
ACCRUAL_CONVERSION_RATE NUMBER

The rate at which a non-monetary accrual is converted to a monetary value
PRICING_GROUP_SEQUENCE NUMBER

Indicates the pricing bucket in which the pricing engine applied the list line
ACCRUAL_FLAG VARCHAR2 (1)
Indicates whether the discount is an accrual or not, i.e whether it should be applied retrospectively
LIST_LINE_NO VARCHAR2 (240)
QP Modifier number. This field is applicable in case of Coupon Issue kind of modifier line
SOURCE_SYSTEM_CODE VARCHAR2 (30)
Source system which created QP List Header record
BENEFIT_QTY NUMBER

The accrual quantity for non-monetary accruals or, for promotional goods, item quantity
BENEFIT_UOM_CODE VARCHAR2 (3)
The accrual unit of measure for non-monetary accruals, or item unit of measure for promotional goods
PRINT_ON_INVOICE_FLAG VARCHAR2 (1)
Reserved for future use
EXPIRATION_DATE DATE

Expiration date of the accrual or coupon
REBATE_TRANSACTION_TYPE_CODE VARCHAR2 (30)
Reserved for future use
REBATE_TRANSACTION_REFERENCE VARCHAR2 (80)
Reserved for future use
REBATE_PAYMENT_SYSTEM_CODE VARCHAR2 (30)
Reserved for future use
REDEEMED_DATE DATE

Reserved for future use
REDEEMED_FLAG VARCHAR2 (1)
Reserved for future use
MODIFIER_LEVEL_CODE VARCHAR2 (30)
The level at which the list line qualified for the transaction
PRICE_BREAK_TYPE_CODE VARCHAR2 (30)
Type of price break
SUBSTITUTION_ATTRIBUTE VARCHAR2 (30)
Identifies the attribute in the TERMS context that will be substituted, used for modfiers of type Term Substitution
PRORATION_TYPE_CODE VARCHAR2 (30)
Reserved for future use
INCLUDE_ON_RETURNS_FLAG VARCHAR2 (1)
Applicable to modifiers of type Freight/Special Charge to indicate whether the charge should be included on a return transaction. Not used by pricing engine, for transaction system use only
CREDIT_OR_CHARGE_FLAG VARCHAR2 (1)
Credit or charge flag
AC_CONTEXT VARCHAR2 (150)
Descriptive flexfield context
AC_ATTRIBUTE1 VARCHAR2 (240)
Descriptive flexfield attribute
AC_ATTRIBUTE2 VARCHAR2 (240)
Descriptive flexfield attribute
AC_ATTRIBUTE3 VARCHAR2 (240)
Descriptive flexfield attribute
AC_ATTRIBUTE4 VARCHAR2 (240)
Descriptive flexfield attribute
AC_ATTRIBUTE5 VARCHAR2 (240)
Descriptive flexfield attribute
AC_ATTRIBUTE6 VARCHAR2 (240)
Descriptive flexfield attribute
AC_ATTRIBUTE7 VARCHAR2 (240)
Descriptive flexfield attribute
AC_ATTRIBUTE8 VARCHAR2 (240)
Descriptive flexfield attribute
AC_ATTRIBUTE9 VARCHAR2 (240)
Descriptive flexfield attribute
AC_ATTRIBUTE10 VARCHAR2 (240)
Descriptive flexfield attribute
AC_ATTRIBUTE11 VARCHAR2 (240)
Descriptive flexfield attribute
AC_ATTRIBUTE12 VARCHAR2 (240)
Descriptive flexfield attribute
AC_ATTRIBUTE13 VARCHAR2 (240)
Descriptive flexfield attribute
AC_ATTRIBUTE14 VARCHAR2 (240)
Descriptive flexfield attribute
AC_ATTRIBUTE15 VARCHAR2 (240)
Descriptive flexfield attribute
LOCK_CONTROL NUMBER

Lock control number
OPERAND_PER_PQTY NUMBER

Value of pricing request detail line
ADJUSTED_AMOUNT_PER_PQTY NUMBER

It holds the value of the bucketed adjusted amount for line types
INTERCO_INVOICED_FLAG VARCHAR2 (1)
Reserved for future use
INVOICED_AMOUNT NUMBER

Reserved for future use
RETROBILL_REQUEST_ID NUMBER

Reserved for future use
TAX_RATE_ID NUMBER (15)
Reserved for future use
Query Text

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


SELECT 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
,      PO_HEADER_ID
,      AUTOMATIC_FLAG
,      PO_LINE_ID
,      ADJ_LINE_NUM
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ORIG_SYS_DISCOUNT_REF
,      CHANGE_SEQUENCE
,      LIST_HEADER_ID
,      LIST_TYPE_CODE
,      LIST_LINE_ID
,      LIST_LINE_TYPE_CODE
,      MODIFIED_FROM
,      MODIFIED_TO
,      UPDATE_ALLOWED
,      CHANGE_REASON_CODE
,      CHANGE_REASON_TEXT
,      UPDATED_FLAG
,      APPLIED_FLAG
,      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
,      ADJUSTED_AMOUNT
,      PRICING_PHASE_ID
,      CHARGE_TYPE_CODE
,      CHARGE_SUBTYPE_CODE
,      RANGE_BREAK_QUANTITY
,      ACCRUAL_CONVERSION_RATE
,      PRICING_GROUP_SEQUENCE
,      ACCRUAL_FLAG
,      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
,      MODIFIER_LEVEL_CODE
,      PRICE_BREAK_TYPE_CODE
,      SUBSTITUTION_ATTRIBUTE
,      PRORATION_TYPE_CODE
,      INCLUDE_ON_RETURNS_FLAG
,      CREDIT_OR_CHARGE_FLAG
,      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
,      INTERCO_INVOICED_FLAG
,      INVOICED_AMOUNT
,      RETROBILL_REQUEST_ID
,      TAX_RATE_ID
FROM PO.PO_PRICE_ADJUSTMENTS;

Dependencies

[top of page]

PO.PO_PRICE_ADJUSTMENTS does not reference any database object

PO.PO_PRICE_ADJUSTMENTS is referenced by following:

SchemaPO
ViewPO_PRICE_ADJUSTMENTS#