VIEW: OZF.OZF_FUNDS_UTILIZED_DRAFT_ALL#

Source

View Text - Preformatted

select DRAFT_RUN_ID DRAFT_RUN_ID, DRAFT_UTILIZATION_ID DRAFT_UTILIZATION_ID, OBJECT_TYPE OBJECT_TYPE, OBJECT_ID OBJECT_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, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, UTILIZATION_TYPE UTILIZATION_TYPE, PLAN_TYPE PLAN_TYPE, PLAN_ID PLAN_ID, ACCTD_AMOUNT ACCTD_AMOUNT, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE, EXCHANGE_RATE_DATE EXCHANGE_RATE_DATE, EXCHANGE_RATE EXCHANGE_RATE, ORG_ID ORG_ID, PRODUCT_ID PRODUCT_ID, CUST_ACCOUNT_ID CUST_ACCOUNT_ID, PRODUCT_LEVEL_TYPE PRODUCT_LEVEL_TYPE, PLAN_CURR_AMOUNT PLAN_CURR_AMOUNT, ACTIVITY_PRODUCT_ID ACTIVITY_PRODUCT_ID, BILLTO_CUST_ACCOUNT_ID BILLTO_CUST_ACCOUNT_ID, REFERENCE_TYPE REFERENCE_TYPE, REFERENCE_ID REFERENCE_ID, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID, BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID, 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_DRAFT_ALL"

View Text - HTML Formatted

SELECT DRAFT_RUN_ID DRAFT_RUN_ID
, DRAFT_UTILIZATION_ID DRAFT_UTILIZATION_ID
, OBJECT_TYPE OBJECT_TYPE
, OBJECT_ID OBJECT_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
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, UTILIZATION_TYPE UTILIZATION_TYPE
, PLAN_TYPE PLAN_TYPE
, PLAN_ID PLAN_ID
, ACCTD_AMOUNT ACCTD_AMOUNT
, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE
, EXCHANGE_RATE_DATE EXCHANGE_RATE_DATE
, EXCHANGE_RATE EXCHANGE_RATE
, ORG_ID ORG_ID
, PRODUCT_ID PRODUCT_ID
, CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, PRODUCT_LEVEL_TYPE PRODUCT_LEVEL_TYPE
, PLAN_CURR_AMOUNT PLAN_CURR_AMOUNT
, ACTIVITY_PRODUCT_ID ACTIVITY_PRODUCT_ID
, BILLTO_CUST_ACCOUNT_ID BILLTO_CUST_ACCOUNT_ID
, REFERENCE_TYPE REFERENCE_TYPE
, REFERENCE_ID REFERENCE_ID
, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID
, BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID
, 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_DRAFT_ALL"