DBA Data[Home] [Help]

VIEW: OZF.OZF_OFFER_ADJUSTMENT_LINES#

Source

View Text - Preformatted

select OFFER_ADJUSTMENT_LINE_ID OFFER_ADJUSTMENT_LINE_ID, OFFER_ADJUSTMENT_ID OFFER_ADJUSTMENT_ID, LIST_LINE_ID LIST_LINE_ID, ARITHMETIC_OPERATOR ARITHMETIC_OPERATOR, ORIGINAL_DISCOUNT ORIGINAL_DISCOUNT, MODIFIED_DISCOUNT MODIFIED_DISCOUNT, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, SECURITY_GROUP_ID SECURITY_GROUP_ID, LIST_HEADER_ID LIST_HEADER_ID, ACCRUAL_FLAG ACCRUAL_FLAG, LIST_LINE_ID_TD LIST_LINE_ID_TD, ORIGINAL_DISCOUNT_TD ORIGINAL_DISCOUNT_TD, MODIFIED_DISCOUNT_TD MODIFIED_DISCOUNT_TD, QUANTITY QUANTITY, CREATED_FROM_ADJUSTMENTS CREATED_FROM_ADJUSTMENTS, DISCOUNT_END_DATE DISCOUNT_END_DATE from "OZF"."OZF_OFFER_ADJUSTMENT_LINES"
View Text - HTML Formatted

SELECT OFFER_ADJUSTMENT_LINE_ID OFFER_ADJUSTMENT_LINE_ID
, OFFER_ADJUSTMENT_ID OFFER_ADJUSTMENT_ID
, LIST_LINE_ID LIST_LINE_ID
, ARITHMETIC_OPERATOR ARITHMETIC_OPERATOR
, ORIGINAL_DISCOUNT ORIGINAL_DISCOUNT
, MODIFIED_DISCOUNT MODIFIED_DISCOUNT
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, LIST_HEADER_ID LIST_HEADER_ID
, ACCRUAL_FLAG ACCRUAL_FLAG
, LIST_LINE_ID_TD LIST_LINE_ID_TD
, ORIGINAL_DISCOUNT_TD ORIGINAL_DISCOUNT_TD
, MODIFIED_DISCOUNT_TD MODIFIED_DISCOUNT_TD
, QUANTITY QUANTITY
, CREATED_FROM_ADJUSTMENTS CREATED_FROM_ADJUSTMENTS
, DISCOUNT_END_DATE DISCOUNT_END_DATE
FROM "OZF"."OZF_OFFER_ADJUSTMENT_LINES"