VIEW: OZF.OZF_FUNDS_UTILIZED_ALL_B#

Source

View Text - Preformatted

select UTILIZATION_ID UTILIZATION_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, CREATED_FROM CREATED_FROM, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, UTILIZATION_TYPE UTILIZATION_TYPE, FUND_ID FUND_ID, PLAN_TYPE PLAN_TYPE, PLAN_ID PLAN_ID, COMPONENT_TYPE COMPONENT_TYPE, COMPONENT_ID COMPONENT_ID, OBJECT_TYPE OBJECT_TYPE, OBJECT_ID OBJECT_ID, ORDER_ID ORDER_ID, INVOICE_ID INVOICE_ID, AMOUNT AMOUNT, ACCTD_AMOUNT ACCTD_AMOUNT, CURRENCY_CODE CURRENCY_CODE, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE, EXCHANGE_RATE_DATE EXCHANGE_RATE_DATE, EXCHANGE_RATE EXCHANGE_RATE, ADJUSTMENT_TYPE ADJUSTMENT_TYPE, ADJUSTMENT_DATE ADJUSTMENT_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ORG_ID ORG_ID, SECURITY_GROUP_ID SECURITY_GROUP_ID, CAMP_SCHEDULE_ID CAMP_SCHEDULE_ID, ADJUSTMENT_TYPE_ID ADJUSTMENT_TYPE_ID, AMS_ACTIVITY_BUDGET_ID AMS_ACTIVITY_BUDGET_ID, PRODUCT_ID PRODUCT_ID, CUST_ACCOUNT_ID CUST_ACCOUNT_ID, GL_DATE GL_DATE, PRODUCT_LEVEL_TYPE PRODUCT_LEVEL_TYPE, AMOUNT_REMAINING AMOUNT_REMAINING, ACCTD_AMOUNT_REMAINING ACCTD_AMOUNT_REMAINING, PRICE_ADJUSTMENT_ID PRICE_ADJUSTMENT_ID, PLAN_CURR_AMOUNT PLAN_CURR_AMOUNT, PLAN_CURR_AMOUNT_REMAINING PLAN_CURR_AMOUNT_REMAINING, SCAN_UNIT SCAN_UNIT, SCAN_UNIT_REMAINING SCAN_UNIT_REMAINING, ACTIVITY_PRODUCT_ID ACTIVITY_PRODUCT_ID, VOLUME_OFFER_TIERS_ID VOLUME_OFFER_TIERS_ID, GL_POSTED_FLAG GL_POSTED_FLAG, BILLTO_CUST_ACCOUNT_ID BILLTO_CUST_ACCOUNT_ID, REFERENCE_TYPE REFERENCE_TYPE, REFERENCE_ID REFERENCE_ID, MONTH_ID MONTH_ID, QUARTER_ID QUARTER_ID, YEAR_ID YEAR_ID, ORDER_LINE_ID ORDER_LINE_ID, ORIG_UTILIZATION_ID ORIG_UTILIZATION_ID, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID, BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID, UNIV_CURR_AMOUNT UNIV_CURR_AMOUNT, UNIV_CURR_AMOUNT_REMAINING UNIV_CURR_AMOUNT_REMAINING, FUND_REQUEST_AMOUNT FUND_REQUEST_AMOUNT, FUND_REQUEST_AMOUNT_REMAINING FUND_REQUEST_AMOUNT_REMAINING, FUND_REQUEST_CURRENCY_CODE FUND_REQUEST_CURRENCY_CODE, PLAN_CURRENCY_CODE PLAN_CURRENCY_CODE, COST_PRICE COST_PRICE, COST_PRICE_CURRENCY_CODE COST_PRICE_CURRENCY_CODE, DISCOUNT_TYPE DISCOUNT_TYPE, DISCOUNT_AMOUNT DISCOUNT_AMOUNT, DISCOUNT_AMOUNT_CURRENCY_CODE DISCOUNT_AMOUNT_CURRENCY_CODE, LIST_LINE_ID LIST_LINE_ID from "OZF"."OZF_FUNDS_UTILIZED_ALL_B"

