[Home] [Help]
View: PMI_REP_GROSS_MARGIN_V
Product: | PMI - Process Manufacturing Intelligence (Obsolete) |
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
Name |
OPERATING_UNIT_ID |
SALES_COMPANY |
SALES_ORGANIZATION |
YEAR_ID |
QUARTER_ID |
PERIOD_ID |
REVENUE |
DISCOUNT |
COGS |
MARGIN |