VIEW: APPS.OKC_PRICE_ADJUSTMENTS_HV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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