View Text - HTML Formatted

SELECT UTILIZATION_ID UTILIZATION_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, CREATED_FROM CREATED_FROM
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, UTILIZATION_TYPE UTILIZATION_TYPE
, FUND_ID FUND_ID
, PLAN_TYPE PLAN_TYPE
, PLAN_ID PLAN_ID
, COMPONENT_TYPE COMPONENT_TYPE
, COMPONENT_ID COMPONENT_ID
, OBJECT_TYPE OBJECT_TYPE
, OBJECT_ID OBJECT_ID
, ORDER_ID ORDER_ID
, INVOICE_ID INVOICE_ID
, AMOUNT AMOUNT
, ACCTD_AMOUNT ACCTD_AMOUNT
, CURRENCY_CODE CURRENCY_CODE
, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE
, EXCHANGE_RATE_DATE EXCHANGE_RATE_DATE
, EXCHANGE_RATE EXCHANGE_RATE
, ADJUSTMENT_TYPE ADJUSTMENT_TYPE
, ADJUSTMENT_DATE ADJUSTMENT_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ORG_ID ORG_ID
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, CAMP_SCHEDULE_ID CAMP_SCHEDULE_ID
, ADJUSTMENT_TYPE_ID ADJUSTMENT_TYPE_ID
, AMS_ACTIVITY_BUDGET_ID AMS_ACTIVITY_BUDGET_ID
, PRODUCT_ID PRODUCT_ID
, CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, GL_DATE GL_DATE
, PRODUCT_LEVEL_TYPE PRODUCT_LEVEL_TYPE
, AMOUNT_REMAINING AMOUNT_REMAINING
, ACCTD_AMOUNT_REMAINING ACCTD_AMOUNT_REMAINING
, PRICE_ADJUSTMENT_ID PRICE_ADJUSTMENT_ID
, PLAN_CURR_AMOUNT PLAN_CURR_AMOUNT
, PLAN_CURR_AMOUNT_REMAINING PLAN_CURR_AMOUNT_REMAINING
, SCAN_UNIT SCAN_UNIT
, SCAN_UNIT_REMAINING SCAN_UNIT_REMAINING
, ACTIVITY_PRODUCT_ID ACTIVITY_PRODUCT_ID
, VOLUME_OFFER_TIERS_ID VOLUME_OFFER_TIERS_ID
, GL_POSTED_FLAG GL_POSTED_FLAG
, BILLTO_CUST_ACCOUNT_ID BILLTO_CUST_ACCOUNT_ID
, REFERENCE_TYPE REFERENCE_TYPE
, REFERENCE_ID REFERENCE_ID
, MONTH_ID MONTH_ID
, QUARTER_ID QUARTER_ID
, YEAR_ID YEAR_ID
, ORDER_LINE_ID ORDER_LINE_ID
, ORIG_UTILIZATION_ID ORIG_UTILIZATION_ID
, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID
, BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID
, UNIV_CURR_AMOUNT UNIV_CURR_AMOUNT
, UNIV_CURR_AMOUNT_REMAINING UNIV_CURR_AMOUNT_REMAINING
, FUND_REQUEST_AMOUNT FUND_REQUEST_AMOUNT
, FUND_REQUEST_AMOUNT_REMAINING FUND_REQUEST_AMOUNT_REMAINING
, FUND_REQUEST_CURRENCY_CODE FUND_REQUEST_CURRENCY_CODE
, PLAN_CURRENCY_CODE PLAN_CURRENCY_CODE
, COST_PRICE COST_PRICE
, COST_PRICE_CURRENCY_CODE COST_PRICE_CURRENCY_CODE
, DISCOUNT_TYPE DISCOUNT_TYPE
, DISCOUNT_AMOUNT DISCOUNT_AMOUNT
, DISCOUNT_AMOUNT_CURRENCY_CODE DISCOUNT_AMOUNT_CURRENCY_CODE
, LIST_LINE_ID LIST_LINE_ID
FROM "OZF"."OZF_FUNDS_UTILIZED_ALL_B"