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

VIEW: APPS.ISC_EDW_BOOKINGS_BILLINGS_S

Object Details
Object Name: ISC_EDW_BOOKINGS_BILLINGS_S
Object Type: VIEW
Owner: APPS
FND Design Data: ViewISC.ISC_EDW_BOOKINGS_BILLINGS_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
BILLINGS NUMBER

Billing amount
CANCELLATIONS NUMBER

Cancellation amount
COGS NUMBER

Cost of Goods Sold
DISCOUNTS NUMBER

Discounts amount
GROSS_BOOKINGS NUMBER

Gross Bookings amount
GROSS_MARGIN NUMBER

Gross Margin (Net Bookings - COGS)
NET_BOOKINGS NUMBER

Net Bookings (at Sell Price)
NET_BOOKINGS_AT_LIST NUMBER

Bookings (at List Price)
RETURNS NUMBER

Returns amount
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
,      BILLINGS
,      CANCELLATIONS
,      COGS
,      DISCOUNTS
,      GROSS_BOOKINGS
,      GROSS_MARGIN
,      NET_BOOKINGS
,      NET_BOOKINGS_AT_LIST
,      RETURNS
FROM APPS.ISC_EDW_BOOKINGS_BILLINGS_S;

Dependencies

[top of page]

APPS.ISC_EDW_BOOKINGS_BILLINGS_S references the following:

SchemaAPPS
SynonymEDW_GEOGRAPHY_M
SynonymEDW_ITEMS_M
SynonymEDW_ORGANIZATION_M
SynonymEDW_TIME_M
SynonymISC_EDW_BOOKINGS_F

APPS.ISC_EDW_BOOKINGS_BILLINGS_S is not referenced by any database object