APPS.GML_MOBILE_RECEIPT dependencies on MTL_ITEM_SUB_INVENTORIES

Line 3158: FROM mtl_item_sub_inventories mis

3154: WHERE msub.organization_id = p_organization_id
3155: AND NVL(msub.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
3156: AND msub.secondary_inventory_name LIKE (p_sub)
3157: AND EXISTS( SELECT NULL
3158: FROM mtl_item_sub_inventories mis
3159: WHERE mis.organization_id = NVL(p_organization_id,
3160: mis.organization_id)
3161:
3162: AND mis.inventory_item_id = p_item_id