DBA Data[Home] [Help] [Dependency Information]

TABLE: OZF.OZF_RES_CUST_PROD_FACTS

Object Details
Object Name: OZF_RES_CUST_PROD_FACTS
Object Type: TABLE
Owner: OZF
FND Design Data: TableOZF.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.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OZF_RES_CUST_PROD_FACTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRESOURCE_ID
ColumnREPORT_DATE
ColumnFACT_ROW_FOR
Columns
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
Query Text

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;

Dependencies

[top of page]

OZF.OZF_RES_CUST_PROD_FACTS does not reference any database object

OZF.OZF_RES_CUST_PROD_FACTS is referenced by following:

SchemaOZF
ViewOZF_RES_CUST_PROD_FACTS#