Product: | ISC - Supply Chain Intelligence (Obsolete) |
---|---|
Description: | This view is used by the Backlog reports |
Implementation/DBA Data: | Not implemented in this database |
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
, TIME.DAY_DAY_PK_KEY DAY_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
, BACKLOG.ORDER_SOURCE_FK_KEY ORDER_SOURCE_FK
, BACKLOG.ORDER_TYPE_FK_KEY ORDER_TYPE_FK
, GEO.REGN_REGION_PK_KEY REGION_FK
, BACKLOG.SALES_CHANNEL_FK_KEY SALES_CHANNEL_FK
, BACKLOG.BILL_BKLG_COST_G BILLING_COST
, BACKLOG.BILL_BKLG_MRG_G BILLING_MARGIN
, BACKLOG.BILL_BKLG_REV_G BILLING_REVENUE
, BACKLOG.DLQT_BKLG_COST_G DELINQUENT_COST
, BACKLOG.DLQT_BKLG_MRG_G DELINQUENT_MARGIN
, BACKLOG.DLQT_BKLG_REV_G DELINQUENT_REVENUE
, BACKLOG.SHIP_BKLG_COST_G SHIPPING_COST
, BACKLOG.SHIP_BKLG_MRG_G SHIPPING_MARGIN
, BACKLOG.SHIP_BKLG_REV_G SHIPPING_REVENUE
, BACKLOG.UNBILL_SHIP_COST_G UNBILL_COST
, BACKLOG.UNBILL_SHIP_MRG_G UNBILL_MARGIN
, BACKLOG.UNBILL_SHIP_REV_G UNBILL_REVENUE
FROM ISC_EDW_BACKLOGS_F BACKLOG
, EDW_GEOGRAPHY_M GEO
, EDW_ITEMS_M ITEM
, EDW_ORGANIZATION_M ORG
, EDW_TIME_M TIME
WHERE ITEM.IREV_ITEM_REVISION_PK_KEY = BACKLOG.TOP_MODEL_ITEM_FK_KEY
AND ORG.ORGA_ORGANIZATION_PK_KEY = BACKLOG.INV_ORG_FK_KEY
AND GEO.GLOC_LOCATION_PK_KEY = BACKLOG.SHIP_TO_LOCATION_FK_KEY
AND TIME.CDAY_CAL_DAY_PK_KEY = BACKLOG.DATE_BALANCE_FK_KEY