Thursday, July 21, 2016

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)

No comments:

Post a Comment

How to improve blog performance

Improving the performance of a blog can involve a variety of strategies, including optimizing the website's technical infrastructure, im...