Product: | OKC - Contracts Core |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OKC_PRICE_ADJUSTMENTS_HV |
SELECT PATB.ROWID ROW_ID
, PATB.ID ID
, PATB.PAT_ID PAT_ID
, PATB.CHR_ID CHR_ID
, PATB.CLE_ID CLE_ID
, PATB.BSL_ID BSL_ID
, PATB.BCL_ID BCL_ID
, PATB.MODIFIED_FROM MODIFIED_FROM
, PATB.MODIFIED_TO MODIFIED_TO
, PATB.MODIFIER_MECHANISM_TYPE_CODE MODIFIER_MECHANISM_TYPE_CODE
, PATB.OPERAND OPERAND
, PATB.ARITHMETIC_OPERATOR ARITHMETIC_OPERATOR
, PATB.AUTOMATIC_FLAG AUTOMATIC_FLAG
, PATB.UPDATE_ALLOWED UPDATE_ALLOWED
, PATB.UPDATED_FLAG UPDATED_FLAG
, PATB.APPLIED_FLAG APPLIED_FLAG
, PATB.ON_INVOICE_FLAG ON_INVOICE_FLAG
, PATB.PRICING_PHASE_ID PRICING_PHASE_ID
, PATB.CONTEXT CONTEXT
, PATB.PROGRAM_APPLICATION_ID
, PATB.PROGRAM_ID
, PATB.PROGRAM_UPDATE_DATE
, PATB.REQUEST_ID
, PATB.LIST_HEADER_ID
, PATB.LIST_LINE_ID
, PATB.LIST_LINE_TYPE_CODE
, PATB.CHANGE_REASON_CODE
, PATB.CHANGE_REASON_TEXT
, PATB.ESTIMATED_FLAG
, PATB.ADJUSTED_AMOUNT
, PATB.CHARGE_TYPE_CODE
, PATB.CHARGE_SUBTYPE_CODE
, PATB.RANGE_BREAK_QUANTITY
, PATB.ACCRUAL_CONVERSION_RATE
, PATB.PRICING_GROUP_SEQUENCE
, PATB.ACCRUAL_FLAG
, LIST_LINE_NO
, PATB.SOURCE_SYSTEM_CODE
, PATB.BENEFIT_QTY
, PATB.BENEFIT_UOM_CODE
, PATB.EXPIRATION_DATE
, PATB.MODIFIER_LEVEL_CODE
, PATB.PRICE_BREAK_TYPE_CODE
, PATB.SUBSTITUTION_ATTRIBUTE
, PATB.PRORATION_TYPE_CODE
, PATB.INCLUDE_ON_RETURNS_FLAG
, PATB.OBJECT_VERSION_NUMBER
, PATB.ATTRIBUTE1
, PATB.ATTRIBUTE2 ATTRIBUTE2
, PATB.ATTRIBUTE3 ATTRIBUTE3
, PATB.ATTRIBUTE4 ATTRIBUTE4
, PATB.ATTRIBUTE5 ATTRIBUTE5
, PATB.ATTRIBUTE6 ATTRIBUTE6
, PATB.ATTRIBUTE7 ATTRIBUTE7
, PATB.ATTRIBUTE8 ATTRIBUTE8
, PATB.ATTRIBUTE9 ATTRIBUTE9
, PATB.ATTRIBUTE10 ATTRIBUTE10
, PATB.ATTRIBUTE11 ATTRIBUTE11
, PATB.ATTRIBUTE12 ATTRIBUTE12
, PATB.ATTRIBUTE13 ATTRIBUTE13
, PATB.ATTRIBUTE14 ATTRIBUTE14
, PATB.ATTRIBUTE15 ATTRIBUTE15
, PATB.CREATED_BY CREATED_BY
, PATB.CREATION_DATE CREATION_DATE
, PATB.LAST_UPDATED_BY LAST_UPDATED_BY
, PATB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PATB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PATB.MAJOR_VERSION MAJOR_VERSION
, PATB.REBATE_TRANSACTION_TYPE_CODE REBATE_TRANSACTION_TYPE_CODE
FROM OKC_PRICE_ADJUSTMENTS_H PATB