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

VIEW: APPS.ISC_EDW_ORDER_FULFILL_SHIP_S

Object Details
Object Name: ISC_EDW_ORDER_FULFILL_SHIP_S
Object Type: VIEW
Owner: APPS
FND Design Data: ViewISC.ISC_EDW_ORDER_FULFILL_SHIP_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 Lookup dimension (Order Category)
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
ONEDAYPICK NUMBER

Number of Orders Booked and Picked within 24 hours
ONEDAYSHIP NUMBER

Number of Orders Booked and Shipped within 24 hours
NOWKENDPICK NUMBER

Number of Orders Booked and Picked within 24 hours, weekends excluded
NOWKENDSHIP NUMBER

Number of Orders Booked and Shipped within 24 hours, weekends excluded
FULFILLED NUMBER

Counter of fulfilled orders
HEADER_ID VARCHAR2 (121)
Sales Order Header 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
,      ONEDAYPICK
,      ONEDAYSHIP
,      NOWKENDPICK
,      NOWKENDSHIP
,      FULFILLED
,      HEADER_ID
FROM APPS.ISC_EDW_ORDER_FULFILL_SHIP_S;

Dependencies

[top of page]

APPS.ISC_EDW_ORDER_FULFILL_SHIP_S references the following:

SchemaAPPS
SynonymEDW_GEOGRAPHY_M
SynonymEDW_ITEMS_M
SynonymEDW_LOOKUP_M
SynonymEDW_ORGANIZATION_M
SynonymEDW_TIME_M
SynonymISC_EDW_BOOKINGS_F

APPS.ISC_EDW_ORDER_FULFILL_SHIP_S is not referenced by any database object