View: WIP_BIS_PROD_VAL_EMP_V

Product:	WIP - Work in Process
Description:	Average production per employee in an inventory organization
Implementation/DBA Data:	APPS.WIP_BIS_PROD_VAL_EMP_V

View Text

SELECT MMT.INVENTORY_ITEM_ID
, MMT.ORGANIZATION_ID
, OOD.ORGANIZATION_NAME
, OOD.LEGAL_ENTITY
, SUM(MMT.PRIMARY_QUANTITY) "QUANTITY"
, OAP.PERIOD_SET_NAME
, OAP.PERIOD_NAME
, OAP.PERIOD_START_DATE
, OAP.SCHEDULE_CLOSE_DATE PERIOD_END_DATE
, MRP_EPI.MRP_ITEM_SELLING_PRICE(MMT.INVENTORY_ITEM_ID
, MMT.ORGANIZATION_ID) "ITEM_PRICE"
, WIP_BIS_COMMON.AVG_EMPLOYEE_NUM(MMT.ACCT_PERIOD_ID
, MMT.ORGANIZATION_ID) "NUM_OF_EMP"
FROM MTL_MATERIAL_TRANSACTIONS MMT
, ORG_ACCT_PERIODS OAP
, ORG_ORGANIZATION_DEFINITIONS OOD
WHERE OAP.ACCT_PERIOD_ID = MMT.ACCT_PERIOD_ID
AND OAP.ORGANIZATION_ID = MMT.ORGANIZATION_ID
AND MMT.ORGANIZATION_ID = OOD.ORGANIZATION_ID
AND MMT.TRANSACTION_SOURCE_TYPE_ID = 5
AND MMT.TRANSACTION_ACTION_ID IN (1
, 31
, 32) GROUP BY MMT.INVENTORY_ITEM_ID
, MMT.ORGANIZATION_ID
, OOD.ORGANIZATION_NAME
, OOD.LEGAL_ENTITY
, MMT.ACCT_PERIOD_ID
, OAP.PERIOD_SET_NAME
, OAP.PERIOD_NAME
, OAP.PERIOD_START_DATE
, OAP.SCHEDULE_CLOSE_DATE

Columns