VIEW: APPS.OPI_EDW_PRODUCT_GROSS_MARGIN_V

Source

View Text - Preformatted

SELECT org.ALL_ALL_PK_KEY All_ORGS_ID, org.BGRP_BUSINESS_GROUP_PK_KEY BGRP_ID, org.LGET_LEGAL_ENTITY_PK_KEY LE_ID, org.OPER_OPERATING_UNIT_PK_KEY OU_ID, org.ORGA_ORGANIZATION_PK_KEY ORG_ID, time.ALL_ALL_PK_KEY ALL_TIME_ID, time.cper_cal_period_pk_key CAL_PERIOD_ID, time.cqtr_cal_qtr_pk_key CAL_QTR_ID, time.cyr_cal_year_pk_key CAL_YEAR_ID, it.ALL_ALL_PK_KEY ALL_ITEMS_ID, it.CO16_CATEGORY_PK_KEY ITEM_CAT_ID, it.IREV_ITEM_REVISION_PK_KEY ITEM_ID, it.ITEM_ITEM_NUMBER_PK_KEY ITEM_NUMBER_ID, it.IORG_ITEM_ORG_PK_KEY ITEM_ORG_ID, sch.A_ALL_PK_KEY ALL_SCH_ID, sch.SCHN_SLSCHNL_PK_KEY SCH_ID, geo.ALL_ALL_PK_KEY ALL_LOCS_ID, geo.GLOC_LOCATION_PK_KEY LOC_ID, geo.CITY_CITY_PK_KEY CITY_ID, geo.STAT_STATE_PK_KEY STATE_ID, geo.COUN_COUNTRY_PK_KEY COUNTRY_ID, geo.REGN_REGION_PK_KEY REGION_ID, geo.ARE1_AREA1_PK_KEY AREA_ID, tp.ALL_ALL_PK_KEY ALL_TRD_PARTNERS_ID, tp.TPRT_TRADE_PARTNER_PK_KEY TRD_PARTNER_ID, prod_amt_g SALES_REVENUE, cogs_g COGS from opi_edw_perd_margin_f margin, edw_time_m time, EDW_TRD_PARTNER_M tp, edw_organization_m org, EDW_OE_SLCHNL_M sch, edw_items_m it, edw_geography_m geo WHERE margin.OPERATING_UNIT_FK_KEY = org.ORGA_ORGANIZATION_PK_KEY AND margin.SALES_CHANNEL_FK_KEY = sch.SCHN_SLSCHNL_PK_KEY AND margin.ITEM_ORG_FK_KEY = it.IREV_ITEM_REVISION_PK_KEY AND margin.SHIP_TO_LOC_FK_KEY = geo.GLOC_LOCATION_PK_KEY AND margin.MARGIN_PERIOD_FK_KEY = time.CDAY_CAL_DAY_PK_KEY AND margin.CUSTOMER_FK_KEY = tp.TPLO_TPARTNER_LOC_PK_KEY

View Text - HTML Formatted

SELECT ORG.ALL_ALL_PK_KEY ALL_ORGS_ID
, ORG.BGRP_BUSINESS_GROUP_PK_KEY BGRP_ID
, ORG.LGET_LEGAL_ENTITY_PK_KEY LE_ID
, ORG.OPER_OPERATING_UNIT_PK_KEY OU_ID
, ORG.ORGA_ORGANIZATION_PK_KEY ORG_ID
, TIME.ALL_ALL_PK_KEY ALL_TIME_ID
, TIME.CPER_CAL_PERIOD_PK_KEY CAL_PERIOD_ID
, TIME.CQTR_CAL_QTR_PK_KEY CAL_QTR_ID
, TIME.CYR_CAL_YEAR_PK_KEY CAL_YEAR_ID
, IT.ALL_ALL_PK_KEY ALL_ITEMS_ID
, IT.CO16_CATEGORY_PK_KEY ITEM_CAT_ID
, IT.IREV_ITEM_REVISION_PK_KEY ITEM_ID
, IT.ITEM_ITEM_NUMBER_PK_KEY ITEM_NUMBER_ID
, IT.IORG_ITEM_ORG_PK_KEY ITEM_ORG_ID
, SCH.A_ALL_PK_KEY ALL_SCH_ID
, SCH.SCHN_SLSCHNL_PK_KEY SCH_ID
, GEO.ALL_ALL_PK_KEY ALL_LOCS_ID
, GEO.GLOC_LOCATION_PK_KEY LOC_ID
, GEO.CITY_CITY_PK_KEY CITY_ID
, GEO.STAT_STATE_PK_KEY STATE_ID
, GEO.COUN_COUNTRY_PK_KEY COUNTRY_ID
, GEO.REGN_REGION_PK_KEY REGION_ID
, GEO.ARE1_AREA1_PK_KEY AREA_ID
, TP.ALL_ALL_PK_KEY ALL_TRD_PARTNERS_ID
, TP.TPRT_TRADE_PARTNER_PK_KEY TRD_PARTNER_ID
, PROD_AMT_G SALES_REVENUE
, COGS_G COGS
FROM OPI_EDW_PERD_MARGIN_F MARGIN
, EDW_TIME_M TIME
, EDW_TRD_PARTNER_M TP
, EDW_ORGANIZATION_M ORG
, EDW_OE_SLCHNL_M SCH
, EDW_ITEMS_M IT
, EDW_GEOGRAPHY_M GEO
WHERE MARGIN.OPERATING_UNIT_FK_KEY = ORG.ORGA_ORGANIZATION_PK_KEY
AND MARGIN.SALES_CHANNEL_FK_KEY = SCH.SCHN_SLSCHNL_PK_KEY
AND MARGIN.ITEM_ORG_FK_KEY = IT.IREV_ITEM_REVISION_PK_KEY
AND MARGIN.SHIP_TO_LOC_FK_KEY = GEO.GLOC_LOCATION_PK_KEY
AND MARGIN.MARGIN_PERIOD_FK_KEY = TIME.CDAY_CAL_DAY_PK_KEY
AND MARGIN.CUSTOMER_FK_KEY = TP.TPLO_TPARTNER_LOC_PK_KEY