VIEW: APPS.WIP_BIS_PROD_VAL_EMP_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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