eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.ISC_EDW_BACKLOG_S

Object Details

Object Name:	ISC_EDW_BACKLOG_S
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ISC.ISC_EDW_BACKLOG_S
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view is designed to be used by Oracle Performance Measure Viewer (PMV). The _FK columns are mapping the dimension levels, while measures are retrieved from the Backlog Snapshot fact table.

[View Source]

Columns

Name	Datatype	Mandatory	Comments
AREA_FK	NUMBER		Foreign key to the Geography dimension, Area level
BUS_GRP_FK	NUMBER		Foreign key to the Internal Organization dimension, Business Group level
CATG_FK	NUMBER		Foreign key to the Item dimension, Category level
COUNTRY_FK	NUMBER		Foreign key to the Geography dimension, Country level
DAY_FK	NUMBER		Foreign key to the Time dimension, Day level
INT_ORGA_FK	NUMBER	Yes	Foreign key to the Internal Organization dimension, Internal Organization level
LEGAL_ENT_FK	NUMBER		Foreign key to the Internal Organization dimension, Legal Entity level
OPER_UNIT_FK	NUMBER		Foreign key to the Internal Organization dimension, Operating Unit level
ORDER_SOURCE_FK	NUMBER		Foreign key to the Lookup dimension (Order Source)
ORDER_TYPE_FK	NUMBER		Foreign key to the Lookup dimension (Order Type)
REGION_FK	NUMBER		Foreign key to the Geography dimension, Region level
SALES_CHANNEL_FK	NUMBER		Foreign key to the Sales Channel dimension, Sales Channel level
BILLING_COST	NUMBER		Billing Backlog amount at cost
BILLING_MARGIN	NUMBER		Billing Backlog Margin (Billing Backlog at Sell Price - Billing Backlog at Cost)
BILLING_REVENUE	NUMBER		Billing Backlog at Sell Price
DELINQUENT_COST	NUMBER		Delinquent Backlog amount at cost
DELINQUENT_MARGIN	NUMBER		Delinquent Backlog Margin (Delinquent Backlog at Sell Price - Delinquent Backlog at Cost)
DELINQUENT_REVENUE	NUMBER		Delinquent Backlog at Sell Price
SHIPPING_COST	NUMBER		Shipping Backlog amount at cost
SHIPPING_MARGIN	NUMBER		Shipping Backlog Margin (Shipping Backlog at Sell Price - Shipping Backlog at Cost)
SHIPPING_REVENUE	NUMBER		Shipping Backlog at Sell Price
UNBILL_COST	NUMBER		Unbilled Shipments Backlog amount at cost
UNBILL_MARGIN	NUMBER		Unbilled Shipments Backlog Margin (Unbilled Shipments Backlog at Sell Price - Unbilled Shipments Backlog at Cost)
UNBILL_REVENUE	NUMBER		Unbilled Shipments Backlog at Sell Price

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT AREA_FK
,      BUS_GRP_FK
,      CATG_FK
,      COUNTRY_FK
,      DAY_FK
,      INT_ORGA_FK
,      LEGAL_ENT_FK
,      OPER_UNIT_FK
,      ORDER_SOURCE_FK
,      ORDER_TYPE_FK
,      REGION_FK
,      SALES_CHANNEL_FK
,      BILLING_COST
,      BILLING_MARGIN
,      BILLING_REVENUE
,      DELINQUENT_COST
,      DELINQUENT_MARGIN
,      DELINQUENT_REVENUE
,      SHIPPING_COST
,      SHIPPING_MARGIN
,      SHIPPING_REVENUE
,      UNBILL_COST
,      UNBILL_MARGIN
,      UNBILL_REVENUE
FROM APPS.ISC_EDW_BACKLOG_S;

Dependencies

[top of page]

APPS.ISC_EDW_BACKLOG_S references the following:

APPS: EDW_GEOGRAPHY_M; EDW_ITEMS_M; EDW_ORGANIZATION_M; EDW_TIME_M; ISC_EDW_BACKLOGS_F

APPS.ISC_EDW_BACKLOG_S is not referenced by any database object