VIEW: OZF.OZF_RESALE_ADJUSTMENTS_ALL#

Source

View Text - Preformatted

select RESALE_ADJUSTMENT_ID RESALE_ADJUSTMENT_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, REQUEST_ID REQUEST_ID, CREATED_BY CREATED_BY, CREATED_FROM CREATED_FROM, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PROGRAM_ID PROGRAM_ID, RESALE_BATCH_ID RESALE_BATCH_ID, STATUS_CODE STATUS_CODE, RESALE_LINE_ID RESALE_LINE_ID, ORIG_SYSTEM_AGREEMENT_UOM ORIG_SYSTEM_AGREEMENT_UOM, ORIG_SYSTEM_AGREEMENT_NAME ORIG_SYSTEM_AGREEMENT_NAME, ORIG_SYSTEM_AGREEMENT_TYPE ORIG_SYSTEM_AGREEMENT_TYPE, ORIG_SYSTEM_AGREEMENT_STATUS ORIG_SYSTEM_AGREEMENT_STATUS, ORIG_SYSTEM_AGREEMENT_CURR ORIG_SYSTEM_AGREEMENT_CURR, ORIG_SYSTEM_AGREEMENT_PRICE ORIG_SYSTEM_AGREEMENT_PRICE, ORIG_SYSTEM_AGREEMENT_QUANTITY ORIG_SYSTEM_AGREEMENT_QUANTITY, AGREEMENT_ID AGREEMENT_ID, AGREEMENT_TYPE AGREEMENT_TYPE, AGREEMENT_NAME AGREEMENT_NAME, AGREEMENT_PRICE AGREEMENT_PRICE, AGREEMENT_UOM_CODE AGREEMENT_UOM_CODE, CORRECTED_AGREEMENT_ID CORRECTED_AGREEMENT_ID, CORRECTED_AGREEMENT_NAME CORRECTED_AGREEMENT_NAME, CREDIT_CODE CREDIT_CODE, CREDIT_ADVICE_DATE CREDIT_ADVICE_DATE, CLAIMED_AMOUNT CLAIMED_AMOUNT, TOTAL_CLAIMED_AMOUNT TOTAL_CLAIMED_AMOUNT, ALLOWED_AMOUNT ALLOWED_AMOUNT, TOTAL_ALLOWED_AMOUNT TOTAL_ALLOWED_AMOUNT, ACCEPTED_AMOUNT ACCEPTED_AMOUNT, TOTAL_ACCEPTED_AMOUNT TOTAL_ACCEPTED_AMOUNT, CALCULATED_PRICE CALCULATED_PRICE, ACCTD_CALCULATED_PRICE ACCTD_CALCULATED_PRICE, CALCULATED_AMOUNT CALCULATED_AMOUNT, LINE_AGREEMENT_FLAG LINE_AGREEMENT_FLAG, TOLERANCE_FLAG TOLERANCE_FLAG, LINE_TOLERANCE_AMOUNT LINE_TOLERANCE_AMOUNT, OPERAND OPERAND, OPERAND_CALCULATION_CODE OPERAND_CALCULATION_CODE, PRICED_QUANTITY PRICED_QUANTITY, PRICED_UOM_CODE PRICED_UOM_CODE, PRICED_UNIT_PRICE PRICED_UNIT_PRICE, LIST_HEADER_ID LIST_HEADER_ID, LIST_LINE_ID LIST_LINE_ID, ORG_ID ORG_ID, SECURITY_GROUP_ID SECURITY_GROUP_ID from "OZF"."OZF_RESALE_ADJUSTMENTS_ALL"

View Text - HTML Formatted

SELECT RESALE_ADJUSTMENT_ID RESALE_ADJUSTMENT_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, REQUEST_ID REQUEST_ID
, CREATED_BY CREATED_BY
, CREATED_FROM CREATED_FROM
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PROGRAM_ID PROGRAM_ID
, RESALE_BATCH_ID RESALE_BATCH_ID
, STATUS_CODE STATUS_CODE
, RESALE_LINE_ID RESALE_LINE_ID
, ORIG_SYSTEM_AGREEMENT_UOM ORIG_SYSTEM_AGREEMENT_UOM
, ORIG_SYSTEM_AGREEMENT_NAME ORIG_SYSTEM_AGREEMENT_NAME
, ORIG_SYSTEM_AGREEMENT_TYPE ORIG_SYSTEM_AGREEMENT_TYPE
, ORIG_SYSTEM_AGREEMENT_STATUS ORIG_SYSTEM_AGREEMENT_STATUS
, ORIG_SYSTEM_AGREEMENT_CURR ORIG_SYSTEM_AGREEMENT_CURR
, ORIG_SYSTEM_AGREEMENT_PRICE ORIG_SYSTEM_AGREEMENT_PRICE
, ORIG_SYSTEM_AGREEMENT_QUANTITY ORIG_SYSTEM_AGREEMENT_QUANTITY
, AGREEMENT_ID AGREEMENT_ID
, AGREEMENT_TYPE AGREEMENT_TYPE
, AGREEMENT_NAME AGREEMENT_NAME
, AGREEMENT_PRICE AGREEMENT_PRICE
, AGREEMENT_UOM_CODE AGREEMENT_UOM_CODE
, CORRECTED_AGREEMENT_ID CORRECTED_AGREEMENT_ID
, CORRECTED_AGREEMENT_NAME CORRECTED_AGREEMENT_NAME
, CREDIT_CODE CREDIT_CODE
, CREDIT_ADVICE_DATE CREDIT_ADVICE_DATE
, CLAIMED_AMOUNT CLAIMED_AMOUNT
, TOTAL_CLAIMED_AMOUNT TOTAL_CLAIMED_AMOUNT
, ALLOWED_AMOUNT ALLOWED_AMOUNT
, TOTAL_ALLOWED_AMOUNT TOTAL_ALLOWED_AMOUNT
, ACCEPTED_AMOUNT ACCEPTED_AMOUNT
, TOTAL_ACCEPTED_AMOUNT TOTAL_ACCEPTED_AMOUNT
, CALCULATED_PRICE CALCULATED_PRICE
, ACCTD_CALCULATED_PRICE ACCTD_CALCULATED_PRICE
, CALCULATED_AMOUNT CALCULATED_AMOUNT
, LINE_AGREEMENT_FLAG LINE_AGREEMENT_FLAG
, TOLERANCE_FLAG TOLERANCE_FLAG
, LINE_TOLERANCE_AMOUNT LINE_TOLERANCE_AMOUNT
, OPERAND OPERAND
, OPERAND_CALCULATION_CODE OPERAND_CALCULATION_CODE
, PRICED_QUANTITY PRICED_QUANTITY
, PRICED_UOM_CODE PRICED_UOM_CODE
, PRICED_UNIT_PRICE PRICED_UNIT_PRICE
, LIST_HEADER_ID LIST_HEADER_ID
, LIST_LINE_ID LIST_LINE_ID
, ORG_ID ORG_ID
, SECURITY_GROUP_ID SECURITY_GROUP_ID
FROM "OZF"."OZF_RESALE_ADJUSTMENTS_ALL"