ACTIVE ORGANIZATION QUERY R12 BASED ON MATERIAL TRANSACTIONS

BASED ON MATERIAL TRANSACTIONS ACTIVE ORGANIZATION QUERY
=========================================================

SELECT OOD.ORGANIZATION_ID,
  OOD.ORGANIZATION_CODE,
  OOD.ORGANIZATION_NAME
FROM APPS.ORG_ORGANIZATION_DEFINITIONS OOD
WHERE OOD.ORGANIZATION_ID IN
  (SELECT DISTINCT MMT.ORGANIZATION_ID
  FROM APPS.MTL_MATERIAL_TRANSACTIONS MMT
  WHERE TRUNC(MMT.TRANSACTION_DATE) BETWEEN :P_SRT_DATE AND :P_END_DATE)