• Sales Order Hold & Release sql scripts


    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

             

                成长

           /      |     \

        学习   总结   分享

    QQ交流群:122230156

  • 相关阅读:
    使用ansible实现批量免密认证
    python自如爬虫
    python批量发邮件
    诸葛亮诫子书
    CSS3阴影 box-shadow的使用和技巧总结
    js必须掌握的基础
    心态不好,你将永远是个弱者!
    Jquery中$.get(),$.post(),$.ajax(),$.getJSON()的用法总结
    xampp的安装和配置
    css3动画
  • 原文地址:https://www.cnblogs.com/benio/p/2580220.html
Copyright © 2020-2023  润新知