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.

VIEW: APPS.ISC_EDW_BOOKINGS_BILLINGS_S

Source

View Text - Preformatted


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

View Text - HTML Formatted

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