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.MTH_MTL_CONS_IT_MV#

Source

View Text - Preformatted


SELECT
TIME_D.DAY_ID DAY_ID,
TIME_D.CALENDAR_MONTH_ID CALENDAR_MONTH_ID,
MTL_CONS.PRODUCT_FK_KEY,
IT_DENORM_PR.LEVEL9_FK_KEY PRODUCT_LEVEL9_KEY,
IT_DENORM.LEVEL9_FK_KEY ITEM_LEVEL9_KEY,
SUM(MTL_CONS.REQUIRED_QTY_G)PLANNED_USAGE_QTY_G,
COUNT(MTL_CONS.REQUIRED_QTY_G) PLANNED_USAGE_QTY_G_COUNT,
SUM(MTL_CONS.REQUIRED_QTY_SG)PLANNED_USAGE_QTY_SG,
COUNT(MTL_CONS.REQUIRED_QTY_SG) PLANNED_USAGE_QTY_SG_COUNT,
SUM(MTL_CONS.REQUIRED_QTY_G*MTL_CONS.ITEM_COST)PLANNED_USAGE_VAL,
COUNT(MTL_CONS.REQUIRED_QTY_G*MTL_CONS.ITEM_COST)PLANNED_USAGE_VAL_COUNT,
SUM(MTL_CONS.ACTUAL_QTY_G)ACTUAL_USAGE_QTY_G,
COUNT(MTL_CONS.ACTUAL_QTY_G)ACTUAL_USAGE_QTY_G_COUNT,
SUM(MTL_CONS.ACTUAL_QTY_SG)ACTUAL_USAGE_QTY_SG,
COUNT(MTL_CONS.ACTUAL_QTY_SG)ACTUAL_USAGE_QTY_SG_COUNT,
SUM(MTL_CONS.ACTUAL_QTY_G*MTL_CONS.ITEM_COST)ACTUAL_USAGE_VAL,
COUNT(MTL_CONS.ACTUAL_QTY_G*MTL_CONS.ITEM_COST)ACTUAL_USAGE_VAL_COUNT,
SUM(MTL_CONS.UNIT_STANDARD_QTY_G)UNIT_STANDARD_QTY_G,
COUNT(MTL_CONS.UNIT_STANDARD_QTY_G)UNIT_STANDARD_QTY_G_COUNT,
SUM(MTL_CONS.UNIT_STANDARD_QTY_SG)UNIT_STANDARD_QTY_SG,
COUNT(MTL_CONS.UNIT_STANDARD_QTY_SG)UNIT_STANDARD_QTY_SG_COUNT,
COUNT(*) AS TOTAL_COUNT
FROM MTH_PROD_MTL_CONSUMED_F MTL_CONS,
MTH_GREGORIAN_CALENDAR TIME_D,
MTH_ITEM_DENORM_D IT_DENORM,
MTH_ITEM_DENORM_D IT_DENORM_PR
WHERE
TRUNC(MTL_CONS.PLANNED_COMPLETION_DATE) = TIME_D.DAY
AND IT_DENORM.HIERARCHY_ID = -6
AND MTL_CONS.MATERIAL_FK_KEY = IT_DENORM.ITEM_FK_KEY
AND IT_DENORM_PR.HIERARCHY_ID = -5
AND MTL_CONS.PRODUCT_FK_KEY = IT_DENORM_PR.ITEM_FK_KEY
GROUP BY IT_DENORM_PR.LEVEL9_FK_KEY,PRODUCT_FK_KEY,IT_DENORM.LEVEL9_FK_KEY,CALENDAR_MONTH_ID,DAY_ID

View Text - HTML Formatted

SELECT TIME_D.DAY_ID DAY_ID
, TIME_D.CALENDAR_MONTH_ID CALENDAR_MONTH_ID
, MTL_CONS.PRODUCT_FK_KEY
, IT_DENORM_PR.LEVEL9_FK_KEY PRODUCT_LEVEL9_KEY
, IT_DENORM.LEVEL9_FK_KEY ITEM_LEVEL9_KEY
, SUM(MTL_CONS.REQUIRED_QTY_G)PLANNED_USAGE_QTY_G
, COUNT(MTL_CONS.REQUIRED_QTY_G) PLANNED_USAGE_QTY_G_COUNT
, SUM(MTL_CONS.REQUIRED_QTY_SG)PLANNED_USAGE_QTY_SG
, COUNT(MTL_CONS.REQUIRED_QTY_SG) PLANNED_USAGE_QTY_SG_COUNT
, SUM(MTL_CONS.REQUIRED_QTY_G*MTL_CONS.ITEM_COST)PLANNED_USAGE_VAL
, COUNT(MTL_CONS.REQUIRED_QTY_G*MTL_CONS.ITEM_COST)PLANNED_USAGE_VAL_COUNT
, SUM(MTL_CONS.ACTUAL_QTY_G)ACTUAL_USAGE_QTY_G
, COUNT(MTL_CONS.ACTUAL_QTY_G)ACTUAL_USAGE_QTY_G_COUNT
, SUM(MTL_CONS.ACTUAL_QTY_SG)ACTUAL_USAGE_QTY_SG
, COUNT(MTL_CONS.ACTUAL_QTY_SG)ACTUAL_USAGE_QTY_SG_COUNT
, SUM(MTL_CONS.ACTUAL_QTY_G*MTL_CONS.ITEM_COST)ACTUAL_USAGE_VAL
, COUNT(MTL_CONS.ACTUAL_QTY_G*MTL_CONS.ITEM_COST)ACTUAL_USAGE_VAL_COUNT
, SUM(MTL_CONS.UNIT_STANDARD_QTY_G)UNIT_STANDARD_QTY_G
, COUNT(MTL_CONS.UNIT_STANDARD_QTY_G)UNIT_STANDARD_QTY_G_COUNT
, SUM(MTL_CONS.UNIT_STANDARD_QTY_SG)UNIT_STANDARD_QTY_SG
, COUNT(MTL_CONS.UNIT_STANDARD_QTY_SG)UNIT_STANDARD_QTY_SG_COUNT
, COUNT(*) AS TOTAL_COUNT FROM MTH_PROD_MTL_CONSUMED_F MTL_CONS
, MTH_GREGORIAN_CALENDAR TIME_D
, MTH_ITEM_DENORM_D IT_DENORM
, MTH_ITEM_DENORM_D IT_DENORM_PR WHERE TRUNC(MTL_CONS.PLANNED_COMPLETION_DATE) = TIME_D.DAY AND IT_DENORM.HIERARCHY_ID = -6 AND MTL_CONS.MATERIAL_FK_KEY = IT_DENORM.ITEM_FK_KEY AND IT_DENORM_PR.HIERARCHY_ID = -5 AND MTL_CONS.PRODUCT_FK_KEY = IT_DENORM_PR.ITEM_FK_KEY GROUP BY IT_DENORM_PR.LEVEL9_FK_KEY
, PRODUCT_FK_KEY
, IT_DENORM.LEVEL9_FK_KEY
, CALENDAR_MONTH_ID
, DAY_ID