Advertisement
Guest User

Untitled

a guest
May 6th, 2016
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.30 KB | None | 0 0
  1. Hibernate:
  2. SELECT
  3. mi.mi_id,
  4. mi.name1,
  5. mi.name2,
  6. mi.hierarchy_id,
  7. mp.price,
  8. mi.barcode,
  9. mi.mi_type,
  10. mi.code,
  11. mi.COMMISSION_GRP_ID as commGrpId
  12. FROM
  13. menu_items mi,
  14. menu_price mp
  15. WHERE
  16. mi.active=1
  17. AND mp.mi_id=mi.mi_id
  18. AND mp.ordr=(
  19. SELECT
  20. MIN(ordr)
  21. FROM
  22. menu_price mpp
  23. WHERE
  24. mpp.mi_id = mi.mi_id
  25. AND nvl(mpp.valid_from,trunc(sysdate))<=trunc(sysdate)
  26. AND nvl(mpp.valid_till,trunc(sysdate))>=trunc(sysdate)
  27. AND (
  28. mpp.allowed_rvcs IS NULL
  29. OR mpp.ALLOWED_RVCS IN (
  30. SELECT
  31. rvc_group_id
  32. FROM
  33. rvc_group_link rl
  34. WHERE
  35. rl.rvc_id=null
  36. )
  37. )
  38. AND (
  39. mpp.ALLOWED_TIME_PROFILE_ID is null
  40. OR mpp.ALLOWED_TIME_PROFILE_ID in (
  41. 243,221
  42. )
  43. )
  44. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement