VIEW: OZF.OZF_RES_CUST_PROD_FACTS#

Source

View Text - Preformatted

select RES_CUST_PROD_FACTS_ID RES_CUST_PROD_FACTS_ID, RESOURCE_ID RESOURCE_ID, REPORT_DATE REPORT_DATE, FACT_ROW_FOR FACT_ROW_FOR, PARTY_ID PARTY_ID, CUST_ACCOUNT_ID CUST_ACCOUNT_ID, BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID, PRODUCT_ATTRIBUTE PRODUCT_ATTRIBUTE, PRODUCT_ATTR_VALUE PRODUCT_ATTR_VALUE, PTD_SALES PTD_SALES, QTD_SALES QTD_SALES, YTD_SALES YTD_SALES, LPTD_SALES LPTD_SALES, LQTD_SALES LQTD_SALES, LYTD_SALES LYTD_SALES, LYSP_SALES LYSP_SALES, LYSQ_SALES LYSQ_SALES, LY_SALES LY_SALES, PERIOD_QUOTA PERIOD_QUOTA, QTR_QUOTA QTR_QUOTA, YEAR_QUOTA YEAR_QUOTA, MTD_BASESALES MTD_BASESALES, QTD_BASESALES QTD_BASESALES, YTD_BASESALES YTD_BASESALES, OUTSTANDING_ORDERS OUTSTANDING_ORDERS, CURRENT_ORDERS CURRENT_ORDERS, BACK_ORDERS BACK_ORDERS, FUTURE_ORDERS FUTURE_ORDERS, TOT_SHIP_PSBL_PERIOD TOT_SHIP_PSBL_PERIOD, YTD_FUND_UTILIZED YTD_FUND_UTILIZED, YTD_FUND_EARNED YTD_FUND_EARNED, YTD_FUND_PAID YTD_FUND_PAID, QTD_FUND_UTILIZED QTD_FUND_UTILIZED, QTD_FUND_EARNED QTD_FUND_EARNED, QTD_FUND_PAID QTD_FUND_PAID, MTD_FUND_UTILIZED MTD_FUND_UTILIZED, MTD_FUND_EARNED MTD_FUND_EARNED, MTD_FUND_PAID MTD_FUND_PAID, FUND_UNPAID FUND_UNPAID, OPEN_CLAIMS OPEN_CLAIMS, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "OZF"."OZF_RES_CUST_PROD_FACTS"

View Text - HTML Formatted

SELECT RES_CUST_PROD_FACTS_ID RES_CUST_PROD_FACTS_ID
, RESOURCE_ID RESOURCE_ID
, REPORT_DATE REPORT_DATE
, FACT_ROW_FOR FACT_ROW_FOR
, PARTY_ID PARTY_ID
, CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID
, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID
, PRODUCT_ATTRIBUTE PRODUCT_ATTRIBUTE
, PRODUCT_ATTR_VALUE PRODUCT_ATTR_VALUE
, PTD_SALES PTD_SALES
, QTD_SALES QTD_SALES
, YTD_SALES YTD_SALES
, LPTD_SALES LPTD_SALES
, LQTD_SALES LQTD_SALES
, LYTD_SALES LYTD_SALES
, LYSP_SALES LYSP_SALES
, LYSQ_SALES LYSQ_SALES
, LY_SALES LY_SALES
, PERIOD_QUOTA PERIOD_QUOTA
, QTR_QUOTA QTR_QUOTA
, YEAR_QUOTA YEAR_QUOTA
, MTD_BASESALES MTD_BASESALES
, QTD_BASESALES QTD_BASESALES
, YTD_BASESALES YTD_BASESALES
, OUTSTANDING_ORDERS OUTSTANDING_ORDERS
, CURRENT_ORDERS CURRENT_ORDERS
, BACK_ORDERS BACK_ORDERS
, FUTURE_ORDERS FUTURE_ORDERS
, TOT_SHIP_PSBL_PERIOD TOT_SHIP_PSBL_PERIOD
, YTD_FUND_UTILIZED YTD_FUND_UTILIZED
, YTD_FUND_EARNED YTD_FUND_EARNED
, YTD_FUND_PAID YTD_FUND_PAID
, QTD_FUND_UTILIZED QTD_FUND_UTILIZED
, QTD_FUND_EARNED QTD_FUND_EARNED
, QTD_FUND_PAID QTD_FUND_PAID
, MTD_FUND_UTILIZED MTD_FUND_UTILIZED
, MTD_FUND_EARNED MTD_FUND_EARNED
, MTD_FUND_PAID MTD_FUND_PAID
, FUND_UNPAID FUND_UNPAID
, OPEN_CLAIMS OPEN_CLAIMS
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "OZF"."OZF_RES_CUST_PROD_FACTS"