View: PMI_REP_GROSS_MARGIN_V

Product:	PMI - Process Manufacturing Intelligence
Description:	PMI Gross Margin Report view
Implementation/DBA Data:	APPS.PMI_REP_GROSS_MARGIN_V

View Text

SELECT OPERATING_UNIT_ID
, SALES_COMPANY
, SALES_ORGANIZATION
, YEAR_ID
, QUARTER_ID
, PERIOD_ID
, EXTENDED_PRICE_BASE_CURRENCY REVENUE
, CHARGES_BASE_CURRENCY DISCOUNT
, ORDER_QUANTITY * PMI_COMMON_PKG.PMICO_GET_COST(ITEM_ID
, WAREHOUSE_SHIPPED_FROM
, NULL
, PERIOD_START_DATE) COGS
, (EXTENDED_PRICE_BASE_CURRENCY - CHARGES_BASE_CURRENCY - ( ORDER_QUANTITY * PMI_COMMON_PKG.PMICO_GET_COST(ITEM_ID
, WAREHOUSE_SHIPPED_FROM
, NULL
, PERIOD_START_DATE))) MARGIN
FROM PMI_REP_SALES_DETAILS_V

Columns