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_BOOK_TO_SHIP_CYCLE_S

Object Details

Object Name:	ISC_EDW_BOOK_TO_SHIP_CYCLE_S
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ISC.ISC_EDW_BOOK_TO_SHIP_CYCLE_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 Bookings fact table.

[View Source]

Columns

Name	Datatype	Length	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
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)
PERIOD_FK	NUMBER			Foreign key to the Time dimension, Period level
QTR_FK	NUMBER			Foreign key to the Time dimension, Quarter level
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
YEAR_FK	NUMBER			Foreign key to the Time dimension, Year level
BOOK_TO_LATEST_PICK_CYCLE	NUMBER			Book to Latest Pick release Cycle Time
BOOK_TO_LATEST_SHIP_CYCLE	NUMBER			Book to Latest Ship Cycle Time
LINE_ID	VARCHAR2	(80)		Sales Order Line Id

Query Text

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


SELECT AREA_FK
,      BUS_GRP_FK
,      CATG_FK
,      COUNTRY_FK
,      INT_ORGA_FK
,      LEGAL_ENT_FK
,      OPER_UNIT_FK
,      ORDER_SOURCE_FK
,      ORDER_TYPE_FK
,      PERIOD_FK
,      QTR_FK
,      REGION_FK
,      SALES_CHANNEL_FK
,      YEAR_FK
,      BOOK_TO_LATEST_PICK_CYCLE
,      BOOK_TO_LATEST_SHIP_CYCLE
,      LINE_ID
FROM APPS.ISC_EDW_BOOK_TO_SHIP_CYCLE_S;

Dependencies

[top of page]

APPS.ISC_EDW_BOOK_TO_SHIP_CYCLE_S references the following:

APPS: EDW_GEOGRAPHY_M; EDW_ITEMS_M; EDW_LOOKUP_M; EDW_ORGANIZATION_M; EDW_TIME_M; ISC_EDW_BOOKINGS_F

APPS.ISC_EDW_BOOK_TO_SHIP_CYCLE_S is not referenced by any database object