学步园

SELECT OHA.ORDER_NUMBER,
       HS.HOLD_ENTITY_CODE CREDIT_CHECK_CRITERIA_CODE,
       FLV.MEANING CREDIT_CHECK_CRITERIA,
       HD.NAME HOLD_NAME,
       HD.TYPE_CODE HOLD_TYPE,
       HR.RELEASE_REASON_CODE,
       FLV1.MEANING RELEASE_REASON,
       HS.RELEASED_FLAG,
       HS.HOLD_ENTITY_ID,
       OH.HOLD_RELEASE_ID,
       OH.HEADER_ID,
       HS.HOLD_SOURCE_ID
  FROM ONT.OE_HOLD_SOURCES_ALL  HS,
       ONT.OE_HOLD_DEFINITIONS  HD,
       ONT.OE_ORDER_HOLDS_ALL   OH,
       ONT.OE_ORDER_HEADERS_ALL OHA,
       APPS.FND_LOOKUP_VALUES   FLV,
       ONT.OE_HOLD_RELEASES     HR,
       APPS.FND_LOOKUP_VALUES   FLV1
 WHERE HS.ORG_ID = '&ORG_ID'

   AND HS.HOLD_ID = HD.HOLD_ID
   AND OH.HOLD_SOURCE_ID = HS.HOLD_SOURCE_ID
   AND OH.HEADER_ID = OHA.HEADER_ID
--   AND OH.HEADER_ID = 106852
   AND FLV.LOOKUP_TYPE = 'HOLD_ENTITY_DESC'
   AND FLV.VIEW_APPLICATION_ID = 660
   AND FLV.LOOKUP_CODE = HS.HOLD_ENTITY_CODE
   AND OH.HOLD_RELEASE_ID = HR.HOLD_RELEASE_ID
   AND FLV1.LOOKUP_TYPE = 'RELEASE_REASON'
   AND FLV1.VIEW_APPLICATION_ID = 660
   AND FLV1.LOOKUP_CODE = HR.RELEASE_REASON_CODE