[Home] [Help] [Dependency Information]
Object Name: | OZF_RES_CUST_PROD_FACTS |
---|---|
Object Type: | TABLE |
Owner: | OZF |
FND Design Data: | OZF.OZF_RES_CUST_PROD_FACTS |
Subobject Name: | |
Status: | VALID |
This table stores all the rollup information that needs to be displayed on the Account Manager Dashboard at a customer and product level for each user.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OZF_RES_CUST_PROD_FACTS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
RESOURCE_ID
REPORT_DATE FACT_ROW_FOR |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RES_CUST_PROD_FACTS_ID | NUMBER | Yes | Unique Identifier | |
RESOURCE_ID | NUMBER | Yes | Resource Identifier | |
REPORT_DATE | DATE | Yes | Report Date | |
FACT_ROW_FOR | VARCHAR2 | (30) | Yes | Identifies if the data is for a Party, Bill to , Ship To or a Product |
PARTY_ID | NUMBER | Party Identifier | ||
CUST_ACCOUNT_ID | NUMBER | Customer Account Identifier | ||
BILL_TO_SITE_USE_ID | NUMBER | Bill To Site Identifier | ||
SHIP_TO_SITE_USE_ID | NUMBER | Ship To site identifier | ||
PRODUCT_ATTRIBUTE | VARCHAR2 | (30) | Product Attribute | |
PRODUCT_ATTR_VALUE | VARCHAR2 | (240) | Product Attribute value | |
PTD_SALES | NUMBER | Period To Date Sales | ||
QTD_SALES | NUMBER | Quarter to date sales | ||
YTD_SALES | NUMBER | Year to date sales | ||
LPTD_SALES | NUMBER | Last year same Period to date sales | ||
LQTD_SALES | NUMBER | Last year same quarter to date sales | ||
LYTD_SALES | NUMBER | Last year todate sales | ||
LYSP_SALES | NUMBER | Last year same period sales | ||
LYSQ_SALES | NUMBER | Last year same quarter sales | ||
LY_SALES | NUMBER | Last Year Sales | ||
PERIOD_QUOTA | NUMBER | Quota for the current period | ||
QTR_QUOTA | NUMBER | Quota for the current quarter | ||
YEAR_QUOTA | NUMBER | Quota for the current year | ||
MTD_BASESALES | NUMBER | Month to date base sales | ||
QTD_BASESALES | NUMBER | Quarter to date base sales | ||
YTD_BASESALES | NUMBER | Year to date base sales | ||
OUTSTANDING_ORDERS | NUMBER | Outstanding Orders | ||
CURRENT_ORDERS | NUMBER | Current Orders | ||
BACK_ORDERS | NUMBER | Back orders | ||
FUTURE_ORDERS | NUMBER | Future Orders | ||
TOT_SHIP_PSBL_PERIOD | NUMBER | Total shipments possible for the current period | ||
YTD_FUND_UTILIZED | NUMBER | Year to date fund utilized | ||
YTD_FUND_EARNED | NUMBER | Year to date fund earned | ||
YTD_FUND_PAID | NUMBER | Year to date fund paid | ||
QTD_FUND_UTILIZED | NUMBER | Quarter to date fund utilized | ||
QTD_FUND_EARNED | NUMBER | Quarter to date fund earned | ||
QTD_FUND_PAID | NUMBER | Quarter to date fund paid | ||
MTD_FUND_UTILIZED | NUMBER | Month to date fund utilized | ||
MTD_FUND_EARNED | NUMBER | Month to date fund earned | ||
MTD_FUND_PAID | NUMBER | Month to date fund Paid | ||
FUND_UNPAID | NUMBER | Unpaid funds | ||
OPEN_CLAIMS | NUMBER | Open claims | ||
CREATION_DATE | DATE | Yes | Standard WHO column | |
CREATED_BY | NUMBER | (15) | Yes | Standard WHO column |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard WHO column |
Cut, paste (and edit) the following text to query this object:
SELECT RES_CUST_PROD_FACTS_ID
, RESOURCE_ID
, REPORT_DATE
, FACT_ROW_FOR
, PARTY_ID
, CUST_ACCOUNT_ID
, BILL_TO_SITE_USE_ID
, SHIP_TO_SITE_USE_ID
, PRODUCT_ATTRIBUTE
, PRODUCT_ATTR_VALUE
, PTD_SALES
, QTD_SALES
, YTD_SALES
, LPTD_SALES
, LQTD_SALES
, LYTD_SALES
, LYSP_SALES
, LYSQ_SALES
, LY_SALES
, PERIOD_QUOTA
, QTR_QUOTA
, YEAR_QUOTA
, MTD_BASESALES
, QTD_BASESALES
, YTD_BASESALES
, OUTSTANDING_ORDERS
, CURRENT_ORDERS
, BACK_ORDERS
, FUTURE_ORDERS
, TOT_SHIP_PSBL_PERIOD
, YTD_FUND_UTILIZED
, YTD_FUND_EARNED
, YTD_FUND_PAID
, QTD_FUND_UTILIZED
, QTD_FUND_EARNED
, QTD_FUND_PAID
, MTD_FUND_UTILIZED
, MTD_FUND_EARNED
, MTD_FUND_PAID
, FUND_UNPAID
, OPEN_CLAIMS
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM OZF.OZF_RES_CUST_PROD_FACTS;
OZF.OZF_RES_CUST_PROD_FACTS does not reference any database object
OZF.OZF_RES_CUST_PROD_FACTS is referenced by following:
|
|
|