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.

[Home] [Help]

View: ISC_EDW_BOOKINGS_BILLINGS_S

Product:	ISC - Supply Chain Intelligence
Description:	This view is used by the Bookings reports
Implementation/DBA Data:	APPS.ISC_EDW_BOOKINGS_BILLINGS_S

View Text

SELECT GEO.ARE1_AREA1_PK_KEY AREA_FK
, ORG.BGRP_BUSINESS_GROUP_PK_KEY BUS_GRP_FK
, ITEM.CO11_CATEGORY_PK_KEY CATG_FK
, GEO.COUN_COUNTRY_PK_KEY COUNTRY_FK
, ORG.ORGA_ORGANIZATION_PK_KEY INT_ORGA_FK
, ORG.LGET_LEGAL_ENTITY_PK_KEY LEGAL_ENT_FK
, ORG.OPER_OPERATING_UNIT_PK_KEY OPER_UNIT_FK
, BOOKINGS.ORDER_SOURCE_FK_KEY ORDER_SOURCE_FK
, BOOKINGS.ORDER_TYPE_FK_KEY ORDER_TYPE_FK
, TIME.ECPR_CAL_PERIOD_PK_KEY PERIOD_FK
, TIME.ECQR_CAL_QTR_PK_KEY QTR_FK
, GEO.REGN_REGION_PK_KEY REGION_FK
, BOOKINGS.SALES_CHANNEL_FK_KEY SALES_CHANNEL_FK
, TIME.ECYR_CAL_YEAR_PK_KEY YEAR_FK
, NVL(BOOKINGS.UNIT_SELL_PRC_G
, 0)*NVL(BOOKINGS.QTY_INVOICED
, 0)-NVL(BOOKINGS.UNIT_SELL_PRC_G
, 0)*NVL(BOOKINGS.QTY_RETURNED
, 0) BILLINGS
, NVL(BOOKINGS.UNIT_SELL_PRC_G
, 0)*NVL(BOOKINGS.QTY_CANCELLED
, 0) CANCELLATIONS
, NVL(BOOKINGS.UNIT_COST_G
, 0)*NVL(BOOKINGS.QTY_ORDERED
, 0)-NVL(BOOKINGS.UNIT_COST_G
, 0)*NVL(BOOKINGS.QTY_RETURNED
, 0) COGS
, (NVL(BOOKINGS.UNIT_LIST_PRC_G
, 0)-NVL(BOOKINGS.UNIT_SELL_PRC_G
, 0))*NVL(BOOKINGS.QTY_ORDERED
, 0)-(NVL(BOOKINGS.UNIT_LIST_PRC_G
, 0)-NVL(BOOKINGS.UNIT_SELL_PRC_G
, 0))*NVL(BOOKINGS.QTY_RETURNED
, 0) DISCOUNTS
, NVL(BOOKINGS.UNIT_SELL_PRC_G
, 0)*NVL(BOOKINGS.QTY_ORDERED
, 0)+NVL(BOOKINGS.UNIT_SELL_PRC_G
, 0)*NVL(BOOKINGS.QTY_CANCELLED
, 0) GROSS_BOOKINGS
, (NVL(BOOKINGS.UNIT_SELL_PRC_G
, 0)-NVL(BOOKINGS.UNIT_COST_G
, 0))*NVL(BOOKINGS.QTY_ORDERED
, 0)-(NVL(BOOKINGS.UNIT_SELL_PRC_G
, 0)-NVL(BOOKINGS.UNIT_COST_G
, 0))*NVL(BOOKINGS.QTY_RETURNED
, 0) GROSS_MARGIN
, NVL(BOOKINGS.UNIT_SELL_PRC_G
, 0)*NVL(BOOKINGS.QTY_ORDERED
, 0)-NVL(BOOKINGS.UNIT_SELL_PRC_G
, 0)*NVL(BOOKINGS.QTY_RETURNED
, 0) NET_BOOKINGS
, NVL(BOOKINGS.UNIT_LIST_PRC_G
, 0)*NVL(BOOKINGS.QTY_ORDERED
, 0)-NVL(BOOKINGS.UNIT_LIST_PRC_G
, 0)*NVL(BOOKINGS.QTY_RETURNED
, 0) NET_BOOKINGS_AT_LIST
, NVL(BOOKINGS.UNIT_SELL_PRC_G
, 0)*NVL(BOOKINGS.QTY_RETURNED
, 0) RETURNS
FROM ISC_EDW_BOOKINGS_F BOOKINGS
, EDW_GEOGRAPHY_M GEO
, EDW_ITEMS_M ITEM
, EDW_ORGANIZATION_M ORG
, EDW_TIME_M TIME
WHERE ITEM.IREV_ITEM_REVISION_PK_KEY = BOOKINGS.TOP_MODEL_FK_KEY
AND ORG.ORGA_ORGANIZATION_PK_KEY = BOOKINGS.INV_ORG_FK_KEY
AND GEO.GLOC_LOCATION_PK_KEY = BOOKINGS.SHIP_TO_LOC_FK_KEY
AND TIME.CDAY_CAL_DAY_PK_KEY = BOOKINGS.DATE_BOOKED_FK_KEY

Columns

Name
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