Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Hibernate:
- SELECT
- mi.mi_id,
- mi.name1,
- mi.name2,
- mi.hierarchy_id,
- mp.price,
- mi.barcode,
- mi.mi_type,
- mi.code,
- mi.COMMISSION_GRP_ID as commGrpId
- FROM
- menu_items mi,
- menu_price mp
- WHERE
- mi.active=1
- AND mp.mi_id=mi.mi_id
- AND mp.ordr=(
- SELECT
- MIN(ordr)
- FROM
- menu_price mpp
- WHERE
- mpp.mi_id = mi.mi_id
- AND nvl(mpp.valid_from,trunc(sysdate))<=trunc(sysdate)
- AND nvl(mpp.valid_till,trunc(sysdate))>=trunc(sysdate)
- AND (
- mpp.allowed_rvcs IS NULL
- OR mpp.ALLOWED_RVCS IN (
- SELECT
- rvc_group_id
- FROM
- rvc_group_link rl
- WHERE
- rl.rvc_id=null
- )
- )
- AND (
- mpp.ALLOWED_TIME_PROFILE_ID is null
- OR mpp.ALLOWED_TIME_PROFILE_ID in (
- 243,221
- )
- )
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement